Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-10-08
2002-08-06
Alam, Hosain T. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C709S248000, C714S020000
Reexamination Certificate
active
06430577
ABSTRACT:
FIELD OF THE INVENTION
This disclosure relates to network Communications where logical audit blocks are created at a source host and transferred to a remote host where the audit trail is used to create and maintain a continuously synchronized remote database backup.
BACKGROUND OF THE INVENTION
A database such as the Unisys Data Management System II, Extended, is a centralized collection of data placed into one or more files. Multiple application programs can access this data concurrently. Consequently, redundant files are not required for each individual application. Application programs running in batch, time sharing, and reload job entry environments can all access the database concurrently. A database of the present configuration consists of the following major components:
(a) Data sets;
(b) Sets;
(c) Subsets;
(d) Data items;
(e) Global data.
A data set, a set, or a subset, that is not an item of another set is termed disjoint. Structures need not be disjoint, that is to say a hierarchy can exist between the various data sets, sets, and subsets. A data set, a set, or a subset, that is an item in another data set, is said to be embedded. When a database contains embedded structures, a hierarchical file structure results.
A data set is a collection of related data records stored in a file in a random access storage device. A data set is similar to a conventional file. It contains data items and has logical and physical properties similar to files. However, unlike conventional files, data sets can contain other data sets, sets, and subsets.
A set is a structure that allows access to all records of a data set in some logical sequence. The set contains one entry for each record in the data set. Each set entry is an index that locates a data set record. If key items are specified for the set, records in the data set are accessed based upon these keys. Otherwise the records are accessed sequentially. Multiple sets can be declared for a single data set, thereby enabling the data in a data set to be accessed in several different sequences. A subset is similar to a set. Unlike a set, a subset need only refer to selected records in the data set. A data item is a field in a database record used to contain an individual piece of information.
Data items that are not a part of any data set are then called global data items. Global data items generally consist of information such as control totals, hash totals, and populations, which apply to the entire database. All global data items are stored in a single record.
The audit trail is a record of changes made to the database. The audit trail is used to recover automatically the database following a hardware or software failure. The audit trail specification clause describes the physical attributes of the audit trail.
The audit trail, as mentioned, consists of a record of changes to the database. It is only created for audited databases and is used in the various forms of database recovery.
An audit trail specification describes the attributes of the audit trail. The specification is optional. If no specification appears, attributes are assigned by default.
All audited databases must include a “restart” data set definition. There is a specialized syntax for specifying the audit trail attributes. These involve area size, area length, block size, buffers, checksum, and sections in addition to whether disk or tape is involved and types of tape being used.
The areas, area size, and area length are involved which indicate that disk or pack files are divided into areas. Areas are only allocated as they are needed. Thus, a potentially large file can be small initially and then grow as needed. The user can control the maximum amount of disk space allocated to a file by using the AREAS and AREASIZE (or the AREALENGTH) options.
AREAS specifies the maximum number of areas to be assigned to the file. The maximum value allowed for this is 1,000.
The user can specify the length of an area using the AREASIZE (or AREALENGTH) option. The default option for AREASIZE is BLOCKS. The default value is 100 blocks.
BLOCKSIZE: The records in the audit trail are normally blocked. The user can control the size of a block using the BLOCKSIZE option. BLOCKSIZE can be specified as one of the following items:
(i) SEGMENTS: The maximum value is 2,184 segments. SEGMENTS can define an audit buffer size that is larger than that defined by either the BYTES or WORDS option.
(ii) WORDS: This is the default option. If a User does not define a BLOCKSIZE, the audit trail will use a default BLOCKSIZE of 900 words. The maximum value here is 4,095 words.
(iii) BYTES: The maximum value allowed here is 24,570 bytes.
A Remote Database Backup or RDB is a database recovery system which can be a key component of a disaster recovery plan since it minimizes the amount of time needed to recover from a loss database access. The RDB system also minimizes the loss of productivity, minimizes the loss of revenue and minimizes the loss of business, which could occur because of interruptions in the ability to access one's database. The RDB works in conjunction with the Data Management System II (DMSII) databases plus Structured Query Language Database (SQLDB), the Semantic Information Manager (SIM) database, and the Logic and Information Network Compiler II (LINCII) databases.
The components of the RDB system consist of a database and also a copy of the database. One database is update capable and the other database can be used only for inquiry purposes. The update-capable database is called the primary database. The host on which this database resides is called the primary host. The “current on-line” remote database copy, which is called the secondary database, is “inquiry-capable” only. The host on which this database resides is called the secondary host. The configuration of the primary and the secondary databases on-their separate hosts is called the RDB System. A single host can participate in multiple RDB systems.
The RDB or remote database backup system enables users to maintain a current on-line inquiry-only copy of a database on an enterprise server, which is separate from the enterprise server on which the update-capable database resides. The host locations can be at the same site or at two geographically distant sites. The remote database backup keeps the database copy up-to-date by applying the audit images from the audited database to the database copy. There is a choice of four audit transmission modes which enables one to choose the means of audit transfer between hosts.
In the RDB system, the term “primary” and the term “secondary” will indicate the intended function of each copy of the database and the host on which it resides.
The primary database has the function for database inquiry and update, while the secondary database has the functionality useful for database inquiry only.
The secondary database cannot be updated by any application programs and the secondary database is modified only by the application of audit images of transactions performed on the primary database.
Since one complete RDB system is made of one database, and includes the secondary database which resides on another host, that is to say the primary database on one host plus one copy of that database.
A host is the system on which a primary or a secondary database resides. A host can function as a primary host in one RDB system and then also concurrently function as a secondary host for another RDB system. Additionally, one host can function as a secondary host (or a primary host) for multiple RDB systems.
When a RDB system is first initialized for a database, then by default, the primary host is the host upon which the database resides. The other host which is defined for that database is designated as a secondary host and it remains a secondary host until a takeover is performed or until the RDB capability is disabled. Both the primary and secondary hosts must have sufficient resources to support the RDB system and its application environment.
As an illustration, it can be seen how the primary database
Alam Hosain T.
Kozak Alfred W.
Rode Lise A.
Starr Mark T.
Unisys Corporation
LandOfFree
System and method for asynchronously receiving multiple... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for asynchronously receiving multiple..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for asynchronously receiving multiple... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2881477