KR101183768B1 - System and method providing integrated view, server having function for generating view - Google Patents

Abstract

A server having an integrated view providing system and method and a view generating function applied thereto are disclosed. According to an embodiment of the present invention, it is determined from the first connector for determining whether the main query is for at least one of the first database and the second database, and transmits the sub-query to the database according to the determination result, and from the first connector An integrated view providing system is provided that includes a second connector that receives a subquery and sends a second view generated in response to the subquery to a first connector. Thereby, the DW can be extended through the network.

Description

System and method providing integrated view, server having function for generating view

The present invention relates to a system and method for providing an integrated view, and a server having a view generating function applied thereto. And a server having a view generating function applied thereto.

Most companies run a database management system (DBMS) to store and manage their data. These DBMSs focus on tasks such as simply storing, inserting, deleting, modifying, and viewing data.

As the number of computerized or automated tasks in a company or organization increases, the amount of data to be stored in a database is increasing, and several DBMSs are operated depending on departments and geographical conditions throughout the organization.

Therefore, it may be difficult to extract the desired data when using the DBMS, and there is a difficulty in performing a separate manual operation on the extracted data.

Recently, a data warehouse system that can analyze data existing in a database and show a result corresponding to a specific question for a company's future career or decision making has been attracting attention. Data warehouses are being used as part of decision-making systems, and their technology and scale are evolving.

However, the data warehouse construction requires a lot of cost and effort, so it is difficult to adopt a data warehouse in a company or an organization that has not previously utilized a large IT infrastructure.

Furthermore, even if a company or an organization has already built a data warehouse system, adding a data warehouse requires a lot of costs, and thus, a method for easily building a data warehouse system is required.

The present invention connects a plurality of data warehouse systems to a network and generates respective views in a data warehouse having data corresponding to a user's request for information, thereby creating a plurality of data warehouses without additional data warehouse system. An object of the present invention is to provide an integrated view providing system and method that can use the system, and a server having a view generating function applied thereto.

According to an embodiment of the present invention, a first connector for determining whether the main query is for at least one of the first database and the second database, and transmits the sub-query to the database according to the determination result; And a second connector configured to receive a subquery from the first connector and to transmit a second view generated in response to the subquery to the first connector.

The first connector, if the main query is for the first database as a result of the determination, transmits a subquery to the first database, and generates a first view based on the data returned from the first database. The third view may be generated by integrating the second view and the first view.

The first connector transmits the main query to the first database when the main query is for the first database, and the first database transmits data corresponding to the received subquery. The first view may be generated based on the transmission, and the generated first view may be transmitted to the first connector.

The first connector may generate a third view integrating the second view and the first view.

The first connector may generate and transmit a subquery to each of the first database and the second database if the main query is for the first database and the second database. .

The second connector may transmit the received subquery to the second database and generate the second view based on the data returned from the second database.

The second connector transmits the received subquery to the second database, and the second database generates the second view based on data corresponding to the received subquery and transmits the generated subquery to the second connector. It may be.

According to another embodiment of the invention, the first data warehouse; A second data warehouse; A first connector which determines whether the main query is for at least one of the first data warehouse and the second data warehouse, and transmits the sub query to the data warehouse according to the determination result; And a second connector configured to receive a subquery from the first connector and to transmit a second view generated in response to the subquery to the first connector.

The first connector, if the main query is for the first data warehouse as a result of the determination, transmits a subquery to the first data warehouse and based on the data returned from the first data warehouse. The first view may be generated, and the third view may be generated by integrating the second view and the first view.

The first connector, if the main query is for the first data warehouse as a result of the determination, transmits a subquery to the first data warehouse, and the first data warehouse sends the received subquery. The first view may be generated based on data corresponding to, and the generated first view may be transmitted to the first connector.

The first connector may be to generate a third view integrating the second view and the first view.

The first connector, if the main query is for the first data warehouse and the second data warehouse as a result of the determination, the sub-query for each of the first data warehouse and the second data warehouse It may be to generate and transmit.

