Patent ID: 6205447
Filing Date: 2001-03-20
Classification: G06F,Y10S

Abstract:
A method of executing a command in a computer to perform a database operation on a relational database stored on a data storage device, the method comprising the steps of:(a) defining a multi-dimensional database using an outline that contains one or more dimensions, each dimension having a list of one or more members;(b) defining a relational schema based on the defined multi-dimensional database;(c) creating a relational database based on the defined relational schema, wherein the relational database includes a fact table and one or more related dimension tables for storing data from the multi-dimensional database, wherein one of the dimension tables is an anchor dimension table that does not intersect the fact table with a common column and wherein the remaining dimension tables are non-anchor dimension tables, each of which intersects the fact table with a common column; and(d) accessing the created relational database using access mechanisms provided by the defined multi-dimensional database and the created relational database.