Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-06-30
1999-05-18
Von Buhr, Maria N.
Data processing: database and file management or data structures
Database design
Data structure types
707101, 707102, G06F17/30
Patent
active
059059850
ABSTRACT:
A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A relational schema is defined from a multi-dimensional database definition. The multi-dimensional database definition has one or more dimensions having one or more members. The relational schema includes a fact table and related dimension tables. The fact table has a dimension column for all but one of the dimensions of the multi-dimensional database and a value column for each member of the remaining dimension. The fact table has one or more rows that contain values corresponding to the intersection of the members identified by the dimension columns and the members associated with the value columns. Each dimension table has a row for each member of a dimension. Each row of each dimension table includes a multi-dimensional member identifier and a relational member identifier. A relational database is created based on the defined relational schema. Rows are accessed from the relational database using the multi-dimensional member identifiers by joining the dimension tables to the fact table through the relational member identifiers.
REFERENCES:
patent: 4992939 (1991-02-01), Tyler
patent: 5359724 (1994-10-01), Earle
patent: 5550964 (1996-08-01), Davoust
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5721910 (1998-02-01), Unger et al.
patent: 5724569 (1998-03-01), Andres
patent: 5765028 (1998-06-01), Gladden
Maurice, The Truth About OLAP, DBMS, pp. 40-42, 44, 46 and 48 Aug. 1995.
Bulos, How to Evaluate OLAP Servers, DBMS, pp. 96-100 and 102 Aug. 1995.
Jay Tyo, Online Analytical Processing Tools Help Users Efficiently Analyze Business Data and Make More Timely Informed Decision, Informationweek No. 587, Printed pp. 58-64 Jul. 1996.
Metaphor Business Series, "Examining Corporate and Syndicated Data", Chapter 3: "Reporter Workshop", 1990, pp. 3-1 through 3-66.
Archer Decision Sciences, Inc., Internet article, http://www.strategy.com/dwf/raden/str101.htm, 1995-1996 (entire document).
Kimball, Ralph, "The Data Warehouse Toolkit: Practical Techniques for Building Dimensional data Warehouses", Appendix D: "User's Guide for Star Tracker.TM.", published by John Wiley & Sons, Inc., 1996, pp. 321-366.
Malloy William Earl
Tomlyn Craig Reginald
Coby Frantz
International Business Machines - Corporation
Von Buhr Maria N.
LandOfFree
Relational database modifications based on multi-dimensional dat does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Relational database modifications based on multi-dimensional dat, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational database modifications based on multi-dimensional dat will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1769161