Patent ID: 9547681
Date: 2017-01-17
CPC Classifications: G06F

Claim:
1. A method for storing data in tabular form, the method comprising: creating a table with a set of one, or more, partitions such that the table includes at least a first partition range and a second partition range; populating the first partition range with a first data set that includes a first plurality of records, with each record of the first plurality of records having a plurality of attribute values corresponding to a plurality of ordered attributes; populating the second partition range with a second data set that includes a second plurality of records, with each record of the second plurality of records having a plurality of attribute values corresponding to a plurality of ordered attributes; and storing the table as a machine readable data structure on a non-transitory storage medium of a machine readable storage device by transforming matter of a storage medium of a machine readable data storage device to correspond to the table data structure; wherein: the plurality of ordered attributes of the first plurality of records has the same attributes and the same order as the plurality of ordered attributes of the second plurality of records; the first plurality of records is stored on the storage medium of the machine readable storage device in a row oriented manner; and the second plurality of records is stored on the storage medium of the machine readable storage device in a column oriented manner; whereby selective use two different orientations for the first and second pluralities of records improves, relative to a single orientation table, a balance between the following design imperatives: speed of stored data access and storage space efficiency.