Availability of Database Objects During Database Operations

A method, computer program product, and system for providing access to a database object during modification of that object. Upon receipt of a data definition language (DDL) operation specifying a modification to the database object, currently executing database transactions are invalidated in a two...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: CHAINANI NARESH K, ZHANG LIPING, WINER MICHAEL J
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:A method, computer program product, and system for providing access to a database object during modification of that object. Upon receipt of a data definition language (DDL) operation specifying a modification to the database object, currently executing database transactions are invalidated in a two-step process of a soft invalidation followed by a hard invalidation. The soft invalidation permits the current database transactions to continue executing while modifying the logical structure of the database object in accordance with the DDL operation, and the hard invalidation waits for the database transactions started prior to the DDL operation to finish execution before modifying the physical structure of the database object in accordance with the DDL operation. After the modification to the logical structure is complete, new database transactions are allowed to execute against the modified database object, thus improving the availability of the object while it is being modified.