Global Patent Index - EP 1002287 A1

EP 1002287 A1 20000524 - METHOD FOR UPGRADING A DATABASE

Title (en)

METHOD FOR UPGRADING A DATABASE

Title (de)

VERFAHREN ZUM ERWEITERN EINER DATABASE

Title (fr)

PROCEDE D'EXTENSION D'UNE BASE DE DONNEES

Publication

EP 1002287 A1 20000524 (EN)

Application

EP 98946302 A 19980807

Priority

  • DE 19734413 A 19970808
  • EP 9805026 W 19980807

Abstract (en)

[origin: DE19734413C1] When upgrading a database the downtime of the database should be kept to a minimum as well as the hardware and software requirements. Moreover, a rollback of the upgrade should be possible at any time. The method disclosed here comprises the steps of creating a new table in said database, copying and/or transforming data from said table to said new table, adding a new version of said stored procedure to said database, and adding an additional stored procedure to the database which refers to both the previous version and the new version of the stored procedure whenever data is to be processed with the stored procedure, for causing data processing to take place in accordance with the previous version and the new version of the stored procedure.

IPC 1-7

G06F 17/30

IPC 8 full level

G06F 11/14 (2006.01); G06F 17/30 (2006.01)

CPC (source: EP)

G06F 11/1433 (2013.01); G06F 16/284 (2019.01); G06F 2201/80 (2013.01)

Citation (examination)

  • Özsu M T and Valduriez P, "Principles of Distributed Database Systems", Prentice-Hall, 1991, ISBN 0-13-715681, Chapter "Distributed Database Design", Section 5.2, pages 99-104
  • Rahm E, "Mehrrechner-Datenbanksysteme", Addison-Wesley, 1994, Chapter "Datenbankverteilung", Section 5.1, pages 60-61
  • Lockemann et al., "Kommunikation und Datenhaltung", Skriptum zur Vorlesung, 1990, Section 4 "Transaktionssysteme", pages 248-263
  • Ries D R et al, "Locking Granularity Revisited", ACM Transactions on Database Systems, Vol. 4, No. 2, June 1979, pp. 210-227, ACM Press
  • Mohan C, "Interactions between query optimization and concurrency control", Second International Workshop on Transactions and Query Processing, February 1992, pp. 26-35, IEEE Press
  • See also references of WO 9908206A1

Designated contracting state (EPC)

FR GB IT

DOCDB simple family (publication)

DE 19734413 C1 19990107; AU 9340598 A 19990301; EP 1002287 A1 20000524; EP 1091305 A1 20010411; EP 1091305 B1 20031029; WO 9908206 A1 19990218

DOCDB simple family (application)

DE 19734413 A 19970808; AU 9340598 A 19980807; EP 00125246 A 19980807; EP 9805026 W 19980807; EP 98946302 A 19980807