JPH021056A - Data base processing system - Google Patents

Abstract

PURPOSE:To eliminate a competition in a data base resource by retrieval processing and update processing and to execute the retrieval processing at a high speed by processing a retrieval request, for which the up-to-dateness of data is unnecessary, using a retrieval system data base. CONSTITUTION:In a DB system (1)40, an update request is processed by accessing an update system DB (A)60, and the update information is stored in update data hysteresis information 70. In a DB system (2)50, only a reference request is accessed using a retrieval system DB (B)80 and processed. The DB (B)80 is the DB to execute a copy at a certain point in the DB (A)60. A user designates an access language according to the aim of the processing, and a language analyzing part 10 analyzes the access language and gives the analyzed access language to a managing part 20. The managing part 20 executes aimed DB processing by determing a DB system to execute the processing based on analysis information and requesting the determined DB system to execute the processing. When the analysis information is the request which never requests the up-to-dateness, a managing part 30 manages loaded status and determines a system having a low load.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database processing system for storing information, and particularly to a database processing system suitable for speeding up search processing.

[Conventional technology]

Conventionally, a method in which multiple tasks perform a search in a database system and another task performs an update is disclosed, for example, in Japanese Patent Laid-Open No. 61-88349.
A method is known in which the load of update processing is distributed by giving priority to update-related tasks and performing processing on a track-by-track basis. According to this method, it is possible to reduce the waiting time of search-related tasks.

[Problem to be solved by the invention]

In the above-mentioned conventional technology, no consideration was given to speeding up the search performance, and it was unfortunate that the search-related tasks could not be processed while the update-related tasks were being processed.

The present invention has been made in view of the above circumstances, and its purpose is to solve the above-mentioned problems in the conventional technology, eliminate competition for database resources due to search processing and update processing, and speed up search processing. The purpose of this invention is to provide a database processing system that achieves the following.

[Means to solve the problem]

The above object of the present invention is to provide a search database.

In a database system separated into an update database or update data history information, in response to a search request for a database that requires up-to-dateness, the search request is
Processing is performed using an update database or update data history information and a search database, and in response to a search request for a database that does not require up-to-dateness, the search request is processed using a search database. This is achieved by a database processing system characterized by the following.

[Effect]

In the database processing system according to the present invention, search requests that do not require data recency are executed by the search database system, which does not perform any shared control processing or exclusive control processing of data resources, so that it is not compatible with general database systems. In comparison, it is possible to improve the performance of search-related processing.

〔Example〕

Hereinafter, one embodiment of the present invention will be described in detail based on the drawings.

FIG. 1 is a diagram showing an example of the configuration of a database (hereinafter referred to as rDBJ) system that is an embodiment of the present invention.

In FIG. 1, DB system (1) 40 and DB system (2) 50 are independent DB systems,
The DB system (1) 40 processes update (including reference) requests by accessing the update system DB (A) 60, and stores the update information in the update data history information 70. DB
In the system (2) 50, only reference requests are sent to a search database (
B) Access and process using 80. Search DB (
B) 80 is a DB that has been copied from the update system DB (A) 60 at a certain point in time.

Note that the update system DB (A) 60 may be omitted, and in that case, the update data history information 70 and the search system DB (B
) 80 for access and processing.

The user specifies the access language shown in FIG. 2 depending on the processing purpose. The language analysis unit 10 analyzes the specified DB access language and passes it to the DB system management unit 20.

The DB system management unit 20 processes D based on the analysis information.
By determining the B system and requesting execution to the DB system, the desired DB processing is performed.

It is determined whether the above analysis information is a request that does not require recency, that is, a request that requires high speed, and if high speed is required, the system load management unit 30 is called.

The system load management unit 30 manages the load status of each DB system and determines a system with a low system load.

Furthermore, if the analysis information is in an update language, the DB update process is performed by requesting execution to the DB system (1) 40 having the update system DB (A) 60.

If the analysis information is a request to reflect updated data, a request is sent to the DB system (1) 40 to transfer the updated data history information 70 to a new storage area, and the updated data history information 70 is disconnected. Let go. DB system (2) 50
is a DB that receives update data history information 70 as input.
An update request is issued and the search system DB (B) 80 is updated.

FIG. 3 is a table for managing the status of the entire system. The system name 31 and DB name 32 are the D
Used to determine the B system.

The copy source DB name 33 is a DB that copied the update system DB, and indicates the name of the update system DB of the copy source, and is a DB with a low system load.
Used for searching B. The number of transactions executed per DB (X) 34 indicates the number of DB access languages being processed for the DB, and the number of transactions allowed in the system (
Y) 35 represents the maximum number of DB access language processes that can be processed in parallel by the DB system. From these, the value of the load factor (Z) 36 is determined by the following formula.

Z = X/Y The above load factor (Z) 36 is used to determine a DB system with a low system load. Update data reflection flag 37
is used to prohibit search processing when a search request is received while the search system DB (B) 80 is being updated. The update DB omission flag 38 is a flag expressing the presence or absence of an update system DB.

