KR100567813B1 - Transaction Analysing System for Tandem system - Google Patents

Abstract

A transaction analysis system for analyzing audit trails that maintain records before and after transactions in a tandem system, wherein the audit time file is determined by receiving a start time and an end time information from a client, and analyzed according to the input time information. A specific time data change history inquiry module for providing an analysis result to a client; A specific file data change history inquiry module which receives the start time, the end time information, and the data file information from the client to determine an audit trail file, analyzes the time according to the time information and the data file information, and provides the analysis result to the client in a second format; And receiving the transaction ID from the client, analyzing the audit trail file, extracting the list for the transaction ID, creating a list of data files, creating a script file, and recovering the changed data due to mistakes or errors with the transaction ID to the original state. Disclosed is a transaction analysis and recovery system of a tandem system comprising a recovery module.

Analysis, analyzing, transaction, query, recovery, tandem

Description

Transaction Analysing System for Tandem System             

1 is a network configuration to which a transaction analysis and recovery system according to the present invention is applied.

Figure 2 is a block diagram showing the functional configuration of the analysis and recovery system according to an embodiment of the present invention.

3 is a screen capture diagram showing a specific time data change history inquiry screen.

4 is a screen capture diagram showing a specific file data change history inquiry screen.

5 is a screen capture diagram showing a data recovery target list.

5A is a screen capture diagram showing a result of data recovery.

6 is a screen capture diagram showing a detailed query result.

7 is a screen capture diagram of an input screen for a batch inquiry job request.

8 is a screen capture diagram showing the number of input and output by time of the statistical processing results.

9 is a screen capture diagram showing the number of input and output files for each of the statistical processing results.

The present invention relates to a transaction analysis and recovery system of a tandem system, and more particularly, by analyzing audit trails that store and manage changes to databases and files operated in the tandem system, Transaction analysis and recovery system of a tandem system to restore.

Tandem System is a generic term for Hewlett Packard's NonStop server family in the United States, and all components, including the operating system, are redundant. Originally made by Tandem of the United States, it was merged by Compaq and then merged with Hewlett Packard.

Tandem systems use a proprietary operating system called Guardian, also called NonStop Kernel or NSK.

In such tandem systems, TMF uses a subsystem called TMF to maintain the integrity and consistency of the database in the event of a media failure, such as a transaction, system, disk drive, or tape drive, due to a sudden power outage or earthquake. Records the before and after image of the transaction in the audit trail to withdraw the transaction when a failure occurs or to perform table-level recovery using the audit trail.

However, in case of system and media failure, recovery using TMF performs table-level recovery, so there is a critical problem that it is not possible to recover data that has been inadvertently changed due to intentional or mistake.

Moreover, there is a problem in that recovery using TMF requires a lot of time and skilled engineers.

In addition, there is a problem that a solution or method for querying the data change history by a transaction is not provided.

Therefore, an object of the present invention is to analyze the data change history of the database file managed in the tandem system without having to go through the complicated procedure by the skilled engineer's involvement to quickly analyze the audit trail, inquire the change history, intentional or mistake It is to provide a transaction analysis and recovery system of a tandem system that can recover data that has been incorrectly changed.

Other objects and features of the present invention will be more clearly understood through the preferred embodiments described below.

According to the present invention, in the transaction analysis and recovery system for analyzing the audit trail to keep the records before and after the transaction in the tandem system, the start time and end time information from the client to determine the audit trail file to the input time information A specific time data change inquiry module for analyzing according to and providing the analysis result to the client in a first format; A specific file data change history inquiry module which receives the start time, the end time information, and the data file information from the client to determine an audit trail file, analyzes the time according to the time information and the data file information, and provides the analysis result to the client in a second format; And receiving the transaction ID from the client, analyzing the audit trail file, extracting the list for the transaction ID, creating a list of data files, creating a script file, and recovering the changed data due to mistakes or errors with the transaction ID to the original state. Disclosed is a transaction analysis and recovery system of a tandem system comprising a recovery module.

Preferably, input a transaction ID to search by selecting a specific record from the result of the primary query by the specific time data change inquiry module or the specific file data change inquiry module, and automatically read the initial RBA and the initial sequence number. According to the transaction ID may further include a detailed lookup module for extracting a list of the input transaction ID from the first inquiry result to provide to the client in a third format.

For example, the first format includes a sequence number, a relative byte address (RBA), a transaction time, a transaction ID, a data file name, and an input / output type, and the second format includes a sequence number, a relative byte address (RBA), a transaction time, and a transaction. The third format may include a transaction ID, a data file name, the number of input / output types, and a processing result.

