×

Computer-implemented method and system for handling and transforming database queries in a fourth generation language

DC CAFC
  • US 8,498,996 B2
  • Filed: 11/03/2008
  • Issued: 07/30/2013
  • Est. Priority Date: 11/03/2008
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method for processing a query, comprising:

  • receiving a native syntax query requesting data stored in a non-native database that uses a non-native syntax, wherein the query is received at an application that is separate from the non-native database, wherein the query requests that the data be retrieved from the non-native database, wherein the query requests that a processing operation be performed on the requested data by the application, wherein the query includes one or more expressions, and wherein one or more of the expressions includes one or more functions;

    parsing the native syntax query, wherein parsing includes identifying a function within an expression that cannot be processed by the non-native database, wherein the function specifies the processing operation to be performed on the requested data by the application, wherein a plurality of labels are associated with the function and the expression, and wherein labels include constant labels and format labels;

    analyzing the function and the expression to determine a context of the function within the expression, wherein the context describes how the function is used within the expression;

    generating, using one or more data processors, a final expression query by obtaining a control string from an internal table for each of the plurality of labels associated with the function and the expression, wherein label modifiers are applied to format labels;

    transforming the native syntax query into an equivalent non-native syntax query, wherein transforming includes parsing and inserting the final expression query into the equivalent non-native syntax query using the function, the expression, and the context to translate the function and the expression into multiple functions and multiple expressions that are configured for processing by a non-native database system;

    transmitting the equivalent non-native syntax query to a non-native database system to generate results and to perform the processing operation on the generated results;

    receiving processed results from the non-native database system; and

    transmitting the processed results to a client application.

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