Data processing: database and file management or data structures – Database and file access – Record – file – and data search and comparisons
Reexamination Certificate
2006-03-31
2010-10-05
Trujillo, James (Department: 2159)
Data processing: database and file management or data structures
Database and file access
Record, file, and data search and comparisons
Reexamination Certificate
active
07809741
ABSTRACT:
Various technologies and techniques are disclosed that improve the retrieval or interaction with data in databases. A database has one or more tables with compound keys. An entity key that is a single composite key of each of the compound keys is generated via an invertible composition transformation. The composite entity key is a binary serialization of the respective compound keys. The composite entity key is used by separate applications to interact with the database instead of the respective underlying compound keys. The composite entity key is decomposed into the underlying compound keys when a particular database operation needs to be performed. The results are then returned to the separate application with the composite entity key.
REFERENCES:
patent: 5010478 (1991-04-01), Deran
patent: 5283894 (1994-02-01), Deran
patent: 5530854 (1996-06-01), Emery et al.
patent: 5555409 (1996-09-01), Leenstra et al.
patent: 5799184 (1998-08-01), Fulton et al.
patent: 5870747 (1999-02-01), Sundaresan
patent: 5966703 (1999-10-01), Burrows
patent: 6003036 (1999-12-01), Martin
patent: 6169990 (2001-01-01), McGregor et al.
patent: 6223182 (2001-04-01), Agarwal et al.
patent: 6446062 (2002-09-01), Levine et al.
patent: 6466942 (2002-10-01), Tolkin
patent: 6546394 (2003-04-01), Chong et al.
patent: 6618833 (2003-09-01), Hill et al.
patent: 6775655 (2004-08-01), Peinado et al.
patent: 6795821 (2004-09-01), Yu
patent: 6859808 (2005-02-01), Chong et al.
patent: 2004/0015506 (2004-01-01), Anonsen et al.
patent: 2004/0210946 (2004-10-01), Shin
patent: 2004/0260706 (2004-12-01), Anonsen et al.
Chong et al. “B+-Tree Indexes with Hybrid Row Identifiers in Oracle8i”, pp. 341-348, 17th International Conference on Data Engineering (ICDE'01), Apr. 2001.
Chong et al., “A Mapping Mechanism to Support Bitmap Index and Other Auxiliary Structures on Tables Stored as Primary B+-trees”, pp. 625-628, Proceedings of the 2002 ACM CIKM International Conference on Information and Knowledge Management (CIKM'02), Nov. 2002.
Hays Christopher A
Mineev Alexandre I
Conyers Dawaune
Microsoft Corporation
Trujillo James
LandOfFree
Generating and utilizing composite keys in lieu of compound... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Generating and utilizing composite keys in lieu of compound..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Generating and utilizing composite keys in lieu of compound... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4189727