System and method for selecting rows from dimensional databases

Details System and method for selecting rows from dimensional databases System and method for selecting rows from dimensional databases

1997-11-05

1999-12-14

Choules, Jack M.

Data processing: database and file management or data structures

Database design

Data structure types

707102, G06F 1730

Patent

active

060030240

ABSTRACT:
A system and method selects rows from a fact table in a dimensional database containing a fact table, a time dimension table and other dimension tables. The other dimension tables each contain rows containing a time invariant attribute to identify an item described by the row, an effective time attribute for the row, and other attributes. If an attribute for an item changes, a new row is added to the dimension table containing the time-invariant attribute for the item and current attributes for the item, without deleting or overwriting any existing rows for that item. Such dimension tables can be selected or used to create other tables using one or more time attributes of the dimension tables. The tables created can be selected or used to create still other tables using one or more time attributes of those tables. One or more of the resulting tables or one or more tables created from a resulting table are then joined to a table in the dimensional database or a table created from a table in the dimensional database.

REFERENCES:
patent: 5317733 (1994-05-01), Murdock
patent: 5347653 (1994-09-01), Flynn et al.
patent: 5359724 (1994-10-01), Earle
patent: 5428774 (1995-06-01), Takahashi et al.
patent: 5440730 (1995-08-01), Elmasri et al.
patent: 5548754 (1996-08-01), Pirahesh et al.
patent: 5551031 (1996-08-01), Cheng et al.
patent: 5557791 (1996-09-01), Cheng et al.
patent: 5572731 (1996-11-01), Morel et al.
patent: 5590324 (1996-12-01), Leung et al.
patent: 5603021 (1997-02-01), Spencer et al.
patent: 5745755 (1998-04-01), Covey
Rolem, D. "Physical Organization of Temoral Data", Proceedings of the Third International Conference on Data Engineering, pp. 547-553, Feb. 1987.
Freind, D. "Taking Databases into the next dimension." Computing Canada, vol. 18, No. 20, pp. 40, Sep. 1992.
Elmasri, R.A. and S.B. Navathe, Fundamentals of Database Systems, 1989, pp. 649-650, Benjamin/Cummings Publishing Company, Inc., Redwood City, California, USA.
Snodgrass, R.T., The Temporal Query Language TQuel, ACM Transactions on Database Systems, Jun. 1987, pp. 247-298, vol. 12, No. 2, Association for Computing Machinery, New York, New York, USA.
Snodgrass, R.T., S. Gomez and L.E. McKenzie Jr., Aggregates in the Temporal Query Language TQuel, IEEE Transactions on Knowledge and Data Engineering, Oct. 1993, pp. 826-842, vol. 5, No. 5, Institute of Electrical and Electronics Engineers, New York, New York, USA.
Snodgrass, R. T. (ed.), The TSQL2 Temporal Query Language, 1995, pp. 1-631, Kluwer Academic Publishers, Boston, Massachusetts, USA.
Snodgrass, R.T., M.H. Boehlen, C.S. Jensen and A. Steiner, Adding Valid Time to SQL/Temporal, ANSI X3H2-96-501r2, ISO/IEC JTC1/SC21/WG3 DBL MAD-146r2, Nov. 1996, pp. 1-77, International Organization for Standardization, Geneva, Switzerland.
Tansel, A., J. Clifford, S. Gadia, S. Jajodia, A. Segev and R.T. Snodgrass, Temporal Databases: Theory, Design, and Implementation, 1993, pp. 1-593, Benjamin/Cummings Publishing Company, Inc., Redwood City, California, USA.
Melton, J, Temporal (SQL/Temporal) ANSI TC X3H2 ISO/IEC JTC 21/WG 3 Database, Apr. 1997, pp. 1-65 plus notes 1-21 and index 1-3, International Organization for Standardization, Geneva, Switzerland.

Affiliated with

Also associated with

Rating

System and method for selecting rows from dimensional databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for selecting rows from dimensional databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for selecting rows from dimensional databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-873556