Attribute-based access for multi-dimensional databases

Details Attribute-based access for multi-dimensional databases Attribute-based access for multi-dimensional databases

1997-06-30

1999-08-17

Ho, Ruay Lian

Data processing: database and file management or data structures

Database design

Data structure types

707 3, 707100, G06F 1730

Patent

active

059408189

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 having one or more members. Each value in the multi-dimensional database is identified by the intersection of one member from each dimension. 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 at least one row that contains the 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. At least one dimension table has one or more attribute columns for holding attribute values for members defined by the dimension table.

REFERENCES:
patent: 5359724 (1994-10-01), Earle
patent: 5363121 (1994-11-01), Freund
patent: 5428771 (1995-06-01), Daniels et al.
patent: 5432926 (1995-07-01), Citron et al.
patent: 5561797 (1996-10-01), Gilles et al.
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5778354 (1998-07-01), Leslie et al.
patent: 5778355 (1998-07-01), Boyer et al.
Transaction Manager Concepts, Two-Pahshe Commit: Making Computations Atomic, pp. 562-574.
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.

Affiliated with

Also associated with

Rating

Attribute-based access for multi-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 Attribute-based access for multi-dimensional databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Attribute-based access for multi-dimensional databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-325727