Patent · US Active

Updating database schemas in a zero-downtime environment

US9507810B2 · kind B2 · utility

17Cited by

3References

12Claims

0Family size

Assignee

SAP SE · DE

Inventors

Stefan Baeuerle · Walldorf, DE
Wolfgang Lehner · Dresden, DE
Anil Kumar Goel · Waterloo, CA
Frank Renkes · Wiesloch, DE
Joydeep Das · Richmond, US

Key dates

Filing date	Dec 10, 2013
Grant date	Nov 29, 2016
Priority date	—
Expiry date	Jan 19, 2035

Classification

Technology area (CPC H)Electricity
CPC primaryH04L67/141
WIPO fieldDigital communication
WIPO sectorElectrical engineering

Abstract

A system is described for processing schema updated in a zero-downtime environment. A technique includes 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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.