Method for extracting data from a relational database using...

Details Method for extracting data from a relational database using... Method for extracting data from a relational database using...

2005-12-13

2005-12-13

Ali, Mohammad (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

06976015

ABSTRACT:
A database manager and a corresponding method for having a database manager extract information from a relational database having, e.g., a star configuration (i.e. having a hub table and related so-called dimension tables) in response to what is called a joining query (one that would require that dimension tables be joined to the hub table), and, in addition, a query according to the invention. The method includes the steps of: having the database manager provide an alias table for a field from at least one dimension table that would be joined to the hub table according to the joining query, the alias table including each value of the field occurring in the dimension table (the aliased field) and also including an alias for each value of the aliased field; and having the database manager transform the joining query into a reduced query in which the aliased field is replaced by the alias.

REFERENCES:
patent: 5519859 (1996-05-01), Grace
patent: 6052681 (2000-04-01), Harvey
patent: 6189004 (2001-02-01), Rassen et al.
patent: 6532470 (2003-03-01), Cochrane et al.
patent: 6609123 (2003-08-01), Cazemier et al.
A. Netz, M. Bower, P. Turner, Newsgroup thread:comp.databases.ola, Subject: “Essbase SQL Interface,” Jun. 19, 2000.
“Hyperion® Essbase® Data Mart Design Approaches,” Hyperion Solutions Corporation, Nov. 2000.

Affiliated with

Also associated with

Rating

Method for extracting data from a relational database using... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for extracting data from a relational database using..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for extracting data from a relational database using... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3520095