×

SQL query construction using durable query components

  • US 7,752,197 B2
  • Filed: 10/03/2002
  • Issued: 07/06/2010
  • Est. Priority Date: 10/03/2002
  • Status: Expired due to Term
First Claim
Patent Images

1. A computer implemented method for generating a reusable query component, comprising:

  • for each of a plurality of reusable query components;

    (1) specifying, via a graphical user interface (GUI), one or more query conditions to include in the reusable query component, wherein the reusable query component comprises at least the one or more query conditions, wherein each condition provides a portion of a database query in a query language, wherein the condition operates to filter results to be returned by the database query, wherein each query condition is an abstract query condition defined by one or more logical fields and wherein each condition includes;

    a field name referencing a field in a database,a comparison operator, anda comparison value to which one or more database values for the field are compared, based on the comparison operator, to determine whether the condition is satisfied for a given database value corresponding to the field;

    (ii) specifying, via the GUI, a name to identify the reusable query component;

    (iii) specifying, via the GUI, an access level to assign to the reusable query component, wherein the access level indicates a privilege level required for a user in order for the reusable query component to be made available to the user for use in building in a database query;

    (iv) associating the reusable query component with the specified name and the specified access level;

    (v) storing the reusable query component, the specified access level, and the specified name;

    wherein the storing comprises storing XML representations of the one or more query conditions, the specified access level, and the specified name in a database for later retrieval; and

    receiving a request to include at least two of the plurality of reusable query components in an abstract query, wherein the request specifies the respective name of the at least two reusable query components; and

    upon determining that the request satisfies the respective specified access level for the reusable query components, including all of the respective query conditions of the reusable query components in the abstract query, responsive to the request.

View all claims
  • 5 Assignments
Timeline View
Assignment View
    ×
    ×