Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-04-24
2003-08-05
Le, Uyen T (Department: 2171)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06604107
ABSTRACT:
FIELD OF THE INVENTION
The invention relates to databases. More specifically, the invention relates to a system and method for providing generic attributes across multiple categories in such databases.
BACKGROUND OF THE INVENTION
With the advent of the computer industry, databases have played an important role in order to store the vast amounts of information employed in such an industry. Different types of databases have been developed depending on the type of information, size, application as well as other factors.
Currently, one type of database is employed for the storage of different types of categories having specific attributes. One application of such a database is used in conjunction with an Internet-based auction facility of different consumer products and services. For the storage of e-commerce goods or consumer product and/or service information into a database, each product (e.g., automobiles and shoes) will have its own category. Typically, in such databases, each category is stored in a separate data structure (e.g., a table), wherein such data structures will include the specific attributes for that category. For example, for a shoes category, the attributes could include (1) color, (2) size, and (3) type of material. Accordingly, a data structure is created that includes these attributes. Similarly, for an automobile category, the attributes could include (1) make, (2) model, (3) year and (4) color. Therefore, a separate data structure is created for these attributes.
Disadvantageously, this type of database wherein a table is allocated for each type of category makes the design, the implementation, the testing as well as the management of such a system very difficult. Accordingly, there is a need for an improved database system that is able to store vast amounts of information across a number of different categories, while being easier to design, implement, test and manage in comparison to the conventional database systems.
SUMMARY OF THE INVENTION
One embodiment of the present invention provides a database that includes an attribute value table that has item entries for items of different categories. Each item entry has attribute values for attributes of the items. The database also includes an attribute map table that has attribute map entries. The attribute map entries have attribute map values. Additionally, an attribute value is associated with an attribute map entry, such that the attribute values are translated based on the attribute map values of the associated attribute map entry.
REFERENCES:
patent: 3573747 (1971-04-01), Adams et al.
patent: 3581072 (1971-05-01), Nymeyer
patent: 4412287 (1983-10-01), Braddock, III
patent: 4674044 (1987-06-01), Kalmus et al.
patent: 4677552 (1987-06-01), Sibley, Jr.
patent: 4789928 (1988-12-01), Fujisaki
patent: 4799156 (1989-01-01), Shavit et al.
patent: 4811199 (1989-03-01), Kuechler et al.
patent: 4823265 (1989-04-01), Nelson
patent: 4864516 (1989-09-01), Gaither et al.
patent: 4903201 (1990-02-01), Wagner
patent: 5063507 (1991-11-01), Lindsey et al.
patent: 5077665 (1991-12-01), Silverman et al.
patent: 5101353 (1992-03-01), Lupien et al.
patent: 5136501 (1992-08-01), Silverman et al.
patent: 5168446 (1992-12-01), Wiseman
patent: 5205200 (1993-04-01), Wright
patent: 5243515 (1993-09-01), Lee
patent: 5258908 (1993-11-01), Hartheimer et al.
patent: 5280442 (1994-01-01), Hotta et al.
patent: 5297031 (1994-03-01), Gutterman et al.
patent: 5297032 (1994-03-01), Trojan et al.
patent: 5305200 (1994-04-01), Hartheimer et al.
patent: 5325297 (1994-06-01), Bird et al.
patent: 5329589 (1994-07-01), Fraser et al.
patent: 5339391 (1994-08-01), Wroblewski et al.
patent: 5375055 (1994-12-01), Togher et al.
patent: 5394324 (1995-02-01), Clearwater
patent: 5426281 (1995-06-01), Abecassis
patent: 5479600 (1995-12-01), Wroblewski et al.
patent: 5485510 (1996-01-01), Colbert
patent: 5553145 (1996-09-01), Micali
patent: 5557728 (1996-09-01), Garrett et al.
patent: 5596994 (1997-01-01), Bro
patent: 5598557 (1997-01-01), Doner et al.
patent: 5627979 (1997-05-01), Chang et al.
patent: 5640569 (1997-06-01), Miller et al.
patent: 5657389 (1997-08-01), Houvener
patent: 5664115 (1997-09-01), Fraser
patent: 5689652 (1997-11-01), Lupien et al.
patent: 5694546 (1997-12-01), Reisman
patent: 5706457 (1998-01-01), Dwyer et al.
patent: 5710889 (1998-01-01), Clark et al.
patent: 5715314 (1998-02-01), Payne et al.
patent: 5715402 (1998-02-01), Popolo
patent: 5717989 (1998-02-01), Tozzoli et al.
patent: 5722418 (1998-03-01), Bro
patent: 5727165 (1998-03-01), Ordish et al.
patent: 5771291 (1998-06-01), Newton et al.
patent: 5771380 (1998-06-01), Tanaka et al.
patent: 5790790 (1998-08-01), Smith et al.
patent: 5794219 (1998-08-01), Brown
patent: 5799285 (1998-08-01), Klingman
patent: 5803500 (1998-09-01), Mossberg
patent: 5818914 (1998-10-01), Fujisaki
patent: 5826244 (1998-10-01), Huberman
patent: 5835896 (1998-11-01), Fisher et al.
patent: 5845265 (1998-12-01), Woolston
patent: 5845266 (1998-12-01), Lupien et al.
patent: 5850442 (1998-12-01), Muftic
patent: 5872848 (1999-02-01), Romney et al.
patent: 5873069 (1999-02-01), Reuhl et al.
patent: 5884056 (1999-03-01), Steele
patent: 5890138 (1999-03-01), Godin et al.
patent: 5905974 (1999-05-01), Fraser et al.
patent: 5905975 (1999-05-01), Ausubel
patent: 5922074 (1999-07-01), Richard et al.
patent: 5924072 (1999-07-01), Havens
patent: 5926794 (1999-07-01), Fethe
patent: 5974412 (1999-10-01), Hazlehurst et al.
patent: 5991739 (1999-11-01), Cupps et al.
patent: 6035288 (2000-03-01), Solomon
patent: 6035402 (2000-03-01), Vaeth et al.
patent: 6044363 (2000-03-01), Mori et al.
patent: 6047264 (2000-04-01), Fisher et al.
patent: 6055518 (2000-04-01), Franklin et al.
patent: 6058417 (2000-05-01), Hess et al.
patent: 6061448 (2000-05-01), Smith et al.
patent: 6073117 (2000-06-01), Oyanagi et al.
patent: 6085176 (2000-07-01), Woolston
patent: 6104815 (2000-08-01), Alcorn et al.
patent: 6119137 (2000-09-01), Smith et al.
patent: 6178408 (2001-01-01), Copple et al.
patent: 6192407 (2001-02-01), Smith et al.
patent: 6202051 (2001-03-01), Woolston
patent: 6243691 (2001-06-01), Fisher et al.
patent: 6356913 (2002-03-01), Chu et al.
patent: 2253543 (1997-03-01), None
patent: 2658635 (1991-08-01), None
patent: WO 92/15174 (1992-09-01), None
patent: WO 95/17711 (1995-06-01), None
patent: WO 96/34356 (1996-10-01), None
patent: WO 97/37315 (1997-10-01), None
patent: WO 99/63461 (1999-12-01), None
patent: 00/17136 (2000-11-01), None
patent: 01/12398 (2001-08-01), None
Van Heck, E., “Experiances with Electronic Auctions in the Dutch Flower Industry,” Focus Theme, 6 pages, No Date Given.
Warbelow, A., et al., “AUCNET: TV Auction Network System,” Harvard Business School Case Study, HBVR# 9-190-001, pp. 1-15, Apr. 12, 1996.
Zwass, V., “Electronic Commerce: Structure and Issues,” International Journal of Electronic Commerce, 1(1):3-23, Fall, 1996, http://www.cba.bgsu.edu/ijec/v1n1/p003full.html, Jun. 10, 1999.
Neo, B.S., “The Implementation of an Electronic Market For Pig Trading in Singapore,” Journal of Strategic Information Systems, 1(5):278-288, Dec. 1992.
“Onsale: Onsale Brings Thrill of auctions and Bargain Hunting Online; Unique Internet Retail Service Debuts with Week-Long Charity Auction for The Computer Museum in Boston,” Business Wire (DIALOG File 810), 3 pages., Jun. 10, 1999.
“Onsale Joins Fray as Online Shopping Picks up Speed: INTERNET BOOMS,” Computer Reseller News, p. 73, Jun. 5, 1995, PROMT(R) (DIALOG File 16) 1 page, Jun. 10, 1999.
“Personal Optimized Decision/Transaction Program,” IBM Technical Disclosure Bulletin, 38(1):83-84, Jan. 1995.
Post, et al., “Application of auctions as a Pricing Mechanism For the Interchange of Electric Power,” IEEE Transactions On Power Systems, 10(3):1580-1584, Aug. 1995.
Reck, M., “Formally Specifying an Automated Trade Execution System,” Journal of Systems and Software, 21:245-252, 1993.
Reck, M., “Trading-Process Characteristics of Electronic Auctions,” Focus Theme, 7 pages, No Date Given.
Rockoff, T.E., et al., “Design of an Internet-Based system for Remote Dutch Auct
Blakely , Sokoloff, Taylor & Zafman LLP
eBay Inc.
Le Uyen T
LandOfFree
Generic attribute database system for storing items of... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Generic attribute database system for storing items of..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Generic attribute database system for storing items of... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3077791