System and method for providing result sets using EJB query language
AssigneeBEA Systems, Inc.
InventorsThorick Chow, Seth White
Life of this patent
Estimating the term…
Abstract
A system and method for accessing requested data in a database using result set objects. The invention also provides a set of enhancements to the EJB Query Language (“EJB QL”) for providing result sets using EJB QL and to efficiently access databases using select methods within Enterprise Java Beans. EJBQL language extensions allow for the selection and retrieval of result sets. Since the use of the invention is expressed in terms of object relational constructs defined in an EJB deployment, it allows for the retrieval of data from a database expressed in terms of the relationships defined in that EJB deployment.
Claims19
A method for accessing requested data in a database using beans, comprising the steps of:
- invoking a single bean select method of a bean query language with a query for requested data from a database, wherein the requested data includes data from multiple fields of the database corresponding to multiple bean types;
- translating the bean select method of the bean query language into a database language query and forwarding the query to the database in a database language;
- processing the query at the database to retrieve the requested data, including data from multiple fields of the database corresponding to multiple bean types;
- creating a single result set object in the bean query language and storing the requested data from multiple fields of the database corresponding to multiple bean types into the single result set object, wherein storing the data bypasses the steps of creating separate bean instances for the requested data and invoking individual get methods to retrieve multiple data fields, and wherein the result set object retains the relationships between the data corresponding to the original database schema;
- and
- providing access to the requested data in the result set object, wherein the result set object contains data from multiple fields of the database corresponding to multiple bean types.
A system for accessing requested data in a database on a computer readable storage medium using beans, comprising:
- a database that stores data on a computer readable storage medium;
- and
- an application server that includes logic for
- allowing a client to invoke a single bean select method of a bean query language with a query for requested data from a database, wherein the requested data includes data from multiple fields of the database corresponding to multiple bean types;
- translating the bean select method of the bean query language into a database language query and forwarding the query to the database in a database language;
- receiving the results of the query at the database to retrieve the requested data, including data from multiple fields of the database corresponding to multiple bean types;
- populating a single result set object in the bean query language with the requested data from multiple fields of the database corresponding to multiple bean types into the single result set object, wherein storing the data bypasses the steps of creating separate bean instances for the requested data and invoking individual net methods to retrieve multiple data fields, and wherein the result set object retains the relationships between the data corresponding to the original database schema;
- and
- providing access to the requested data in the result set object, wherein the result set object contains data from multiple fields of the database corresponding to multiple bean types.
A computer readable storage medium including instructions stored thereon which when executed cause the computer to perform the steps of:
- an application server that includes logic for
- allowing a client to invoke a single bean select method of a bean query language with a query for requested data from a database, wherein the requested data includes data from multiple fields of the database corresponding to multiple bean types;
- translating the bean select method of the bean query language into a database language query and forwarding the query to the database in a database language;
- receiving the results of the query at the database to retrieve the requested data, including data from multiple fields of the database corresponding to multiple bean types;
- populating a single result set object in the bean query language with the requested data from multiple fields of the database corresponding to multiple bean types into the single result set object, wherein storing the data bypasses the steps of creating separate bean instances for the requested data and invoking individual get methods to retrieve multiple data fields, and wherein the result set object retains the relationships between the data corresponding to the original database schema;
- and
- providing access to the requested data in the result set object, wherein the result set object contains data from multiple fields of the database corresponding to multiple bean types.
Dependencies are inferred from the claim text.