×

Systems and methods for optimizing database queries

  • US 8,583,593 B1
  • Filed: 11/18/2011
  • Issued: 11/12/2013
  • Est. Priority Date: 04/11/2005
  • Status: Active Grant
First Claim
Patent Images

1. A method of dynamically revising a query before processing by a relational database, the method comprising:

  • receiving, with a query management system, a query comprising one or more attributes, each of the one or more attributes related to data stored in two or more base tables of a relational database;

    accessing, with the query management system, an attribute view definition that defines an attribute view, the attribute view definition referencing a plurality of base tables of the relational database, including the two or more base tables, wherein the attribute view definition references more base tables than necessary for deriving the one or more attributes comprised in the query, wherein the one or more attributes in the query are a subset of attributes available in the attribute view;

    identifying, with the query management system, the one or more attributes in the query, wherein the identified one or more attributes are the one or more attributes in the query;

    determining, with the query management system, a set of unreferenced base tables from the plurality of base tables, wherein the unreferenced base tables do not store data used for calculating the one or more attributes of interest, wherein the accessing is performed prior to the determining;

    generating, with the query management system, a modified definition of the attribute view definition, the modified definition defining a temporary attribute view for processing the query, the modified definition excludes references to the set of unreferenced base tables; and

    electronically submitting, with the query management system, the query to the relational database for generation of the temporary attribute view using the modified definition and for execution of the query on the temporary attribute view,wherein the query management system comprises a computer processor and an electronic memory storage.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×