KR100262948B1 - Global Lookup Method of Database System with Intermediate Processor - Google Patents

Abstract

PURPOSE: A global query method of a database system having an intermediate processor is provided to distribute a communication capacity, and to reduce a query time. CONSTITUTION: Intermediate processors(200,220,240) analyze query sentences received from a data consumer(110), and decide whether the query sentences need to be transmitted to data sources(120,122,124,126,128,130,132,134). If so, the intermediate processors(200,220,240) transmit the query sentences to the data sources(120,122,124,126,128,130,132,134). The data sources(120,122,124,126,128,130,132,134) process the received query sentences to transmit the processed query sentences to the data consumer(110). If the query sentences do not need to be transmitted, the intermediate processors(220,220,240) process the received query sentences, and transmit a processed result to the data consumer(110).

Description

Global query method of database system with intermediate processor

The present invention relates to a global query method for a database system having an intermediate processor.

With the proliferation of computer communication network and the increase of computer processing system, the development of database system in distributed environment is increasing day by day, but the transmission of data is connected to the interconnection protocol by using computer communication network due to the physical isolation between producers and consumers of data. By sharing the material.

Global Query refers to searching required data by logically grouping databases of systems distributed locally through a network.

There is a data replication problem inherent in the distribution of data through the network, and various techniques for solving the problem have appeared, and some of them have been adopted in commercial products.

On the other hand, currently existing problems include a synchronization problem of data replication, that is, a synchronization replication and asynchronous replication problem, and a connection problem of a distributed database, that is, a problem of connecting individual databases by polling. Synchronous replication means that when the data in the source database changes, the intermediate or consumer database changes simultaneously. Asynchronous replication means that even when the data in the source database changes, the intermediate or consumer database changes. The data are not changed immediately, but the data are changed at preset intervals. Synchronous replication is good for instantaneous data changes, but it causes a lot of network traffic. Asynchronous replication is the reverse.

In addition, the problem of accessing distributed database is to connect all network hosts that are in the range of query when searching data. Data replication is related to the increase and decrease of traffic, and database access is closely related to the increase and decrease of traffic. have.

Inter-database communication in a distributed environment has a traditional environment as shown in FIG.

1 is a structural diagram of a conventional database system.

As shown in the figure, a conventional database system includes a data consumer 110, a data producer 120, 122, 124, 126, 128, 130, 132, and a data consumer 110 and a data producer 120, 122. , 124, 126, 128, 130, 132 is provided with a network 140 for connecting.

In such an environment, the connection between databases may be connected to various data sources (120, 122, 124, 126, 128, 130, 132) distributed in a network in a data consumer (110) that needs data. Data is collected by communicating with the database of the defined protocol.

The data consumer 110 is connected to the database of all data producers 120, 122, 124, 126, 128, 130, and 132 included in the defined range of the necessary data individually to bring the necessary data.

However, the conventional method has less problem when the range of data is obtained is small, but when the range is large, that is, when it spreads to the entire range of the enterprise network, a large amount of connection time is required, which significantly lowers the utilization rate of the database resource. In addition, there was a problem in that the reliability is also poor.

Accordingly, the present invention has been made to solve the problems of the prior art as described above, and provides a global query method for a database system having an intermediate processor that distributes communication and shortens inquiry time when connecting a distributed database. Its purpose is to.

1 is a structural diagram of a conventional database system.

2 is a structural diagram of a database system having an intermediate processor to which the present invention is applied;

3 is a flowchart illustrating a global inquiry performing process of a data consumer according to an embodiment of the present invention.

4 is a flowchart illustrating a global inquiry performing process of an intermediate processor according to an embodiment of the present invention.

5 is a flowchart illustrating a global inquiry performing process of a data producer according to an embodiment of the present invention.

* Explanation of symbols for the main parts of the drawings

110: data consumer

120, 122, 124, 126, 128, 130, 132, 134: data producer

200, 220, 240: Intermediate processor

In order to achieve the above object, the present invention provides a global inquiry method applied to a database system having an intermediate processor, wherein the intermediate processor analyzes an inquiry sentence received from a data consumer to determine whether it is necessary to transmit an inquiry sentence to a data producer. A first step of making; A second step in which the intermediate processor transmits an inquiry sentence to the data producer when the inquiry sentence needs to be transmitted, and the data producer processes the received inquiry sentence and transmits it to the data consumer. ; And a third step of transmitting the processing result to the data consumer by processing the received inquiry sentence by itself when the transmission of the inquiry sentence is not necessary as a result of the determination of the first step. do.

Hereinafter, an embodiment according to the present invention will be described in detail with reference to FIGS. 2 to 5.

2 is a structural diagram of a database system having an intermediate processor to which the present invention is applied.

As shown in the figure, a database system having an intermediate processor includes a data consumer 110, a data producer 120, 122, 124, 126, 128, 130, 132, 134, a network 140, and a network 140. Intermediate processor (200, 220) located on the communication path connecting the data source with data producers (120, 122, 124, 126, 128, 130, 132, 134) to distribute the traffic in the database connection and have a quick inquiry time And 240).

In a database system having intermediate processors 200, 220, and 240, the intermediate processors 200, 220, and 240 are around the data producers 120, 122, 124, 126, 128, 130, 132, and 134, respectively. Always retrieve data from data producers 120, 122, 124, 126, 128, 130, 132, and 134 through interprocessors 200, 220, and 240. do.

At this time, the data consumer 110 attempts to access a large range of databases by only connecting intermediate databases of the predetermined intermediate processors 200, 220, and 240 without having to access each database system belonging to the range. Can greatly reduce the traffic.

