JPH05334359A - Integrated data extraction system - Google Patents

Abstract

PURPOSE:To extract data from a data base by accessing the data base at the least frequency under integrated extraction conditions and to put an on-line system in simultaneous parallel operation. CONSTITUTION:An extraction condition registration/alteration part 3 registers and alters extraction condition definition information, classified by purposes, in an extraction condition file 6 and an integrated extraction condition generation part 4 generates integrated extraction conditions for efficient data extraction from the extraction condition definition information in the extraction condition file 6, structure definition information on data held in the data base 10 of a data attribute table 7, and definition information on its retrieval procedure and stores the generated conditions in an integrated extraction condition file 8; and the extraction execution control part 51 of an extraction execution part 5 performs execution control over data extraction processing on the basis of the integrated extraction conditions in an integrated extraction condition file 8, and the data extraction/output part 52 refers to the data attribute table 7 to extract object data from the data base 10 and also outputs the data to an extraction file 9 after the extraction.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for extracting data from a database in a computer system, and more particularly to an integrated data extraction method for generating integrated extraction conditions (hereinafter simply referred to as integrated extraction conditions) and data extraction.

[0002]

2. Description of the Related Art Conventionally, in an online system using a computer (for example, a banking system), data extraction processing for returning information to the end user etc. of the business processing results of the system is performed by the extraction
It was usual to develop and execute extraction business processing programs that perform processing.

[0003]

The above-mentioned conventional data extraction method has the following drawbacks because it has a form of individually developing and executing an extraction business processing program for each purpose.

(1) Since the extraction business processing programs for each purpose are individually developed and executed, a case occurs in which the same data is repeatedly extracted by a plurality of extraction business processing programs, and the processing is performed while the online system is operating. Data competition with the online system occurs frequently, affecting the processing capacity of the online system. In particular, this effect is great in an online system having a large-scale database such as a banking system.

Further, since each extraction business processing program implements a processing procedure depending on the database structure,
When the database structure is changed, it is necessary to modify all the extraction business processing programs, which requires a lot of man-hours and periods.

(2) When an extraction business processing program in which a plurality of purposes are integrated is developed in an attempt to overcome the drawbacks of (1), the processing becomes complicated and diversified, so that development and subsequent function change are largely performed. Requires a lot of man-hours and time.

In view of the above points, an object of the present invention is to extract data at the minimum number of times by the integrated extraction condition in which the extraction conditions are integrated without creating an extraction work processing program for each purpose. In this way, it is possible to simultaneously perform the multi-purpose data extraction processing with the online system, and to provide the integrated data extraction method that enables the data extraction processing function to be changed and new additions to be performed quickly. ..

[0008]

An integrated data extraction method of the present invention is a computer for extracting data for returning information to an end user or the like from a database that holds information on the results of business processing operating on an online system. In the system, an extraction condition file that stores data extraction condition definition information, and extraction condition registration / registration / registration of the extraction condition definition information for each purpose in this extraction condition file
A change unit, an integrated extraction condition file that stores integrated extraction conditions, a data attribute table that registers structure definition information of data held in a database and definition information of the search procedure, and extraction condition definition of the integrated extraction condition file Generates integrated extraction conditions for efficient data extraction in the entire computer system from the information and the structure definition information of the data of the data attribute table and the definition information of the search procedure, and stores the integrated extraction conditions in the integrated extraction condition file. Integrated extraction condition generation unit, an extraction execution control unit that controls execution of data extraction processing based on the integrated extraction conditions of the integrated extraction condition file, and extraction target data from the database based on an instruction from the extraction execution control unit. And a data extraction / output unit for performing extraction and outputting the extracted data to a file.

[0009]

In the integrated data extraction method of the present invention, the extraction condition file stores the extraction condition definition information of the data, and the extraction condition registration / change unit registers and changes the extraction condition definition information for each purpose in the extraction condition file. The integrated extraction condition file stores the integrated extraction conditions, the data attribute table registers the structure definition information of the data held in the database and the definition information of the search procedure, and the integrated extraction condition generation unit extracts the integrated extraction condition file. Generates integrated extraction conditions for efficient data extraction in the entire computer system from the condition definition information and the structure definition information of the data of the data attribute table and the definition information of the search procedure, and stores it in the integrated extraction condition file Then, the extraction execution control unit controls the execution of the data extraction process based on the integrated extraction conditions in the integrated extraction condition file, Out / to output to a file after extraction data with the extraction of the extracted target data from the database on the basis of the output unit is an instruction of the extracted execution control unit.

