SADL query view—a model-driven approach to speed-up read-only use cases
View Patent ↗Embodiments of the invention relate to computing, and in particular, to a systems and methods for a querying a database. Certain embodiments implement a model-driven database query (“the SADL query”) facilitating a design-time tool that allows a developer to create the query based upon existing Business Objects (BOs) and their associations. This SADL query leverages mapping between business-layer entities and database-layer entities, such mapping being derived from association metadata already extant in the business model used to create the Business Objects. In certain embodiments, query views may be based upon associations present within the business layer, rather than upon database-level entities (such as joins or restriction rules) that are typically relied upon in conventional query creation. Embodiments of the present invention may thus align query creation more closely with the structure of the business layer, and may also render query design agnostic relative to the identity of the underlying database.
1. A computer-implemented method comprising:
providing a database comprising a plurality of database-level entities;
referencing a business object model to create a business layer in direct communication with the database, the business layer comprising a plurality of business-level entities including at least one association between the plurality of business-level entities, wherein the business object model includes association metadata;
providing a user interface in communication with the business layer;
referencing the business object model only to create a query of the database, the query including mappings derived from the association metadata and comprising direct links between the plurality of business-level entities and the plurality of database-level entities, the query further including a constraint comprising a selection parameter filtering a view of the business object model; and
causing the user interface to execute the query delegated to the database and return corresponding data read from the database;
wherein the business-level entities are defined in a business object-related domain specific language comprising Service Adaptation Definition Language (SADL) reflecting the constraint in order to produce a simplified query result.
2. The method of claim 1 wherein the association is used to create a query view.
3. The method of claim 1 wherein a business-level entity comprises a foreign-key relationship corresponding to a database-level join condition entity.
4. The method of claim 1 wherein a business-level entity comprises a resolving node having attributes bound to constant values corresponding to a restriction rule in the database.
5. The method of claim 1 wherein a business-level entity comprises a resolving node having attributes bound to a filter parameter corresponding to a restriction rule with a placeholder in the database.
6. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:
providing a database comprising a plurality of database-level entities;
referencing a business object model to create a business layer in direct communication with the database, the business layer comprising a plurality of business-level entities including at least one association between the plurality of business-level entities, wherein the business object model includes association metadata;
providing a user interface in communication with the business layer;
referencing the business object model only to create a query of the database, the query including mappings derived from the association metadata and comprising direct links between the plurality of business-level entities and the plurality of database-level entities, the query further including a constraint comprising a selection parameter filtering a view of the business object model; and
causing the user interface to execute the query delegated to the database and return corresponding data read from the database;
wherein the business-level entities are defined in a business object related domain specific language comprising Service Adaptation Definition Language (SADL) reflecting the constraint in order to produce a simplified query result.
7. The non-transitory computer readable storage medium of claim 6 wherein the association is used to create a query view.
8. The non-transitory computer readable storage medium of claim 6 wherein a business-level entity comprises a foreign-key relationship corresponding to a database-level join condition entity.
9. The non-transitory computer readable storage medium of claim 6 wherein a business-level entity comprises a resolving node having attributes bound to constant values corresponding to a restriction rule in the database.
10. The non-transitory computer readable storage medium of claim 6 wherein a business-level entity comprises a resolving node having attributes bound to a filter parameter corresponding to a restriction rule with a placeholder in the database.
11. A computer system comprising:
one or more processors;
a software program, executable on said computer system, the software program configured to:
provide a database comprising a plurality of database-level entities;
reference a business object model to create a business layer in direct communication with the database, the business layer comprising a plurality of business-level entities including at least one association between the plurality of business-level entities, wherein the business object model includes association metadata;
provide a user interface in communication with the business layer;
reference the business object model only to create a query of the database, the query including mappings derived from the association metadata and comprising direct links between the plurality of business-level entities and the plurality of database-level entities, the query further including a constraint comprising a selection parameter filtering a view of the business object model; and
cause the user interface to execute the query delegated to the database and return corresponding data read from the database;
wherein the business-level entities are defined in a business object related domain specific language comprising Service Adaptation Definition Language (SADL) reflecting the constraint in order to produce a simplified query result.
12. The computer system of claim 11 wherein the association is used to create a query view.
13. The computer system of claim 11 wherein a business-level entity comprises a foreign-key relationship corresponding to a database-level join condition entity.
14. The computer system of claim 11 wherein a business-level entity comprises a resolving node having attributes bound to constant values corresponding to a restriction rule in the database.
15. The computer system of claim 11 wherein a business-level entity comprises a resolving node having attributes bound to a filter parameter corresponding to a restriction rule with a placeholder in the database.