Performing spreadsheet-like calculations in a database system

Details Performing spreadsheet-like calculations in a database system Performing spreadsheet-like calculations in a database system

2006-01-10

2006-01-10

Ali, Mohammad (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

06985895

ABSTRACT:
A method and system for performing spreadsheet-like operations in a database system is described herein. As explained, a database language is extended to introduce new clauses (“spreadsheet-like clauses”), for defining and executing spreadsheet-like operations on data contained within a RDBMS. According to one aspect of the invention, in response to receiving a database query that specifies an operation for manipulating data, data from a relational structure is retrieved and stored in a non-relational structure that can be addressed as a multi-dimensional array. The operation specified in the database query is the performed on then data.

REFERENCES:
patent: 5319777 (1994-06-01), Perez
patent: 5359724 (1994-10-01), Earle
patent: 5819282 (1998-10-01), Hooper et al.
patent: 5943668 (1999-08-01), Malloy et al.
patent: 5978796 (1999-11-01), Malloy et al.
patent: 6317750 (2001-11-01), Tortolani et al.
patent: 6434544 (2002-08-01), Bakalash et al.
patent: 6615241 (2003-09-01), Miller et al.
patent: 2004/0133567 (2004-07-01), Witkowski et al.
patent: 2004/0133568 (2004-07-01), Witkowski et al.
patent: 411161656 (1999-09-01), None
patent: WO 99/48029 (1999-09-01), None
Jim Gray et al., “Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals,” Feb. 26, 1996, IEEE, XP010158909, pp. 152-159.
Mark Rittman, “The New Oracle 10g SQL MODEL Clause,”Breaking Oracle News, http://dba-oracle.com/oracle—news/2004—1—15—rittman.htm, data retrieved Apr. 8, 2004, pp. 1-4.
European Patent Office, “Communication pursuant to Article 96(2) EPC,” Aug. 22, 2004, 4 pages.
“New Claims, (Clean Copy),” Current claims from International Application No. 01984272.3, pp. 48-50.
Copy of Invitation pursuant to Article 96(2) and Rule 51(2) EPC from corresponding European case 01984272.3.
Copy of current claims of corresponding European case 01984272.3.

Affiliated with

Also associated with

Rating

Performing spreadsheet-like calculations in a database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Performing spreadsheet-like calculations in a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Performing spreadsheet-like calculations in a database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3570002