SYSTEMS AND METHODS FOR PROGRAMMATIC GENERATION DATABASE STATEMENTS
First Claim
Patent Images
1. A computer system comprising:
- a computer database comprising a plurality of data tables;
a computer device that executes an application that requires data from the database; and
a code generation engine in communication with the computer device and the database, wherein the code generation engine comprises a processor circuit, a memory circuit, and a metadata database comprising computer database metadata, wherein the code generation engine is programmed to translate a data request from the application, the data request being in a first language, to one or more data queries of the data tables of the computer database, wherein the one or more data queries are in a second language that is different from the first language.
35 Assignments
0 Petitions
Accused Products
Abstract
Computer-based systems and methods for programmatically generating code, such as Structure Query Language (SQL) code, to perform an operation on a database. A code generation engine, referred to herein as an Alchemy engine, receives a request in a first language, such as an XML-based language, and translates the request into a second language, such as an SQL-based language. The translation process utilizes information stored in a metadata database.
38 Citations
18 Claims
-
1. A computer system comprising:
-
a computer database comprising a plurality of data tables; a computer device that executes an application that requires data from the database; and a code generation engine in communication with the computer device and the database, wherein the code generation engine comprises a processor circuit, a memory circuit, and a metadata database comprising computer database metadata, wherein the code generation engine is programmed to translate a data request from the application, the data request being in a first language, to one or more data queries of the data tables of the computer database, wherein the one or more data queries are in a second language that is different from the first language. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer-implemented method for retrieving data from a database, the method comprising:
-
storing data in a computer database comprising a plurality of data tables; receiving from an application a data request in a first language; and translating with a code generation engine the data request to one or more data queries of the database, wherein the one or more data queries are in a second language that is different from the first language, and wherein the code generation engine comprises a processor circuit, a memory circuit, and a metadata database comprising computer database metadata. - View Dependent Claims (8, 9, 10, 11, 12, 13)
-
-
14. A computer readable medium having instructions stored thereon which when executed by a processor cause the processor to:
-
store data in a computer database comprising a plurality of data tables; receive from an application a data request in a first language; and translate the data request to one or more data queries of the database, wherein the one or more data queries are in a second language that is different from the first language. - View Dependent Claims (15, 16, 17)
-
-
18. A computer system comprising:
-
means for storing data in a computer database comprising a plurality data tables; means for executing an application on a computer device that requires data from the database; means for generating a data request with the application, the data request generated in a first language; and means for translating the data request to one or more data queries of the database, wherein the one or more data queries are in a second language that is different from the first language.
-
Specification