Defining sub-cube scope based upon a query

Details Defining sub-cube scope based upon a query Defining sub-cube scope based upon a query

2008-02-04

2011-12-20

Brown, Sheree (Department: 2163)

Data processing: database and file management or data structures

Database and file access

C707S600000, C707S737000

Reexamination Certificate

active

08082239

ABSTRACT:
Technologies are described herein for defining the scope of a sub-cube based upon a database query. A request is received to perform a query of a multi-dimensional database, such as a cube, stored at a server computer. In response to the request, the scope for a sub-portion, called a sub-cube, of the multi-dimensional database is determined based upon the query. The scope of the sub-cube may be determined by identifying the minimum sub-portion of the cube necessary to perform the query. Once the scope has been determined, the sub-cube is generated at the server computer and transmitted to a client computer. The client computer stores the sub-cube locally and performs the requested database query on the sub-cube stored at the client computer. A user interface may be provided through which a user can modify the scope of the sub-cube determined based upon the query.

REFERENCES:
patent: 5799300 (1998-08-01), Agrawal et al.
patent: 6108647 (2000-08-01), Poosala et al.
patent: 6477536 (2002-11-01), Pasumansky et al.
patent: 6484179 (2002-11-01), Roccaforte
patent: 6636870 (2003-10-01), Roccaforte
patent: 6778996 (2004-08-01), Roccaforte
patent: 6917940 (2005-07-01), Chen et al.
patent: 6980980 (2005-12-01), Yeh
patent: 7660811 (2010-02-01), Netz et al.
patent: 2004/0103092 (2004-05-01), Tuzhilin et al.
patent: 2004/0122646 (2004-06-01), Colossi et al.
patent: 2004/0237029 (2004-11-01), Medicke et al.
patent: 2005/0278290 (2005-12-01), Bruce et al.
patent: 2006/0010139 (2006-01-01), Netz et al.
patent: 2006/0085444 (2006-04-01), Sarawgi et al.
patent: 2006/0218157 (2006-09-01), Sourov et al.
patent: 2006/0229057 (2006-10-01), Farrugia et al.
patent: 2007/0022120 (2007-01-01), Huang et al.
patent: 2007/0118516 (2007-05-01), Li et al.
patent: 2007/0203933 (2007-08-01), Iversen et al.
patent: 2008/0288524 (2008-11-01), Dumitru et al.
patent: WO2005106711 (2005-11-01), None
Malcolm, “Business Intelligence in SQL Server 2008”, Aug. 2007, Microsoft Corporation, pp. 16.
Pay, “DB2 Cube Views Version 8.2 Best Practices”, IBM, Feb. 10, 2005, pp. 1-11.
Soni, “OLAP Distinct Counts and Performance Analysis”, Microsoft Corporation, 2007, pp. 1-23.

Affiliated with

Also associated with

Rating

Defining sub-cube scope based upon a query does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Defining sub-cube scope based upon a query, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Defining sub-cube scope based upon a query will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4307613