×

Extensibility in a database system

  • US 10,642,589 B2
  • Filed: 03/13/2017
  • Issued: 05/05/2020
  • Est. Priority Date: 03/13/2017
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • obtaining a user query in a structured query language, the user query comprising at least one query parameter for selecting data from a content database;

    parsing the user query to identify a skeletal query form of the user query in a first programming language and the at least one query parameter, wherein the skeletal query comprising at least one unresolved object and a function calling the at least one unresolved object;

    generating byte code defining a plurality of functions corresponding to the user query,interpreting the byte code using the at least one query parameter, thereby returning a result of the user query satisfying the at least one query parameter,generating machine code corresponding to the user query based on the byte code,executing the machine code corresponding to the user query using the at least one query parameter if the user query is called again, thereby returning a result of the user query satisfying the at least one query parameter;

    wherein the generating and executing machine code corresponding to the user query comprising;

    on a first pass through the skeletal query;

    binding each respective unresolved object to a respective placeholder object such that the function calls each respective placeholder object and each respective placeholder object is mapped to the respective unresolved object,delaying evaluation of the skeletal query until a second pass through the skeletal query;

    on a second pass through the skeletal query, obtaining machine code corresponding to a compiled version of the skeletal query by;

    sequentially obtaining machine code for each respective unresolved object as each respective placeholder is called in the skeletal query; and

    executing the machine code corresponding to the compiled version of the skeletal query, thereby performing at least one operation on the data of the content database.

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