Automated latent star schema discovery tool

Details Automated latent star schema discovery tool Automated latent star schema discovery tool

2008-04-22

2010-12-21

Trujillo, James (Department: 2159)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

Using a denormalized schema

C707S804000

Reexamination Certificate

active

07856416

ABSTRACT:
A method, computer program product, and data processing system for computer-aided design of multidimensional data warehouse schemas are disclosed. A preferred embodiment of the present invention provides a software tool for identifying a latent star schema structure within an existing database. This software tool performs a heuristic analysis of the existing database schema to locate potential keys and measurement fields. Database tables within the existing schema are scored heuristically as to their suitability as fact tables based on the key candidates and measurement fields. For each fact table, other tables from the existing schema are identified as possible dimension tables. Data from the database is then used to test the suitability of the fact tables and dimension tables. The identified fact tables and their associated dimension tables are then reported to the user to reveal a basic star schema structure, which can be used as a basis for further design.

REFERENCES:
patent: 6778996 (2004-08-01), Roccaforte
patent: 6829621 (2004-12-01), Keller
patent: 7058640 (2006-06-01), Le
patent: 7716170 (2010-05-01), Farag
patent: 2002/0107840 (2002-08-01), Rishe
patent: 2003/0115211 (2003-06-01), Chen et al.
patent: 2003/0120651 (2003-06-01), Bernstein et al.
patent: 2004/0260715 (2004-12-01), Mongeon et al.
patent: 2005/0004918 (2005-01-01), Platt
patent: 2005/0050069 (2005-03-01), Vaschillo et al.
patent: 2006/0085489 (2006-04-01), Tomic et al.
patent: 2006/0206512 (2006-09-01), Hanrahan et al.
patent: 2006/0242142 (2006-10-01), Coen et al.
patent: 2004112301 (2004-12-01), None

Affiliated with

Also associated with

Rating

Automated latent star schema discovery tool does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Automated latent star schema discovery tool, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automated latent star schema discovery tool will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4203566