Method for generating copy of database

#The current application claims the benefit of co-pending U.S. application Ser. No. 12/858,637, titled “Device and Method for Generating Copy of Database,” which was filed on Aug. 18, 2010, and which is hereby incorporated by reference.

#The present invention relates to devices and methods for generating copies of databases, and in particular, relates to a device and a method for generating a copy of a database at a specific point in time.

#Recently, the number of computer systems continuously providing services 24 hours a day, every day of the year, has increased. In such computer systems, databases are continuously updated. However, even in the case of a database that is continuously updated, when the database is used as, for example, input data for batch processing or a Data Warehouse, it is required to make copies of the database at a specific quiesce point.

#FIG. 1 is a diagram showing exemplary components of a computer to which an embodiment of the present invention is applied.

#FIG. 2 is a diagram showing the outline of an operation according to the embodiment of the present invention.

#FIG. 3 is a diagram showing transactions, a backup operation, a recovery start point, and a quiesce point on the time axis.

#An embodiment of the present invention enables simple creation of a copy of a table at a specific quiesce point, the copy being useful for operations, using backup data and update logs that have hitherto been used only for recovery of a failure of a database.

#The outline of this operation will briefly be described below. In this case, the description will be given, assuming that an original table (a base table) in a database is TABLE1, and a table (a target table) in which a copy of the base table is stored is TABLEX.

#A database management system (DBMS) first acquires backup data of TABLE1 by performing online backup without stopping updating of TABLE1.