Analytic enhancements to model clause in structured query...

Details Analytic enhancements to model clause in structured query... Analytic enhancements to model clause in structured query...

2011-07-12

2011-07-12

Alam, Shahid A (Department: 2167)

Data processing: database and file management or data structures

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

Data extraction, transformation, and loading

C707S769000

Reexamination Certificate

active

07979384

ABSTRACT:
A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.

REFERENCES:
patent: 5319777 (1994-06-01), Perez
patent: 5359724 (1994-10-01), Earle
patent: 5485608 (1996-01-01), Lomet et al.
patent: 5819282 (1998-10-01), Hooper et al.
patent: 5870760 (1999-02-01), Demers et al.
patent: 5943668 (1999-08-01), Malloy et al.
patent: 5978796 (1999-11-01), Malloy et al.
patent: 6298342 (2001-10-01), Graefe et al.
patent: 6317750 (2001-11-01), Tortolani et al.
patent: 6389410 (2002-05-01), Gupta
patent: 6434544 (2002-08-01), Bakalash et al.
patent: 6615241 (2003-09-01), Miller et al.
patent: 6622138 (2003-09-01), Bellamkonda et al.
patent: 6631371 (2003-10-01), Lei et al.
patent: 6985895 (2006-01-01), Witkowski et al.
patent: 7177855 (2007-02-01), Witkowski et al.
patent: 7761403 (2010-07-01), Witkowski et al.
patent: 2002/0059203 (2002-05-01), Witkowski et al.
patent: 2002/0107754 (2002-08-01), Stone
patent: 2004/0133567 (2004-07-01), Witkowski et al.
patent: 2004/0133568 (2004-07-01), Witkowski et al.
patent: 2007/0078826 (2007-04-01), Bozkaya et al.
patent: 2007/0192336 (2007-08-01), Iyer et al.
patent: 411161656 (1999-09-01), None
patent: WO 99/48029 (1999-09-01), None
Gray Jim et al., “Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals,” Feb. 26, 1996, IEEE, XP010158909, pp. 152-159.
Rittman, Mark, “The New Oracle 1Og 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.
Mohan, C. et al., “ARIES-RRH: Restricted Repeating of History in the ARIES Transaction Recovery Method,” Proceeding of the Seventh International Conference on Data Engineering, Apr. 18-20, 1991, IEEE 1991, pp. 718-727.
Lane, Paul, “Oracle Database Data Warehouses Guide”, 1Og Release 1(10.1), Oracle Corporation, Dec. 2003, 81 pages.
Haydu, John, “The SQL Model Clause of Oracle Database 10g”, Oracle Corporation, Aug. 2003, 20 pages.
J.M. Hellerstein and M. Stonebraker, “Predicate migration: Optimizing queries with expensive predicates,” Proceedings of ACM SIGMOD 2003, Washington DC, 1993.
Andrew Witkowski, et al., “Advanced SQL Modeling in RDBMS”, Oracle Corporation, ACM Transactions on Database Systems, vol. 30, No. 1, Mar. 2005, pp. 83-121.
U.S. Appl. No. 10/703,412, filed Nov. 6, 2003, Notice of Allowance, Mar. 11, 2010.

Affiliated with

Also associated with

Rating

Analytic enhancements to model clause in structured 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 Analytic enhancements to model clause in structured query..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Analytic enhancements to model clause in structured query... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2683538