WO2018110909A1

WO2018110909A1 - Method and apparatus for processing queries

Info

Publication number: WO2018110909A1
Application number: PCT/KR2017/014370
Authority: WO
Inventors: 엄정호; 박경석; 이용; 문봉기; 김상철
Original assignee: 한국과학기술정보연구원
Priority date: 2016-12-12
Filing date: 2017-12-08
Publication date: 2018-06-21
Also published as: KR101757249B1

Abstract

Disclosed are a method and apparatus for processing queries, the method and system processing a particular query (such as a union query or a multi-dimensional query) by means of links between a plurality of multi-dimensional databases located remotely, thereby implementing a novel query processing scheme that is different from the conventional on the basis of synchronized multi-dimensional databases.

Description

Apparatus and Method for Processing Query

The present invention relates to a query processing technique based on a multi-dimensional database, and more particularly, to a new query processing for performing a specific query (eg, an association query, a multidimensional query, etc.) between a plurality of multidimensional databases. It's about the room.

The multidimensional database is a database that manages data containing a large number of attribute items in order to model large amounts of multidimensional data such as scientific information and medical information, and to support query processing and computation.

Based on such a multidimensional database, a large amount of multidimensional data may be analyzed and the results may be stored. However, recently, due to the development of observation equipment and related technologies, the capacity of data used in experimental data and scientific research has not been able to store and manage all data in one cluster or one institution.

In order to solve this problem, a multidimensional database can be built on the computational resources of the researcher to analyze and query the multidimensional data.

However, as the multi-dimensional database is individually constructed, the cost of loading and managing data rapidly increases. In addition, there is a limitation in that query processing cannot be performed because a method for interlocking and controlling a multidimensional database managed by different management methods is not established.

Accordingly, there is a need for a technique for processing a query and sharing the results among a plurality of multidimensional databases that are not provided in the existing multidimensional databases.

The present invention has been made in view of the above circumstances, and an object of the present invention is to perform a specific query (eg, association query, multidimensional query, etc.) through interworking between a plurality of remotely located multidimensional databases. By doing so, a new query processing scheme based on synchronized multidimensional database is realized.

The query processing apparatus according to the present invention for achieving the above object, the transmission and reception management unit for receiving a specific query associated with at least two multi-dimensional database from the user terminal; A procedure manager to determine a query processing procedure based on a result of checking the attribute of the specific query; And a query execution management unit for processing the specific query based on the query processing procedure to generate a specific query processing result.

A connection manager configured to control a connection between corresponding multidimensional databases based on master related information of each master server of the at least two multidimensional databases; And a synchronization management unit for controlling synchronization to be performed based on slave related information for each slave server of the connected multidimensional database.

The master related information includes address and port information for each master server, and the slave related information includes network information for each slave server and at least one array information.

The procedure management unit, when the specific query calls array information distributed in the synchronized multidimensional database, confirms the attribute of the specific query with a federated query, and the specific query is synchronized. When calling only array information stored in some multidimensional databases among the multidimensional databases, the attribute of the specific query is identified as a multidimensional query.

The procedure manager, when the specific query is the association query, generates a first query processing procedure for simultaneously performing the processing on the association query in the synchronized multidimensional database, wherein the specific query is the multidimensional query. In this case, the second query processing procedure may be generated so that the processing for the multidimensional query is performed only in the partial multidimensional database.

The query execution management unit controls the first query processing result to be merged when the federated query is processed based on the first query processing procedure to generate a first query processing result for each synchronized multidimensional database. Generate a specific query processing result, and when the multidimensional query is processed based on the second query processing procedure and a second query processing result is generated only in the partial multidimensional database, the second query processing result is processed by the specific query processing. It is characterized by determining as a result.

In order to achieve the above object, a method of operating a query processing apparatus according to the present invention includes a transmission and reception management step of receiving a specific query related to at least two multidimensional databases from a user terminal; A procedure management step of determining a query processing execution procedure based on a result of checking the attribute of the specific query; And a query execution management step of processing the specific query based on the query processing procedure to generate a specific query processing result.

A connection management step of controlling a connection between corresponding multidimensional databases based on master related information for each master server of the at least two multidimensional databases; And a synchronization management step of controlling synchronization to be performed based on slave related information for each slave server of the connected multidimensional database.

The procedure management step may include: when the specific query calls array information distributed in the synchronized multidimensional database, ascertaining the attribute of the specific query as an association query; And when the specific query calls only array information stored in a part of the synchronized multidimensional database, the attribute of the specific query as a multidimensional query.

