File-based transport of table content

• US 9,916,154 B2
• Filed: 03/12/2015
• Issued: 03/13/2018
• Est. Priority Date: 03/12/2015
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Block, Meinolf, Bestfleisch, Urlich, Hutzel, Daniel, Klein, Udo
• Primary Examiner(s): Pan, Hang
• Application Number:
  US14/645,611
• Publication Number:
  US 20160266895A1
• Time in Patent Office: 1,097 Days
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 8/70 Software maintenance or management
• CPC Class Codes: G06F 8/71 Version control security arrangements therefor G06F21/57; Configuration management

Abstract

A system includes reception of a configuration set definition file defining the structure of one or more customizing tables of a software application, reception of a configuration data file including data for the one or more customizing tables, and, during activation of the software application in a run-time system, generation of the one or more customizing tables based on the configuration set definition file, generation of a service to access the configuration data file, and population of the one or more customizing tables with data of the configuration data file.

Claims

1. A system comprising:

a memory storing processor-executable process steps; and

a processor to execute the processor-executable process steps to cause the system to;

receive a configuration set definition file that (i) defines the structure of one or more customizing tables of a software application, the customizing tables configured to expose data files as database tables and (ii) specifies an application-specific database procedure associated with verifying data semantics, the application-specific database procedure built on top of the exposed data files;

receive a configuration data file including data for the one or more customizing tables; and

during activation of the software application in a run-time system;

generate the one or more customizing tables based on the configuration set definition file, generate a configuration service to (i) expose a model comprising a first fixed entity that exposes the configuration data file and a second fixed entity that exposes one or more content blocks associated with the configuration data file, (ii) access, create, delete and update the content of the configuration data file, and (iii) populate the one or more customizing tables with data of the configuration data file wherein the application-specific database procedure is called during the activation of the software application to verify that the data in the populated customizing tables is semantically correct;

identifying a second set of non-translatable customizing tables of the configuration set definition file; and

for each of the second set of non-translatable customizing tables, generating a first table storing a semantic key for table text of each of the second set of non-translatable customizing tables and generation of a second table storing the table text.

2. A system according to claim 1, wherein the processor is further to execute the processor-executable process steps to cause the system to:

receive a request to read data from the configuration data file from a user interface application;

in response to the request, execute the service to deserialize the data into a temporary table; and

transmit the data of the temporary table to the user interface application.

3. A system according to claim 2, wherein the processor is further to execute the processor-executable process steps to cause the system to:

receive a second request to update the transmitted data;

in response to the second request, execute the service to serialize the updated data into the configuration data file.

4. A system according to claim 3, wherein the processor is further to execute the processor-executable process steps to cause the system to:

populate the one or more customizing tables with the updated data of the configuration data file.

5. A system according to claim 1, wherein generation of the one or more customizing tables based on the configuration set definition file comprises:

identification of a first set of non-translatable customizing tables of the configuration set definition file; and

generation of the first set of non-translatable customizing tables.

6. A system according to claim 1, wherein generation of the one or more customizing tables based on the configuration set definition file further comprises:

for each of the second set of non-translatable customizing tables, generation of a view joining the first table and the second table.

7. The method of claim 1, wherein the exposed model further comprises a third fixed entity that exposes configuration data associated with keys to match a key-range of the one or more content blocks of the configuration data file.

8. A computer-implemented method comprising:

receiving a configuration set definition file that (i) defines the structure of one or more customizing tables of a software application, the customizing tables configured to expose data files as database tables and (ii) specifies an application-specific database procedure associated with verifying data semantics, the application-specific database procedure built on top of the exposed data files;

receiving a configuration data file including data for the one or more customizing tables;

during activation of the software application in a run-time system;

automatically generating the one or more customizing tables based on the configuration set definition file, generating a service to (i) expose a model comprising a first fixed entity that exposes the configuration data file and a second fixed entity that exposes one or more content blocks associated with the configuration data file, (ii) access, create, delete and update the content of the configuration data file, and (iii) populating the one or more customizing tables with data of the configuration data file wherein the application-specific database procedure is called during the activation of the software application to verify that the data in the populated customizing tables is semantically correct;

identification of a second set of non-translatable customizing tables of the configuration set definition file; and

for each of the second set of non-translatable customizing tables, generation of a first table storing a semantic key for table text of each of the second set of non-translatable customizing tables and generation of a second table storing the table text.

9. A method according to claim 8, further comprising:

receiving a request to read data from the configuration data file from a user interface application;

in response to the request, executing the service to deserialize the data into a temporary table; and

transmitting the data of the temporary table to the user interface application.

10. A method according to claim 9, further comprising:

receiving a second request to update the transmitted data;

in response to the second request, executing the service to serialize the updated data into the configuration data file.

11. A method according to claim 10, further comprising:

populating the one or more customizing tables with the updated data of the configuration data file.

12. A method according to claim 8, wherein generating the one or more customizing tables based on the configuration set definition file comprises:

identifying a first set of non-translatable customizing tables of the configuration set definition file; and

generating of the first set of non-translatable customizing tables.

13. A method according to claim 8, wherein generating the one or more customizing tables based on the configuration set definition file further comprises:

for each of the second set of non-translatable customizing tables, generating a view joining the first table and the second table.

14. A non-transitory computer-readable medium storing program code, the program code executable by a computer system to cause the computer system to:

receive a configuration set definition file that (i) defines the structure of one or more customizing tables of a software application, the customizing tables configured to expose data files as database tables and (ii) specifies an application-specific database procedure associated with verifying data semantics, the application-specific database procedure built on top of the exposed data files;

receive a configuration data file including data for the one or more customizing tables;

during activation of the software application in a run-time system;

generate the one or more customizing tables based on the configuration set definition file, generate a service to (i) expose a model comprising a first fixed entity that exposes the configuration data file and a second fixed entity that exposes one or more content blocks associated with the configuration data file, (ii) access, create, delete and update the content of the configuration data file, and (iii) populate the one or more customizing tables with data of the configuration data file wherein the application-specific database procedure is called during the activation of the software application to verify that the data in the populated customizing tables is semantically correct;

identification of a second set of non-translatable customizing tables of the configuration set definition file; and

for each of the second set of non-translatable customizing tables, generation of a first table storing a semantic key for table text of each of the second set of non-translatable customizing tables and generation of a second table storing the table text.

15. A medium according to claim 14, wherein the program code is further executable by a computer system to cause the computer system to:

receive a request to read data from the configuration data file from a user interface application;

in response to the request, execute the service to deserialize the data into a temporary table; and

transmit the data of the temporary table to the user interface application.

16. A medium according to claim 15, wherein the program code is further executable by a computer system to cause the computer system to:

receive a second request to update the transmitted data;

in response to the second request, execute the service to serialize the updated data into the configuration data file.

17. A medium according to claim 16, wherein the program code is further executable by a computer system to cause the computer system to:

populate the one or more customizing tables with the updated data of the configuration data file.

18. A medium according to claim 14, wherein generation of the one or more customizing tables based on the configuration set definition file comprises:

identification of a first set of non-translatable customizing tables of the configuration set definition file; and

generation of the first set of non-translatable customizing tables.

19. A medium according to claim 14, wherein generation of the one or more customizing tables based on the configuration set definition file further comprises:

for each of the second set of non-translatable customizing tables, generation of a view joining the first table and the second table.