The second connector may transmit the received subquery to the second data warehouse and generate the second view based on the data returned from the second data warehouse.

The second connector transmits the received subquery to the second data warehouse, and the second data warehouse generates the second view based on data corresponding to the received subquery. It may be to send to the connector.

According to another embodiment of the invention, the first server having a first data warehouse; And a second server having a second data warehouse, wherein the first server determines and determines whether the main query from outside is for at least one of the first data warehouse and the second data warehouse. If the data warehouse associated with the main query is the second data warehouse, the sub query is transmitted to the second server, and the second server receives the sub query from the first server and corresponds to the sub query. Provided is an integrated view providing system, characterized in that for transmitting the generated second view to the first server.

The first server transmits a subquery to the first database when the main query is for the first database and generates a first view based on the data returned from the first database. The third view may be a combination of the second view and the first view.

The first server may be a tenant server, and the second server may be a cloud server.

According to another embodiment of the present invention, a step of receiving a main query for requesting information from a user terminal device; Analyzing the main query to determine which database among the plurality of databases the main query is related to; Sending a subquery to at least one related database; And integrating and providing the at least one view generated in response to the sub-query to the user terminal device.

The method of providing a consolidated view according to an embodiment of the present invention may further include generating a subquery for each of the related databases when the main query is related to at least two or more databases. .

When the main query is related to one database, transmitting the sub query may be to transmit the main query as the sub query.

According to another embodiment of the present invention, a server, comprising: a first data warehouse for storing and managing data; And receiving a main query from a user terminal device, analyzing the main query to determine which data warehouse has data corresponding to the main query among a second data warehouse and the first data warehouse, and determining the data query. A server having an integrated view generation function is provided, including; a first connector for requesting corresponding data from the data warehouse.

The first connector forwards the information request to the first data warehouse when the data warehouse containing data corresponding to the information request is the first data warehouse, and returns from the first data warehouse. The first view may be generated by using the received data.

The first connector transmits the information request to a second server having the second data warehouse when the data warehouse holding data corresponding to the information request is the second data warehouse. It may be to receive a second view from the server.

The first connector may include a first sub that requests data from the main query to the first data warehouse when the data warehouse having data corresponding to the information request is the first and second data warehouses. Generate a second server query requesting data from the query and the second data warehouse, send the first sub-query to the first data warehouse, and the second sub-query to send the second data warehouse It may be to the second server having.

The first connector generates a first view using data returned from the first data warehouse, receives a second view from the second server, and integrates the first view and the second view. It may be to create a unified view.

The server may be a tenant server, and the second server may be a cloud server.

According to another embodiment of the present invention, a cloud data warehouse for storing and managing data; And a connector that receives a subquery requesting data for the cloud data warehouse from a tenant server, receives data corresponding to the subquery from the cloud data warehouse, and generates a view using the returned data. There is provided a cloud server having a view generating function, including;

The integrated view providing system and method and a server having a view generating function applied thereto according to an embodiment of the present invention, when an enterprise having its own data warehouse system wants to extend the data warehouse system through a network, By using connected data warehouse systems, you can use extended data warehouse systems without actually having to extend them.

In addition, the integrated view providing system and method according to an embodiment of the present invention and a server having a view generating function applied thereto, by providing the data extracted by the data warehouse system through the view, while preventing damage to the original data There is an effect that can provide the desired information to the user.

1 is a block diagram of an integrated view providing system according to an embodiment of the present invention;
2 is a conceptual diagram illustrating a method of providing a unified view according to an embodiment of the present invention;
3 is a conceptual diagram illustrating a method of providing an integrated view according to another embodiment of the present invention;
4 is a conceptual view illustrating a method for providing a unified view according to another embodiment of the present invention;
5 is a conceptual diagram for explaining a method for providing a unified view according to another embodiment of the present invention;
6 is a flowchart illustrating a method of providing an integrated view according to an embodiment of the present invention.

