Updating data in a database requires updating the schema

Posted by / 16-Oct-2019 01:50

Updating data in a database requires updating the schema

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.Here, some of client devices 104-1 through 104-M can access application 160 using web browsers 105-1 through 105-N, respectively.Application sessions 170-1 through 170-M are in turn established.When all application sessions that existed before the update are terminated, the TCV and any temporary databases associated with the TCV can be deleted to avoid polluting the database and the DBMS.illustrates system 100 according to one embodiment.The method then converts, by the processor, the database to an updated database according to the schema update after establishing the application session.

This in turn can change the structure of object instances in a database.

Over time, a database schema is updated as the database evolves.

This can include adding, modifying, or deleting data structures from the database.

In another embodiment, a non-transitory computer readable storage medium stores one or more programs comprising instructions 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.

In another embodiment, a computer implemented system comprises one or more computer processors and a non-transitory computer-readable storage medium.

updating data in a database requires updating the schema-18updating data in a database requires updating the schema-57updating data in a database requires updating the schema-56

Various embodiments described herein enable application sessions with a database management system (DBMS) to remain active while a database's underlying schema is being updated.