US6496833B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for generating code for query object interfacing
Assignee: Oracle America Inc
•
Filing: 1999-11-01
•
Granted: 2002-12-17
•
Expires: 2019-11-01
Abstract
Abstract A query object generator tool is used to generate interface definitions and source code which implement a database query object. The tool allows a client to construct a query object without being familiar with the underlying database language and without being concerned with programming details such as concurrency problems and connection management. The tool consists of an internal state object which represents the query object, including information which can be saved to reconstruct the query object at a later date, and code generator objects which generate the code required to implement the query object defined by the internal state object. In a preferred embodiment, the code generator objects are arranged in a hierarchy so that a generator object can be instantiated which generator object is specific to the database to be accessed and the language to which the implementation is targeted. An optional graphic user interface (GUI) may also be provided to allow a user to interact with the tool.
Inventors
- 👤 Robert N. Goldberg
- 👤 Gloria Y. Lam
- 👤 Chung Le
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 02:02
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; G06F16/2423; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 26
Claim 1
Independent Claim
120 words
A system for generating interface definitions and source code which implement a query object for accessing a database using a predetermined programming language in a computer having a memory, the system comprising: an input mechanism which receives an input query from a user; a query translator which translates query commands in the input query to database commands used with the database; and at least one code generator class in the memory, which contains methods which generate the source code required to implement the query object, the code generator class generating source code that is specific to the database to be accessed and the programming language and that uses the database commands to generate the interface definitions and the source code.
Claim 2
Independent Claim
120 words
A system for generating interface definitions and source code which implement a query object for accessing a database using a predetermined programming language in a computer having a memory, the system comprising: an input mechanism which receives an input query from a user; a query translator which translates query commands in the input query to database commands used with the database; and at least one code generator class in the memory, which contains methods which generate the source code required to implement the query object, the code generator class generating source code that is specific to the database to be accessed and the programming language and that uses the database commands to generate the interface definitions and the source code.
Claim 3
Dependent Claim
26 words
A system according to claim 1 further comprising a display mechanism which generates a graphic user interface to allow the user to interact with the system.
Claim 4
Dependent Claim
21 words
A system according to claim 2 wherein the graphic user interface receives from the user input queries expressed as text strings.
Claim 5
Dependent Claim
23 words
A system according to claim 1 further comprising an internal state object in the memory which internal state object represents the query object.
Claim 6
Dependent Claim
25 words
A system according to claim 4 wherein the internal state object includes configuration information which can be saved and retrieved to reconstruct the query object.
Claim 7
Dependent Claim
56 words
A system according to claim 1 further comprising selected implementation logic and a code generator mechanism which instantiates the code generator object in the memory and wherein the code generator object generates both interface code to allow a client to access the query object and code which implements the query object for the selected implementation logic.
Claim 8
Dependent Claim
31 words
A system according to claim 1 further comprising a database schema access object in the memory which contains methods for accessing the database and extracting database schema information from the database.
Claim 9
Dependent Claim
42 words
A system according to claim 7 further comprising a display mechanism which generates a graphic user interface to allow the user to interact with the system and wherein the extracted database schema are displayed to the user using the graphic user interface.
Claim 10
Dependent Claim
32 words
A system according to claim 1 wherein each method which generates the source code required to implement the query object comprises a template which generates a plurality of predefined source code statements.
Claim 11
Dependent Claim
47 words
A system according to claim 9 wherein the query object comprises a plurality of queries and wherein each method which generates the code required to implement the query object further comprises a section which generates a predefined source code statement for each query in the query object.
Claim 12
Dependent Claim
31 words
A system according to claim 1 wherein each of the plurality of code generators comprises methods for generating build scripts for building a query object from the query object source code.
Claim 13
Independent Claim
121 words
A method for generating interface definitions and source code which implement a query object for accessing a database using a predetermined programming language in a computer having a memory, the method comprising the steps of: (a) receiving an input query from a user; (b) translating query commands in the input query to database commands used with the database; and (c) creating a plurality of code generator classes in the memory, each of which contains methods which generate the source code required to implement the query object, the code generator classes generating source code that is specific to the database to be accessed and the programming language and that uses the database commands to generate the interface definitions and the source code.
Claim 14
Independent Claim
121 words
A method for generating interface definitions and source code which implement a query object for accessing a database using a predetermined programming language in a computer having a memory, the method comprising the steps of: (a) receiving an input query from a user; (b) translating query commands in the input query to database commands used with the database; and (c) creating a plurality of code generator classes in the memory, each of which contains methods which generate the source code required to implement the query object, the code generator classes generating source code that is specific to the database to be accessed and the programming language and that uses the database commands to generate the interface definitions and the source code.
Claim 15
Dependent Claim
30 words
A method according to claim 12 further comprising the step of: (d) generating a graphic user interface on a display mechanism to allow the user to interact with the system.
Claim 16
Dependent Claim
31 words
A method according to claim 13 wherein step (d) further comprises the step of: (d1) using the graphic user interface to receive from the user input queries expressed as text strings.
Claim 17
Dependent Claim
28 words
A method according to claim 12 further comprising the step of: (e) creating an internal state object in the memory which internal state object represents the query object.
Claim 18
Dependent Claim
35 words
A method according to claim 12 wherein step (e) further comprises the step of: (e1) creating an internal state object which includes configuration information which can be saved and retrieved to reconstruct the query object.
Claim 19
Dependent Claim
59 words
A method according to claim 12 further comprising the step of: (f) instantiating a code generator object in the memory for the database and selected implementation logic and wherein the code generator object generates both interface code to allow a client to access the query object and source code which implements the query object for the selected implementation logic.
Claim 20
Dependent Claim
37 words
A method according to claim 12 further comprising the step of: (g) creating a database schema access object in the memory which object contains methods for accessing the database and extracting database schema information from the database.
Claim 21
Dependent Claim
45 words
A method according to claim 18 further comprising the step of: (h) generating a graphic user interface on a display mechanism to allow the user to interact with the system; and (i) displaying the extracted database schema to the user using the graphic user interface.
Claim 22
Dependent Claim
25 words
A method according to claim 12 wherein step (c) comprises the step of: (c1) generating a plurality of predefined source code statements with a template.
Claim 23
Dependent Claim
37 words
A method according to claim 20 wherein the query object comprises a plurality of queries and wherein step (c) comprises the steps of: (c2) generating a predefined source code statement for each query in the query object.
Claim 24
Dependent Claim
28 words
A method according to claim 12 wherein step (c) comprises the step of: (c3) generating build scripts for building a query object from the query object source code.
Claim 25
Dependent Claim
130 words
A computer program product for generating interface definitions and source code which implement a query object for accessing a database using a predetermined programming language in a computer having a memory, the computer program product comprising a computer usable medium having computer readable program code thereon including: program code which receives an input query from a user; program code which translates query commands in the input query to database commands used with the database; and a plurality of code generator classes, each of which contains methods which generate the code required to implement the query object, the code generator classes generating source code that is specific to the database to be accessed and the programming language and uses the database commands to generate the interface definitions and the source code.
Claim 26
Dependent Claim
130 words
A computer program product for generating interface definitions and source code which implement a query object for accessing a database using a predetermined programming language in a computer having a memory, the computer program product comprising a computer usable medium having computer readable program code thereon including: program code which receives an input query from a user; program code which translates query commands in the input query to database commands used with the database; and a plurality of code generator classes, each of which contains methods which generate the code required to implement the query object, the code generator classes generating source code that is specific to the database to be accessed and the programming language and uses the database commands to generate the interface definitions and the source code.
References Cited (Backward Citations)
US5504885A
Cited
US5499371A
Cited
US5487141A
Cited
US5819282A
Cited
US5644764A
Cited
US6260078B1
Cited
US6081808A
Cited
US6223184B1
Cited
US6006224A
Cited
US6212672B1
Cited
US6047284A
Cited
US5937409A
Cited
US6076092A
Cited
US5953526A
Cited
US6282547B1
Cited
US6263328B1
Cited
US6199195B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-12-16 | 2006-06-17 | 2006-12-17 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-12-16 | 2010-06-17 | 2010-12-17 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-12-16 | 2014-06-17 | 2014-12-17 | $7700.00 | Window Closed / Lapsed |