The procedure management step may include: generating a first query processing procedure for simultaneously processing the association query in the synchronized multidimensional database when the specific query is the association query; And when the specific query is the multidimensional query, generating a second query processing procedure for performing the processing on the multidimensional query only in the partial multidimensional database.

In the query execution management step, when the association query is processed based on the first query processing procedure to generate a first query processing result for each synchronized multidimensional database, the first query processing result is controlled to be merged. Generating a result of processing the specific query; And determining the second query processing result as the specific query processing result when the multidimensional query is processed based on the second query processing procedure to generate a second query processing result only in the partial multidimensional database. Characterized in that.

Therefore, according to the apparatus and method for processing a query of the present invention, the specific query (e.g., association query, multidimensional query, etc.) processing is performed by interworking between a plurality of remotely located multidimensional database, different from the existing one. It can provide a new query processing method based on synchronized multidimensional database.

1 is a diagram illustrating a communication environment to which a query processing apparatus according to an embodiment of the present invention is applied.

2 is a diagram illustrating a schematic configuration diagram of a multidimensional database according to an exemplary embodiment of the present invention.

3 is a diagram showing a schematic configuration of a query processing apparatus according to an embodiment of the present invention.

4 is a diagram illustrating a flow of providing a synchronization-based query processing service according to an embodiment of the present invention.

It is to be noted that the technical terms used herein are merely used to describe particular embodiments, and are not intended to limit the present invention. In addition, the technical terms used in the present specification should be interpreted as meanings generally understood by those skilled in the art unless they are specifically defined in this specification, and are overly inclusive. It should not be interpreted in the sense of or in the sense of being excessively reduced. In addition, when the technical terms used herein are incorrect technical terms that do not accurately represent the spirit of the present invention, it should be replaced with technical terms that can be understood correctly by those skilled in the art. In addition, the general terms used in the present invention should be interpreted as defined in the dictionary or according to the context before and after, and should not be interpreted in an excessively reduced sense.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings, and the same or similar components will be given the same reference numerals regardless of the reference numerals, and redundant description thereof will be omitted. In addition, in describing the present invention, when it is determined that the detailed description of the related known technology may obscure the gist of the present invention, the detailed description thereof will be omitted. In addition, it is to be noted that the accompanying drawings are only for easily understanding the spirit of the present invention and are not to be construed as limiting the spirit of the present invention by the accompanying drawings. The spirit of the invention should be construed to extend to all changes, equivalents, and substitutes in addition to the accompanying drawings.

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

First, a communication environment to which an apparatus (hereinafter, a query processing apparatus) for processing a plurality of multi-dimensional databases based queries of the present invention will be described will be described with reference to FIG. 1.

As shown in FIG. 1, the communication environment to which the present invention is applied may include a query processing apparatus 100, a user terminal 200, and a plurality of multi-dimensional databases (eg, multi-dimensional databases a, b, and c. .) 300 may have a configuration including.

The query processing apparatus 100 is a device for processing a specific query (eg, association query, multidimensional query, etc.) between the multidimensional database 300. In particular, the service to be provided by the present invention, that is, a plurality of remote locations An apparatus for providing a new query processing service (hereinafter, referred to as a synchronization-based query processing service) based on a synchronized multidimensional database that is different from the existing one so that query processing may be performed through interworking between the multidimensional databases 300.

Here, the specific query refers to a combined query processed by calling array information distributed in the synchronized multidimensional database when the synchronization is performed after the multidimensional database 300 is connected, and the synchronized multidimensional database. Some of them may be divided into multidimensional queries processed by calling only array information stored in a multidimensional database. Each query processing process will be described in more detail later.

Such a query processing apparatus 100 may be implemented in the multidimensional database 300 or may be implemented as a separate device. In the embodiment of the present invention, the query processing apparatus 100 is separated from the multidimensional database 300 and exists independently, and will be described with reference to controlling the multidimensional database 300.

That is, the query processing apparatus 100 determines a query processing procedure for processing a specific query (eg, association query, multidimensional query, etc.) through interworking with the multidimensional database 300, and then based on the result, the specific query processing result. It generates and provides to the user terminal 200.

The user terminal 200 may be a terminal used by a user to receive a synchronization-based query processing service, and transmits a specific query (eg, association query, multidimensional query, etc.) input from the user to the query processing apparatus 100. You can request the generation of a specific query result.

The user terminal 200 may be a terminal of an organization / organization that wants to receive a synchronization-based query processing service, or may be a terminal used by an individual.

The multidimensional database 300 is a database for modeling a large amount of multidimensional data (for example, scientific information, medical information, etc.) and managing data having a plurality of attribute items in order to support query processing and operation.

