Automated relational schema generation within a...

Details Automated relational schema generation within a... Automated relational schema generation within a...

2004-11-30

2009-10-27

Stevens, Robert (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07610300

ABSTRACT:
Techniques are described for publishing multidimensional data from an enterprise software system. A relational database schema is automatically created for storing the multidimensional data. The database schema may be a relational star schema as described herein. The techniques may include processes for automatically producing the database schema based on the organization of the multidimensional data cube, and for populating the database schema with data from the data cube. The database schema may be used for reporting the multidimensional enterprise data, or may serve as a staging area to move the enterprise data toward a data warehouse within an enterprise software system. The reporting schema may support heterogeneous data types and heterogeneous formats. The reporting schema may also contain metadata that describes the schema, allowing for enhanced interpretation of the database schema. Also described is a process for automatically generating a reporting model from the database schema.

REFERENCES:
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5692181 (1997-11-01), Anand et al.
patent: 5734887 (1998-03-01), Kingberg et al.
patent: 5864857 (1999-01-01), Ohata et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5978788 (1999-11-01), Castelli et al.
patent: 5978796 (1999-11-01), Malloy et al.
patent: 6134541 (2000-10-01), Castelli et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6366922 (2002-04-01), Althoff
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6418427 (2002-07-01), Egilsson et al.
patent: 6477536 (2002-11-01), Pasumansky et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6510420 (2003-01-01), Cessna et al.
patent: 6594672 (2003-07-01), Lampson et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6636870 (2003-10-01), Roccaforte
patent: 6691102 (2004-02-01), Chang et al.
patent: 6714940 (2004-03-01), Kelkar
patent: 6768986 (2004-07-01), Cras et al.
patent: 6768995 (2004-07-01), Thier et al.
patent: 6801921 (2004-10-01), Tsuchida et al.
patent: 6829621 (2004-12-01), Keller
patent: 6965903 (2005-11-01), Agarwal et al.
patent: 7080084 (2006-07-01), Yoshimura et al.
patent: 7089266 (2006-08-01), Stolte et al.
patent: 7171427 (2007-01-01), Witkowski et al.
patent: 7181440 (2007-02-01), Cras et al.
patent: 7181450 (2007-02-01), Malloy et al.
patent: 7287218 (2007-10-01), Knotz et al.
patent: 7418438 (2008-08-01), Gould et al.
patent: 2002/0038306 (2002-03-01), Griffin et al.
patent: 2002/0073088 (2002-06-01), Beckmann et al.
patent: 2002/0078018 (2002-06-01), Tse et al.
patent: 2002/0087516 (2002-07-01), Cras et al.
patent: 2002/0087686 (2002-07-01), Cronk
patent: 2002/0129003 (2002-09-01), Bakalash et al.
patent: 2003/0004959 (2003-01-01), Kotsis et al.
patent: 2003/0182300 (2003-09-01), Anjur et al.
patent: 2003/0187830 (2003-10-01), Chang et al.
patent: 2003/0208506 (2003-11-01), Greenfield et al.
patent: 2004/0034616 (2004-02-01), Witkowski et al.
patent: 2004/0059724 (2004-03-01), Petculescu et al.
patent: 2004/0064349 (2004-04-01), Humenansky et al.
patent: 2004/0064433 (2004-04-01), Thier et al.
patent: 2004/0117379 (2004-06-01), Khatchatrian et al.
patent: 2004/0122646 (2004-06-01), Colossi et al.
patent: 2004/0122844 (2004-06-01), Malloy et al.
patent: 2004/0139061 (2004-07-01), Colossi et al.
patent: 2004/0181519 (2004-09-01), Anwar
patent: 2004/0193633 (2004-09-01), Petculescu et al.
patent: 2004/0236738 (2004-11-01), Thier et al.
patent: 2004/0243593 (2004-12-01), Stolte et al.
patent: 2005/0015360 (2005-01-01), Cras et al.
patent: 2005/0060300 (2005-03-01), Stolte et al.
patent: 2005/0149550 (2005-07-01), Berger et al.
patent: 2006/0010159 (2006-01-01), Mirchandani et al.
patent: 2006/0020619 (2006-01-01), Netz et al.
patent: 2006/0116859 (2006-06-01), Legault et al.
patent: 2006/0116976 (2006-06-01), Legault et al.
patent: 2007/0130116 (2007-06-01), Cras et al.
patent: WO 97/46958 (1997-12-01), None
patent: WO 01/29690 (2001-04-01), None
Colossi, Nathan, et al., “Relational Extensions for OLAP”, IBM Systems Journal, vol. 41, No. 4, © 2002, pp. 714-731.
Sapia, Carsten, et al., “Extending the E/R Model for the Multidimensional Paradigm”, Lecture Notes in Computer Science, vol. 1552, Springer-Verlag, Berlin/Heidelberg, © 1999, pp. 105-116.
Pedersen, Torben Bach, et al., “Multidimensional Database Technology”, Computer, vol. 34, No. 12, Dec. 2001, pp. 40-46.
Thalheim, Bernhard, “Component Construction of Database Schemes”, ER 2002, LNCS 2503, Springer-Verlag, Berlin, Germany, © 2002, pp. 20-34.
Rahm, Erhard, et al., “A Survey of Approaches to Automatic Schema Matching”, The VLDB Journal, vol. 10, © 2001, pp. 334-350.
Pedersen, Torben B., et al., “A Foundation for Capturing and Querying Complex Multidimensional Data”, Information Systems, vol. 26, © 2001, pp. 383-423.
Malinowski, Elzbieta, et al., “Representing Spatiality in a Conceptual Multidimensional Model”, GIS '04, Washington, DC, Nov. 12-13, 2004, pp. 12-21.
Kernighan, Brian W., et al., The C Programming Language, Prentice-Hall, Inc., Englewood Cliffs, NJ, © 1978, pp. 39-42 and 109.
“Cognos® Management Series Planning, Introduction to the Contributor Database,” 18 pages (2003).
“Cognos® Enterprise Planning Series Cognos Planning, Administration Guide,” Chapter 20: Administration Extensions, pp. 181-192 (2004).
“Reporting from the Contributor Data Structure,” 35 pages (Oct. 21, 2002).
Search Report and Written Opinion from corresponding PCT Application Serial No. PCT/IB2005/004139 mailed Aug. 3, 2006 (9 pages).
International Preliminary Report on Patentability from corresponding PCT Application Serial No. PCT/IB2005/004139 mailed Jun. 14, 2007 (5 pages).
Australian Examiner's Report from corresponding Australian Application No. 2005315255, mailed Oct. 7, 2008 (2 pages).
U.S. Appl. No. 12/185,574, filed Aug. 4, 2008 entitled “Automated Default Dimension Selection Within a Multidimensional Enterprise Software System,” Michael Gould et al., (US 2008/0307357).

Affiliated with

Also associated with

Rating

Automated relational schema generation within a... 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 relational schema generation within a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automated relational schema generation within a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4057143