[0010]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an integrated data extraction system according to an embodiment of the present invention. The online system to which the integrated data extraction method of this embodiment is applied is a host computer 1 and a center console 13.
And a workstation 14 and an online terminal 15.

The host computer 1 has an integrated extraction processing mechanism 2 for extracting data, an extraction file 9 for storing the extracted data, a database 10 for holding information on business processing results, and business processing on the online system. A business online system 11 for performing the above and a business processing program 12 for performing secondary processing for returning extracted data to an end user or the like and outputting to a final output destination are installed.

The integrated extraction processing mechanism 2 includes an extraction condition registration / change unit 3, an integrated extraction condition generation unit 4, an extraction execution unit 5,
The extraction condition file 6, the data attribute table 7, and the integrated extraction condition file 8 are included.

The extraction condition registration / change unit 3 is activated by an instruction to input and change the extraction condition definition information from the workstation 14, and registers new extraction condition definition information in the extraction condition file 6 and saves existing extraction condition definition information. Make a change.

The extraction condition file 6 is a file for storing extraction condition definition information.

The integrated extraction condition generating unit 4 is activated by an instruction from the center console 13 and extracts the extraction condition file 6
All extraction condition definition information that should be executed at the same time is taken out, individual extraction conditions are integrated based on the information on the data attribute table 7, and efficient extraction is performed in consideration of the structure of the database 10. A possible integrated extraction condition is generated and output to the integrated extraction condition file 8.

The data attribute table 7 is a database 1
3 is a storage table of structure definition information of data held in 0 and access path information which is definition information of an efficient search procedure for those data.

The integrated extraction condition file 8 is a storage file of integrated extraction conditions.

The extraction execution unit 5 is activated by an instruction from the center console 13 and executes an actual extraction process. The extraction execution control unit 51 and the data extraction / output unit 52.
It consists of and.

The extraction execution control unit 51 issues an extraction output instruction for extraction and output of the extracted data to the data extraction / output unit 52.

When the data extraction / output unit 52 receives an extraction output instruction from the extraction execution control unit 51, the data extraction / output unit 52 extracts the integrated extraction condition from the integrated extraction condition file 8 according to the instruction,
Based on the definition information and the information on the data attribute table 7, the target data is extracted from the database 10,
After extraction, the extracted data can be a single or multiple extracted files 9 (first
It is selectively output to the extraction file 91, the second extraction file 92, the third extraction file 93, ..., The nth extraction file 9n).

Referring to FIG. 2, the data extraction / output unit 5
2 further includes an integrated extraction unit 521 and an individual extraction / output unit 5
22 and 22.

Here, the extraction condition definition information is as follows. Data extraction condition; a condition for specifying the extraction condition for the data item to be extracted based on the data storage structure of the database 10. Extraction timing: Designates the timing of actual extraction (for example, every day, every weekend, every month end, specific day, etc.). Output information: Designates the storage file for the extracted data.

The information held in the data attribute table 7 is as follows. (A) Database structure information: Information that defines the hierarchical relationship between various data held in the database 10 and the storage order (ascending order, descending order, random) of each data. (B) Access path information; Data item search procedure information for efficient data search based on the database structure information of (a).

Next, the operation of the integrated data extraction method of the present embodiment thus constructed will be described based on the concrete example shown in FIG.

When activated by inputting or changing an extraction condition definition information from the workstation 14, the extraction condition registration / change unit 3 registers the new extraction condition definition information in the extraction condition file 6 or the existing extraction condition definition. Change information.

The integrated extraction condition generating unit 4 checks the output timing of all the extraction condition definition information held in the extraction condition file 6 and extracts all the extraction condition definition information to be processed. Next, the integrated extraction condition generation unit 4
Analyzes the extraction conditions for each data item based on the database structure information on the data attribute table 7, finds the logical sum of the extraction conditions for the corresponding data items of all extraction condition definition information, and stores them in the integrated extraction condition file 8 in a table format. Store. At that time, the order of arrangement of condition values is also changed according to the storage order of the database structure information (if the storage order is ascending order, the condition values are in ascending order, if it is descending order, it is in descending order, if it is random, it is in order of occurrence. Store).