The multi-dimensional database 300 includes at least one multi-dimensional database (a, b, c ..) located remotely, in conjunction with the query processing apparatus 100 to provide a synchronization-based query processing service Perform an algorithm for processing a specific query (eg, association query, multidimensional query, etc.).

In this regard, Fig. 2 shows an example of the configuration of the multidimensional database of the present invention. Since each configuration of the multidimensional database (a, b, c ..) shown in FIG. 1 is the same, in FIG. When the pre-built multidimensional database is a multidimensional database b, a specific query processing algorithm is performed through interworking with the multidimensional databases a and b to provide a synchronization-based query processing service.

As shown in FIG. 2, the multidimensional databases a and b of the present invention each include a master server MS and at least one slave server SS. The multidimensional database a, b executes a specific query processing algorithm for processing a specific query (eg, federated query, multidimensional query, etc.) input from the user through the master server MS under the control of the query processing apparatus 100. do. In this case, array information stored in at least one slave server SS is used.

Hereinafter, since the configurations of the master servers MS of the multidimensional databases a and b are the same, the characteristics of each configuration will be described in more detail using the master servers MS of the multidimensional databases a and b.

The query processing procedure establishing unit 310a may be a federated multi-dimensional data query planner. The query processing procedure establishing unit 310a may access to which array information to access a specific query (eg, association query, multidimensional query, etc.) input from the user, and plan which operation to perform. The basic query processing procedure is established.

The query scheduler 320a may be a federated multi-dimensional data query scheduler. The query scheduler 320a registers a specific query (eg, a federated query, a multidimensional query, etc.) input to a database, and performs a function of managing work execution.

The query processing unit 330a may be a federated multi-dimensional data query processor, and executes a function of executing a specific query processing algorithm such that a specific query processing result is generated through processing of a specific query (eg, an association query, a multidimensional query, etc.). To perform.

The merge execution unit 340a may be a Result Data Merger. The merge execution unit 340a performs a function of generating a specific query processing result by performing merging on the respective query processing results when the respective query processing results are generated on each multidimensional database.

The data transmitter / receiver 350a may be a data transmitter and a data receiver, and performs data transmission and reception when interworking with the query processing apparatus 100 or another multidimensional database.

The connection execution unit 360a may be a database connector and performs a function of executing a connection between the master servers MS.

Accordingly, the multidimensional databases a and b may perform a connection based on master related information about each master server MS. Here, the master related information may include address and port information for each master server.

Accordingly, the master server MS of the multidimensional database a and the master server MS of the multidimensional database b may perform a connection based on their own address and corresponding port information.

As such, when the physical connection is completed, the multidimensional databases a and b perform a process of sharing and synchronizing the environmental information with each other.

That is, the physically connected multidimensional databases a and b perform synchronization based on slave related information for each slave server SS. Here, the slave related information may include network information for each slave server (SS) and at least one array information.

Since the multidimensional databases a and b mainly consider the cluster environment, the network information of the respective slave servers SS and the array information held by the multidimensional databases a and b are matched and shared as meta information.

In the exemplary embodiment of the present invention, the query processing apparatus 100 and the multidimensional database 300 are interlocked to perform a specific query processing algorithm. However, the present invention is not limited thereto, and the query processing apparatus 100 may be configured in the multidimensional database 300. When the function of the is implemented, the multidimensional database 300 may perform a function of the query processing apparatus 100 independently to provide a service.

Hereinafter, a configuration of a query processing apparatus according to an embodiment of the present invention will be described in detail with reference to FIG. 3.

As shown in Figure 3, the query processing apparatus 100 according to the present invention, the transmission and reception management unit 110 for receiving a specific query associated with at least two multi-dimensional database from the user terminal 200, confirming the properties of the specific query It may have a configuration including a procedure management unit 120 for determining a query processing execution procedure based on the result, and a query execution management unit 130 for generating a specific query processing result by processing a specific query based on the query processing execution procedure. have.

In addition, the query processing apparatus 100 according to the present invention further comprises a connection management unit 140 for controlling the connection between the multi-dimensional database based on the master-related information for each master server of at least two multi-dimensional database. Can have.

Here, the master related information includes address and port information for each master server.

That is, the connection manager 140 checks the master related information including the address and port of the master server MS of each of the at least two multidimensional databases. Thereafter, the connection management unit 140 generates a control command for requesting to perform a physical connection based on the master related information, and transmits the control command to each multidimensional database.

In addition, the query processing apparatus 100 according to the present invention further includes a synchronization management unit 150 for controlling synchronization to be performed based on slave related information for each slave server of the multidimensional database connected by the connection management unit 140. It may have a configuration to.

Here, the slave related information includes network information for each slave server and at least one array information.