Preferably, it receives the start time and end time information, file name, input / output type, and output file name from the client, reads the environment variables set from the server's environment file, analyzes the audit trail file according to the input conditions, and provides them to the client. It may further include a batch lookup module for converting to a format to generate a result file of the specified output file name.

Also, preferably, all data changes generated by analyzing the audit trail file by inputting start time and end time information and optionally file name are displayed as data change by time of a specific file or data change by file between set time. The data change number may further include a statistical processing module for classifying the normal number of processing cases and the number of rolled-back processes and classifying each data again according to the input / output type.

Preferably, by designating a file name and inputting a standard utilization rate, the volume information is sequentially read from the specified files to obtain detailed information identified by the file name from the volume information, and then analyzed and processed into an appropriate format. It may further include a file usage check module provided.

Hereinafter, with reference to the accompanying drawings will be described an embodiment of the present invention.

1 is a diagram illustrating a network to which a transaction analysis system according to the present invention is applied.

The operator accesses the web server 200 using HTTP using the computer system 100, and the TM / MP 310, which is a subsystem of the kernel rotation system provided by the system itself in the tandem system 300, is connected to the database. The data change history of the file is stored in the audit trail 320 in transaction units.

The audit trail 320 stores data changes in transaction units, and each module of the analysis system 350 to be described below performs each function with reference to the audit trail 320.

Figure 2 is a block diagram showing the functional configuration of the analysis system according to an embodiment of the present invention.

Referring to FIG. 2, the analysis system according to the present invention includes a specific time data change history inquiry module 351, a specific file data change history inquiry module 353, and a recovery module 354.

The specific time data change inquiry module 351 receives the start time and the end time information from the client 100, determines an audit trail file, analyzes the received audit trail file according to the input time information, and provides the client with the first format. Provide analysis results.

Referring to the inquiry screen of FIG. 3, when the user logs in to a web page provided by the analysis system according to the present invention through the web server 200, selects a data change history inquiry function, and then selects a data change history inquiry for a specific time, the start is performed. A screen for inputting time and end time information is provided.

After receiving the start time and end time information from the client, the specific time data change history inquiry module 351 reads environment variables set from an environment file of a server constituting the tandem system.

Thereafter, the audit trail file is determined, and the audit trail file is analyzed according to the input time information, and the analysis result is provided to the client in the format shown in FIG.

That is, it provides in sequence number (SEQNO), relative byte address (RBA), transaction time, transaction ID, data file name and input / output (IO) type.

Here, the input / output type is either delete, insert, or update. For example, if the database is a customer information database, membership registration is inserted, membership withdrawal is deleted, and membership information is changed. Will be determined by the update.

Also, the specific file data change inquiry module 353 receives the start time, the end time information, and the data file information from the client, and then reads the environment variables set from the environment files of the server constituting the tandem system.

After that, the audit trail file is determined, the audit trail file is analyzed according to the input time information and the data file information, and only the list of the input specific file is extracted, and the analysis result is provided to the client in the format shown in FIG.

For example, as shown in Figure 4, the sequence number (SEQNO), RBA (Relative)

Byte Address), transaction time, transaction ID, and IO type.

In the two types of inquiry, the data may be transmitted in blocking or record units according to the amount of data to be transmitted to the client.

The recovery module 354 restores the changed data due to a mistake or an error to the original state based on the transaction analysis result.

Select one from the list of recovery targets shown in FIG. 5 to receive a transaction ID from the client. At this time, the RBA and the sequence number are input at the same time. The audit trail file is analyzed and the list of the corresponding transaction ID is analyzed. Extract only.

Subsequently, a list of data files related to the corresponding transaction is created, a script file is created, and recovered as a transaction ID. As shown in FIG. 5A, the number of I / O types generated in the corresponding data file is stored.

Optionally, the analysis system of the present invention includes a detail query module 352.

That is, the detailed information related to the specific transaction ID may be inquired from the result of the primary inquiry by the specific time data change history inquiry module 351 or the specific file data change history inquiry module 353.

That is, if a specific record is selected on the screen of FIG. 3 or FIG. 4, the transaction ID to be searched is input and the detail inquiry function is selected, the system reads the first RBA and the first sequence number.

Subsequently, a list of the input transaction IDs is extracted from the primary inquiry result according to the input transaction ID and provided to the client in a format as shown in FIG. 6.

Referring to FIG. 6, a transaction ID is used as an index key and output as a transaction time, a file name, an RBA, and an input / output type.

If you select any one of them, the details are displayed. Depending on the input and output types, the before image when deleting, the after image when inserting, and the before and after images when updating are displayed.