In this way, after the integrated extraction condition is generated for all data items, the integrated extraction condition generation unit 4
Individually extracts the extraction condition definition information that has been analyzed /
The output condition is stored in the integrated extraction condition file 8 in a table format. Here, the table format is a format for enabling efficient analysis / execution of the extraction execution unit 5, and it is assumed that condition values are arranged. Further, it is assumed that the condition relationship between the data items is predetermined (in FIG. 2, the condition relationship between the data items having a hierarchical relationship is shown as a logical product).

After the integrated extraction condition is generated, when the extraction execution unit 5 is activated from the center console 13, the extraction execution control unit 51 operates and issues an extraction output instruction to the data extraction / output unit 52.

When the data extraction / output unit 52 receives the extraction output instruction, the integrated extraction unit 521 first operates to extract the integrated extraction condition from the integrated extraction condition file 8 and the access path information from the data attribute table 7, respectively. The search of the database 10 according to the access path information and the determination of the integrated extraction condition are sequentially performed. Integrated extraction unit 52
1 is such that when a combination of data items matching the conditions is found, the combination of the data items is individually extracted / outputted by the output unit 522.
To take over.

The individual extraction / output unit 522 sequentially analyzes all the individual extraction / output conditions in the integrated extraction condition file 8 and checks whether the inherited combination of data items matches the extraction condition. If they match, the individual extraction / output unit 522 determines the extraction file 9 based on the output information held in the corresponding individual extraction / output condition, and outputs the data item. If they do not match, the individual extraction / output unit 522 checks the following individual extraction / output conditions.

In this way, after checking by all the individual extraction / output conditions, the individual extraction / output unit 52
2 issues an instruction to extract the next combination of data items to the integrated extraction unit 521.

The processes of the integrated extraction unit 521 and the individual extraction / output unit 522 are repeatedly performed until the corresponding data item does not exist in the database 10, and when the data item does not exist, the extraction execution unit 5 ends the process. To do.

[0034]

As described above, according to the present invention, since the data is extracted under the integrated extraction condition in which a plurality of extraction conditions are integrated, the same data is extracted from the database for a plurality of extraction purposes. Since it is only once, the data competition with the online system can be minimized, and the parallel operation can be performed without affecting the processing capability of the online system.

Further, since only the extraction condition definition information is created, it is not necessary to create an extraction operation processing program for each purpose, and a change in the database structure can be dealt with only by changing the extraction condition definition information. This has the effect of enabling swift response to function changes and new additions.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of an integrated data extraction method according to an embodiment of the present invention.

FIG. 2 is a block diagram showing the processes of an integrated extraction condition generation unit and an extraction execution unit shown in FIG. 1 in more detail.

[Explanation of symbols]

 1 Host computer 2 Integrated extraction processing mechanism 3 Extraction condition registration / change unit 4 Integrated extraction condition generation unit 5 Extraction execution unit 6 Extraction condition file 7 Data attribute table 8 Integrated extraction condition file 9 Extraction file 10 Database 11 Business online system 12 Business processing Program 13 Center console 14 Workstation 15 Online terminal 51 Extraction execution control unit 52 Data extraction / output unit 91 First extraction file 92 Second extraction file 93 Third extraction file 9n nth extraction file 521 Integrated extraction unit 522 Individual extraction / output Department

Claims (1)

[Claims] 1. A computer system for extracting data for returning information to an end user or the like from a database that holds information on the results of business processes operating on an online system, and an extraction for storing data extraction condition definition information. A condition file, an extraction condition registration / change unit that registers and changes extraction condition definition information for each purpose in this extraction condition file, an integrated extraction condition file that stores integrated extraction conditions, and the structure of the data held in the database An entire computer system from a data attribute table for registering definition information and definition information of its search procedure, extraction condition definition information of the integrated extraction condition file, structure definition information of data in the data attribute table and definition information of its search procedure Create integrated extraction conditions for efficient data extraction as seen in And an integrated extraction condition generation unit that stores the integrated extraction condition file in the integrated extraction condition file, an extraction execution control unit that controls execution of the data extraction process based on the integrated extraction condition of the integrated extraction condition file, and an instruction of the extraction execution control unit An integrated data extraction method comprising: a data extraction / output unit that extracts extraction target data from a database based on the above and outputs the extracted data to a file.