BRIEF DESCRIPTION OF THE DRAWINGS The above and other objects, features, and advantages of the present invention will become more readily apparent from the following description of preferred embodiments with reference to the accompanying drawings. However, the present invention is not limited to the embodiments described herein but may be embodied in other forms. Rather, the embodiments disclosed herein are provided so that the disclosure can be thorough and complete, and will fully convey the scope of the invention to those skilled in the art. In this specification, when an element is referred to as being on another element, it may be directly formed on another element, or a third element may be interposed therebetween.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. In the present specification, the singular form includes plural forms unless otherwise specified in the specification. The terms "comprises" and / or "comprising" used in the specification do not exclude the presence or addition of one or more other elements.

Hereinafter, the present invention will be described in detail with reference to the drawings. In describing the specific embodiments below, various specific details have been set forth in order to explain the invention in greater detail and to assist in understanding it. However, those skilled in the art can understand that the present invention can be used without these various specific details. In some cases, it is mentioned in advance that parts of the invention which are commonly known in the description of the invention and which are not highly related to the invention are not described in order to prevent confusion in explaining the invention without cause.

Definition of Terms

'Database' means 'a set of integrated and stored operational data that can be shared by multiple users' and is used to include 'data warehouse' as well as traditional databases.

'Query' is used to mean 'main query' and 'sub query'.

'Main query' refers to a query that the tenant connector receives from the outside (for example, a user terminal device).

 'Sub query' refers to the query that the connector sends to the database. According to an embodiment of the present invention, the 'sub query' may be the same as the 'main query' or a query generated by splitting from the 'main query'.

Meanwhile, even though the 'sub query' is actually the same as the 'main query', in the present specification, a query received by the tenant connector from the outside is referred to as a 'main query', and a query transmitted by the tenant connector to the cloud connector is referred to as a 'sub query'. The term "sub query" and "main query" will be collectively referred to as "query" when there is no profit to distinguish between "sub query" and "main query."

1 is a block diagram of an integrated view providing system according to an exemplary embodiment of the present invention.

Referring to FIG. 1, an integrated view providing system according to an exemplary embodiment may include a first server and a second server connected through a network. Here, the network is collectively referred to as a wired or wireless communication network, and is not limited to the type of communication network.

Although the first server has its own data warehouse, it may correspond to a tenant-side server that needs an extension of the data warehouse. Accordingly, in the present embodiment, the tenant server 100 is described as an example of the first server.

The tenant server 100 may include a first data warehouse and a first connector. In the present embodiment, the first data warehouse may correspond to the tenant DW 110, and the first connector may correspond to the tenant connector 120.

The second server includes a data warehouse used to extend the data warehouse of the first server, and corresponds to a server on the cloud side that provides a service in a cloud form to the tenant server 100 connected through a network. can do. Accordingly, in the present embodiment, the cloud server 200 will be described as an example of the second server.

The cloud server 200 may include a second data warehouse and a second connector. In the present embodiment, the second data warehouse may correspond to the cloud DW 210 and the second connector may correspond to the cloud connector 220.

Tenant server 100 may include tenant DW 110 and tenant connector 120. The tenant server 100 may correspond to a server of a tenant to extend the data warehouse.

The tenant DW 110 corresponds to a data warehouse system provided in the tenant server 100, and stores and manages data to be managed by the tenant server 100. In addition, the tenant DW 110 extracts and provides corresponding data in response to an information request from the tenant connector 120 to be described later.

The tenant connector 120 may receive a main query from the user terminal device 300, and determine which data warehouse has data corresponding to the main query by analyzing the received main query. Based on the results, the information is requested to the data warehouse. In the present embodiment, the tenant connector 120 is illustrated as being connected to the user terminal 300 through a network, where the network is used as a meaning including any network, such as the Internet or an internal network.

More specifically, when the main query is input from the user terminal device 300, the tenant connector 120 analyzes the input main query to determine whether data corresponding to the main query is held in the tenant DW 110 or the cloud DW. At 210, it is determined whether or not it is held.

