Validation of web-based database updates

Patent metadata

Field	Value
Publication number	US-10409801-B2
Application number	US-201414318853-A
Country	US
Kind code	B2
Filing date	Jun 30, 2014
Priority date	Nov 25, 2013
Publication date	Sep 10, 2019
Grant date	Sep 10, 2019

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.

First claim

What is claimed is:

1. A system comprising:
a database storing data; and
a processor to execute processor-executable process steps to cause the system to:
receive an OpenData Protocol (OData) request to modify the data, the request including first data;
execute processing to fulfill the request;
determine, during execution of the processing to fulfill the request to modify the data, that a validation exit including executable code to validate the data to be modified is registered for the modification and for a current state of the processing to fulfill the request to modify the data, wherein the current state is one of before or after the modification operation;
store the first data in a local temporary table in response to the determination that the validation exit is associated with the current state of the processing to fulfill the request to modify the data, wherein the current state is the before state, the data of the local temporary table is not part of the database, and when the current state is the after state, the data of the local temporary table is part of the database;
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, wherein execution of the validation exit comprises execution of a join between the local temporary table and one or more tables of the database, and wherein execution of the validation exit includes execution of a native processing engine of the database system to validate the first data.

2. The 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. The system according to claim 2 , wherein execution of the join comprises execution of the join by the native processing engine of the database.

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

5. The 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. The 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 an Open Data Protocol (OData) 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 to fulfill the request to modify the data, that a validation exit including executable code to validate the data to be modified is registered for the modification and for a current state of the processing to fulfill the request to modify the data, wherein the current state is one of before or after the modification operation;
storing the first data in a local temporary table in response to the determination that the validation exit is associated with the current state of the processing to fulfill the request to modify the data, wherein when the current state is the before state, the data of the local temporary table is not part of the database, and when the current state is the after state, the data of the local temporary table is part of the database;
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, and wherein execution of the validation exit includes execution of a native processing engine of the database system to validate the first data.

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

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

10. The 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. The 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.

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 an OpenData Protocol (OData) 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 to fulfill the request to modify the data, that a validation exit including executable code to validate the data to be modified is registered for the modification and for a current state of the processing to fulfill the request to modify the data, wherein the current state is one of before or after the modification operation;
store the first data in a local temporary table in response to the determination that the validation exit is associated with the current state of the processing to fulfill the request to modify the data, wherein when the current state is the before state, the data of the local temporary table is not part of the database, and when the current state is the after state, the data of the local temporary table is part of the database;
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, wherein execution of the validation exit comprises executing a join between the local temporary table and one or more tables of the database, and wherein execution of the validation exit includes execution of a native processing engine of the database system to validate the first data.

13. The 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. The medium according to claim 13 , wherein execution of the join comprises execution of the join by the native processing engine of the database.

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

16. The 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. The medium according to claim 7 , wherein the program code is further executable by the computer system

Assignees

• Foebel Florian
• Friedmann Bjoern
• Gruschko Boris
• Mohr Christian
• Strenge Martin
• Zorn Sascha
• Sap Se

Inventors

• Foebel Florian
• Friedmann Bjoern
• Gruschko Boris
• Mohr Christian
• Strenge Martin
• Zorn Sascha

Classifications

• G06F16/951

  Indexing; Web crawling techniques · CPC title

• G06F21/6218

  to a system of files or objects, e.g. local or distributed file system or database · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title

• G06F16/215

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title

• H04L67/02 Primary

  based on web technology, e.g. hypertext transfer protocol [HTTP] · CPC title