Relational database implementation of a multi-dimensional databa

Details Relational database implementation of a multi-dimensional databa Relational database implementation of a multi-dimensional databa

1997-06-30

1999-07-20

Amsbury, Wayne

Data processing: database and file management or data structures

Database design

Data structure types

707101, G06F 1730

Patent

active

059268182

ABSTRACT:
A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is represented as a relational schema in the relational database. The multi-dimensional database has one or more dimensions. Each dimension has one or more members. The relational schema includes a fact table and one or more related dimension tables. Additionally, 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 also has at least one row that contains values corresponding to the intersection of the members identified by the dimension columns and the members associated with the value columns.

REFERENCES:
patent: 5359724 (1994-10-01), Earle
patent: 5519859 (1996-05-01), Grace
patent: 5632009 (1997-05-01), Rao et al.
patent: 5694608 (1997-12-01), Shostak
Metaphor Business Series, "Examining Corporate and Syndicated Data", Chapter 3: Reporter Workshop, Jan. 1990, pp. 3-1 through 3-66.
Archer Decision Sciences, Inc., Internet article, http://www.strategy.com/dwf/raden/str101.htm, Jan. 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., Jan. 1996, pp. 321-366 .

Affiliated with

Also associated with

Rating

Relational database implementation of a multi-dimensional databa 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 implementation of a multi-dimensional databa, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational database implementation of a multi-dimensional databa will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1331775