According to the determination result, when the main query corresponds to data held in the tenant DW 110, the tenant connector 120 uses the main query input from the user terminal device 300 as a sub query as the tenant DW 110. ) Can be delivered. Accordingly, the tenant DW 110 provides data corresponding to the requested information to the tenant connector 120, and the tenant connector 120 generates a first view using the data extracted by the tenant DW 110. do. The first view generated as described above may be transmitted to the user terminal 300 by the tenant connector 120. In this case, when the main query is transmitted to the tenant DW 110, when the main query needs to be modified to fit the tenant DW 110, the main query may be modified and transferred to the tenant DW 110. For convenience of description, in the present specification, 'delivery' is used as a meaning including not only the case of transmitting data as it is received, but also the meaning of transmitting by applying an appropriate modification.

The above-described 'view' is a kind of virtual table generated by extracting from the tenant DW 110 in response to the query. For example, the view can be a copy of the actual data or an index of the storage area that holds the actual data.

The tenant connector 120 may also receive a second view generated by the cloud connector 220 from the cloud connector 220 to be described later. In this case, the tenant connector 120 may transmit the second view to the user terminal 300 after receiving the second view.

In addition, when the second view is transmitted from the cloud server 200 while the first tenant connector 120 generates the first view, the tenant connector 120 may generate the integrated view by integrating the first view and the second view. In this case, the view transmitted to the user terminal 300 may be an integrated view.

The unified view refers to a view newly generated by integrating a plurality of views into one, and is generated by the tenant connector 120. The tenant connector 120 may generate a unified view in two cases, for example.

First, there may be a form of simply integrating the first view and the second view. That is, when the first view and the second view are integrated without considering any conditions, the first view and the second view may be used when work considering the entire system and the data is necessary. Second, there may be a form of integration based on intersection. That is, in the case where the first view and the second view are refined and integrated according to the association of data and the request for information from the user terminal device, an operation such as removing duplicates or unifying formats for duplicate data is added or It may be a form in which an operation such as combining data according to a specific condition presented by the user is added.

In the present embodiment, the view generated by the tenant connector 120 is referred to as a 'first view', and the view generated by the cloud connector 220 is referred to as a 'second view'.

The cloud server 200 may include a cloud DW 210 and a cloud connector 220. In FIG. 1, one cloud server 200 and one tenant server 100 are connected to each other through a network. However, this is merely an example, and a plurality of tenant servers 100 may be connected to one cloud server 200. have.

The cloud DW 210 is provided in the cloud server 200 to store and manage data, and provides data corresponding to a query received from the cloud connector 220.

The cloud connector 220 is provided in the cloud server 200 and connected to the tenant connector 120 to provide an interface between the cloud server 200 and the tenant server 100.

When the cloud connector 220 receives the query from the tenant server 100, the cloud connector 220 forwards the query to the cloud DW 210 and receives the corresponding data from the cloud DW 210. The cloud connector 220 generates a second view using the data returned from the cloud DW 210 and transmits the generated second view to the tenant connector 120.

The user terminal device 300 may access the tenant server 100, that is, the tenant connector 120, through the network. The user terminal device 300 may request information from the tenant connector 120. The user terminal 300 may generate a query for requesting information and request the information, and transmit the generated query to the tenant connector 120.

In the present invention, any device that requires DW data may be used as the user terminal 300. For example, a device that provides a business intelligence (BI) service may also be used as the user terminal device. Therefore, in the present specification, the term "user terminal device" is used to mean "any device requiring DW data."

2 is a conceptual diagram illustrating a method of providing an integrated view according to an embodiment of the present invention.

The tenant connector 120 receives the query Q1 from the user terminal 300. In the present embodiment, it is assumed that Q1 is a query for requesting data stored in the tenant DW 110.

The tenant connector 120 receiving Q1 from the user terminal device 300 determines whether Q1 is a query for requesting data stored in the tenant DW 110 or the cloud DW 210.

Accordingly, when the tenant connector 120 determines that Q1 is a query for requesting data stored in the tenant DW 110, the tenant connector 120 transmits Q1 to the tenant DW 110. The tenant DW 110 that receives Q1 returns the data D1 corresponding to Q1 among the data it has to the tenant connector 120.

