Data processing: database and file management or data structures – Database and file access – Database access control methods
Reexamination Certificate
2006-07-25
2010-11-09
Robinson, Greta L (Department: 2169)
Data processing: database and file management or data structures
Database and file access
Database access control methods
C707S713000, C707S752000, C707S769000
Reexamination Certificate
active
07831617
ABSTRACT:
A data access system which includes the capability to categorize subsets of the data in the data store, query result or other source of data as aggregate data or as detail data and also the ability to explicitly re-categorize the aggregate data as detail data, e.g., as part of execution of one or more processes on the data, so that operations that apply to detail data also apply to the re-categorized aggregate data. Additionally, automatic processes are provided for re-categorizing aggregate data as detail data based on data usage context, i.e., based upon how data in the data store is to be manipulated, processed and/or presented according to queries, commands, etc. received by the data store. Calculation of aggregations on top of already pre-aggregated data is enabled, and merging of designated aggregate data with detail data provides increased flexibility in a final dataset.
REFERENCES:
patent: 5781896 (1998-07-01), Dalal
patent: 5822751 (1998-10-01), Gray et al.
patent: 5832475 (1998-11-01), Agrawal et al.
patent: 6163774 (2000-12-01), Lore et al.
patent: 6247008 (2001-06-01), Cambot et al.
patent: 6295527 (2001-09-01), McCormack et al.
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6405207 (2002-06-01), Petculescu et al.
patent: 6480836 (2002-11-01), Colby et al.
patent: 6493700 (2002-12-01), Couch et al.
patent: 6996569 (2006-02-01), Bedell et al.
patent: 2002/0184187 (2002-12-01), Bakalash et al.
patent: 2003/0208506 (2003-11-01), Greenfield et al.
patent: 2005/0278738 (2005-12-01), Kaneko et al.
patent: 2005/0283494 (2005-12-01), Colossi et al.
patent: 2006/0020580 (2006-01-01), Dettinger et al.
International Search Report dated Jan. 4, 2008 for PCT Application Serial No. PCT/US2007/016331, 2 Pages.
J. Gray, A. Bosworth, A. Layman, and H. Pirahesh, “Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals,” Data Mining and Knowledge Discover, vol. 1, No. 1, 1997, pp. 29-53. ftp://ftp.research.microsoft.com/pub/tr/tr-97-32.doc.
S. Agarwal, R. Agrawal, P. M. Deshpande, A. Gupta, J. F. Naughton, R. Ramakrishnan, and S. Sarawagi. On the computation of multidimensional aggregates. In Proc. 22nd VLDB, pp. 506-521, Mumbai, Sep. 1996. http://citeseer.ist.psu.edu/agarwal96computation.html.
Craig S. Mullins, “Using CASE Expressions,” SQL Server Update (Xephon) Aug. 1999. http://www.craigsmullins.com/ssu—0400.htm.
Bruckner Robert M.
Hays Christopher A.
Wang Fang
Microsoft Corporation
Robinson Greta L
Wilcox James J
Workman Nydegger
LandOfFree
Re-categorization of aggregate data as detail data and... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Re-categorization of aggregate data as detail data and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Re-categorization of aggregate data as detail data and... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4169282