DATABASE CONTENT PUBLISHER

• US 20150161235A1
• Filed: 12/10/2013
• Published: 06/11/2015
• Est. Priority Date: 12/10/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Libfeld, Zahi, Assraf, Itay
• Granted Patent: US 9,747,353 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Various embodiments of systems and methods to publish database content as service for accessing business data are described herein. In one aspect, a business transaction instantiated by a user is executed on an application server. During the execution, at least one database table of a plurality of database tables and at least one database relationship associated with the at least one database table are identified. In another aspect, a data structure model is automatically generated based on the identified at least one database table and at least one database relationship. In yet another aspect, data from the at least one database table is exposed to be consumed as a service based on the data structure model.

Claims

1. A computer system publishing database content, the system comprising:

at least one processor;

a memory storing a business transaction analyzer designed to perform operations comprising monitor an execution, by the at least one processor, of a business transaction, and to identify at least one database table of a plurality of database tables, wherein the at least one database table is referred by the business transaction; and

a publisher configured to perform operations comprising automatically generate a data structure model based on the identified at least one database table, and to expose, as a service based on the data structure model, data of the at least one database table.

2. The computer system claim 1 further comprising:

a database relationship analyzer to identify at least one database relationship associated with the at least one database table of the plurality of database tables when a user associated with the business transaction is authorized to access the at least one database table.

3. The computer system of claim 1, wherein the publisher is configured to perform operations further comprising:

generate an abstract data model based on the data structure model to define access to the data of the at least one database table; and

construct a plurality of identifiers associated with the abstract data model to expose the data of the at least one database table.

4. The computer system of claim 1, wherein the publisher is configured to perform operations further comprising:

modify the abstract data model based on user input.

5. A non-transitory computer-readable storage medium comprising instructions that, when executed by at least one processor of a machine, cause the machine to perform operations comprising:

run a business transaction within an application server;

identify at least one database table of a plurality of database tables, wherein the at least one database table is referred by the business transaction;

identify at least one database relationship including the at least one database table of the plurality of database tables;

automatically generate a data structure model based on the identified at least one database table and the identified at least one database relationship; and

expose, as a service based on the data structure model, data of the at least one database table.

6. The storage medium of claim 5, wherein identifying the at least one database table comprises:

verify a right to access the at least one database table for a security role assigned to a user associated with the business transaction, based on a predefined database security configuration.

7. The storage medium of claim 5, wherein identifying the at least one database relationship comprises:

verify a right to access the at least one database table for a security role assigned to a user associated with the business transaction, based on a predefined database security configuration.

8. The storage medium of claim 5, wherein automatically generating the data structure model comprises:

modify the automatically generated data structure model based on a user input.

9. The storage medium of claim 5, wherein exposing the data comprises:

generate an abstract data model based on the data structure model to define access to the data of the at least one database table; and

construct a plurality of identifiers associated with the abstract data model to expose the data of the at least one database table.

10. The storage medium of claim 6 further comprising:

modify the abstract data model based on user input.

11. The storage medium of claim 5 further comprising:

provide access to the data of the at least one database table in response to a consumer request to the service.

12. The storage medium of claim 11 further comprising:

verify a right to access the at least one database table for a security role assigned to a user associated with the consumer request, based on a predefined database security configuration.

13. A computer implemented method to publish database content, the method comprises:

executing a business transaction by at least one processor of the computer;

identifying, at a memory, at least one database table of a plurality of database tables, wherein the at least one database table is referred during the execution of the business transaction;

identifying at least one database relationship involving the at least one database table of the plurality of database tables;

automatically generating, by the processor, a structure model based on the identified at least one database table and the identified at least one database relationship; and

exposing, as a service based on the structure model, data of the at least one database table to a consumer.

14. The method of claim 13, wherein identifying the at least one database table comprises:

verifying a right to access the at least one database table for a security role assigned to a user associated with the business transaction, based on a predefined database security configuration.

15. The method of claim 13, wherein identifying the at least one database relationship comprises:

verifying a right to access the at least one database table for a security role assigned to a user associated with the business transaction, based on a predefined database security configuration.

16. The method of claim 13, wherein automatically generating the data structure model comprises:

modifying the automatically generated data structure model based on a user input.

17. The method of claim 13, wherein exposing the data comprises:

generating an abstract data model based on the data structure model to define access to the data of the at least one database table; and

constructing a plurality of identifiers associated with the abstract data model to expose the data of the at least one database table.

18. The method of claim 17 further comprising:

modifying the abstract data model based on user input.

19. The method of claim 13 further comprising:

provide access to the data of the at least one database table in response to a consumer request to the service.

20. The method of claim 19, wherein providing access to the data comprises:

filtering the access to the data of the at least one database table based on a security role assigned to a user associated with the consumer request, according to a predefined database security configuration.