APPLICATION PROGRAMMING INTERFACE LAYERS FOR ANALYTICAL APPLICATIONS

• US 20140143278A1
• Filed: 11/16/2012
• Published: 05/22/2014
• Est. Priority Date: 11/16/2012
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Nos, Karl-Peter, Gembalzyk, Martin
• Application Number:
  US13/679,726
• Publication Number:
  US 20140143278A1
• Time in Patent Office: Days
• US Class Current: 707/781
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A system for accessing analytical data for external use may include a database storing a first data set and a second data set. The first data set and the second data set may include analytical data. A first access layer may provide access to a first data set from the database and a second access layer may provide access to a second data set from the database. A first application programming interface may provide functions to access the first access layer and a second application programming interface may provide functions to access the second access layer. The first application programming interface may be configured to receive a request via the first access layer to access the first data set from the database and the second application programming interface may be configured to receive a request via the second access layer.

Claims

1. A system for accessing analytical data for external use, comprising:

a database storing a first data set and a second data set, wherein the first data set and the second data set include analytical data;

a first access layer that provides access to a first data set from the database;

a second access layer that provides access to a second data set from the database;

a first application programming interface providing functions to access the first access layer, wherein the first application programming interface is configured to receive a request via the first access layer to access the first data set from the database; and

a second application programming interface providing functions to access the second access layer, wherein the second application programming interface is configured to receive a request via the second access layer.

2. The system of claim 1, wherein the first application programming interface provides a first analytical view of the first data set and the second application programming interface provides a second analytical view of the second data set.

3. The system of claim 1, wherein the first set of data is distinct from the second set of data.

4. The system of claim 1, wherein the database is an in-memory database.

5. The system of claim 1, where the first data set and the second data includes data for analytical reports and models for accessing the data.

6. The system of claim 5 wherein the models include at least one of analytical views and calculation views.

7. The system of claim 1, wherein the first access layer provides a first degree of access to the database and the second access layer provides a second degree of access to the database.

8. The system of claim 1, wherein the first degree of access depends on a user who initiates a request to the first access layer.

9. The system of claim 1, wherein the first access layer is associated with a set of application programming interfaces.

10. The system of claim 1, wherein the first application programming interface and the second application programming interface provide stateless access to the database.

11. A method for accessing analytical data in a database, comprising:

at a first access layer, receiving a request from a requestor to access a data set from the database;

identifying a first application programming interface and one or more functions of the first application programming interface based on the request, wherein the first application programming interface is associated with the first access layer;

retrieving the data set from the database via the identified one or more functions of the first application programming interface and the first access layer;

generating a report based on the retrieved data set; and

providing the report to the requestor.

12. The method of claim 11, further comprising:

identifying a second application programming interface and one or more functions of the second application programming interface; and

retrieving another data set from the database via the identified one or more functions of the second application programming interface and the first access layer.

13. The method of claim 12, wherein the second application programming interface and the one or more functions of the second application programming interface are identified in response to a message from a function of the first application programming interface.

14. The method of claim 12, wherein the report is generated based on the retrieved data set and the another data set.

15. The method of claim 11, further comprising:

at a second access layer, receiving a request to access a second data set from the database;

identifying a third application programming interface and one or more functions of the third application programming interface; and

retrieving the second data set from the database via the identified one or more functions of the third application programming interface and the second access layer, wherein the second data set is distinct from the data set.

16. The method of claim 15, wherein the report is generated based in part on the retrieved second data set.

17. The method of claim 15, further comprising:

generating a second report based on the retrieved second set of data, wherein the report corresponds to a first analytical view and the second report corresponds to a second analytical view.

18. The method of claim 11, wherein the request includes report definitions and wherein the report is based in part on the report definitions.

19. The method of claim 11, wherein the request identifies a user and the first application programming interface is identified based in part on access privileges of the identified user.

20. A non-transitory computer readable medium storing a program causing a computer to execute a process for accessing analytical data in a database, the process comprising:

at a first access layer, receiving a request from a requestor to access a data set from the database;

identifying a first application programming interface and one or more functions of the first application programming interface based on the request, wherein the first application programming interface is associated with the first access layer;

retrieving the data set from the database via the identified one or more functions of the first application programming interface and the first access layer;

generating a report based on the retrieved data set; and

providing the report to the requestor in response to the request.