Method and system for operating on database queries
First Claim
1. A method of operating on database queries, comprising:
- identifying a parameterized input query in a first database query language, wherein the parameterized input query includes one or more parameter placeholders, each parameter placeholder defining a parameter name and a declared parameter type;
generating, for each parameter placeholder in the parameterized input query in the first database query language, a random value of the declared parameter type;
constructing a concrete instance of the parameterized input query in the first database query language, where the concrete instance of the parameterized input query replaces each parameter placeholder with the corresponding generated random value of the declared parameter type;
generating, from the concrete instance of the parameterized input query in the first database query language, a translated output query in a second database query language different from the first query language, the translated output query including the generated random value of the declared parameter type; and
replacing the generated random values within the translated output query in the second database query language with a placeholder value associated with the second database query language.
2 Assignments
0 Petitions
Accused Products
Abstract
The present disclosure involves systems, software, and computer implemented methods for operating on database queries. One example method includes identifying a parameterized input query in a first database query language. The parameterized input query includes one or more parameter placeholders. A random value is generated, for each parameter placeholder. A concrete instance of the parameterized input query in the first database query language is constructed. The concrete instance of the parameterized input query replaces each parameter placeholder with the corresponding generated random value. A translated output query in a second database query language is generated, from the concrete instance of the parameterized input query. The translated output query includes the generated random values. Each of the generated random values are replaced within the translated output query in the second database query language with a placeholder value associated with the second database query language.
-
Citations
20 Claims
-
1. A method of operating on database queries, comprising:
-
identifying a parameterized input query in a first database query language, wherein the parameterized input query includes one or more parameter placeholders, each parameter placeholder defining a parameter name and a declared parameter type; generating, for each parameter placeholder in the parameterized input query in the first database query language, a random value of the declared parameter type; constructing a concrete instance of the parameterized input query in the first database query language, where the concrete instance of the parameterized input query replaces each parameter placeholder with the corresponding generated random value of the declared parameter type; generating, from the concrete instance of the parameterized input query in the first database query language, a translated output query in a second database query language different from the first query language, the translated output query including the generated random value of the declared parameter type; and replacing the generated random values within the translated output query in the second database query language with a placeholder value associated with the second database query language. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 14, 15)
-
-
11. A system comprising:
-
one or more computers associated with an enterprise portal; and a computer-readable medium coupled to the one or more computers having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations comprising; identifying a parameterized input query in a first database query language, wherein the parameterized input query includes one or more parameter placeholders, each parameter placeholder defining a parameter name and a declared parameter type; generating, for each parameter placeholder in the parameterized input query in the first database query language, a random value of the declared parameter type; constructing a concrete instance of the parameterized input query in the first database query language, where the concrete instance of the parameterized input query replaces each parameter placeholder with the corresponding generated random value of the declared parameter type; generating, from the concrete instance of the parameterized input query in the first database query language, a translated output query in a second database query language different from the first query language, the translated output query including the generated random value of the declared parameter type; and replacing the generated random values within the translated output query in the second database query language with a placeholder value associated with the second database query language. - View Dependent Claims (12, 13)
-
-
16. A computer program product encoded on a non-transitory storage medium, the product comprising non-transitory, computer readable instructions for causing one or more processors to perform operations comprising:
-
identifying a parameterized input query in a first database query language, wherein the parameterized input query includes one or more parameter placeholders, each parameter placeholder defining a parameter name and a declared parameter type; generating, for each parameter placeholder in the parameterized input query in the first database query language, a random value of the declared parameter type; constructing a concrete instance of the parameterized input query in the first database query language, where the concrete instance of the parameterized input query replaces each parameter placeholder with the corresponding generated random value of the declared parameter type; generating, from the concrete instance of the parameterized input query in the first database query language, a translated output query in a second database query language different from the first query language, the translated output query including the generated random value of the declared parameter type; and replacing the generated random values within the translated output query in the second database query language with a placeholder value associated with the second database query language. - View Dependent Claims (17, 18, 19, 20)
-
Specification