That is, the synchronization manager 150 checks the network information of the slave server SS of each of the at least two multidimensional databases and the slave related information including the currently provided array. The synchronization manager 150 generates a control command requesting to share and synchronize the environment information with each other based on the slave related information, and transmits the control command to each multidimensional database.

In addition, the query processing apparatus 100 according to the present invention provides a query screen for inputting a specific query related to at least two multidimensional databases, and analyzes the result of analyzing a specific query input through the user terminal 200. It may have a configuration that further includes an interface unit 160 to process all interfaces until a specific query processing result is provided on the basis.

The entire configuration of the query processing apparatus 100 including the transmission and reception management unit 110, the procedure management unit 120, the query execution management unit 130, the connection management unit 140, the synchronization management unit 150, and the interface unit 160. At least a part may be implemented in the form of a software module or a hardware module executed by a processor, or may be implemented in the form of a combination of a software module and a hardware module.

As a result, the query processing apparatus 100 according to an exemplary embodiment of the present invention may allow a specific query (eg, association query, multidimensional query, etc.) to be performed through interworking between a plurality of remotely located multidimensional databases. A new query processing scheme based on a synchronized multidimensional database is provided. Hereinafter, each component in the query processing apparatus 100 for this purpose will be described in detail.

Hereinafter, for convenience of description, as mentioned above, the multi-dimensional database a, which is a local multi-dimensional database built on a user's computer resource among the multi-dimensional databases (a, b, c ..) illustrated in FIG. 1, is a query processing apparatus. The multi-dimensional database b, which is operated in the master execution mode according to the control command of (100) and is located in the remote multi-dimensional database b, operates in the slave execution mode.

Here, in the master execution mode, when it is necessary to merge the query processing results, the query processing result is received from the multidimensional database operating in the slave execution mode and merged, or whether the access to a remote multidimensional multidimensional database is necessary. This means a mode in which an operation is predominantly performed according to a control command of the query processing apparatus 100.

The transmission and reception management unit 110 performs a function of receiving a specific query from the user terminal 200.

More specifically, the transmission and reception management unit 110, when a user who wants to use the synchronization-based query processing service is connected, the interface unit 160 so that a specific query related to the multi-dimensional database a, b can be input from the user terminal 200 ) Provides a query screen to the user terminal 200 through.

Here, the specific query is a combined query processed by calling array information distributed in the synchronized multidimensional databases a and b when the synchronization is performed after the multidimensional databases a and b are connected, and the synchronized multi dimensions. Some of the databases a and b are divided into multidimensional queries that are processed by calling only array information stored in the multidimensional database a / b.

Then, when the user inputs a specific query through the query screen, the transmission and reception management unit 110 receives the specific query from the user terminal 200 through the interface unit 160.

Subsequently, the transmission / reception manager 110 transmits the specific query to the procedure manager 120 to notify that the specific query has been received from the user terminal 200.

The procedure manager 120 determines a query processing procedure based on the result of checking the attribute of the specific query.

More specifically, the procedure manager 120 checks the attribute of the specific query based on a result of determining whether the specific query calls array information distributed in the synchronized multidimensional databases a and b.

When a specific query is received, the procedure manager 120 interoperates with the multidimensional database a to call array information stored in at least one slave server SS of the multidimensional database a to process the specific query. Check it. Thereafter, the procedure manager 120 checks whether the array information stored in at least one slave server SS of the multidimensional database b is called in order to process a specific query.

On the other hand, when a specific query is received, the procedure manager 120 interoperates only with the multidimensional database a operating in the master execution mode without interworking with the multidimensional database b, and processes at least one of the multidimensional databases a and b to process the specific query. It is also possible to check whether the array information stored in the slave server SS is called.

When it is checked whether the array information stored in each slave server (SS) of the multidimensional databases a and b is called, the array information distributed to the synchronized multidimensional databases a and b is checked. When the call is made, the procedure manager 120 determines the attribute of the specific query as the association query.

Thereafter, the procedure manager 120 generates a first query processing procedure for simultaneously performing the processing of the association query in the synchronized multidimensional databases a and b.

That is, the procedure management unit 120, in conjunction with the synchronized multi-dimensional database a, b, the association between the multi-dimensional database a and the multi-dimensional database b located remotely based on the basic query processing procedure of each multi-dimensional database a, b Create a first query processing procedure that causes the query to be processed.

On the other hand, if only the array information stored in the multidimensional database (a / b) of the multi-dimensional database a, b of the specific query is synchronized, the procedure management unit 120, the attribute of the specific query to the multi-dimensional query To judge.

Thereafter, the procedure manager 120 generates a second query processing procedure that allows the processing of the multidimensional query to be performed only in some multidimensional databases a / b.

That is, the procedure manager 120 interoperates with the synchronized multidimensional databases a and b, and performs multidimensional query on the multidimensional database a or a multidimensional database b located remotely based on the basic query processing procedure of each multidimensional database a and b. Create a second query processing procedure that causes the to be processed.

As a result, when the multidimensional query calls only array information stored in the multidimensional database a of some multidimensional databases a / b, there is no need to transmit and register the multidimensional query to a remote multidimensional database b. Accordingly, the procedure manager 120 generates a second query processing procedure for processing the multidimensional query in the multidimensional database a.

On the other hand, when the multidimensional query calls only array information stored in the multidimensional database b remotely located among some of the multidimensional databases a / b, the multidimensional query is transmitted and registered to the remote multidimensional database b. Should be. Accordingly, the procedure manager 120 generates a second query processing procedure for processing the multidimensional query in the multidimensional database b.

The query execution management unit 130 processes the specific query to generate a specific query processing result.

More specifically, when the query execution procedure is generated from the procedure manager 120, the query execution management unit 130 generates a specific query processing result based on the query processing procedure.

That is, when the first query processing procedure is generated from the procedure manager 120, the query execution manager 130 is processed between the multi-dimensional databases a and b in which the combined query, which is a specific query, is synchronized. The first query processing result generated for each b can be confirmed.

When the first query processing result for each of the synchronized multidimensional databases a and b is confirmed, the query execution management unit 130 controls the first query processing results for the synchronized multidimensional databases a and b to be merged to generate a specific query processing result. Done.

On the other hand, the query execution management unit 130, when the second query processing procedure is generated from the procedure management unit 120, the multi-dimensional query that is a specific query is processed only in some multi-dimensional database (a / b), some multi-dimensional database ( It is possible to check the second query processing result generated only in a / b).

As such, when the second query processing result is confirmed only in some multidimensional databases a / b, the query execution management unit 130 determines the second query processing result as the specific query processing result.

As described above, when the generation and determination of the specific query processing result is completed, the query execution management unit 130 provides the specific query processing result to the user terminal 200 through the interface unit 150.

Hereinafter, with reference to FIGS. 2 and 3 described above, the operation of the multidimensional database a, b controlled by each functional unit of the query processing apparatus 100 described above will be described.

