WO2000079409A2 - Product catalogue production system - Google Patents
Product catalogue production system Download PDFInfo
- Publication number
- WO2000079409A2 WO2000079409A2 PCT/GB2000/002384 GB0002384W WO0079409A2 WO 2000079409 A2 WO2000079409 A2 WO 2000079409A2 GB 0002384 W GB0002384 W GB 0002384W WO 0079409 A2 WO0079409 A2 WO 0079409A2
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- product
- data
- classification
- attribute
- code
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Definitions
- the present invention relates to a product catalogue production
- the database storing a plurality of attributes for a product
- product data may be organised into a hierarchical category structure.
- the products are classified into sections, sub-sections, groups within sub-
- a product may fall into a plurality of
- a category may include a plurality of products.
- category storage table 56 store data records for each respective classification
- section table 52 includes, in each sub-section record, a pointer to the section
- section storage table 50 to sub-section storage table 52. Similar one-to-many
- a category-product storage table 58 stores relationships
- Figure 7 illustrates the product storage table 60, and its associated
- the product storage table 60 is
- Each row 64 provides one
- each hierarchical level limit the number and structure of classification
- the system may be used in a variety of product catalogue production contexts.
- catalogue production system comprising a data storage means for storing
- product data in the form of product codes and associated product attribute data
- said data storage means having a data structure allowing a plurality of
- data items are associated with a given product code, in the form of a plurality
- Figure 1 schematically illustrates a product catalogue production
- Figure 2 illustrates a set of product storage tables, and relationships
- Figure 3 illustrates in further detail fields present in a product storage
- Figure 4 illustrates fields present in a classification control storage
- Figure 5 illustrates fields present in a classification detail storage table
- Figure 6 illustrates a set of data storage tables used in prior art product
- Figure 7 illustrates a product storage table and an attributes control
- Figure 1 schematically illustrates a product catalogue production
- a software platform 2 including a relational database 8 and several
- relational database 8 may be run on any SQL 92-compliant data server, such as
- software applications 10-18 may be run on an appropriate server facility such as
- the system also includes a plurality of plug-
- TM Microsoft NT
- catalogue output devices 6 which may include a Web
- the catalogue production software applications include a core data
- the core data manager 10 is responsible by the functionality of the core data manager.
- client workstation for capturing and retrieving both key product information and further product information including multimedia data files, text data files
- a catalogue compiler software application 12 constructs a data set
- Query criteria are entered by an operator of the system,
- SQL Structured Query Language
- a catalogue layout designer software application 14 includes media- neutral routines for laying out catalogue data and media-specific routing for providing templates for defining the navigational and look and feel rules for generating data to be used in the production of paper-format catalogues and
- a catalogue production manager software application 16 creates laid- out catalogues by presenting core data as selected by the catalogue compiler 12.
- a catalogue update manager software application 18 ensures that any changes made to core data are reflected automatically in the catalogues
- a first plug-in module 19 is an Internet catalogue publishing module.
- catalogue is accessed by users via an Internet interface device 26.
- a second catalogue publishing module 20 produces a master CD-
- the CD-ROM module 20 takes data from the catalogue
- the master CD-ROM may
- a third catalogue publishing module 22 provides a paper catalogue.
- the paper module 22 interfaces with Quark Xpress (trade mark) and provides
- catalogue update manager 18 The output data is loaded onto a storage
- a fourth catalogue publishing module 24 which may be implemented
- FIG. 2 illustrates the data storage tables implemented by the core
- the data storage tables include an attribute control table 100 which
- a product stores control data about all product and classification attributes.
- detail table 200 stores product detail data in records consisting of a reference
- An attribute value table 300 stores the actual values of attributes
- a product control table 400 stores
- control data about all products a single record being provided per product.
- a classification-product-link table 500 stores relationships between
- the table consists of records including a single
- product code being a unique product identifier, and a single classification
- a plurality of such records may
- the classification-product-link table may store
- a classification control table 600 stores control data about all
- classifications including all classifications at different hierarchical levels.
- the classification control table 600 also defines the vertical relationships
- a classification detail table 700 stores classification detail data in the
- attribute value data stored in attribute control table 100 and the attribute value
- table may be related to both product records and classification records.
- classification may be related to many classification detail records.
- a product structure control table 800 stores control data about product
- One product structure can be used by any of a number of different
- a product structure detail table 900 stores product structure detail data
- the product attribute references are references to records stored in the
- Each product structure may be related to many
- Rules may be defined in the system
- levels of classification may be merged to produce a combined product
- the product detail table 200 is capable of storing and manipulating an
- Each product detail record includes five fields.
- a product code field is a product code field.
- P-Code product code
- An attribute code field 204 stores a unique identifier, the attribute
- A-Code which is a pointer to an attribute control record stored in the
- a data type field 206 stores a type identifier (D-
- attribute value data may consist of one of four types, namely either a memo
- a text field (consisting of a large amount of text data), a text field (consisting of a
- an object field consisting of multimedia-type data, such as a picture file or a Power Point (trademark) file
- multimedia-type data such as a picture file or a Power Point (trademark) file
- a value code field 208 stores the value code (N-Code), which is a
- S-Code numerical sort code
- the attribute control table 100 includes a data field 102 for storing a
- attribute code A-Code
- description field 104 stores a name (A-Desc) for each attribute.
- the attribute value table 300 includes a value code field 302, whereby
- An attribute value data item may be related to one, or a plurality of,
- a classification control table includes five fields
- the classification control table is
- a child classification is defined in the hierarchy to
- PA-Code parent code
- a classification code field 602 stores the classification code (C-Code),
- parent classification may thus be inherited by its one or more child
- a sequence code field 610 stores a numerical sort code (S-Code) used
- a classification description field 604 stores a name (C-Desc) for the
- a product structure code field 608 stores a product structure
- PS-Code which is a unique identifier for a product structure record
- the product structure control table 800 includes a product structure
- the product structure record is related to a classification control record.
- classification control record is related to a limit of one product structure
- a product structure record may be related to one or many
- a product structure description field 804 contains a name of the product structure (PS-Desc), for
- the product structure detail table 900 includes a product structure
- a plurality of product structure detail records may contain the same
- product structure detail record includes a single attribute code field 904,
- a sequence code field 906 stores a numerical sort code (S-Code) allowing a
- the product structure detail table 900 thus stores one or many attribute
- the classification detail table 700 is capable of
- Each classification has attributes associated with the classification in records.
- detail record contains fields identical with the product detail records stored in product detail table 200, and having the same fimctionality, except that a
- classification code (C-Code), uniquely identifying the classification, is stored
- Field 704 stores an attribute code (A-
- field 706 stores a data type (D-
- field 708 stores a value code (N-Code) pointing to an attribute value
- S-Code for sorting the classification attributes, where a number of
- classification detail records include the same classification code in field 702,
- attribute control data and attribute value data may be associated only with one
- values may be associated with a product. That is to say, the data structure itself does not limit the number of attributes which may be associated with a
- control table 100 and/or the attribute value table 300 are control tables 100 and/or the attribute value table 300.
- attribute as used herein is intended to include any types of data which may
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
AU56910/00A AU5691000A (en) | 1999-06-21 | 2000-06-20 | Product catalogue production system |
EP00942201A EP1221107A2 (en) | 1999-06-21 | 2000-06-20 | Product catalogue production system |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
GB9914471A GB2351368A (en) | 1999-06-21 | 1999-06-21 | Product catalogue production system |
GB9914471.9 | 1999-06-21 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2000079409A2 true WO2000079409A2 (en) | 2000-12-28 |
WO2000079409A3 WO2000079409A3 (en) | 2002-05-02 |
Family
ID=10855765
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/GB2000/002384 WO2000079409A2 (en) | 1999-06-21 | 2000-06-20 | Product catalogue production system |
Country Status (4)
Country | Link |
---|---|
EP (1) | EP1221107A2 (en) |
AU (1) | AU5691000A (en) |
GB (1) | GB2351368A (en) |
WO (1) | WO2000079409A2 (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6871198B2 (en) | 2001-12-21 | 2005-03-22 | Requisite Technology, Inc. | Composing and cataloging item configuration data |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
GB2377771A (en) * | 2001-03-09 | 2003-01-22 | Zygon Systems Ltd | Electronic information storage and retrieval system |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0360387A2 (en) * | 1988-09-23 | 1990-03-28 | International Business Machines Corporation | Data base management system |
US5295256A (en) * | 1990-12-14 | 1994-03-15 | Racal-Datacom, Inc. | Automatic storage of persistent objects in a relational schema |
EP0797160A2 (en) * | 1996-03-22 | 1997-09-24 | Pilot Software Inc | Computer system and computer-implemented process for classifying records in a computer database |
GB2315576A (en) * | 1996-07-19 | 1998-02-04 | Ericsson Telefon Ab L M | Telecommunications one-dimensional database structure |
US5907846A (en) * | 1996-06-07 | 1999-05-25 | Electronic Data Systems Corporation | Method and system for accessing relational databases using objects |
-
1999
- 1999-06-21 GB GB9914471A patent/GB2351368A/en not_active Withdrawn
-
2000
- 2000-06-20 AU AU56910/00A patent/AU5691000A/en not_active Abandoned
- 2000-06-20 WO PCT/GB2000/002384 patent/WO2000079409A2/en not_active Application Discontinuation
- 2000-06-20 EP EP00942201A patent/EP1221107A2/en not_active Withdrawn
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0360387A2 (en) * | 1988-09-23 | 1990-03-28 | International Business Machines Corporation | Data base management system |
US5295256A (en) * | 1990-12-14 | 1994-03-15 | Racal-Datacom, Inc. | Automatic storage of persistent objects in a relational schema |
EP0797160A2 (en) * | 1996-03-22 | 1997-09-24 | Pilot Software Inc | Computer system and computer-implemented process for classifying records in a computer database |
US5907846A (en) * | 1996-06-07 | 1999-05-25 | Electronic Data Systems Corporation | Method and system for accessing relational databases using objects |
GB2315576A (en) * | 1996-07-19 | 1998-02-04 | Ericsson Telefon Ab L M | Telecommunications one-dimensional database structure |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6871198B2 (en) | 2001-12-21 | 2005-03-22 | Requisite Technology, Inc. | Composing and cataloging item configuration data |
Also Published As
Publication number | Publication date |
---|---|
GB9914471D0 (en) | 1999-08-18 |
WO2000079409A3 (en) | 2002-05-02 |
GB2351368A (en) | 2000-12-27 |
AU5691000A (en) | 2001-01-09 |
EP1221107A2 (en) | 2002-07-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5778370A (en) | Data village system | |
US7925658B2 (en) | Methods and apparatus for mapping a hierarchical data structure to a flat data structure for use in generating a report | |
Ullman | Principles of database systems | |
US6199059B1 (en) | System and method for classifying and retrieving information with virtual object hierarchy | |
US7685136B2 (en) | Method, system and program product for managing document summary information | |
US7043490B2 (en) | Method, system, and program product to support multiple content-management data models | |
Chowdhury et al. | Organizing information: from the shelf to the web | |
US9218409B2 (en) | Method for generating and using a reusable custom-defined nestable compound data type as database qualifiers | |
US20030110055A1 (en) | Electronic catalogue | |
US20030115176A1 (en) | Information system | |
CN101673287A (en) | SQL sentence generation method and system | |
CN101719135A (en) | Administrative resource catalog control system and method | |
CN102081630A (en) | Method for classifying, storing and inquiring data | |
CN101488086A (en) | Software generation method and apparatus based on field model | |
EP2524300A1 (en) | Apparatus and method for constructing data applications in an unstructured data environment | |
CN101770291A (en) | Semantic analysis data hashing storage and analysis methods for input system | |
Cecelja | Manufacturing Information and Data Systems: Analysis, Design and Practice | |
CN101814064B (en) | Establishment method of report template, report generation method and report system | |
WO2000079409A2 (en) | Product catalogue production system | |
CN101297290A (en) | Method for controlling relational database system | |
Milosavljevic et al. | XML schema of UNIMARC format variant and bibliographic record in BISIS software system | |
Belić et al. | Model of a user friendly system for library cataloguing | |
Koutamanis | Computer-mediated briefing for architects | |
JPH0934906A (en) | Book management device | |
Weich | Generic containers for a distributed object store |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A2 Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
WWE | Wipo information: entry into national phase |
Ref document number: 2000942201 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 10018698 Country of ref document: US |
|
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
WWP | Wipo information: published in national office |
Ref document number: 2000942201 Country of ref document: EP |
|
WWW | Wipo information: withdrawn in national office |
Ref document number: 2000942201 Country of ref document: EP |
|
NENP | Non-entry into the national phase in: |
Ref country code: JP |