BOOK OF BUSINESS MECHANISM
First Claim
1. A method for accessing a database from an application, the method comprising:
- receiving, at one or more computer systems, information defining a hierarchy of business data containers for the application, each business data container in the hierarchy of business data containers limiting data access at the application to a subset of data stored in the database according to predetermined criteria, each business data container having;
one or more entries configured to cache first data obtained from the database at the application according to a data schema associated with the business data container, andan index for the application indexing the one or more entries using or more key attributes of second data stored in the database;
receiving, at the one or more computer systems, information indicative of a selection of a user of a graphical user interface provided by the application of a visual representation of a business data container in the hierarchy of business data containers;
receiving, at the one or more computer systems, a query associated with a predefined task presented by the application for the selected business data container;
determining, with the one or more processors associated with one or more computer systems, a data domain for the selected business data container;
determining, with the one or more processors associated with one or more computer systems, the index for the selected business data container;
generating, with the one or more processors associated with the one or more computer systems, a query plan based on the query, the data domain, and the index associated with the selected business data container; and
executing, with the one or more processors associated with the one or more computer systems, the query plan to obtain a subset of the second data from the database.
0 Assignments
0 Petitions
Accused Products
Abstract
A “Book of Business” (or Book) is a set of business domain data of one or more book types. This set of data is identified by a “driving condition” or quality. A driving condition typically arises from a business practice, and may be further qualified by local conditions. Accordingly, data may be organized based on local activities or conditions that may not be explicitly stored in a database. In one embodiment, a method for querying the database includes identifying data in a database. The data is organized into one or more segments. A book of business associated with a segment in the one or more segments is then generated. The book of business includes a set of references to the data organized into the segment. A query plan may be determined based on the book of business. A set of results may then be generated based on the query plan.
9 Citations
20 Claims
-
1. A method for accessing a database from an application, the method comprising:
-
receiving, at one or more computer systems, information defining a hierarchy of business data containers for the application, each business data container in the hierarchy of business data containers limiting data access at the application to a subset of data stored in the database according to predetermined criteria, each business data container having; one or more entries configured to cache first data obtained from the database at the application according to a data schema associated with the business data container, and an index for the application indexing the one or more entries using or more key attributes of second data stored in the database; receiving, at the one or more computer systems, information indicative of a selection of a user of a graphical user interface provided by the application of a visual representation of a business data container in the hierarchy of business data containers; receiving, at the one or more computer systems, a query associated with a predefined task presented by the application for the selected business data container; determining, with the one or more processors associated with one or more computer systems, a data domain for the selected business data container; determining, with the one or more processors associated with one or more computer systems, the index for the selected business data container; generating, with the one or more processors associated with the one or more computer systems, a query plan based on the query, the data domain, and the index associated with the selected business data container; and executing, with the one or more processors associated with the one or more computer systems, the query plan to obtain a subset of the second data from the database. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. The method of claim 7 wherein generating, with the one or more processors associated with the one or more computer systems, the query plan based on the query, the data domain, and the index associated with the selected business data container further comprises generating the query plan based on the ownership information.
-
8. A non-transitory computer-readable medium storing computer-executable code for accessing a database from an application, the non-transitory computer-readable medium comprising:
-
code for receiving information defining a hierarchy of business data containers for the application, each business data container in the hierarchy of business data containers limiting data access at the application to a subset of data stored in the database according to predetermined criteria, each business data container having; one or more entries configured to cache first data obtained from the database at the application according to a data schema associated with the business data container, and an index for the application indexing the one or more entries using or more key attributes of second data stored in the database; code for receiving information indicative of a selection of a user of a graphical user interface provided by the application of a visual representation of a business data container in the hierarchy of business data containers; code for receiving a query associated with a predefined task presented by the application for the selected business data container; code for determining a data domain for the selected business data container; code for determining the index for the selected business data container; code for generating a query plan based on the query, the data domain, and the index associated with the selected business data container; and code for executing the query plan to obtain a subset of the second data from the database. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A system comprising:
-
one or more computer systems configured to provide access to a database; and one or more computer systems configured to host an application configured to; receive information defining a hierarchy of business data containers for the application, each business data container in the hierarchy of business data containers limiting data access at the application to a subset of data stored in the database according to predetermined criteria, each business data container having; one or more entries configured to cache first data obtained from the database at the application according to a data schema associated with the business data container, and an index for the application indexing the one or more entries using or more key attributes of second data stored in the database; receive information indicative of a selection of a user of a graphical user interface provided by the application of a visual representation of a business data container in the hierarchy of business data containers; receive a query associated with a predefined task presented by the application for the selected business data container; determine, with the one or more processors associated with one or more computer systems, a data domain for the selected business data container; wherein either the one or more computer systems configured to provide access to the database or the one or more computer systems configured to host the application are configured to; determine the index for the selected business data container; generate a query plan based on the query, the data domain, and the index associated with the selected business data container; and execute the query plan to obtain a subset of the second data from the database. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification