Method and system for managing multiple database storage units

• US 7,321,907 B2
• Filed: 08/30/2004
• Issued: 01/22/2008
• Est. Priority Date: 09/08/2000
• Status: Expired due to Fees

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Yamashita, Nobuyuki, Kawamura, Nobuo, Tsuchida, Masashi
• Primary Examiner(s): Alam; Shahid
• Assistant Examiner(s): Ehichioya; Fred I
• Application Number:
  US10/929,699
• Publication Number:
  US 20050027759A1
• Time in Patent Office: 1,240 Days
• Field of Search: 707 1- 10, 707/100, 707/101, 707/102, 707/201, 707/202, 707/104.1, 707/203, 707/204, 711/162
• US Class Current: 707/607
• CPC Class Codes: G06F 11/2094 Redundant storage or storage space G06F11/2056 takes precedence
• CPC Class Codes: G06F 11/2097 maintaining the standby controller/processing unit updated initialisation or re-synchronisation thereof G06F11/1658 and subgroups
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database. When the above duplication or incorporation is completed, the intermediate storage unit is updated for the transactions that have taken place during the above operations to be synchronized with the main storage unit.

Claims

1. A method of archiving data, comprising the steps of:

maintaining first data in a first database, the first format being chronological, the first data being divided into a first predetermined number of first data portions each representing a first consecutive time period;

maintaining second data in a second database, the second data being also chronological and being divided into a second predetermined number of second data portions each representing a second consecutive time period that is shorter than the first consecutive time period, the second predetermined number of the second consecutive data portions corresponding to one of the first data portions;

determining a point in time for a predetermined database management task to update the first data based upon the second predetermined number of the second data portions;

consolidating the second consecutive data portions into a corresponding one of the first data portions; and

subsequently updating the first database to reflect said consolidating step.

2. The method of archiving data according to claim 1 wherein the first database is a relational database while the second database is an On-Line Analysis Process (OLAP) database.

3. The method of archiving data according to claim 1 wherein the first database includes a first dictionary for mapping a key range to a storage area name.

4. The method of archiving data according to claim 1 wherein the second database includes a second dictionary for mapping a key range to a storage area name.