The tenant connector 120 receiving the D1 generates the view A according to a predetermined form using the D1, and provides the view A to the user terminal 300 that transmitted Q1.

3 is a conceptual view illustrating a method of providing an integrated view according to another embodiment of the present invention.

The tenant connector 120 receives the query Q2 from the user terminal 300. In the present embodiment, it is assumed that Q2 is a query for requesting data stored in the cloud DW 210.

The tenant connector 120 that has received Q2 from the user terminal 300 determines whether Q2 is a query for requesting data stored in the tenant DW 110 or the cloud DW 210.

Accordingly, when the tenant connector 120 determines that Q2 is a query for requesting data stored in the cloud DW 210, the tenant connector 120 transmits Q2 to the cloud connector 220. When Q2 is transmitted, the cloud connector 220 delivers Q2 to the cloud DW 210, and the cloud DW 210 delivers data D2 corresponding to Q2 to the cloud connector 220.

The cloud connector 220 receives D2 from the cloud DW 210, generates a view B using the D2, and transmits the generated view B to the tenant connector 120. The tenant connector 120 provides the view B received from the cloud server 200 to the user terminal device 300 that transmitted Q2.

4 is a conceptual view illustrating a method of providing an integrated view according to another embodiment of the present invention.

The tenant connector 120 receives the query Q3 from the user terminal 300. In the present embodiment, it is assumed that Q3 is a query that requests both data stored in the tenant DW 110 and data stored in the cloud DW 210.

The tenant connector 120 receiving Q3 from the user terminal 300 determines whether Q3 is a query for requesting data stored in the tenant DW 110 or the cloud DW 210.

Accordingly, the tenant connector 120 requests a first subquery Q3 'requesting data stored in the tenant DW 110 and a second subquery requesting data stored in the cloud DW 210 during Q3. Produces (Q3 '').

Thereafter, the tenant connector 120 transmits the first sub query Q3 ′ to the tenant DW 110, and the second sub query Q3 ″ to the cloud connector 220. As a result, the cloud connector 220 returns the second sub-query Q3 " to the cloud DW 210. FIG.

Tenant DW 110 transmits data D3 ′ corresponding to Q3 ′ to tenant connector 120, and cloud DW 210 transmits data D3 ″ corresponding to Q3 ″ to cloud connector 220. Reply

Tennant connector 120 generates view C using D3 ′, and cloud connector 220 generates view D using D3 ″. Cloud connector 220 also forwards view D to tenant connector 120.

As a result, the tenant connector 120 integrates the view C generated by the tenant connector 120 and the view D generated by the cloud connector 220 to generate the view E as an integrated view. As mentioned earlier, the method for creating the view E may use simple integration or integration based on crossover.

5 is a conceptual diagram illustrating a method of providing an integrated view according to another embodiment of the present invention.

Referring to FIG. 5, unlike the above-described embodiments, each 'view' (eg, view C or view D) is generated in the cloud DW 510 or the tenant DW 410, respectively. It consists of.

That is, when the tenant DW 410 receives Q3 ', it may generate view C and transmit the generated view C to the tenant connector 420. In addition, the cloud DW 510 generates view D when Q3 '' is received, transmits the generated view D to the cloud connector 520, and the cloud connector 520 transmits the received view D to the tenant connector 420. To send). Thereafter, the cloud connector 520 may generate the integrated view E and provide the integrated view E to the user terminal 300.

The other functions of the tenant DW 410, tenant connector 420, client DW 510, and client connector 520 function the same as components with similar reference numerals in the above-described embodiments. Detailed description thereof will be omitted.

As described above, according to one embodiment of the present invention, the unified view is created by the tenant connector, but each individual view (eg, view C and view D) for creating the unified view has its own connector. You can create or implement each DW to generate. Alternatively, a separate third component for generating individual views may be provided, and the separate third component may be implemented as a function module provided independently without belonging to a connector or a DW.

6 is a flowchart illustrating a method of providing an integrated view according to an embodiment of the present invention.

If there is desired information, the user terminal device 300 accesses the tenant server 100 and inputs a main query for requesting information (S400).

