Updating data in a database requires updating the schema
In a traditional business environment, the administrator can inform customers that the database system will be down for maintenance for a period of time.
During this downtime, active application sessions with the database system are aborted and new application sessions with the database system are delayed until the update is complete.
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.
System 100 includes server 150, network 106 and client devices 104-1 through 104-N.
Through network 106, each client device can access application 160 on server 150.
Here, some of client devices 104-1 through 104-M can access application 160 using web browsers 105-1 through 105-N, respectively.
This in turn can change the structure of object instances in a database.These updates can add or change the functionality of the database.Traditionally, a database system that is updating the database schema to a newer version requires a period of downtime.In one embodiment, a computer-implemented method establishes, by a processor, an application session to access a database (DB).The method then receives, by the processor, a schema update.