Transparent database table replacement

Patent metadata

Field	Value
Publication number	US-9910871-B2
Application number	US-201414570672-A
Country	US
Kind code	B2
Filing date	Dec 15, 2014
Priority date	Dec 15, 2014
Publication date	Mar 6, 2018
Grant date	Mar 6, 2018

Abstract

A table can be replaced with a view transparently to the application. For example, a data dictionary can specify that the view is to be substituted for the table. At runtime, application operations on the table are redirected to be performed on the view. Validation can be performed to ensure congruence between the table and the view. Can be useful for situations where a view with enhanced functionality is desired to be used in place of the table without re-coding the application.

First claim

What is claimed is:

1. A method of controlling database operations at runtime of an application, the method comprising:
storing a table object representing a database table, wherein the table object comprises a stored indication that the database table should be replaced by a database view in at least a portion of database operations, a reference to a view object for the database view, and an incongruence flag indicating incongruence between the database table and the database view, wherein the database table has a database table identifier and the database view has a database view identifier;
storing the view object, wherein the view object comprises the database view identifier for the database view;
at runtime of an application, receiving a request from the application to perform an operation on the database table, the requested database operation comprising the database table identifier for the database table;
detecting that the database view has been specified to replace the database table in at least a portion of received database operation requests, wherein detecting comprises evaluating the stored indication in the table object;
detecting that no incongruence exists between the database table and the database view via the incongruence flag;
translating the requested database operation, wherein translating the requested database operation comprises, responsive to the detections, substituting the database view identifier for the database table identifier in the requested database operation;
performing the requested database operation as translated; and
returning results of the requested database operation to the application as if the operation was performed on the database table when instead it was performed on the database view, thereby replacing the database table with the database view transparently to the application.

2. The method of claim 1 , wherein performing the requested database operation comprises:
submitting the translated requested database operation to a database management system.

3. The method of claim 2 , wherein the database management system provides enhanced services comprising a submission to at least one of: an SQL engine, a calculation engine, or an SQL script.

4. The method of claim 1 , wherein the method further comprises:
at runtime, determining whether the requested database operation comprises a specified type of statement;
wherein the substituting is performed responsive to determining that the requested database operation does comprise the specified type of statement.

5. The method of claim 4 , wherein the specified type of statement is a SELECT statement.

6. The method of claim 1 , wherein:
the database view is provided by an enhanced database service providing view functionality beyond that of an SQL engine.

7. The method of claim 6 , wherein the view functionality comprises one or more domain-specific languages.

8. The method of claim 1 , further comprising:
following the reference to the view object; and
retrieving the database view identifier from the view object.

9. The method of claim 1 , further comprising:
responsive to encountering a REPLACE directive in a data dictionary, storing the indication in the table object.

10. The method of claim 1 , further comprising:
detecting a modification of a data dictionary describing the database table and the database view; and
responsive to detecting the modification, validating congruence between the database table and the database view.

11. The method of claim 1 , further comprising:
responsive to detecting incongruence between the database table and the database view, raising an error condition.

12. The method of claim 10 , further comprising:
responsive to detecting incongruence between the database table and the database view, setting the incongruence flag to allow for substitution and providing a warning of the incongruence.

13. The method of claim 1 , wherein the incongruence flag indicates congruence when at least one control field of the database table and at least one control field of the database view are different.

14. The method of claim 1 , wherein the database view mirrors the database table.

15. One or more computer-readable media comprising computer-executable instructions causing a computing system to perform a method comprising:
reading a data dictionary comprising a classic database view description describing a classic database view and an enhanced database view description describing an enhanced database view, wherein the data dictionary specifies that the enhanced database view is to replace the classic database view;
confirming that the classic database view description and the enhanced database view description indicate congruent description for the classic database view and the enhanced database view, wherein the confirming comprises performing a congruence check;
based on the enhanced database view description, creating an enhanced view object stored in memory comprising a reference to the enhanced database view;
based on the classic database view description, creating a classic view object stored in memory indicating that the classic database view is replaced by the enhanced database view, wherein the classic view object comprises a reference to the enhanced view object; and
at runtime, when receiving a request to perform an operation on the classic database view, detecting that the classic view object indicates that the classic database view is to be replaced by the enhanced database view, verifying that the classic view object indicates that the congruence check was successful, substituting the enhanced database view for the classic database view, and performing the operation on the enhanced database view instead of the classic database view.

16. One or more computer-readable media comprising computer-executable instructions that, when executed, cause a computing system to perform a method of controlling database operations at runtime of an application, the method comprising:
in memory, storing a table object representing a database table, wherein the table object comprises a stored indication that the database table should be replaced by a database view in at least a portion of database operations, a reference to a view object for the database view, and an incongruence flag indicating incongruence between the database table and the database view, wherein the database table has a database table identifier and the database view has a database view identifier;
in memory, storing the view object, wherein the view object comprises the database view identifier for the database view;
at runtime of an application, receiving a request from the application to perform an operation on the database table, the requested database operation comprising the database table identifier for the database table;
detecting that the database view has been specified to replace the database table, wherein detecting comprises evaluating the stored indication in the table object;
detecting that no incongruence exists between the database table and the database view via the incongruence flag;
translating the requested database operation, wherein translating the requested database operation comprises, responsive to the detections, substituting the database view identifier for the database table identifier in the requested database operation;
performing the requested database operation as translated; and
returning results of the requested database operation to the application as if the operation was performed on the database table when instead it was performed on the databas

Assignees

• Stork Christian
• Hoeft Kerstin
• Becker Frank
• Roedel Bernd
• Beissel Thomas
• Sap Se

Inventors

• Stork Christian
• Hoeft Kerstin
• Becker Frank
• Roedel Bernd
• Beissel Thomas

Classifications

• G06F17/30595

  Physics · mapped topic

• G06F17/30194

  Physics · mapped topic

• G06F17/30339

  Physics · mapped topic

• G06F17/30294 Primary

  Physics · mapped topic

• G06F17/30569

  Physics · mapped topic