Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-12-27
2005-12-27
Rones, Charles (Department: 2164)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C345S215000, C345S215000
Reexamination Certificate
active
06980980
ABSTRACT:
A database architecture and method for processing data in a multidimensional database, including performing Web usage analysis. A summary cube contains the members of an upper level of a dimension and a detail cube contains a subset of the members of a lower level of the dimension partitioned therefrom based on a selected member of the upper level of the dimension. The detail cube also includes one or more sub-cubes containing aggregations of the first subset of the lower level members. An XML template implements a workflow to automatically create a second detail cube partitioned from the dimension based on another selected member of the upper level. Using XML metadata, the invention implements zoom in/zoom out events to navigate between information in the summary cube and information in the detail cubes.
REFERENCES:
patent: 6094651 (2000-07-01), Agrawal et al.
patent: 6134541 (2000-10-01), Castelli et al.
patent: 6330564 (2001-12-01), Hellerstein et al.
patent: 6708172 (2004-03-01), Wong et al.
patent: 2002/0099692 (2002-07-01), Shah et al.
patent: 2003/0115194 (2003-06-01), Pitts et al.
Agrawal, et al., “Modeling Multidimensional Databases,” Proceedings of the 13th International Conference on Data Engineering, 1997, 23 pages, Birmingham, U.K.
Dinter et al., “The OLAP Market: State of the Art and Research Issues,” Conference on Information and Knowledge Management, 1998, pp. 22-27, ACM Press, New York, NY.
Yang et al., “Accessing Data Cubes Along Complex Dimensions,” Conference on Information and Knowledge Management, 1999, pp. 73-78, ACM Press, New York, NY.
Pourabbas, et al., “Characterization of Hierarchies and Some Operators in OLAP Environment,” Conference on Information and Knowledge Management, 1999, pp. 54-59, ACM Press, New York, NY.
Hurtado et al., “Updating OLAP Dimensions,” Conference on Information and Knowledge Management, 1999, pp. 60-66, ACM Press, New York, NY.
Golfarelli et al., “A Methodological Framework for Data Warehouse Design,” Conference on Information and Knowledge Management, 1998, pp. 3-9, ACM Press, New York, NY.
Fu et al., “CubiST: A New Algorithm for Improving the Performance of Ad-hoc OLAP Queries,” Conference on Information and Knowledge Management, 2000, pp. 72-79, ACM Press, New York, NY.
Trujillo et al., “An Object Oriented Approach to Multidimensional Database Conceptual Modeling (OOMD),” Conference on Information and Knowledge Management, 1998, pp. 16-21, ACM Press, New York, NY.
Microsoft Corporation
Ortiz Belix M.
Rones Charles
Senniger Powers
LandOfFree
Summary-detail cube architecture using horizontal... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Summary-detail cube architecture using horizontal..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Summary-detail cube architecture using horizontal... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3510857