CONSUMPTION LAYER QUERY INTERFACE

• US 20150161180A1
• Filed: 06/12/2014
• Published: 06/11/2015
• Est. Priority Date: 12/05/2013
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Hermanns, Marcel, Buchholz, Cristina, Vollrath, Ivo
• Application Number:
  US14/303,565
• Publication Number:
  US 20150161180A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/288 Entity relationship models
• CPC Class Codes: G06F 8/20 Software design
• CPC Class Codes: G06F 8/22 Procedural
• CPC Class Codes: G06F 8/24 Object-oriented
• CPC Class Codes: G06F 8/40 Transformation of program code

Abstract

A non-transitory computer-readable storage medium having stored thereon computer executable program code which, when executed on a computer system, causes the computer system to perform steps. The steps include receiving an indication of a selection of an entity type from a plurality of entity types each associated with a model layer framework, two or more of the model layer frameworks being different model layer frameworks, and the selection of the entity type being based on a user interface interaction on a first user interface where the plurality of entity types are displayed independent of the different model layer frameworks, receiving an indication of a selection of an entity from the selected entity type, receiving an indication of a selection of an element from the selected entity, and generating a service based on the entity and item.

Claims

1. A non-transitory computer-readable storage medium having stored thereon computer executable program code which, when executed on a computer system, causes the computer system to perform steps comprising:

receive an indication of a selection of an entity type from a plurality of entity types each associated with a model layer framework, two or more of the model layer frameworks being different model layer frameworks, and the selection of the entity type being based on a user interface interaction on a first user interface where the plurality of entity types are displayed independent of the different model layer frameworks;

receive an indication of a selection of an entity from the selected entity type;

receive an indication of a selection of an element from the selected entity; and

generate a service based on the entity and item.

2. The non-transitory computer-readable storage medium of claim 1, the steps further comprising:

map a data source to the selected item of the selected entity.

3. The non-transitory computer-readable storage medium of claim 1, the steps further comprising:

generate a second user interface based on the first interface and configured to display data based on the view.

4. The non-transitory computer-readable storage medium of claim 1, the steps further comprising:

interface with a database including a plurality of core capabilities; and

delegate execution of a service implementing one of the core capabilities to the database.

5. The non-transitory computer-readable storage medium of claim 1, the steps further comprising:

interface with two or more databases, wherein

a first database includes a plurality of core capabilities, and

a second database includes a plurality of convenience capabilities;

map the plurality of core capabilities and the plurality of convenience capabilities using a registry; and

delegate execution of a service implementing one of the plurality of core capabilities or the plurality of convenience capabilities to the database using the map.

6. The non-transitory computer-readable storage medium of claim 1, the steps further comprising:

interface with two or more databases each database including a plurality of capabilities; and

expose the plurality of capabilities in a uniform manner such that the plurality of capabilities are indistinguishable based on the two or more databases.

7. The non-transitory computer-readable storage medium of claim 1, the steps further comprising:

check during runtime, if a capability is enabled; and

delegate execution of a service implementing the capability if the capability is enabled.

8. The non-transitory computer-readable storage medium of claim 1, the steps further comprising:

receive a service indicating a query to be executed, the query requesting data from at least two databases;

disassociate elements of the query into a first sub-element and a second sub-element based on the at least two databases;

delegate the first sub-element and the second sub-element to a corresponding database; and

associate the results of the delegation as the result of the query.

9. The non-transitory computer-readable storage medium of claim 1, wherein the entity is associated with an in memory database.

10. The non-transitory computer-readable storage medium of claim 9, the in memory database is a High Performance Analytic Appliance (HANA).

11. A non-transitory computer-readable storage medium having stored thereon computer executable program code which, when executed on a computer system, causes the computer system to perform steps comprising:

read metadata associated with a Service Adaptation Definition Language (SADL) entity;

translate the metadata into Structured Query Language (SQL) artifacts; and

build a runtime load indicating how to retrieve data from a data source based on the SQL artifacts.

12. The non-transitory computer-readable storage medium of claim 11, wherein the runtime load is a SADL runtime.

13. The non-transitory computer-readable storage medium of claim 11, wherein the steps further comprise:

generating a service based on two or more entity elements selected from two or more entity types, wherein the metadata is associated with the generated service.

14. The non-transitory computer-readable storage medium of claim 11, wherein the runtime load is configured to execute the SQL artifacts in response to a request for data.

15. The non-transitory computer-readable storage medium of claim 11, wherein the SQL artifacts include SQL views, SQLScript and application functions.

16. The non-transitory computer-readable storage medium of claim 11, wherein the SQL artifacts include a Query-Pushdown to High Performance Analytic Appliance (HANA).

17. An apparatus comprising:

a plurality of query engines including a first query engine configured to implement in-memory database specific features; and

a query interface configured to determine a query engine, of the plurality of query engines, to call based on an associated consumer level query execution.

18. The apparatus of claim 17, wherein the query interface is further configured to map an application programming interface corresponding to a database implementation of a capability and a consumer request to implement the capability.

19. The apparatus of claim 17, wherein the query interface is further configured to disassociate elements associated with a larger operation such that each element is pushed-down to a corresponding query engine for each element.

20. The apparatus of claim 17, further comprising:

a condition provider registry configured to provide at least one of application specific and framework specific restrictions for data manipulation.