Back to results
US 2014/0279977 A1Published application
Data access of slowly changing dimensions
AssigneeBMC Software, Inc.
InventorsZack Milousheff, Mark Hutchins
Life of this patent
Estimating the term…
Abstract
Disclosed is a method including storing selected historical persist dimension attribute data utilizing a row insertion without updating all previous versions of the selected persist dimension attribute, and generating a view of persisted dimension attribute data as dual values utilizing a star join.
Claims17
A method comprising:
- storing selected historical persist dimension attribute data utilizing a row insertion without updating all previous versions of the selected persist dimension attribute;
- and
- generating a view of persisted dimension attribute data as dual values utilizing a star join.
A data warehouse comprising:
- a database,
- at least one processor, and
- at least one memory storing code segments that when executed by the processor cause the processor to,
- generate a configuration structure to store information indicating a dimension attribute to be historically persisted,
- generate a plurality of data tables in the database, each of the plurality of data tables including an associated schema, the associated schema including current attribute data, history attribute data, effective date data for the attribute, and data indicating an attribute is current, and
- store selected historical persist dimension attribute data utilizing a row insertion without updating all previous versions of the selected persist dimension attribute.
3 more elements
A method, comprising:
- associating foreign key columns of a fact table with a column identifying dimension data of at least one dimension data table, the association being a star join, and
- generating a view configured to convert row data to column data based on the star join, the column data being dual values.
The method of claim 17, wherein the view includes a snapshot validity interval.
Dependencies are inferred from the claim text.