The tenant server 100 analyzes a query input from the user terminal device 300 and determines whether the query corresponds to a DW on the tenant server 100 side or a DW on the cloud server 200 side. (S410).

The tenant server 100 transmits the query to the DW according to the result determined in step S410 (S420). More specifically, the query may correspond only to the DW of the tenant server 100, may correspond to the DW of the cloud server 200, or the DW and the cloud server 200 of the tenant server 100. It may correspond to both DW of the side.

The DW received the query extracts data corresponding to the received query, and the tenant server 100 or the cloud server 200 generates a view using the data extracted by the DW (S430).

The tenant server 100 transmits the view generated by the tenant server 100 or the view generated by the cloud server 200 to the user terminal device 300. In this case, when the tenant server 100 receives the view generated by the cloud server 200 together with the view generated by the tenant server 100, the tenant server 100 generates one integrated view and provides the integrated view to the user terminal device (S440). .

By the above procedure, the user can be provided with both the plurality of DWs that are separated, that is, data stored in the DW on the tenant server 100 and the DW on the cloud server 200.

For example, suppose that A company, which was in the automobile sales business, started selling golf course membership as a new business expansion item, and assumes that A has a DW for car sales. At this time, a DW for sales of golf course membership should be provided, but the integrated view providing system of the present invention is introduced without establishing it through infrastructure expansion.

Company A can apply this embodiment to such an analysis as determining the size of a buyer who has a golf course membership among car buyers, or a buyer who is expected to purchase a new car among new golf course membership buyers.

For example, if a new golf course membership buyer wants to determine a buyer who is expected to purchase a new car, a purchase list that is intentional to purchase a car from the DW held by the A company, that is, the DW of the tenant server 100 And a list of buyers having golf course memberships from the DW of the cloud server 200 will be extracted. In this case, according to the present embodiment, the two lists will be integrated and provided to the A company. In this way, separate information managed by each DW can be obtained as if obtained using one DW.

Although the above embodiments have been described with reference to a data warehouse, the present invention can be applied to a general database instead of the data warehouse. In other words, it can be applied as a way to extend a typical database.

In addition, although the above-described embodiments have been described as extending one data warehouse, the present invention is also applicable to extending two or more data warehouses.

While the present invention has been described with reference to the particular embodiments and drawings, it is to be understood that the invention is not limited to the disclosed embodiments, but, on the contrary, is intended to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims. This is possible. Therefore, the scope of the present invention should not be limited to the described embodiments, but should be determined by the equivalents of the claims, as well as the claims.

100: tenant server 110: tenant DW
120: tenant connector 200: cloud server
210: Cloud DW 220: Cloud Connector
300: user terminal device

Claims (27)

