COMBINING ROW BASED AND COLUMN BASED TABLES TO FORM MIXED-MODE TABLES

摘要

Various ways of storing data in tabular form such that some records are stored in a row oriented manner and some data is stored in a column oriented manner. The records respectively stored in the row and column oriented manners may, or may not, overlap (in whole or in part. Some embodiments accomplish this dual orientation of data by: (i) using a range partition; (ii) using a union all view command; and/or (iii) using a first table, a staging table and a materialized query table.

主权项

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 machine readable data on a machine readable storage device; 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 populated to be row oriented; and the second plurality of records is populated to be column oriented.