Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-01-30
2007-01-30
Wong, Don (Department: 2163)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
10424003
ABSTRACT:
A method and mechanism for performing an operation based on multidimensional data in a relational database. A query is generated that includes a first set of instructions to select a portion of multidimensional data for inclusion in a relational cube and a second set of instructions to group the portion of multidimensional data in the relational cube using at least two or more levels of granularity of at least one dimension, thereby causing a relational cube to be generated. Based on a received request for an operation to be performed, the query is modified to include a third set of instructions that represent the requested operation; and the query is submitted to the relational database engine of the relational database management system. Thereafter, the operation is performed against the relational cube.
REFERENCES:
patent: 5799300 (1998-08-01), Agrawal et al.
patent: 5871019 (1999-02-01), Belohlavek
patent: 5890151 (1999-03-01), Agrawal et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5926818 (1999-07-01), Malloy
patent: 5987467 (1999-11-01), Ross et al.
patent: 6119103 (2000-09-01), Basch et al.
patent: 6163774 (2000-12-01), Lore et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6438537 (2002-08-01), Netz et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 6560594 (2003-05-01), Cochrane et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6684206 (2004-01-01), Chen et al.
patent: 2002/0091707 (2002-07-01), Keller
patent: 2002/0126545 (2002-09-01), Warren et al.
patent: 2002/0138353 (2002-09-01), Schreiber et al.
patent: 2002/0168621 (2002-11-01), Cook et al.
patent: 2002/0188507 (2002-12-01), Busche
patent: 2003/0097356 (2003-05-01), Lee et al.
patent: 2003/0145004 (2003-07-01), Egilsson et al.
patent: 2004/0034616 (2004-02-01), Witkowski et al.
Frank Ch. Eigler, Translating GraphLog to SQL, IBM Centre for Advanced Studies and University of Toronoto, Oct. 1994, pp. 1-13.
Oracle Corporation, “Oracle Express, Analyzer Briefing Designer's Guide, Release 6.3,” Sep. 1999, A70078-01, pp. 1-198 (text provided on CD-ROM).
Oracle Corporation, “Oracle Express, Database Administration Guide, Release 6.3.2.1,” Jan. 2001, Part No. A82800-02, pp. 1-380 (text provided on CD-ROM).
Ramsak, Frank, “Interactive ROLAP on Large Datasets: A Case Study with UB-Trees,” Database Engineering & Applications, Jul. 16-18, 2001, pp. 167-176.
Ross, Kenneth A., “Serving Datacube Tuples from Main Memory,” Scientific and Statistical Database Management, Jul. 26-28, 2000, pp. 182-195.
Dorman Gregory
Greenfield David
Witkowski Andrew
Black Linh
Brokaw Christoper J.
Hickman Palermo & Truong & Becker LLP
Oracle International Corporation
Wong Don
LandOfFree
Methods of navigating a cube that is implemented as 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 Methods of navigating a cube that is implemented as a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Methods of navigating a cube that is implemented as a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3787289