2 and 3, when a specific query is received from the user terminal 200, the connection management unit 140 of the query processing apparatus 100, to each master server (MS) of the multidimensional database a, b Based on the master related information, the connection between the multidimensional databases a and b is controlled (①, ① ').

Accordingly, the connection execution unit 360a of each master server MS of the multidimensional database a and b includes master related information including address and port information for each master server identified under the control of the connection management unit 140. Based on this, the physical connection can be performed.

Thereafter, the synchronization management unit 150 in the query processing apparatus 100 controls the synchronization between the corresponding multidimensional databases a and b based on slave related information about each slave server SS of the physically connected multidimensional database.

Accordingly, environment information is shared and synchronized based on network information of each slave server SS of the multidimensional database a and b and slave related information including at least one array information (②, ② '). Such synchronization may be performed by the

connection execution units

360a and 360b of each master server MS, or may be performed for each slave server SS.

Thereafter, the procedure manager 120 in the query processing apparatus 100 determines the attribute of the specific query based on a result of determining whether the specific query calls array information distributed in the synchronized multidimensional databases a and b. Verify that the first query processing procedure or the second query processing procedure is generated.

That is, when the procedure manager 120 calls array information distributed in the multidimensional databases a and b in which a specific query is synchronized, the procedure manager 120 determines the attribute of the specific query as a federated query and performs the first query processing procedure. Create

On the other hand, when the procedure management unit 120 calls only the array information stored in some multidimensional database (a / b) of the multi-dimensional database (a, b) of the specific query is synchronized, the attribute of the specific query as a multi-dimensional query In response, the second query processing procedure is generated.

As described above, in order to enable the procedure management unit 120 to check the attributes of a specific query, each query processing

procedure establishing unit

310a, 310b of the synchronized multidimensional database a, b is configured to process a specific query. (Array) Establish basic query processing procedures by accessing information and planning what operations to perform. The query processing

procedure establishing unit

310a or 310b provides the established basic query processing procedure to the sharing and procedure management unit 120 (3, 3 ').

In this case, the planning is performed by dividing the plan into chunks of fixed size according to the number of cells in the array since the data is an array.

Therefore, the procedure manager 120 checks the attributes of the specific query based on the basic query processing procedure received from the synchronized multidimensional databases a and b, and generates the first query processing procedure if the attributes of the specific query are federated queries. If the attribute of the specific query is a multidimensional query, the second query processing procedure can be generated.

As such, when the generation of the first query processing procedure or the second query processing procedure is completed from the procedure manager 120, the query execution management unit 130 in the query processing apparatus 100 performs a specific query based on the query processing procedure. Generate the processing result.

That is, when the first query processing procedure is generated from the procedure manager 120, the query execution management unit 130 may check the first query processing result that is the result of the association query generated for each of the synchronized multidimensional databases a and b. Will be.

In order to ensure the first query processing result as described above, each of the

query schedulers

320a and 320b of the multidimensional database a and b manages the work execution after registering the federated query (④, ④ '), and the query processing unit ( 330a and 320b executes a specific query processing algorithm associated with the association query to generate first query processing results that are the processing results of the association query (⑤, ⑤ ').

Then, the query execution management unit 130, when the synchronized first query processing results for each of the multi-dimensional database a, b is confirmed, each merge execution unit (340a, 340b) of the multi-dimensional database a, b so that the first query processing results are merged To control.

Under the control of the query execution management unit 130, the merge execution unit 340a of the multidimensional database a executes the merge of the respective first query processing results to generate a specific query processing result, and the query execution management unit ( 130).

That is, since the multidimensional database a is in the master execution mode, the merge execution unit 340a of the multidimensional database a receives the first query processing result from the multidimensional database b (6 ') and merges it with its first query processing result. Generates results of specific query processing (⑥, ⑦).

Accordingly, the query execution management unit 130 can receive the specific query processing result which is the result of the association query processing.

On the other hand, the query execution management unit 130, when the second query processing procedure is generated from the procedure management unit 120, in conjunction with the synchronized multi-dimensional database a, b, multi-dimensional query generated from the multi-dimensional database a, or multi-dimensional database b Check the second query processing result that is the processing result of.

In order to confirm the second query processing result as described above, the query scheduler 320a of the multidimensional database a is based on an array of multidimensional database b based on the basic query processing procedure established by the query processing procedure establishing unit 310a. Array) determines whether information should be called and determines whether access to a multidimensional database b located remotely is necessary (④).

That is, when array information of the multidimensional database b is called, the query scheduler 320a of the multidimensional database a transmits the multidimensional query to the multidimensional database b (2, 2 '). Then, the query scheduler 320b of the multidimensional database b determines whether its array information is called based on the basic query processing procedure established by the query processing procedure establishing unit 310b and registers the multidimensional query. Determine whether or not (④ ').

On the other hand, when the array information of the multidimensional database b does not need to be called, the query scheduler 320a of the multidimensional database a does not need access to the multidimensional database b, and thus registers the multidimensional query with itself (④). .

When the multidimensional query is registered in the multidimensional database a or the multidimensional database b according to the above, the corresponding query processing units 330a and 330b of the multidimensional database a and b execute a specific query processing algorithm related to the multidimensional query to process the multidimensional query. Generate a second query processing result (⑤ / ⑤ ').

In the above description, in order to confirm the second query processing result, the multidimensional database a operates in a master execution mode to determine whether access to a remote multidimensional database b is required, but is not limited thereto. Each of a and b may determine whether its array information is called to determine whether to register a multidimensional query, and generate a second query processing result.

That is, in order for the second query processing result to be confirmed, the

query schedulers

320a and 320b of the multidimensional database a and b each execute a basic query processing procedure established by the query processing

procedure establishing unit

310a or 320b. On the basis of determining whether its array information is called, it is determined whether to register a multidimensional query, and the corresponding query processing unit 330a / 330b determined to register the multidimensional query, processes a specific query related to the multidimensional query. The algorithm is executed to generate a second query processing result which is a processing result of the multidimensional query.

Accordingly, the query execution management unit 130 may receive the second query processing result from any one of the multidimensional databases a and b, and determine the second query processing result as the specific query processing result.

Hereinafter, a flow of providing a synchronization-based query processing service according to an embodiment of the present invention will be described in detail with reference to FIG. 4. Hereinafter, for convenience of description, it will be described with reference to the reference numerals mentioned in FIGS.

Hereinafter, as described above, among the multidimensional databases (a, b, c ..) shown in FIG. We will continue with the description by referring to b.

The query processing apparatus 100 controls the connection between the corresponding multidimensional databases based on the master related information for each master server MS of the multidimensional databases a and b (S100).

That is, the query processing apparatus 100 confirms master related information including the addresses and corresponding ports of the master servers MS of the multidimensional databases a and b. The query processing apparatus 100 generates a control command for requesting to perform a physical connection based on the master related information, and transmits the control command to each of the multidimensional databases a and b.

Thereafter, the query processing apparatus 100 controls the synchronization to be performed based on the slave related information for each slave server SS of the physically connected multidimensional databases a and b (S101).

That is, the query processing apparatus 100 checks the network information of each of the slave servers SS and the slave related information including the currently included array. The query processing apparatus 100 generates a control command requesting to share and synchronize the environment information with each other based on the slave related information, and transmits the control command to each of the multidimensional databases a and b.

In an embodiment of the present invention, the connection and synchronization between the multidimensional databases a and b are performed before the specific query is received from the user, but the present invention is not limited thereto. Of course.

When the user who wants to use the synchronization-based query processing service is connected, the query processing apparatus 100 displays the query screen so that a specific query related to the multidimensional databases a and b can be input from the user terminal 200. To provide.

Thereafter, when the user inputs a specific query through the query screen, the query processing apparatus 100 receives the specific query from the user terminal 200 (S102).

The query processing apparatus 100 checks the attribute of the specific query based on a result of determining whether the specific query calls array information distributed in the synchronized multidimensional databases a and b (S103).

As a result of the determination in step S103, the query processing apparatus 100, in conjunction with the multidimensional database a, calls array information stored in at least one slave server SS of the multidimensional database a to process a specific query. Check if it works. Thereafter, the query processing apparatus 100 checks whether array information stored in at least one slave server SS of the multidimensional database b is called in order to process a specific query in conjunction with the multidimensional database b. .

Meanwhile, when a specific query is received, the query processing apparatus 100 works only with the multidimensional database a operating in the master execution mode without interworking with the multidimensional database b, and at least one of each of the multidimensional databases a and b to process the specific query. It is also possible to check whether the array information stored in the slave server of the SS is called.

When it is checked whether the array information stored in each slave server (SS) of the multidimensional databases a and b is called, the array information distributed to the synchronized multidimensional databases a and b is checked. When the call is made, the query processing apparatus 100 determines the attribute of the specific query as the association query.

Subsequently, the query processing apparatus 100 generates a first query processing procedure for allowing the simultaneous query processing to be simultaneously performed in the synchronized multidimensional databases a and b (S104).

That is, the query processing apparatus 100 interoperates with the synchronized multidimensional databases a and b, and performs the process between the multidimensional database a and the multidimensional database b located remotely based on the basic query processing procedure of each of the multidimensional databases a and b. Create a first query processing procedure that allows the federated query to be processed.

When the generation of the first query processing procedure is completed according to the above, the query processing apparatus 100 is processed between the synchronized multidimensional databases a and b, so that the first query generated for each of the synchronized multidimensional databases a and b. You can check the result of query processing.

When the synchronized first query processing results for the multidimensional databases a and b are confirmed, the query processing apparatus 100 controls the merged first query processing results for the multidimensional databases a and b to generate a specific query processing result. (S106, S107).

On the other hand, as a result of the determination in step S103, when only the array (store) information stored in some of the multi-dimensional database (a / b) of the multi-dimensional database (a, b) that the specific query is synchronized, the query processing apparatus 100, Determine the attributes of a query as a multidimensional query.

Subsequently, the query processing apparatus 100 generates a second query processing procedure that allows the processing of the multidimensional query to be performed only in some multidimensional databases a / b (S105).

That is, the query processing apparatus 100 interoperates with the synchronized multidimensional databases a and b, and multi-dimensionally based on the multidimensional database a or a remotely located multidimensional database b based on the basic query processing procedure of each multidimensional database a and b. Generate a second query processing procedure that causes the query to be processed.

As a result, when the multidimensional query calls only array information stored in the multidimensional database a of some multidimensional databases a / b, there is no need to transmit and register the multidimensional query to a remote multidimensional database b. Accordingly, the query processing apparatus 100 generates a second query processing procedure for causing the multidimensional query to be processed in the multidimensional database a.

On the other hand, when the multidimensional query calls only array information stored in the multidimensional database b remotely located among some of the multidimensional databases a / b, the multidimensional query is transmitted and registered to the remote multidimensional database b. Should be. Accordingly, the query processing apparatus 100 generates a second query processing procedure for causing the multidimensional query to be processed in the multidimensional database b.

When the generation of the second query processing procedure is completed according to the above, the query processing apparatus 100 may process the multidimensional query, which is a specific query, only in some of the multidimensional databases a / b. Only the second query processing result generated can be checked.

Thereafter, the query processing apparatus 100 determines the second query processing result as the specific query processing result (S107).

When the generation and the determination of the specific query processing result are completed by the first query processing procedure or the second query processing procedure according to the above, the query processing apparatus 100 transmits the specific query processing result to the user terminal 200. Provided (S108).

As described above, according to the present invention, a specific query (eg, association query, multidimensional query, etc.) processing is performed through interworking between a plurality of remotely located multidimensional databases, and thus, based on a synchronized multidimensional database based on other synchronized The effect of providing a new query processing scheme is achieved.

Embodiments of the present invention can be implemented in the form of program instructions that can be executed by various computer means and recorded on a computer readable medium. The computer readable medium may include program instructions, data files, data structures, etc. alone or in combination. Program instructions recorded on the media may be those specially designed and constructed for the purposes of the present invention, or they may be of the kind well-known and available to those having skill in the computer software arts. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tape, optical media such as CD-ROMs, DVDs, and magnetic disks, such as floppy disks. Magneto-optical media, and hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, flash memory, and the like. Examples of program instructions include not only machine code generated by a compiler, but also high-level language code that can be executed by a computer using an interpreter or the like. The hardware device described above may be configured to operate as one or more software modules to perform the operations of the present invention, and vice versa.

Although the present invention has been described in detail with reference to preferred embodiments, the present invention is not limited to the above-described embodiments, and the technical field to which the present invention belongs without departing from the gist of the present invention as claimed in the following claims. Anyone skilled in the art will have the technical idea of the present invention to the extent that various modifications or changes are possible.

Claims

A transmission and reception management unit for receiving a specific query related to at least two multidimensional databases from a user terminal;

A procedure manager to determine a query processing procedure based on a result of checking the attribute of the specific query; And

A query execution management unit for generating a specific query processing result by processing the specific query based on the query processing procedure.

Query processing apparatus comprising a.
The method of claim 1,

A connection manager configured to control a connection between corresponding multidimensional databases based on master related information of each master server of the at least two multidimensional databases; And

And a synchronization manager for controlling synchronization to be performed based on slave related information for each slave server of the connected multidimensional database.
The method of claim 2,

The master related information includes address and port information for each master server,

The slave related information includes network information for each slave server and at least one array information.
The method of claim 3, wherein

The procedure management unit,

When the specific query calls array information distributed in the synchronized multidimensional database, the attribute of the specific query is identified by a federated query.

And when the specific query calls only array information stored in a part of the synchronized multidimensional database, the attribute of the specific query as a multidimensional query.
The method of claim 4, wherein

The procedure management unit,

When the specific query is the association query, generating a first query processing procedure for simultaneously performing the processing on the association query in the synchronized multidimensional database,

And when the specific query is the multidimensional query, generating a second query processing procedure for processing the multidimensional query only in the partial multidimensional database.
The method of claim 5, wherein

The query execution management unit,

When the association query is processed based on the first query processing procedure to generate a first query processing result for each synchronized multidimensional database, the first query processing result is controlled to be merged to generate the specific query processing result. ,

When the multi-dimensional query is processed based on the second query processing procedure to generate a second query processing result only in the partial multi-dimensional database, the second query processing result is determined as the specific query processing result. Query processing unit.
A transmission and reception management step of receiving a specific query related to at least two multidimensional databases from a user terminal;

A procedure management step of determining a query processing execution procedure based on a result of checking the attribute of the specific query; And

A query execution management step of generating a specific query processing result by processing the specific query based on the query processing procedure.

Method of operation of a query processing apparatus comprising a.
The method of claim 7, wherein

A connection management step of controlling a connection between corresponding multidimensional databases based on master related information for each master server of the at least two multidimensional databases; And

And a synchronization management step of controlling synchronization to be performed based on slave related information for each slave server of the connected multidimensional database.
The method of claim 8,

The master related information includes address and port information for each master server,

The slave related information may include network information for each slave server and at least one array information.
The method of claim 9,

The procedure management step,

When the specific query calls array information distributed in the synchronized multidimensional database, confirming an attribute of the specific query as a federated query; And

When the specific query calls only array information stored in some multi-dimensional databases of the synchronized multi-dimensional database, identifying the property of the specific query as a multi-dimensional query. How it works.
The method of claim 10,

The procedure management step,

If the specific query is the federated query, generating a first query processing procedure for simultaneously processing the federated query in the synchronized multidimensional database; And

And when the specific query is the multidimensional query, generating a second query processing procedure for processing the multidimensional query only in the partial multidimensional database.
The method of claim 11,

The query execution management step,

When the association query is processed based on the first query processing procedure to generate a first query processing result for each synchronized multidimensional database, the first query processing result is controlled to be merged to generate the specific query processing result. Making; And

Determining that the second query processing result is the specific query processing result when the multidimensional query is processed based on the second query processing procedure to generate a second query processing result only in the partial multidimensional database. Method of operation of a query processing apparatus, characterized in that.