VALIDATION OF WEB-BASED DATABASE UPDATES

• US 20150149421A1
• Filed: 06/30/2014
• Published: 05/28/2015
• Est. Priority Date: 11/25/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Foebel, Florian, Friedmann, Bjoern, Gruschko, Boris, Mohr, Christian, Strenge, Martin, Zorn, Sascha
• Granted Patent: US 10,409,801 B2
• Time in Patent Office: Days
• US Class Current: 707/690
• CPC Class Codes: G06F 11/3668 Software testing software testing in telephone exchanges H04M3/242, testing of hardware G06F11/22
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: H04L 43/10 Active monitoring, e.g. heartbeat, ping or trace-route
• CPC Class Codes: H04L 63/08 for authentication of entities cryptographic mechanisms or cryptographic arrangements for entity authentication H04L9/32
• CPC Class Codes: H04L 63/083 using passwords cryptographic mechanisms or cryptographic arrangements for entity authentication using a predetermined code H04L9/3226
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

A system includes reception of a request to modify the data of a database, the request including first data, execution of processing to fulfill the request, determination, during execution of the processing, that a validation exit is associated with a current state of the processing, storage of the first data in a local temporary table in response to the determination, passage of the local temporary table to the validation exit, and execution of the validation exit to validate the first data based on the local temporary table and on the data of the database.

Claims

1. A system comprising:

a database storing data; and

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

receive a request to modify the data, the request including first data;

execute processing to fulfill the request;

determine, during execution of the processing, that a validation exit is associated with a current state of the processing;

store the first data in a local temporary table in response to the determination;

pass the local temporary table to the validation exit; and

execute the validation exit to validate the first data based on the local temporary table and on the data of the database.

2. A system according to claim 1, wherein execution of the validation exit comprises:

execution of a join between the local temporary table and one or more tables of the database.

3. A system according to claim 2, wherein execution of the join comprises execution of the join by a native processing engine of the database.

4. A system according to claim 1, wherein the request conforms to Hypertext Transfer Protocol and to OData protocol.

5. A system according to claim 1, wherein determination that the validation exit is associated with a current state of the processing comprises determination of whether the validation exit is registered to the current state of the processing.

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

determine, during execution of the processing, that a second validation exit is associated with a next state of the processing;

pass the local temporary table to the second validation exit; and

execute the second validation exit to validate the first data based on the local temporary table and on the data of the database.

7. A computer-implemented method comprising:

receiving a request to modify the data of a database, the request including first data;

executing processing to fulfill the request;

determining, during execution of the processing, that a validation exit is associated with a current state of the processing;

storing the first data in a local temporary table in response to the determination;

passing the local temporary table to the validation exit; and

executing the validation exit to validate the first data based on the local temporary table and on the data of the database, wherein executing the validation exit comprises executing a join between the local temporary table and one or more tables of the database.

8. A computer-implemented method according to claim 7, wherein executing the join comprises executing the join by a native processing engine of the database.

9. A computer-implemented method according to claim 7, wherein the request conforms to Hypertext Transfer Protocol and to OData protocol.

10. A computer-implemented method according to claim 7, wherein determining that the validation exit is associated with a current state of the processing comprises determining that the validation exit is registered to the current state of the processing.

11. A computer-implemented method according to claim 7, further comprising:

determining, during execution of the processing, that a second validation exit is associated with a next state of the processing;

passing the local temporary table to the second validation exit; and

executing the second validation exit to validate the first data based on the local temporary table and on the data of the database.

16. A medium according to claim 7, wherein determination that the validation exit is associated with a current state of the processing comprises determination of whether the validation exit is registered to the current state of the processing.

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

determine, during execution of the processing, that a second validation exit is associated with a next state of the processing;

pass the local temporary table to the second validation exit; and

execute the second validation exit to validate the first data based on the local temporary table and on the data of the database.

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

receive a request to modify the data of a database, the request including first data;

execute processing to fulfill the request;

determine, during execution of the processing, that a validation exit is associated with a current state of the processing;

store the first data in a local temporary table in response to the determination;

pass the local temporary table to the validation exit; and

execute the validation exit to validate the first data based on the local temporary table and on the data of the database.

13. A medium according to claim 12, wherein execution of the validation exit comprises execution of a join between the local temporary table and one or more tables of the database.

14. A medium according to claim 13, wherein execution of the join comprises execution of the join by a native processing engine of the database.

15. A medium according to claim 12, wherein the request conforms to Hypertext Transfer Protocol and to OData protocol.