Providing continuous database access during database modification

US9471659B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Volker Driesen · Heidelberg, DE
• Nicolai Jordt · Angelbachtal, DE
• Martin Mayer · Heidelberg, DE
• Wieland Hoprich · Mannheim, DE
• Andrey Engelko · Karlsruhe, DE
• Steffen Meissner · Heidelberg, DE
• Peter Schreiber · Jena, DE
• Levke Bentzien · Heidelberg, DE

Key dates

• Filing date: Dec 28, 2012
• Grant date: Oct 18, 2016
• Expiry date: May 25, 2033

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/214
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

The subject matter described herein relates to providing a continuous access to a database at times, including when the database is being modified or upgraded. Initially, access to an old version of a table is enabled and provided to a user. A copy of the old version is generated. Access is asynchronously redirected from the old version to the copy of the old version. A new version of the table is generated by modifying the structure of the first version of the table. The copy of the old version is accessible when the database is being modified or upgraded. When the structure is being modified, access is asynchronously redirected from the copy of the old version to the new version.