CONSUMPTION LAYER QUERY INTERFACE

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.