On the other hand, the data of the database of the intermediate processor (200, 220, 240) and the data producers (120, 122, 124, 126, 128, 130, 132, 134) contained therein is periodically or every time each database is updated. By updating the database data of the intermediate processor 200, 220, 240 immediately, the consistency of the data can be maintained.

The hierarchical structure of the scope for querying data can be divided into Global, Region, and System. Regions can be further divided according to network structure and number of access systems.

The method of referring to this hierarchical structure is as follows.

CREATE ALLAS GLOBAL alpha IN (beta, REGION1, ... REGIONn) refers to the entire region by the name alpha,

CREATE ALLAS REGION beta IN (theta, REGION1, ... REGIONn) and

CREATE ALLAS REGION theta IN (SITE1, SITE2, SITE3, ... SITEn) refers to the lower layer. When querying the actual data by the defined name, you can refer to the scope by using the following command.

SELECT name, phone, address FROM employee AREA alpha;

3 is a flowchart illustrating a global inquiry performing process of a data consumer according to an embodiment of the present invention.

As shown in the figure, in the process of performing a global inquiry of a data consumer, the data consumer first prepares an inquiry sentence to make an inquiry (301), and searches an information table of predefined intermediate processors (302).

Thereafter, the data processor sequentially connects to the intermediate processor through the network (303), transmits the prepared inquiry sentence to the intermediate processor (304), and drives the processor that receives the transmitted result (305).

Subsequently, it is determined whether it is the last intermediate processor (306).

As a result of the determination, if the final intermediate processor does not repeat the process of preparing an inquiry sentence (301), and if the final intermediate processor determines whether all the inquiry results have been received (307).

As a result of the determination, if all the inquiry results have not been received, after waiting for a predetermined time (308), the process of determining whether all the inquiry results have been received is repeated from step 307, and if all the inquiry results have been received after processing the inquiry results (309). Exit.

4 is a flowchart illustrating a global inquiry performing process of an intermediate processor according to an embodiment of the present invention.

As shown in the figure, in the process of performing the global inquiry of the intermediate processor, the intermediate processor first determines whether the inquiry sentence is received in the waiting state 401 for receiving the inquiry sentence (402).

As a result of the determination, if the inquiry sentence has not been received, the process is repeated from step 402 of determining whether the inquiry sentence has been received, and if the inquiry sentence is received, after analyzing the inquiry sentence (403), whether to transmit the inquiry sentence to the data producer or to process itself. It is determined whether to do (404).

As a result of determination, if it is determined that the self-processing process is to process the inquiry sentence directly (408), it is repeated from the process of waiting for the inquiry sentence 401, and if the inquiry sentence is to be transmitted to the data producer, after the inquiry sentence is transmitted (405) It is determined whether or not (407).

As a result of the determination, if the inquiry result has not been received, the process repeats the process of determining whether to receive the inquiry result (407), and if the inquiry result is received after transmitting the received inquiry result (409) from the inquiry sentence waiting process (401). Repeat.

5 is a flowchart illustrating a global inquiry performing process of a data producer according to an embodiment of the present invention.

As shown in the figure, in the global inquiry performing process of the data producer, the data producer first determines whether to receive an inquiry sentence in a waiting state for an inquiry sentence (501).

As a result of the determination, if the inquiry sentence is not received, the inquiry sentence stays in a waiting state, and when the inquiry sentence is received, the received inquiry sentence is processed (502), and the inquiry result is transmitted to the intermediate processor (503) and the inquiry sentence is received. The process repeats from step 501 to determine whether it is.

The present invention described above is capable of various substitutions, modifications, and changes without departing from the spirit of the present invention for those skilled in the art to which the present invention pertains, and the above-described embodiments and accompanying It is not limited to the drawing.

As described above, the present invention has the effect of distributing communication amount and connecting at a short time in distributed database connection.

Claims (4)

In the global query method applied to a database system having an intermediate processor, A first step in which the intermediate processor analyzes the inquiry sentence received from the data consumer and determines whether the inquiry sentence needs to be transmitted to the data producer; A second step in which the intermediate processor transmits an inquiry sentence to the data producer when the inquiry sentence needs to be transmitted, and the data producer processes the received inquiry sentence and transmits it to the data consumer. ; And A third step of transmitting the processing result to the data consumer by processing the received inquiry sentence by itself when the transmission of the inquiry sentence is not necessary as a result of the determination of the first stage; Global query method of the database system having an intermediate processor made, including. The method of claim 1, The first step is, The data consuming party prepares an inquiry sentence and sends it to the intermediate processor; The data consuming destination is a fifth step of driving a receiving processor; A sixth step of receiving, by the intermediate processor, an inquiry sentence; A seventh step of analyzing the inquiry sentence received by the intermediate processor; And An eighth step of the intermediate processor determining whether an inquiry sentence needs to be transmitted to the data producer based on an analysis result; Global query method of the database system having an intermediate processor made, including. The method of claim 2, The second step, A ninth step of transmitting an inquiry sentence to the data producer; A tenth step of processing the inquiry sentence received by the data producer; An eleventh step of sending, by the data producer, a processing result to the intermediate processor; And A twelfth step of transmitting the processing result received by the intermediate processor to the data consumer; Global query method of the database system having an intermediate processor made, including. The method of claim 3, wherein The third step, A thirteenth step in which the intermediate processor processes the inquiry sentence itself; And A fourteenth step in which the intermediate processor transmits its own processing result to the data consumer; Global query method of the database system having an intermediate processor made, including.

Images