US 2016/0078089 A1 · METHOD AND SYSTEM FOR ADAPTIVELY BUILDING A COLUMN STORE DATABASE FROM A TEMPORAL ROW STORE DATABASE BASED ON QUERY DEMANDS

Abstract

A method for dynamically building a column store database from a row store database. The method includes establishing the row store database for storing data, wherein each row includes a plurality of attributes, and wherein data in row store database is current to a temporal point in time. The method includes establishing the column store database including data structured to satisfy received analytic queries. The method includes beginning from an initial state of the column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of the row store database into the column store database to satisfy the corresponding subsequently received analytic query.

Claims20

Dependent claims

A computer system for accessing information, comprising:

memory having stored therein computer-executable instructions;
and
a processor executing said computer-executable instructions including:
establishing a row store database for storing data, wherein each row of said row store database comprises a plurality of attributes, wherein said data in said row store database is current to a temporal point in time;
establishing a column store database comprising data structured to satisfy received analytic queries;
and
beginning from an initial state of said column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of said row store database into said column store database to satisfy said corresponding subsequently received analytic query.

4 more elements

A method for dynamically building a column store database from a row store database, comprising;

establishing said row store database for storing data, wherein each row of said row store database comprises a plurality of attributes, wherein said data in said row store database is current to a temporal point in time;
establishing said column store database comprising data structured to satisfy received analytic queries;
and
beginning from an initial state of said column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of said row store database into said column store database to satisfy said corresponding subsequently received analytic query.

1 more element

A non-transitory computer-readable medium having computer-executable instructions for causing a computer system to perform a method, comprising:

establishing said row store database for storing data, wherein each row of said row store database comprises a plurality of attributes, wherein said data in said row store database is current to a temporal point in time;
establishing said column store database comprising data structured to satisfy received analytic queries;
and
beginning from an initial state of said column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of said row store database into said column store database to satisfy said corresponding subsequently received analytic query.

1 more element

Dependencies are inferred from the claim text.

Method and system for adaptively building a column store database from a temporal row store database based on query demands

Life of this patent

Method and system for adaptively building a column store database from a temporal row store database based on query demands

Life of this patent

Abstract

Claims20