System and method for storing data
First Claim
1. A method for storing a composite table of data, the method comprising:
- storing a set of initial fields in an initial table, with each field having a plurality of entries;
storing a definition for at least one additional field having a plurality of entries, wherein the at least one additional field is not stored;
storing a common value that is common to at least two entries of the plurality of entries in the at least one additional field; and
storing at least one other value that is different from the common value for the remainder of entries of the plurality of entries in the at least one additional field.
2 Assignments
0 Petitions
Accused Products
Abstract
The present invention is directed to a system and method for storing a composite table of data. The invention involves storing a set of initial fields in an initial table, with each field having a plurality of entries; storing a definition for at least one additional field having a plurality of entries, wherein the at least one additional field is not stored; storing a common value that is common to at least two entries of the plurality of entries in the at least one additional field; and storing at least one other value that is different from the common value for the remainder of entries of the plurality of entries in the at least one additional field.
57 Citations
21 Claims
-
1. A method for storing a composite table of data, the method comprising:
-
storing a set of initial fields in an initial table, with each field having a plurality of entries;
storing a definition for at least one additional field having a plurality of entries, wherein the at least one additional field is not stored;
storing a common value that is common to at least two entries of the plurality of entries in the at least one additional field; and
storing at least one other value that is different from the common value for the remainder of entries of the plurality of entries in the at least one additional field. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method for forming a composite table of data from compactly stored data, the method comprising:
-
retrieving a stored initial table that comprises a plurality of initial fields and a plurality of records, with each combination of a record and an initial field has an entry of the initial table;
retrieving a stored definition for at least one additional field that is associated with the plurality of records, wherein the definition includes a stored common value that is associated with at least two records for the at least one additional field;
retrieving at least one other stored value that is different from the common value for the remainder of records of the at least one additional field; and
generating the composite table from the initial table, the definition for the at least one additional field, and the at least one other value. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A system for storing data comprising:
-
a memory;
an initial table that is stored in the memory and comprises a plurality of initial fields, wherein each initial field has a plurality of entries;
a dynamic field definition table that is stored in the memory and comprises a definition for at least one additional field and a default value that is associated with the at least one additional field, wherein the at least one additional field is not stored on the memory; and
a dynamic field values table that is stored in the memory and comprises values that are different from the default value and are associated with the at least one additional field. - View Dependent Claims (18, 19, 20)
-
-
21. A database system for accessing a composite table that comprises a plurality of fields, the system comprising:
-
means for storing a definition of a plurality of fields that are not stored, a respective default value that is associated with each field, and other values for each field that are different from the default value; and
means for generating the composite table from the definition, the default values, and the other values.
-
Specification