Method and system for dynamic templatized query language in software

• US 20050182758A1
• Filed: 12/08/2004
• Published: 08/18/2005
• Est. Priority Date: 12/08/2003
• Status: Active Grant

• Current Assignee: PayPal, Inc. (PayPal Holdings, Inc.)
• Original Assignee: eBay Inc.
• Inventors: Seitz, Greg, Kasten, Christopher J.
• Granted Patent: US 8,200,684 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 12/0808 with cache invalidating means G06F12/0815 takes precedence
• CPC Class Codes: G06F 12/0875 with dedicated cache, e.g. instruction or stack
• CPC Class Codes: G06F 12/12 Replacement control
• CPC Class Codes: G06F 12/128 adapted to multidimensional cache systems, e.g. set-associative, multicache, multiset or multilevel
• CPC Class Codes: G06F 16/2272 Management thereof
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/40 of multimedia data, e.g. slideshows comprising image and additional audio data retrieval of still image data G06F16/50; retrieval of audio data G06F16/60; retrieval of video data G06F16/70
• CPC Class Codes: G06F 2212/452 Instruction code
• CPC Class Codes: G06F 2212/465 Structured object, e.g. database record
• CPC Class Codes: G06F 9/5016 the resource being the memory
• CPC Class Codes: G06F 9/54 Interprogram communication
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A system to automatically generate query language in software is described. The system receives a request for data that is persistently stored in a database. The system selects a predefined query template from a number of query templates based on the request. The system utilizes the query template to receive content from at least one different source, the first source being a prototype data object. The system generates a query statement based on the query template that includes the content. Finally the system queries the database using the query statement to retrieve the requested data.

Claims

1. A method to automatically generate query language in software, the method including:

receiving a request for data that is persistently stored in a database;

selecting a predefined query template from a plurality of query templates based on the request;

receiving content from at least one of a plurality of different sources, the first source being a prototype data object;

generating a query statement based on the query template, the query statement including the content; and

querying the database using the query statement.

2. The method of claim 1, wherein the content includes a physical table name that is determined by a second source that includes a software routine that selects the physical table name from a plurality of physical table names.

3. The method of claim 1, wherein the content includes a set of columns that are determined by a second source that includes a software routine that selects the set of columns from a plurality of sets of columns.

4. The method of claim 1, wherein the content includes a set of columns and values that are determined by a second source that includes a software routine that selects the set of columns and values based on at least one of the attributes in a data object that have been modified and the attributes in the data object that have been loaded.

5. The method of claim 1, wherein the content includes specific query language expressions surrounding the binding of a value that is determined by a second source that includes a software routine that selects the specific query language expressions surrounding the binding of the value based on the type of operation being performed.

6. The method of claim 1, wherein the content includes specific query language expressions that is determined by a second source that includes a software routine that selects the specific query language expressions in place of a bind position based on the type of operation being performed.

7. The method of claim 1, wherein the content includes a SQL join language construct that is determined by a second source that includes a software routine that determines if the SQL join language construct is required based on columns determined during runtime.

8. The method of claim 1, wherein the receiving is performed by a data access layer.

9. The method of claim 1, wherein the query template includes any one of a group of query templates including a select query template, an update query template, an insert query template, a delete query template, and a PL/SQL block template.

10. A system to automatically generate query language in software, the system including:

a receiving module to receive a request for data that is persistently stored in a database;

a processing module to select a predefined query template from a plurality of query templates based on the request;

the processing module to receive content from at least one of a plurality of different sources, the first source being a prototype data object;

the processing module to generate a query statement based on the query template, the query statement to include the content; and

the processing module to query the database using the query statement.

11. The system of claim 10, wherein the content includes a physical table name that is determined by a second source that includes a software routine that selects the physical table name from a plurality of physical table names.

12. The system of claim 10, wherein the content includes a set of columns that are determined by a second source that includes a software routine that selects the set of columns from a plurality of sets of columns.

13. The system of claim 10, wherein the content includes a set of columns and values that are determined by a second source that includes a software routine that selects the set of columns and values based on at least one of the attributes in a data object that have been modified and the attributes in the data object that have been loaded.

14. The system of claim 10, wherein the content includes specific query language expressions surrounding the binding of a value that is determined by a second source that includes a software routine that selects the specific query language expressions surrounding the binding of the value based on the type of operation being performed.

15. The system of claim 10, wherein the content includes specific query language expressions that are determined by a second source that includes a software routine that selects the specific query language expressions in place of a bind position based on the type of operation being performed.

16. The system of claim 10, wherein the content includes a SQL join language construct that is determined by a second source that includes a software routine that determines if the SQL join language construct is required based on columns determined during runtime.

17. The system of claim 10, wherein the processing module is to receive in a data access layer.

18. The system of claim 10, wherein the query template includes any one of a group of query templates including a select query template, an update query template, an insert query template, a delete query template, and a PL/SQL block template.

19. A machine readable medium storing a set of instructions that, when executed by a machine, cause the machine to:

receive a request for data that is persistently stored in a database;

select a predefined query template from a plurality of query templates based on the request;

receive content from at least one of a plurality of different sources, the first source being a prototype data object;

generate a query statement based on the query template, the query statement including the content; and

query the database using the query statement.

20. A system to automatically generate query language in software, the system including:

a first means for receiving module to receive a request for data that is persistently stored in a database;

a second means for processing module to select a predefined query template from a plurality of query templates based on the request;

the second means for processing module to receive content from at least one of a plurality of different sources, the first source being a prototype data object;

the second means for generating a query statement based on the query template, the query statement including the content; and

the second means for querying the database using the query statement.