Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2006-03-02
2010-11-23
Rones, Charles (Department: 2164)
Data processing: database and file management or data structures
Database and file access
Query optimization
Reexamination Certificate
active
07840553
ABSTRACT:
Systems, methods, computer-readable media and other embodiments are provided that relate to processing database queries. In one embodiment, a query analysis logic can be configured to analyze a query to identify multiple instances of the same table. Instance numbering for the multiple table instances can then be performed using the query structure such that equivalent queries will likely get the same instance number assignments to improve materialized view recommendations for queries.
REFERENCES:
patent: 5960423 (1999-09-01), Chaudhuri et al.
patent: 6275818 (2001-08-01), Subramanian et al.
patent: 6347314 (2002-02-01), Chidlovskii
patent: 6356889 (2002-03-01), Lohman et al.
patent: 6513029 (2003-01-01), Agrawal et al.
patent: 6721747 (2004-04-01), Lipkin
patent: 2002/0073236 (2002-06-01), Helgeson et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2003/0182282 (2003-09-01), Ripley
patent: 2004/0122804 (2004-06-01), Zhang et al.
patent: 2005/0125427 (2005-06-01), Dageville et al.
patent: 2005/0256835 (2005-11-01), Jenkins et al.
Kimberly Floss, Getting Good Advice About Access, (As Published in Oracle Magazine), Jul. Aug. 2004, pp. 1-4, Oracle Technology Network, Oracle Corp., Redwood Shores, CA.
Dr. Lilian Hobbs, Oracle Materialized Views & Query Rewrite, (An Oracle White Paper), May 2005, pp. 1-24, Oracle Corp., Redwood Shores, CA.
Ramakrishnan et al., “Database Management Systems”, Third Edition, McGraw-Hill, 2003.
Chaudhuri, “An Overview of Query Optimization in Relational Systems” Proceedings of the Seventeenth ACM SIGACT-SIGMOD-SIGART Symposium on . . . , p. 34-42; Seattle, WA; 1998; ACM.
U.S. Office Action dated May 9, 2007 for U.S. Appl. No. 11/287,622, filed Nov. 28, 2005. (pp. 1-14).
USPTO Non-Final Office Action in co-pending U.S. Appl. No. 11/287,622, filed Nov. 28, 2005, having a mailing date of Jul. 29, 2008.
Chong, et. al., “An Efficient SQL-based RDF Querying Scheme”, Proceedings of the 31st International Conference on Very Large Databases 2005, pp. 1216-1227, Aug. 30-Sep. 2, 2005 ACM.
U.S. Office Action in co-pending U.S. Appl. No. 11/287,622, and entitled “Functional-Based Index Tuning for Queries With Expressions” having a date of mailing of Feb. 4, 2009.
DBASupport.com: http/www.DBAsupport.com/http://www.dbasupport.com/oracle/ora8/fbi.shtml-, Accessed Sep. 26, 2007, Jupitermedia Co. 2007 (pp. 1-8).
US Patent Office: Office Action from U.S. Appl. No. 11/287,622; dated Oct. 1, 2007; pp. 1-15 & cv:).
Kraguljac & Kalnay LLC
Oracle International Corp.
Quader Fazlul
Rones Charles
LandOfFree
Recommending materialized views for queries with multiple... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Recommending materialized views for queries with multiple..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Recommending materialized views for queries with multiple... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4172166