Production information system enhanced for availability

• US 5,842,222 A
• Filed: 10/04/1996
• Issued: 11/24/1998
• Est. Priority Date: 10/04/1996
• Status: Expired due to Term

• Current Assignee: Taiwan Semiconductor Manufacturing Company Limited
• Original Assignee: Taiwan Semiconductor Manufacturing Company Limited
• Inventors: Lo, Shih-Yung, Lin, Chun-Ching, Chan, Yi-Hsin, Hsu, Hung-Chieh
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Choules, Jack M.
• Application Number:
  US08/725,803
• Time in Patent Office: 781 Days
• Field of Search: 707/200, 707/202, 707/204, 707/201
• US Class Current: 707/646
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method for providing high availability in a production information system is described. The information system consists of a primary and a secondary copy running on a dual machine architecture. A backup database is added to the system which is updated daily from a transaction log. Database maintenance and archive procedures are performed on the data in the backup database relieving the primary and secondary databases of this activity. Database conversion is performed periodically, and the backup database is used to fill in for the primary and secondary databases when they are being converted.

Claims

1. A database and production information system adapted for high availability, and comprising:

a) a dual machine architecture having a primary and a secondary side,

b) each side having a fileserver, a database, a transaction log and a task communicator,

c) said database on the primary side being a primary database and said database on the secondary side being a secondary database,

d) said fileserver on the primary side being connected to the primary database, a transaction log, and a task communicator,

e) the task communicator on the primary side connected to the task communicator on the secondary side,

f) the primary system communicating with the secondary database through the task communicator on the primary side connected to the task communicator on the secondary side,

g) the task communicator on the primary side connected to the transaction log,

h) said transaction log on the primary side connected to a backup database through a daily backup process,

i) said backup database used for database maintenance thereby increasing the availability of the primary system.

2. The database and production information system of claim 1 wherein the transaction log maintains a record of the incremental changes of the database and is used to provide data to update the backup database.

3. The database and production information system of claim 1 wherein the data in the backup database is updated daily, and comprising:

a) closing the transaction log,

b) opening a new transaction log,

c) applying the closed transaction log to the backup database,

d) upon completion of the backup process the backup database being caught up with the primary database.

4. The database and production information system of claim 1 wherein the backup database provides a backup for the primary and secondary databases.

5. A database and production information system adapted for high availability by using a backup database for an archival process, and comprising:

a) a dual machine computing system containing primary, secondary and backup databases,

b) a production information system running on each machine,

c) production data stored first in the primary database and then the secondary database,

d) a transaction log used to tabulate incremental changes to the backup database,

e) a new transaction log created each day,

f) daily backup of the backup database using the previous day'"'"'s transactions log,

g) all data base maintenance and archive processes use the backup database freeing the primary and secondary databases for production purposes.

6. The database and production information system of claim 5 wherein a lot archiving process on the backup database includes mark lots for archive, copy archive lots, backup archive directory files and delete archive lots, and comprising:

a) redefine "fil_-- data" logical name in the archiving process to point to the backup database,

b) make local access to database files in the backup database,

c) perform database maintenance and archival procedures.

7. The database and production information system of claim 5 wherein the backup database is periodically archived to tape.

8. A database conversion process done periodically on primary, secondary and backup databases, and comprising:

a) creating a temporary database using extra disk space,

b) updating said backup database from the previous day'"'"'s transaction log,

c) converting the backup database files to the temporary database,

d) deleting the files in said backup database and copying the converted files from the temporary database back to the backup database,

e) shutting down the secondary production information system while maintaining the secondary database,

f) re-establishing the secondary system using the backup database,

g) deleting the secondary database and copying the converted files from the temporary database to the secondary database,

h) shutting down the primary and secondary production information system while maintaining the primary database,

i) re-establishing the primary system using the backup database, and re-establishing the secondary system using the secondary database,

j) deleting the primary database and copying the converted files from the temporary database to the primary database,

k) shutting down the primary production information system and then restarting the primary production information system using the converted primary database.

9. The database conversion process of claim 8 wherein the temporary database is created to hold data to which all other data bases are converted.

10. The database conversion process of claim 8 wherein the backup database becomes a replacement database for the primary and secondary databases as the primary and secondary databases each become converted allowing the production information system to function with minimal interruption.

11. The conversion process of claim 8 wherein a file pointer is returned to a converted database from the backup database after the conversion process is completed.

12. The conversion process of claim 8 wherein the transaction log is applied to a converted database after database conversion to bring that database up to date with the most recent changes.