Patent ID: 8200684
Filing Date: 2012-06-12
Classification: G06F,Y10S

Abstract:
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 insert query template including a logical table name from a plurality of query templates based on the request; receiving first content from at least a first source of a plurality of different sources, the first source being a prototype data object that includes an attribute that is passed from the prototype data object as a hint to a query engine, the hint value being selected from a group of hints consisting of the attribute in the prototype data object and a hint hash table defined by metadata in the prototype data object; receiving second content from a second source, the second content including a physical table name that is identified by the second source based on both the logical table name included in the insert query template and second information received from an application domain, the first content including specific query language expressions that are determined by the second source of the plurality of different sources including a software routine that selects the specific query language expressions in place of a bind position based on a type of operation being performed; generating a query statement based on the insert query template, the query statement including the first content and the second content, the first content including the hint and the specific query language expressions; and querying the database using the query statement.