System for currently updating database by one host and reading the database by different host for the purpose of implementing decision support functions

• US 5,852,715 A
• Filed: 03/19/1996
• Issued: 12/22/1998
• Est. Priority Date: 03/19/1996
• Status: Expired due to Term

• Current Assignee: EMC Corporation (Dell Technologies Inc.)
• Original Assignee: EMC Corporation (Dell Technologies Inc.)
• Inventors: Tamer, Philip, Raz, Yoav
• Primary Examiner(s): Meky, Moustafa M.
• Application Number:
  US08/617,689
• Time in Patent Office: 1,008 Days
• Field of Search: 395/827, 395/840, 395/841, 395/800, 395/608, 395/619, 395/603, 395/604, 395/615, 395/182.18, 395/475, 395/50, 395/200.32, 395/200.33, 395/200.61, 395/54 , 395/680, 395/200.31
• US Class Current: 709/201
• CPC Class Codes: G06F 11/1466 to make the backup process non-disruptive
• CPC Class Codes: G06F 11/2066 Optimisation of the communication load
• CPC Class Codes: G06F 11/2082 Data synchronisation
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A method of implementing decision support in an environment including a data storage system and a plurality of host processors at least some of which are connected to the data storage system, wherein the data storage system stores a working database, the method including the steps of through a selected one of the plurality of host processors, updating the working database on an ongoing basis; while the working database is being updated on an ongoing basis, generating a copy of the working database; using the copy of the database to generate a support copy of the database; and through a different one of the plurality of host processors, using the support copy for the purpose of implementing decision support functions.

Claims

1. A method of implementing decision support in an environment including a data storage system to which a plurality of host processors is connected, wherein said data storage system stores a database, said method comprising:

through a selected one of said plurality of host processors, updating said database on an ongoing basis; and

through a different one of said plurality of host processors, reading said database for the purpose of implementing decision support functions, wherein the updating and the reading of said database are allowed to take place concurrently without imposing any interhost locks on said database.

2. A method of implementing decision support in an environment including a data storage system and a plurality of host processors at least some of which are connected to the data storage system, wherein said data storage system stores a working database, said method comprising:

through a selected one of said plurality of host processors, updating said working database on an ongoing basis;

while said working database is being updated on an ongoing basis, mirroring said working database to generate a mirror copy of said working database;

using the mirror copy of the database to generate a support copy of the database; and

through a different one of said plurality of host processors, using said support copy for the purpose of implementing decision support functions.

3. The method of claim 2 wherein the step of generating the support copy comprises:

disconnecting the mirror copy from the working database at time t₀ ; and

generating the support copy from the disconnected mirror copy.

4. The method of claim 3 wherein the step of generating the support copy further comprises:

shutting down the working database; and

after the working database has become quiet, disconnecting the mirror copy from the working database.

5. The method of claim 3 wherein the step of generating the support copy from the disconnected copy comprises making the disconnected copy consistent.

6. The method of claim 5 further comprising the steps of:

after using said support copy for decision support functions, reconnecting the support copy to the working database; and

resynchronizing the support copy with the working copy so that it again becomes a mirror copy of the working database.

7. The method of claim 5 further comprising the steps of:

after using said support copy for decision support functions, generating a modified support copy by backing out changes which have occurred to the support copy as a result of using it for decision support functions;

reconnecting the modified support copy to the working database; and

resynchronizing the modified support copy with the working copy so that it again becomes a mirror copy of the working database.

8. The method of claim 3 wherein the plurality of host processors includes a first host processor and a second host processor, wherein the first mentioned data storage system is a local data storage system which is connected to a remote data storage system through a data communications link, and wherein the first host processor is connected to the local data storage system and the second host processor is connected to the remote data storage system, said method further comprising:

mirroring said working database to the remote data storage system to produce a remote database that is a mirror of said working database, wherein the step of mirroring is performed over the data communications link and wherein the updating and the mirroring take place concurrently so that changes made to the local database are recorded in the remote database on an ongoing basis, wherein said support copy is derived from said remote database and wherein second host processor uses said support copy for the purpose of implementing decision support functions.

9. The method of claim 8 further comprising:

disconnecting the remote database copy from the working database; and

generating the support copy from the disconnected mirror copy.

10. The method of claim 9 wherein the step of generating the support copy further comprises:

shutting down the working database; and

after the working database has become quiet, disconnecting the mirror copy from the working database.

11. The method of claim 10 further comprising the steps of:

after using said support copy for decision support functions, reconnecting the support copy to the working database; and

resynchronizing the support copy with the working copy so that it again becomes a mirror copy of the working database.

12. The method of claim 11 further comprising the steps of:

after using said support copy for decision support functions, generating a modified support copy by backing out changes which have occurred to the support copy as a result of using it for decision support functions;

reconnecting the modified support copy to the working database; and

resynchronizing the modified support copy with the working copy so that it again becomes a mirror copy of the working database.

13. The method of claim 9 wherein the step of generating the support copy from the disconnected copy comprises making the disconnected copy consistent.

14. A method of implementing decision support in an environment including a data storage system and a plurality of host processors at least some of which are connected to the data storage system, wherein said data storage system stores a working database, said method comprising:

through a selected one of said plurality of host processors, updating said working database on an ongoing basis;

initiating a process of copying said working database at time t₀ generate a concurrent copy thereof, said concurrent copy representing the value of the data within said working database at time t₀, wherein said updating and said process of copying take place concurrently;

using the concurrent copy of the database to generate a support copy of the database; and

through a different one of said plurality of host processors, using said support copy for the purpose of implementing decision support functions.

15. The method of claim 14 wherein the plurality of host processors includes a first host processor and a second host processor, wherein the first mentioned data storage system is a local data storage system which is connected to a remote data storage system through a data communications link, wherein the first host processor is connected to the local data storage system and the second host processor is connected to the remote data storage system, wherein the process of copying said working database at time t₀ generates said concurrent copy in said remote data storage system, said remote copy representing the value of the data within said working database at time t₀, and wherein the step of using said support copy for the purpose of implementing decision support functions is performed by said second host processor.