×

Mapping of an RDBMS schema onto a multidimensional data model

  • US 6,768,986 B2
  • Filed: 04/03/2001
  • Issued: 07/27/2004
  • Est. Priority Date: 04/03/2000
  • Status: Active Grant
First Claim
Patent Images

1. A method of translating a relational model defined by a relational table into a multi-dimensional data model, the method comprising the steps of:

  • (a) if the relational table is not normalized, creating a normalized table from the relational table and defining a relationship between the relational table and the normalized table, and if the relational table is normalized, referring to the relational table as the normalized table;

    (b) transforming the normalized table into an OLAP model; and

    (c) prior to step (a), if the relational table is normalized, but not by dependence between columns, redefining the relational table by a foreign key.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×