On the other hand, the recovery function can also be performed in the detail inquiry result screen, which can be performed without inputting a separate transaction ID since the target transaction ID is already input during the detail inquiry.

In addition, the analysis system of the present invention optionally includes a batch query module 356.

Referring to FIG. 7, a start time and end time information, a file name, an input / output type, and an output file name are input from a client, and environment variables set from an environment file of a server are read. Then, the audit trail file is analyzed and converted into a format to be provided to the client according to the input condition to generate a result file of the designated output file name, and the generated file can be transmitted to the path specified by the client by FTP.

According to the invention, it optionally includes a statistical processing module 355.

The statistics processing module 355 presents all data change cases generated for a specific time zone or a specific file, and distinguishes between normal processing rolls and rolled back processing numbers and outputs them according to input / output types.

Referring to FIGS. 8 and 9, a screen for processing statistics by a specific time zone or a specific file is shown. When the start time and end time information and optionally a file name are input, all data based on this are displayed. Provide the number of changes.

In the I / O statistics by time zone, the number of data changes by time zone of a specific file is displayed. In the I / O statistics by file, the number of data changes by file is displayed during the set time. In the same way, the normal number of processed cases and the number of rolled back cases are distinguished, and each processed number is displayed by being divided into delete, insert, and update according to the input / output type.

Also, preferably, the analysis system of the present invention may include a file usage check module 357 to search for a file whose usage rate exceeds a threshold to prevent file full.

You can specify a specific file name or use wildcards. The file usage checking module 357 sequentially reads volume information from the designated files and obtains detailed information identified by the file name from the volume information.

The analyzed result is processed in an appropriate format and provided to the client. For example, the size of the file, the current usage, and whether the file is currently open can be displayed.

Although the above has been described with reference to the preferred embodiment of the present invention, various modifications can be made at the level of those skilled in the art. Therefore, the scope of the present invention should not be determined limited to the above embodiment, but should be determined by the claims described below.

As described above, according to the present invention, there is an advantage in that, in addition to the table-based recovery through the TMF provided by the tandem system, data that is incorrectly changed by a mistake or an error can be recovered in a transactional unit.

In addition, the web-based user interface has the advantage that it is easy to analyze the audit trail and look up the data change history without having to be an experienced engineer.

Claims (6)

In the transaction analysis and recovery system that analyzes the audit trail that keeps records before and after the transaction in the tandem system, A specific time data change history inquiry module for receiving a start time and an end time information from a client, determining an audit trail file, analyzing the audit trail file, and providing an analysis result to the client in a first format; The specific file data change inquiry module which receives the start time, the end time information and the data file information from the client, determines the audit trail file, analyzes it according to the time information and the data file information, and provides the analysis result to the client in the second format. ; And Input the transaction ID from the client, analyze the audit trail file, extract the list for the transaction ID, create a list of data files, create a script file, and change the data by mistake or error to the original state with the transaction ID. Transaction analysis and recovery system of a tandem system comprising a recovery module for recovering. According to claim 1, The specific time data change history inquiry module or the specific file data change history inquiry module selects a specific record from the result of the primary inquiry, and inputs the transaction ID to be queried and automatically inputs the first RBA and the first sequence. Transaction analysis of the tandem system further comprises a detailed query module for reading the number and extracts a list of the input transaction ID from the first inquiry result in accordance with the transaction ID to provide to the client in a third format And recovery system. 3. The method of claim 2, wherein the first format includes a sequence number, a relative byte address (RBA), a transaction time, a transaction ID, a data file name, and an input / output type, and the second format includes a sequence number, a relative byte address (RBA), And a third format comprises a transaction ID, a data file name, the number of I / O types, and a processing result. The transaction analysis and recovery system of a tandem system. The method according to claim 1, wherein the audit trail file is read according to the input condition by receiving a start time and end time information, a file name, an input / output type, and an output file name from the client, and reading environment variables set from an environment file of a server. And a batch query module for analyzing and converting the file into a format to be provided to the client to generate a result file of a specified output file name. According to claim 1, The start time and the end time information and optionally the file name received by analyzing the audit trail file all the data changes generated by the number of data changes per time zone of the specific file or the number of data changes per file between the set time The data change number is divided into normal processing number and rolled back processing number, and the transaction analysis and recovery system of the tandem system further comprises a statistical processing module for classifying and displaying each again according to the input / output type. . The method of claim 1, wherein the file name is specified and a reference usage rate is input to sequentially read volume information from the designated files to obtain detailed information identified by the file name from the volume information, and to analyze the result in an appropriate format. Transaction processing and recovery system of the tandem system, characterized in that it further comprises a file usage check module for processing and providing to the client.

Images