The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 21, 2004
Filed:
Jul. 17, 2001
Lin Yu, Fort Lauderdale, FL (US);
Trendium, Inc., Fort Lauderdale, FL (US);
Abstract
Database systems, methods and/or computer program products that include a database management system and a database having partitioned tables. The partitioned tables include at least two entity tables and a relationship table where the relationship table has a child-to-parent relationship to each of the entity tables. Keys and indices are defined for the entity tables and the relationship table so that the database management system maintains referential integrity between the relationship table and the entity tables to thereby enforce the child-parent relationship. The keys and indices include a primary key which includes one or more columns of a corresponding entity table. The columns of the primary key, however, does not include columns which are used only for partitioning the entity table. A super key includes the columns of the primary key of a corresponding entity table and one or more columns of the entity table which are used only for partitioning the entity table A super key index of the corresponding entity table is based on the super key. Foreign keys are defined for the relationship table corresponding to the primary keys of the entity tables which are related by the relationship table.