An integrated view providing system comprising a first connector and a second connector,
The first connector determines whether the main query received from the user terminal device is at least one of the first database and the second database, and as a result of the determination, the main query is for the first database and the second database. In the case of generating a first subquery to be transmitted to the first database and generating a second subquery to be transmitted to the second database, the first subquery is transmitted to the first database, and the second subquery is generated. Transmits to the second connector,
The first connector generates a first view based on the data returned from the first database that has received the first subquery,
The second connector receives a second subquery from the first connector, transmits a second view generated in response to the second subquery, to the first connector,
And the first connector generates a third view integrating the first view and the second view and provides the generated third view to the user terminal device. delete The method of claim 1,
The first connector, if the main query is for the first database as a result of the determination, sends the main query to the first database,
The first connector receives the extracted data corresponding to the main query from the first database, generates a view using the received extracted data, and provides the integrated view providing system to the user terminal device. . delete delete The method of claim 1,
The second connector,
Transmitting the second sub-query received from the first connector to the second database, and generating the second view based on the data returned from the second database received the second sub-query to generate the first connector. Integrated view providing system, characterized in that for transmitting to. The method of claim 1,
The second connector transmits a second subquery received from the first connector to the second database, and receives the second view from the second database that receives the second subquery.
And wherein the second view is generated by the second database. A first data warehouse;
A second data warehouse;
A first connector; And
A second connector;
The first connector receives a main query from a user terminal device and determines whether the received Kane query is for at least one of the first data warehouse and the second data warehouse. In case of the first data warehouse and the second data warehouse, a first subquery to be transmitted to the first data warehouse is generated, and a second subquery to be transmitted to the second data warehouse is generated. The first subquery is sent to the first data warehouse, the second subquery is sent to the second connector,
The first connector generates a first view based on the data returned from the first data warehouse that has received the first sub-query,
The second connector receives a second subquery from the first connector, transmits a second view generated in response to the second subquery, to the first connector,
And the first connector generates a third view integrating the first view and the second view and provides the generated third view to the user terminal device. delete The method of claim 8,
The first connector, if the main query is for the first data warehouse as a result of the determination, sends the main query to the first data warehouse,
The first connector receives the extracted data corresponding to the main query from the first database, generates a view using the received extracted data, and provides the integrated view providing system to the user terminal device. . delete delete The method of claim 8,
The second connector,
Transmitting the second sub query received from the first connector to the second data warehouse, and generating the second view based on the data returned from the second data warehouse receiving the second sub query; Integrated view providing system, characterized in that for transmitting to the first connector. The method of claim 8,
The second connector transmits a second sub query received from the first connector to the second data warehouse, receives the second view from the second data warehouse that receives the second subquery,
And wherein the second view is generated by the second data warehouse. delete delete delete Determining, by the tenant server, whether the main query received from the user terminal device is at least one of a first data warehouse of the tenant server and a second data warehouse of the cloud server; And
The tenant server, if the main query is for the first data warehouse and the second data warehouse, the first sub-query and the first sub-query to be transmitted to the first data warehouse; Generating a second subquery to be transmitted to a data warehouse, transmitting the first subquery to the first data warehouse, and transmitting the second subquery to the cloud server;
The first data warehouse extracts data corresponding to the first sub query, and the tenant server generates a first view using the data extracted by the first data warehouse,
The cloud server extracts data corresponding to the second sub-query, generates a second view, and transmits the second view to the tenant server.
And the tenant server generates and provides a third view in which the first view and the second view are integrated and provided to the user terminal device. The method of claim 18,
The tenant server transmits the main query to the first database when the main query is for the first database as a result of the determination of the determining step.
The first data warehouse extracts data corresponding to the main query, and the tenant server generates a view using the data extracted by the first data warehouse and provides the view to the user terminal device. To provide an integrated view. The method of claim 18,
The cloud server transmits a second sub query received from the tenant server to the second database, and receives the second view from the second database that receives the second sub query.
And wherein the second view is generated by the second database. In the server,
A first data warehouse for storing and managing data; And
It is determined whether the main query received from the user terminal device is about at least one of the first data warehouse and the second data warehouse. As a result of the determination, the main query is the first data warehouse and the second data warehouse. In response to, generate a first sub-query to send to the first data warehouse, generate a second sub-query to send to the second data warehouse, so that the first sub-query is the first data warehouse And a second connector to transmit to the second connector.
The first connector generates a first view based on the data returned from the first data warehouse that has received the first sub-query,
The second connector sends the second sub-query to the second data warehouse,
The first connector receives a second view generated from data extracted by the second data warehouse that has received the second sub-query from the second connector,
And the first connector generates a third view in which the first view and the second view are integrated and provides the generated third view to the user terminal device. 22. The method of claim 21,
The first connector,
If the data warehouse that holds data corresponding to the main query is the first data warehouse, the main query is forwarded to the first data warehouse and the view is returned using the data returned from the first data warehouse. A server having an integrated view generation function, characterized in that for generating. 22. The method of claim 21,
The first connector,
When the data warehouse having data corresponding to the main query is the second data warehouse, the main query is transmitted to the second connector, and the second view is received from the second connector. Server with integrated view creation. delete 22. The method of claim 21,
And wherein the second view is generated by the second connector or the second data warehouse. 22. The method of claim 21,
The server is a tenant server, and the second server is a cloud server. delete

Images