Layout aware calculations

Details Layout aware calculations Layout aware calculations

2011-01-25

2011-01-25

Ehichioya, Fred I (Department: 2156)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

C707S726000, C707S771000, C707SE17128, C707S999004

Reexamination Certificate

active

07877348

ABSTRACT:
A method for analyzing data from a database using an analytic database function includes receiving a selection of measured items from a user, receiving a placement item from the user, and determining a partitioning of the selection of measured items from the placement item. A placement item can be a column, a row, or an axis. A template associated with the analytic database function is adapted to define at least one partitioning relative to the placement item. The template is further adapted to define an ordering parameter for the analytic database function and optionally an aggregation level for the analytic database function. A database query is created with the partitioning. The database query can be an SQL statement.

REFERENCES:
patent: 5713020 (1998-01-01), Reiter et al.
patent: 5832475 (1998-11-01), Agrawal et al.
patent: 5970493 (1999-10-01), Shoup et al.
patent: 2004/0006574 (2004-01-01), Witkowski et al.
patent: 2004/0128289 (2004-07-01), Cochrane et al.
Ed Kosciuszko, Analytical Functions in Oracle 8i, Dec. 17, 2001, SeQuel Consulting, pp. 1-34.
Koutsoukis et al., Adapting on-line analytical processing for decision modelling: the interaction of information and decision technologies, 1999 Elsevier, pp. 1-30.
Iteliano et al., A Hybrid Model for Data Synchronism in Data Warehouse Project, 2003 IEEE, pp. 1-10.
Rauber et al., An Architecture for Modular On-Line Analytical Processing Systems: Supporting Distributed and Parallel Query Processing Using Co-operating COBRA Objects, 2002, pp. 1-5.
Ed Kosciuszko, Analytical Functions in Oracle 8i, Dec. 17, 2001, pp. 1-34, SeQuel Consulting.
A. Billington, Introduction to 8i Analytic Functions, Apr. 2002, pp. 1-9, Quest Software.

Affiliated with

Also associated with

Rating

Layout aware calculations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Layout aware calculations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Layout aware calculations will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2632922