Mapping of an RDBMS schema onto a multidimensional data model

Details Mapping of an RDBMS schema onto a multidimensional data model Mapping of an RDBMS schema onto a multidimensional data model

2007-02-05

2010-02-16

Alam, Shahid A (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C709S227000

Reexamination Certificate

active

07664777

ABSTRACT:
A Relational Database Management System (RDBMS) having any arbitrary structure is translated into a multi-dimensional data model suitable for performing OLAP operations upon. If a relational table defining the relational model includes any tables with cardinality of 1,1 or 0,1, the tables are merged into a single table. If the relational table is not normalized, then normalization is performed and a relationship between the original table and the normalized table is created. If the relational table is normalized, but not by dependence between columns, such as in the dimension table in a snowflake schema, the normalization process is performed using the foreign key in order to generate the normalized table. Once the normalized table is generated, OLAP measures are derived from the normalized relational table by an automated method. In addition, OLAP dimensions are derived from the normalized relational table and the results of the OLAP measures derivation by an automated method according to the present invention. According to an aspect, it is possible to associate a member of a dimension to another member of the same or another dimension. According to another aspect, it is possible to create a new dimension of analysis, the members of which are all the different values that a scalar expression can take on. According to yet another aspect, it is possible to access the various instances of a Reporting Object as members in an OLAP dimension. According to the yet another aspect, it is possible to apply opaque filters or a combination of them to the data that underlies analysis.

REFERENCES:
patent: 5390296 (1995-02-01), Crandall et al.
patent: 5511186 (1996-04-01), Carhart et al.
patent: 5555403 (1996-09-01), Cambot et al.
patent: 5778375 (1998-07-01), Hecht
patent: 5852819 (1998-12-01), Beller
patent: 5905985 (1999-05-01), Malloy et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5937402 (1999-08-01), Pandit
patent: 5943668 (1999-08-01), Malloy et al.
patent: 5965858 (1999-10-01), Suzuki et al.
patent: 5995961 (1999-11-01), Levy et al.
patent: 6163774 (2000-12-01), Lore et al.
patent: 6182060 (2001-01-01), Hedgcock et al.
patent: 6260050 (2001-07-01), Yost et al.
patent: 6366922 (2002-04-01), Althoff
patent: 6385301 (2002-05-01), Nolting et al.
patent: 6408292 (2002-06-01), Bakalash et al.
patent: 6411681 (2002-06-01), Nolting et al.
patent: 6434544 (2002-08-01), Bakalash et al.
patent: 6519604 (2003-02-01), Acharya et al.
patent: 6556226 (2003-04-01), Gould et al.
patent: 6581068 (2003-06-01), Bensoussan et al.
patent: 6581154 (2003-06-01), Zaidi
patent: 6615202 (2003-09-01), Ding et al.
patent: 6631382 (2003-10-01), Kouchi et al.
patent: 6691140 (2004-02-01), Bogrett
patent: 6714979 (2004-03-01), Brandt et al.
patent: 6721405 (2004-04-01), Nolting et al.
patent: 6744866 (2004-06-01), Nolting et al.
patent: 6768995 (2004-07-01), Thier et al.
patent: 6859798 (2005-02-01), Bedell et al.
patent: 6999956 (2006-02-01), Mullins
Li, Zhaohui Kevin et al., “A Multimedia Information System for Document Authoring, Indexing and Presentation”, 1997 IEEE, pp. 302-307.
Vassiliadis, Panos “Modeling Multidimensional Databases, Cubes and Cube Operations”, Proceedings of the Tenth International Conference on Scientific and Statistical Database Management, Jul. 1-3, 1998, pp. 53-62.

Affiliated with

Also associated with

Rating

Mapping of an RDBMS schema onto a multidimensional data model does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Mapping of an RDBMS schema onto a multidimensional data model, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Mapping of an RDBMS schema onto a multidimensional data model will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4195784