FIG. 4 is a flowchart showing the operation of the DB system management section 20 of this embodiment configured as described above. Hereinafter, an example of operation will be described in detail according to this.

First, in step 200, the DB access language is “
If it is ATT, increase the number of database unit execution transactions of the corresponding DB in the system management table described above by 1 (step 201), and if the update system DB (A) 60 is not omitted in step 202, The update system DB system (1) 40 is commanded to perform a search process (step 203), and if the update system DB (A) 60 is omitted, the update data history information 70 is commanded to perform a search process (step 204).

In step 205, if the data does not exist, the search DB system (2) 50 is ordered to perform the search process (step 206), and after the search process is completed, the number of database unit execution transactions for the DB in the system management table is subtracted by 1. (Step 207), the process ends.

Next, in step 210, if the DB access language is
IB", the system load management section 30 described above
The process is passed to the specified DB name, and the copy DB with the minimum load rate is
The search database system (B
) 80 to perform the search process (step 213), and after the search process is completed, the number of database unit execution transactions for the corresponding DB in the system management table is decreased by 1 (step 213).
14), the process ends.

Finally, in step 220, if the DB access language is II CII, the system load management unit 30
The process is passed to the specified DB name, and the search system D with the minimum load rate is
Obtain B name or update system DB name (Step 22)
1) Increase the number of database unit execution transactions of the DB in the system management table by 1 step 222
), instructs the DB system to perform a search process, step 22
3) After the search process is completed, the corresponding DB in the system management table
The number of database unit transactions in the database is decreased by 1 (step 224), and if in step 225,
If the DB is a DB lock, the process is executed again, and if the DB is not a DB lock, the process is ended.

Meanwhile, in step 220, the DB access language is “
D'', the update system DB is commanded to swap the update data history information (step 231), and the update data reflection flag of the search system DB that updates the system management table is turned on (step 232).

Instruct the search database to be updated based on the update data history information 70 (step 233), and after the update data history information update process is completed, turn off the updated data reflection flag of the search database that reflects the update of the system management table. At step 234), the process ends.

FIG. 5 is a flowchart showing the operation of the system load management section 30 in this embodiment. Hereinafter, an example of operation will be described in detail according to this.

First, the load factor of each DB is determined from the number of transactions executed per database and the number of transactions allowed in the system (step 300). Next, in step 301, a copy DB name is determined by referring to the system management table from the specified DB name, and in step 302, if the updated data reflection flag of the DB is off from the system management table, the process proceeds to the next step. If it is on, search the next system management table. In step 303, if the load factor is the minimum, the process advances to the next step, and if it is not the minimum load factor, the next system management table is searched. In step 305, if the copy DB name has been determined, the determined DB name is returned (step 307).
). On the other hand, in step 305, if the copy DB name has not been determined, the designated DB name is returned as the determined DB name.

According to the above embodiment, if the database system or the like does not require the latestness of the data to be searched, processing overhead due to contention of data resources can be eliminated, and the search processing performance of the system can be improved. Furthermore, since user requests are distributed to the most appropriate databases while taking into account the load balance of multiple database systems, it is also effective in improving the throughput performance of the entire system.

Note that each of the above embodiments is shown as an example, and the present invention should not be limited thereto.

[Effects of the Invention] As described above, according to the present invention, in a database system that is separated into a search database and an update database or update data history information, it is possible to respond to a search request for a database that requires up-to-dateness. and processes the search request using an update database or update data history information and search database, and
In response to a search request for a database that does not require up-to-dateness, the search request is processed using a search database, eliminating competition for database resources between search processing and update processing, and increasing the speed of search processing. This has the remarkable effect of making it possible to realize a database processing system that is highly scalable.

[Brief explanation of the drawing]

Fig. 1 is a diagram showing the configuration of a DB system that is an embodiment of the present invention, Fig. 2 is a diagram showing an overview of the DB access language, Fig. 3 is a diagram showing the format of the system management table, and Fig. 4 is a diagram showing the outline of the DB access language. Flowchart showing the operation of the DB system management section, No. 5
The figure is a flowchart showing the operation of the system load management section. 10: Language analysis department, 20: DB system management department, 30 System load management department, 40: DB system (1), 50
: DB system (2), 60: Update system DB (A),
70: Update data history information, 80: Search database (B). Figure Patent Applicant: Hitachi, Ltd.

Claims (1)

[Scope of Claims] 1. In a database system separated into a search database and an update database or update data history information, in response to a search request for a database that requires up-to-dateness, the search request is A database processing system characterized by processing using a database, or update data history information and a search database. 2. The database processing system according to claim 1, wherein in response to a search request for a database that does not require up-to-dateness, the search request is processed using a search database. 3. Database processing according to claim 1, characterized in that in response to a search request for a database regardless of its latestness, the search request is processed using a database with a light load within the system. system. 4. Database processing according to claim 3, characterized in that if a database lock occurs during processing, the database processing is stopped and the search request is processed using a database of another system. system. 5. The database processing system according to claim 1 or 2, characterized in that a database access language indicating whether or not the search request requires up-to-dateness is used.