Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-08-21
2007-08-21
Nguyen, Cam Linh (Department: 2161)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
10791941
ABSTRACT:
A database including vertical tables useful for storing large numbers of objects having potentially thousands of attributes in, e.g., e-commerce applications. To support querying the vertical database using conventional SQL, a horizontal view over the underlying vertical tables is defined, and then queries are posed against the view. The queries are automatically transformed and executed against the vertical tables. If desired, the query results can be transformed back to a horizontal format. In this way, it appears to the user that a conventional horizontal data format is being used.
REFERENCES:
patent: 5794228 (1998-08-01), French et al.
patent: 5794229 (1998-08-01), French et al.
patent: 5918225 (1999-06-01), White et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6023696 (2000-02-01), Osborn et al.
patent: 6298342 (2001-10-01), Graefe et al.
PUBLICATION: “Relational Databases for Querying XML Documents: Limitations and Opportunities”. Shanmugasundaram et al. In Proceedings of the 25th Very Large Data Bases, Conference, Sep. 7-10, 1999, Edinburgh, Scotland.
PUBLICATION: “A Domain Based Internal Schema For Relational Database Machines”. In Proceedings of the 182 ACM SIGMOD International Conference on Management of Data, pp. 215-224. Orlando, Florida, Jun. 2-4, 1082.
PUBLICATION: “On Efficiently Implementing SchemaSQL on a SQL Database System”, pp. 471-482. In Proceedings of the 25th Very Large Data Bases, Conference, Sep. 7-10, 1999, Edinburgh, Scotland.
PUBLICATION: “A Query Processing Strategy For The Decomposed Storage Model”. In Proceedings of the Third International Conference on Data Engineering, pp. 636-643. Feb. 3-5, 1987, Los Angeles, California.
Technical Report: “A Performance Evaluation of Alternative Mapping Schemes for Storing SML Data in a Relational Database”. D. Florescu et al. INRIA, France, May 1999.
PUBLICATION: “Storing Semistructure Data with Stored”, pp. 431-442. A. Deutsch et al. In SIGMOD 1999, Proceedings ACM SIGMOD International Conference on Management of Data, Jun. 1-3, 1999, Philadelphia, Pennsylvania.
PUBLICATION: “A Decomposition Storage Model”, pp. 268-279. G. Copeland et al. In Proceedings of the 1985 ACM SIGMOD International Conference on Management of Data, Austin, Texas, May 28-31, 1985.
PUBLICATION: “MIL Primitives For Querying A Fragmented World”, pp. 1-20. P. Boncz et al. VLDB Journal, 8(2), Oct. 1999.
Agrawal Rakesh
Somani Amit
Xu Yirong
International Business Machines - Corporation
Nguyen Cam Linh
Rogitz John L.
LandOfFree
System and method for generating horizontal view for SQL... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for generating horizontal view for SQL..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for generating horizontal view for SQL... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3880306