Updating data in a database requires updating the schema
The compensation logic provides backwards compatibility to the updated database.
As a result, the DBMS can process database transactions from existing application sessions by using the TCV to locate where a desired object instance is located, either in the updated database or in an auxiliary database.
Over time, a database schema is updated as the database evolves.
The method then receives, by the processor, a schema update.The non-transitory computer-readable storage medium comprises instructions, that when executed, control the one or more computer processors to be configured for establishing an application session to access a database, receiving a schema update, converting the database to an updated database according to the schema update after establishing the application session, generating a temporary compensation view from the schema update, the temporary compensation view containing compensation logic to locate database objects belonging to the database, receiving a database transaction from the application session to access a database object in the database, and processing the compensation logic to locate the database object.The following detailed description and accompanying drawings provide a better understanding of the nature and advantages of the present disclosure.Problems may arise when an existing application session accesses the updated database because object instances have moved or have been deleted.To address this problem, the DBMS creates a temporary compensation view (TCV) that contains compensation logic.