KR101137069B1 - System and method for business intelligence service, and servers used in the same - Google Patents

Abstract

Disclosed are a business intelligence service system and method and a server used therein. According to one embodiment of the invention, a first server for storing and managing data in a database; And storing and managing data in a second database, generating a business intelligence application using at least one of the database and the second database in response to a business intelligence service request, and generating the business intelligence application through the generated business intelligence application. A business intelligence service system is provided that includes a second server that provides the requested business intelligence service. This makes it easier to use data warehouse-based business intelligence services.

Description

System and method for business intelligence service, and servers used in the same}

The present invention relates to a business intelligence service system and method, and a server used therein. More particularly, the present invention relates to a business intelligence service system and method for selectively using a business intelligence service and a data warehouse service, and a server used therein. .

In today's world where cloud computing is becoming an issue, organizations are increasingly looking to deploy multiple services into cloud environments. Cloud computing refers to Internet-based computing technology, which is a web-based software service that typically uses a program on a utility data server on the Internet and loads it into a client terminal when needed.

In such a cloud environment, the specification of the client terminal using the service is sufficient to execute the web, and since there is no need for a separate storage space for storing a program, there is an advantage of low initial purchase cost and high portability. .

Among other areas that use cloud computing technologies are business intelligence systems. Business intelligence systems are software systems that help everyone in the business make better decisions based on data with the right calculation criteria at the right time.

However, in order to adopt a business intelligence system, a lot of burdens arise due to the construction of a data warehouse (DW) and the construction of a business intelligence solution. For this reason, many companies feel the need for a business intelligence system, but have not actually adopted a business intelligence system.

In addition, a company that has already built and used a business intelligence system in a cloud environment may need to build an additional DW or use an enhanced business intelligence service for the same reason as a new business. Even in such a case, there is a problem in that the enterprise has a large burden.

The present invention provides a business intelligence service system and method that can use a desired service quickly without efforts to build a system by selectively using a business intelligence service and a data warehouse service through a network in an enterprise that wants to use a business intelligence service, and It aims to provide a server to be used.

According to one embodiment of the invention, a first server for storing and managing data in a first database; Storing and managing data in a second database, and generating a business intelligence application using at least one of the first database and the second database in response to a Business Intelligence service request from the first server; And a second server that provides the requested business intelligence service through the generated business intelligence application.

The first server extracts the data of the first database and transmits the data to the second server, and the second server receives the extracted data from the first server and receives the extracted data from the first server. Metadata corresponding to a service request may be generated, a business intelligence application may be generated using the generated metadata, and the business intelligence application may be executed to correspond to a service request from the first server.

The first server extracts the data of the first database and transmits it to the second server, and the second server receives the extracted data from the first server and stores the extracted data in the second database. After the conversion may be stored in the second database.

The second server generates metadata corresponding to a service request from the first server from data stored in the second database, generates a business intelligence application using the generated metadata, and generates the business intelligence application. This may be to provide a service requested from the first server.

When the first server receives a business intelligence service request from the user, the first server requests the second database to receive data, and transmits the metadata corresponding to the business intelligence service request requested from the user. It may be to create a business intelligence application based on the generated metadata, to provide a service requested from the user.

The first server transmits data stored in the first database to the second server, and the second server converts the data received from the first server into a form that can be stored in the second database. In a second database, when the first server receives a Business Intelligence service request from a user, the first server requests the second database to receive data, and receives the received data from the user. The metadata may be generated according to the request, and a business intelligence application may be generated based on the generated metadata to provide a service requested by the user.

Meanwhile, according to another embodiment of the present invention, a business intelligence connection unit for requesting data for the requested business intelligence service in response to a business intelligence service request, and a database according to a service mode specified for the request of the business intelligence connection unit. It provides a server comprising a connector for providing data for the requested business intelligence service.

The business intelligence connection unit may receive the business intelligence service request from at least one user terminal device.

When the predetermined service mode is a mode using an internal operation database, the connector extracts data for the requested business intelligence service from the operation database, and extracts data for the extracted business intelligence service from the business intelligence service. Can be sent to the provisioning server.

The operational database may be at least one of a general database and a data warehouse.

The business intelligence connection unit may receive the requested business intelligence service through a business intelligence application generated by using the transmitted data from the business intelligence service providing server.

When the predetermined service mode is a mode that uses a data warehouse of a business intelligence service providing server, the connector requests data for the requested business intelligence service from the business intelligence service providing server, and provides the business intelligence service. The requested data can be received from a server.

 The connector may generate metadata required for the operation and configuration of the business intelligence application using the received data.

The apparatus may further include a business intelligence service provider configured to generate a business intelligence application for the requested business intelligence service by using the metadata generated by the connector.

The business intelligence service provider may provide the requested business intelligence service through the generated business intelligence application.

When a change in data occurs in the provided business intelligence service, the business intelligence service provider may request to store the data in which the change occurs through the connector.

Meanwhile, according to another embodiment of the present invention, data for the requested business intelligence service is stored from a data warehouse that stores data for a business intelligence service, and a database according to a service mode specified for the business intelligence service request. Provides a server that includes a connector to provide.

When data for the business intelligence service is requested from a tenant server, the connector may extract the requested data from the data warehouse and transmit the extracted data to the tenant server.

The connector may receive data for the business intelligence service from a tenant server.

The connector may generate metadata required for the operation and configuration of a business intelligence application using the received data for the business intelligence service.

The apparatus may further include a business intelligence service provider configured to generate a business intelligence application for the requested business intelligence service by using the metadata generated by the connector.

The apparatus may further include a business intelligence interface that provides the requested business intelligence service through the generated business intelligence application.

When a change in data occurs in the provided business intelligence service, the business intelligence service provider may request the tenant server to store the data in which the change occurs.

Meanwhile, according to another embodiment of the present invention, generating a business intelligence application using at least one of the database and the second database with respect to a business intelligence service request, and generating the request through the generated business intelligence application. It provides a business intelligence service method comprising the step of providing a predetermined business intelligence service.

The generating may use at least one of the database and the second database according to a predetermined service mode.

The providing may include providing the requested business intelligence service in the form of any one of Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS).

Business intelligence service system and method and a server used therein according to an embodiment of the present invention, the service that the client wants through the network without having to invest a lot to use the data warehouse based business intelligence services to their situation There is an effect that can be selected accordingly.

1 is a network diagram of a business intelligence service system according to an embodiment of the present invention;
FIG. 2 is a block diagram of the first and second connectors shown in FIG. 1;
3 is a view for explaining an example of a service provided by the business intelligence service system shown in FIG. 1;
4 is a view for explaining another example of the service provided by the business intelligence service system shown in FIG. 1;
5 is a view for explaining another example of a service provided by the business intelligence service system shown in FIG. 1;
FIG. 6 is a view for explaining another example of a service provided by the business intelligence service system shown in FIG. 1;
7 is a flowchart illustrating a business intelligence service method according to an embodiment of the present invention;
8 is a flowchart illustrating a business intelligence service method according to another embodiment of the present invention;
9 is a flowchart for explaining a business intelligence service method according to another embodiment of the present invention;
10 is a flowchart illustrating a business intelligence service method according to another 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 and 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. As used herein, the words 'comprises' and / or 'comprising' do not exclude the presence or addition of one or more other components.

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings. In describing the specific embodiments below, various specific details are set forth in order to explain the invention more specifically and to help understand. However, one of ordinary skill 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.

1 is a network diagram of a business intelligence service system according to an embodiment of the present invention.

Referring to FIG. 1, a business intelligence service system according to an embodiment of the present invention may include a first server 100 and a second server 200 connected to each other through a network. The network is a generic term for wired or wireless communication networks, and is not limited to the type of communication network.

The first server 100 may correspond to a side that stores and manages data in a database and requests a business intelligence (BI) service to the second server 200 through a network. The first server 100 may selectively use at least one of a BI service and a DW service provided by the second server 200 by accessing the second server 200 through a network. To this end, the first server 100 may be a tenant subscribed to a service provided by the second server 200.

According to one embodiment of the invention, the BI service system can be used for cloud computing. In this case, the first server 100 may be a tenant server, and the second server 200 may be a cloud server that provides a cloud service.

According to an embodiment of the present invention, the first server 100 may receive at least one of a BI service and a DW service provided by the second server 200. For example, a user of the first server 100 may subscribe to a BI service and a DW service provided by the second server 200 through online or offline. In the case of online, the first server 100 may subscribe to a service desired by the screen provided by the second server 200.

When the first server 100 requests to provide a service, the second server 200 determines which service (hereinafter, 'service mode') the first server 100 subscribes to, and then provides the subscribed service. Can be. To this end, the second server 200 may receive information identifying the first server 100.

 The second server 200 may identify the first server 100 and provide a service according to a service mode to which the first server 100 subscribes.

 The first service mode is a mode in which the first server 100 subscribes only to the BI service, and the first server 100 has its own DW, so that the DW 230 of the second server 200 is not used. to be.

That is, the first service mode may correspond to a mode using the database 130 inside the first server 100. In the second service mode, the first server 100 subscribes to both the BI service and the DW service. When the first server 100 does not have a DW itself or has a DW itself, This mode is available when you want to extend. The third service mode is that the first server 100 subscribes only to the DW service, but the first server 100 has built its own BI service system, but does not have a DW itself, or wants to extend the DW. This mode can be used when doing so. The first server 100 may selectively use one of the first to third service modes.

As illustrated, the first server 100 may include a first BI service providing unit 110, a BI connecting unit 120, a database 130, and a first connector 140.

The first BI service provider 110 generates a BI application for the requested BI service in response to the BI service request, and provides a BI service through the generated BI application. Here, the first BI service provider 110 may receive the metadata necessary for the operation and configuration of the BI application from the first connector 140, thereby generating the BI application using the metadata.

In the present embodiment, it is illustrated that the first BI service provider 110 is included in the first server 100, but this is not necessarily limited thereto. That is, in the case where a tenant server such as an enterprise constructs a system for its own BI service, the first BI service provider 110 may be included in the first server 100.

The BI connection unit 120 may be directly connected to the BI interface unit 210 of the second server 200 to be described later through a network. As a result, the BI connection unit 120 may transmit and receive various information with the BI interface unit 210.

The BI connection unit 120 may request data for the BI service requested from the BI interface unit 210 of the second server 200 in response to the BI service request. In this case, if the first server 100 does not have a data warehouse (hereinafter referred to as "DW") or if there is a previously built DW, the DW may be additionally extended through the network. This may be the case.

The database 130 stores all data necessary for the operation of the first server 100. Here, the data stored in the database 130 may include data for the BI service. In addition, the database 130 may include at least one of a general database and a DW.

The first connector 140 may communicate with each other through a connection with the second connector 240 of the second server 200, and may request a BI service requested from the database 130 in response to a request of the BI connector 120. Data can be extracted and provided for.

In the present embodiment, the first connector 140 may operate according to the service mode. More specifically, when the service mode is the first service mode, that is, the mode using the database 130 of the first server 100, the first connector 140 is connected to the requested BI service from the database 130. Extract the data for the second data and transmit the extracted data to the second connector 240 of the second server 200.

In addition, when the service mode is the second service mode or the third service mode, that is, the mode using the DW of the second server 200, the first connector 140 is the second connector of the second server 200. Request data for the requested BI service to 240, and receive the data requested for this request. The first connector 140 will be described in more detail later with reference to FIG. 2.

The second server 200 may include a BI interface unit 210, a second BI service provider 220, a DW 230, and a second connector 240. The second server 200 provides at least one of a BI service and a DW service to at least one first server 100 connected through a network, corresponding to the service mode subscribed to the first server 100. Can provide services. Therefore, the second server 200 may correspond to a BI service providing server. In addition, if the BI service system is applied to cloud computing, the second server 200 may correspond to a cloud server.

When the user requests a BI service, the BI interface 210 may classify a tenant to which the user who requested the BI service belongs and provide a BI service through a corresponding BI application.

In addition, when a BI service is requested from the BI connection unit 120 of the first server 100, the BI interface unit 210 identifies which tenant the first server 100 is to the BI service provider 220. By requesting a BI application, a user who requests a BI service to the first server 100 may receive a BI service.

The BI interface 210 may classify tenants to which the first server 100 requesting the service belongs, and determine which service the first server 100 subscribes to according to the divided tenants. That is, when the first server 100 requests the service, the BI interface unit 210 determines the tenant to which the first server 100 belongs to service the service in any one of the first to third service modes. You can decide whether to provide. As a result, the BI interface unit 210 may request the corresponding service from the second BI service provider 220.

In the present embodiment, it is shown that one first server 100 is connected to the second server 200. However, this is only for convenience of description, and in the actual BI service system, the plurality of first servers 100 are connected to the second server 200, and the services used for each of the first servers 100 may be different from each other. have. Accordingly, the BI interface unit 210 includes a function of identifying a tenant to which the first server 100 that has requested a service belongs.

More specifically, the BI interface unit 210 may distinguish three tenants to which the first server 100 belongs, for example. First, when the BI connection unit 120 is connected, there is a method of classifying tenants by sessions applied to login information received from the user terminal device 300 through the BI connection unit. Second, in order to classify a specific IP (Internet Protocol) area, since a usable IP area is generally determined in an enterprise, there is a method of classifying tenants using the IP of the first server 100. Third, there is a method using a client application identification key. This is a case where the present system is applied to cloud computing, and the client application customized using an API (Application Program Interface) of the cloud center has an identification key for identifying itself. That is, when a user accesses a cloud center using a client application, the tenant is identified using an identification key of the client application.

The second BI service provider 220 generates a BI application using the metadata generated by the second connector 240 in order to provide a BI service to the first server 100, thereby creating a BI application. It provides the BI service requested by the first server 100.

The second BI service provider 220 may provide a BI service in any one form of Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS).

DW 230 stores data for a BI service. Although one DW 230 is shown in this embodiment, this is not necessarily limited thereto. The second server 200 may be connected to a plurality of first servers 100 through a network to request a BI service or a DW service suitable for them. In this case, the DW 230 may include a DW for each tenant, that is, the first server 100 subscribed to the service provided by the second server 200, or logically divide the DW into the first server 100. DW may be provided for each.

The second connector 240 may transmit / receive data for BI service or DW service to the first server 100 through a connection with the first connector 140 of the first server 100. That is, the second connector 240 may provide data for the BI service requested from the database according to the predetermined service mode with respect to the BI service request.

More specifically, when a request for data for a BI service is received from the first connector 140, the second connector 240 extracts the requested data from the second DW, and then extracts the extracted data from the first connector 140. ) Can be sent. This case may correspond to the case where the first server 100 uses only the BI service of the second server 200.

In addition, the second connector 240 may receive data for the BI service from the first connector 140. This case may correspond to the case where the first server 100 operates the DW itself. Thereafter, the second connector 240 may generate metadata necessary for the operation and configuration of the BI application using data for the BI service received from the first connector 140. The second connector 240 will be described in more detail later with reference to FIG. 2.

FIG. 2 is a block diagram of the first and second connectors shown in FIG. 1.

Referring to FIG. 2, the first connector 140 may include a first encryption / decryption unit 141, a first synchronization unit 142, a first metadata generation unit 143, a first data extraction unit 144, and It may include a first transceiver 145, the second connector 240 is the second encryption and decryption unit 241, the second synchronization unit 242, the second metadata generating unit 243, the second data The extractor 244 may include a second transceiver 245.

The first encryption / decryption unit 141 encrypts data to be transmitted when the data is transmitted from the first connector 140 to the second connector 240. In addition, the first encryption / decryption unit 141 decrypts the data transmitted from the second connector 240 to the first connector 140.

The first synchronizer 142 connects the database 130 of the first server 100 and the DW 230 of the second server 200 by interworking with the second synchronizer 242 of the second connector 240. Synchronize. The first synchronization unit 142 is not necessarily included in the first connector 140, and may be omitted in some cases.

The first metadata generator 143 generates metadata required for the operation and configuration of the BI application using data for the BI service. The first metadata generator 143 may operate only when the first server 100 includes the first BI service provider 110.

The first data extractor 144 extracts data for the BI service from the database 130 when the service mode is a mode using the internal database 130. The data extracted by the first data extracting unit 144 may be provided to the first metadata generating unit 143 to be used for generating metadata, or transmitted to the second connector 240.

The first transceiver 145 communicates with the second connector 240. More specifically, when data is to be transmitted from the first connector 140 to the second connector 240, the data encrypted by the first encryption / decryption unit 141 is transmitted to the second connector 240. In addition, when data is transmitted from the second connector 240, the transmitted data is received and provided to the first encryption / decryption unit 141.

When the second connector 240 receives the encrypted data from the first connector 140, the second encryption / decryption unit 241 decrypts the received data. In addition, the second encryption / decryption unit 241 encrypts data to be transmitted when the second connector 240 intends to transmit data to the first connector 140.

The second synchronizer 242 synchronizes the DW 230 of the database of the first server 100 and the second server 200 through interworking with the first synchronizer 142. The second synchronizer 242 is not necessarily included in the second connector 240, and may be omitted in some cases. However, if the first synchronizer 142 is included in the first connector 140, the second synchronizer 242 must also be included in the second connector 240.

When the second BI service provider 220 provides the BI service, the second metadata generator 243 uses metadata provided from the first server 100 or data extracted from the DW 230. Create

The second data extractor 244 extracts data for the BI service from the DW 230. The second data extractor 244 operates when the first server 100 uses a DW service provided by the second server 200. The data extracted by the second data extractor 244 is a second meta data. The data generator 243 may be used to generate metadata, or may be transmitted to the first connector 140.

The second transceiver 245 receives data transmitted from the first connector 140 through communication with the first transceiver 145 of the first connector 140, and receives the second connector 140 from the second connector 140. The data to be transmitted to the connector 240 is transmitted.

FIG. 3 is a diagram for explaining an example of a service provided by the business intelligence service system shown in FIG. 1.

In this embodiment, data for the BI service is stored in a database 130 operated by the first server 100, and the first server 100 subscribes to a BI service among services provided by the second server 200. On the premise that

① At least one user terminal device 300 connects to the BI connection unit 120. When the first server 100 is a tenant server of a company, terminal devices of employees in the company may correspond to the user terminal device 300.

② When the user terminal device 300 is connected, the BI connection unit 120 communicates with the BI interface unit 210 of the second server 200 through the network. In this case, the BI interface 210 may provide a login page in the same form as a normal web page. Here, the user terminal device 300 may transmit the login information to the BI interface unit 210 through the BI connection unit 120 to authenticate the use authority for the service provided by the second server 200. When the login is performed, the user terminal device 300 makes a service request, and the service request is transmitted to the BI interface unit 210 through the BI connection unit 120.

③ When the BI interface unit 210 receives a service request from the BI connection unit 120 of the first server 100, the BI interface unit 210 transmits the received service request to the second BI service provider 220.

④ When the service request is received, the second BI service provider 220 transmits a corresponding command to the second connector 240 to request data necessary for generating the requested BI service.

⑤ The second transceiver 245 of the second connector 240 transmits a data request of the second BI service provider 220 through communication with the first transceiver 145 of the first connector 140. .

⑥ The first connector 140 receives a data request of the second connector 240 through the first transceiver 145, and extracts the corresponding data from the database 130 in the first data extractor 144. Here, as shown, the database 130 may be at least one of a general DB or DW.

⑦ After the first connector 140 encrypts the data extracted from the database 130 by the first encryption / decryption unit 141, the second transceiver 140 of the second connector 240 is connected through the first transceiver 145. 245).

⑧ The second connector 240 decodes the data received from the first connector 140 through the second encryption / decryption unit 241 and uses the data decoded by the second metadata generator 243 to decrypt the metadata. After generating the metadata, the metadata is transmitted to the second BI service provider 220.

⑨ The second BI service provider 220 generates a BI application using the metadata received from the second connector 240 and notifies the BI interface 210 that the BI application has been created.

The BI interface unit 210 provides the BI service by the BI application generated by the second BI service provider 220 to the user terminal device 300 through the BI connection unit 120.

FIG. 4 is a diagram for explaining another example of a service provided by the business intelligence service system shown in FIG. 1.

In the present embodiment, when the first server 100 is subscribed to both the BI service and the DW service among the services provided by the second server 200, the database 130 and the second server of the first server 100 ( The DW 230 of 200 is assumed to be synchronized.

In FIG. 4, arrows indicated by dotted lines indicate that the database 130 of the first server 100 and the DW 230 of the second server 200 are synchronized. According to a setting, the first synchronization unit 142 transmits the data stored in the database 130 to the second connector 240 periodically or aperiodically by interworking with the second synchronization unit 242, and the second connector 240. ) Stores the data transmitted from the first connector 140 in the DW (230). Here, when stored in the DW 230 is converted into a suitable form and stored.

① The user terminal device 300 accesses the BI connection unit 120 of the first server 100 and requests a BI service.

② The BI connection unit 120 accesses the BI interface unit 210 and transmits a BI service request of the user terminal device 300 to the second server 200.

③ The BI interface unit 210 transmits the BI service request of the first server 100 to the second BI service provider 220.

④ The second BI service provider 220 requests the corresponding data from the BI service requested by the second connector 240 in response to the BI service request of the first server 100.

⑤ The second connector 240 extracts data requested by the second BI service provider 220 from the DW 230.

⑥ The second connector 240 transmits the data extracted from the DW 230 to the second BI service provider 220.

⑦ The second BI service provider 220 generates a BI application by using the data received from the second connector 240, and notifies the BI interface 210 that the BI application has been created.

⑧ The BI interface unit 210 provides the BI service requested by the first server 100 by the BI application.

FIG. 5 is a diagram for describing another example of a service provided by the business intelligence service system shown in FIG. 1.

In the present embodiment, the database 130 and the second server of the first server 100 in a state in which the first server 100 is subscribed to both the BI service and the DW service among the services provided by the second server 200. It is assumed that DW 230 of 200 does not perform synchronization.

① The user terminal device 300 accesses the BI connection unit 120 of the first server 100 and requests a BI service.

② The BI connection unit 120 accesses the BI interface unit 210 and transmits a BI service request of the user terminal device 300 to the second server 200.

③ The BI interface unit 210 transmits the BI service request of the first server 100 to the second BI service provider 220.

④ The second BI service provider 220 transmits a command for requesting corresponding data to the BI service requested by the second connector 240, in response to the BI service request of the first server 100.

⑤ The second connector 240 communicates with the first transceiver 145 of the first connector 140 through the second transceiver 245 to request data received from the second BI service provider 220. Send the command.

⑥ In response to the data request received from the second connector 240, the first connector 140 extracts the data requested by the first data extractor 144 from the database 130.

⑦ The first connector 140 encrypts the data extracted from the database 130 by the first encryption / decryption unit 141 and transmits the encrypted data to the second connector 240 through the first transceiver 145. do.

⑧ The second connector 240 decodes the data transmitted through the communication with the first connector 140 by the second encryption / decoding unit 241 and converts the decoded data into a form that can be loaded into the DW 230. After loading, it is loaded in the DW 230.

9) The data loaded in the DW 230 by the second connector 240 is provided to the second BI service provider 220.

⑩ The second BI service provider 220 generates an application for the corresponding BI service using this data, and delivers the generated application to the BI interface 210.

The BI interface unit 210 transmits a BI application to the BI connection unit 120 to provide a BI service requested by the first server 100.

FIG. 6 is a diagram for describing another example of a service provided by the business intelligence service system shown in FIG. 1.

In the present embodiment, the DW 130 of the database 130 and the second server 200 of the first server 100 in a state in which the first server 100 is subscribed to only the DW service among the services provided by the second server 200. 230 assumes a state in which synchronization occurs. In addition, it is assumed that the database 130 of the first server 100 is a general DB.

Arrows indicated by dotted lines in FIG. 6 indicate that the database 130 of the first server 100 and the DW 230 of the second server 200 are synchronized. According to a setting, the first synchronizer 142 transmits the data stored in the database 130 to the second connector 240 periodically or aperiodically in association with the second synchronizer 242, and the second connector 240. ) Stores the data transmitted from the first connector 140 in the DW (230).

① The user terminal device 300 requests a BI service through a BI application provided by the first BI service provider 110.

② The first BI service provider 110 transmits a command for requesting data for the BI service requested by the first connector 140.

③ The first connector 140 requests data for the BI service from the second connector 240 through the first transceiver 145.

④ The second connector 240 extracts data requested by the first BI service provider 110 from the DW 230. In this case, it is assumed that the DW 230 is synchronized with the DW 230 of the second server 200.

⑤ The second connector 240 transmits the data extracted from the DW 230 to the first connector 140 through the second transceiver 245.

⑥ The first metadata generator 143 of the first connector 140 generates the metadata using the data received from the second connector 240 and then generates the generated metadata in the first BI service provider ( 110). Thereafter, the first BI service providing unit 110 generates a BI application using metadata and provides a BI service through the generated BI application.

7 is a flowchart illustrating a business intelligence service method according to an embodiment of the present invention.

In the present embodiment, when the first server 100 does not include the first BI service providing unit 110 and the DW, that is, the BI among the services provided by the first server 100 by the second server 200. BI service method in case of using both service and DW service. In addition, the present embodiment may correspond to a case where a previously generated BI application does not exist, that is, when the first server 100 uses the BI service of the second server 200 for the first time. This embodiment is related to FIGS. 4 and 5.

Although not illustrated, as described with reference to FIGS. 4 and 5, the user terminal device 300 may access the BI connection unit 120 and input a service request. The service request from the user terminal 300 may be delivered by the same procedure as described with reference to FIGS. 4 and 5.

In order to load the data in the database 130 of the first server 100 into the DW 230 of the second server 200, the first connector 140 extracts data for the BI service from the database 130. The extracted data is transmitted to the second connector 240 (S403).

After receiving data from the first connector 140, the second connector 240 converts the data into a form that can be loaded into the DW 230, and then instructs the DW 230 to load data (S405) and the DW 230. ) Loads the corresponding data according to the instruction of the second connector 240 (S407). Here, steps S401 to S407 denoted as A may be performed in the background by an interlocking operation of the first synchronization unit 142 and the second synchronization unit 242 regardless of whether the BI service and the DW service are provided, or It may be performed every time the BI service is used.

The BI connection unit 120 connects to the BI interface unit 210 (S409), and the BI interface unit 210 distinguishes a tenant to which the first server 100 to which the BI connection unit belongs. Here, the BI interface unit 210 may identify the tenants by one of the three methods described above. In addition, the BI interface unit 210 determines the tenant to which the first server 100 requesting the service belongs, and then determines the service mode to which the divided tenant is subscribed (S411). In the present embodiment, the first server 100 may be subscribed to the second service mode.

The BI interface 210 classifies the tenant to which the first server 100 that requested the service belongs, and then, according to the service mode corresponding to the tenant to which the first server 100 belongs, to the second BI service provider 220. Request a BI service (S413).

The second BI service provider 220 requests data for the BI service from the second connector 240 (S415), and the second connector 240 extracts the corresponding data from the DW 230 (S417). In this case, the DW 230 of the second server 200 may be synchronized with the database 130 of the first server 100 by A process.

The second connector 240 extracting data from the DW 230 generates metadata necessary for configuration and operation of the BI application using the data (S419), and the second connector 240 removes the generated metadata. 2 is provided to the BI service providing unit 220 (S421).

The second BI service provider 220 generates a BI application using the metadata provided from the second connector 240 (S423), and provides the generated BI application to the BI interface unit 210 (S425). . As a result, the BI interface unit 210 provides a BI service through the BI application (S427).

If data change occurs while the BI service is provided through the BI application (S429-Y), the BI interface unit 210 stores the changed data to the second BI service provider 220. Request (S431).

Accordingly, the second BI service provider 220 instructs the data storage to the DW 230 (S433), and the DW 230 sends the corresponding data according to the data storage instruction of the second BI service provider 220. Save (S435).

8 is a flowchart illustrating a business intelligence service method according to another embodiment of the present invention.

In this embodiment, as shown in FIG. 7, when the first server 100 does not include the first BI service providing unit 110 and the DW, that is, the first server 100 is provided by the second server 200. BI service method in the case of using both BI service and DW service among services to be described. However, the present embodiment describes a BI service method when there is a previously generated BI application. This embodiment is related to FIGS. 4 and 5. In addition, A 'is the same process as A demonstrated in FIG. 7, and description is abbreviate | omitted here.

The BI connection unit 120 connects to the BI interface unit 210 (S509). Here, the BI connection unit 120 may be accessed through a login page provided by the BI interface unit 210.

The BI interface unit 210 distinguishes tenants to which the first server 100 that is connected belongs, and determines a service mode corresponding to the divided tenants (S511). In the present embodiment, the service mode to which the first server 100 subscribes may be the second service mode.

After dividing the tenants, the BI interface unit 210 requests the BI service to the second BI service provider 220 (S513), and the second BI service provider 220 belongs to the first server 100. The parasitic BI application corresponding to the tenant is provided to the BI interface unit 210 (S515). The BI interface 210 provides a BI service through the BI application provided from the second BI service provider 220 (S517).

Since steps S519 to S525 are the same as those of steps S429 to S435 described with reference to FIG. 7, descriptions thereof will be omitted.

9 is a flowchart illustrating a business intelligence service method according to another embodiment of the present invention.

In this embodiment, the first server 100 may correspond to a case of using a BI service among the services provided by the second server 200. That is, it may correspond to a more detailed procedure for the signal flow shown in FIG. In addition, in the present embodiment, the database 130 of the first server 100 may correspond to a DW or a case in which both a general DB and a DW are provided.

When requesting a BI service from the first server 100 to the second server 200, the BI connection unit 120 accesses the BI interface unit 210 through the network (S601). As described with reference to FIG. 3, the BI service request may be input from the user terminal 300.

When the BI service request is input, the BI interface unit 210 distinguishes tenants to which the first server 100 requesting the BI service belongs, and determines a service mode corresponding to the divided tenants (S603). In the present embodiment, the service mode subscribed to the first server 100 may be the first service mode.

The BI interface 210 requests the BI service to the second BI service provider 220 according to the service mode to which the first server 100 subscribes, that is, according to the first service mode (S605).

The second BI service provider 220 requests data from the second connector 240 in response to the BI service request of the BI interface 210 (S607), and the second connector 240 is the first connector 140. In step S609, data is requested.

The first connector 140 extracts data for the BI service requested by the second connector 240 from the DW 230, encrypts the data, and transmits the encrypted data to the second connector 240 (S611 and S613).

The second connector 240, which has received data from the first connector 140, decrypts the encrypted data and generates metadata necessary for configuration and operation of the BI application using the decrypted data (S615).

The second connector 240 provides metadata to the second BI service provider 220 (S617), and the second BI service provider 220 generates a BI application using the metadata (S619).

The second BI service providing unit 220 provides a BI application to the BI interface unit 210 (S621), and the BI interface unit 210 provides a BI service through the BI application (S623).

Thereafter, data change through the BI service may occur. In this case, steps S625 to S629 may be performed. Steps S625 to S629 are the same as steps S427 to S435 in FIG. 7. If no change of data occurs while the BI service is provided, this procedure ends when the provision of the BI service is terminated.

10 is a flowchart illustrating a business intelligence service method according to another embodiment of the present invention.

This embodiment may correspond to a case in which the first server 100 includes the first BI service providing unit 110 but does not have a DW or if a DW is provided but a further DW is to be constructed. have. This embodiment is related to FIG. 6.

Since the first server 100 provides the BI service through the first BI service provider 110, a BI service request is input through the first BI service provider 110, and the first BI service provider ( When the BI service request is received, the 110 requests a BI service to the first connector 140 (S701).

The first connector 140 requests data necessary for the BI service requested to the second connector 240 in response to a request of the first BI service provider 110 (S703).

In response to the data request of the first connector 140, the second connector 240 identifies a tenant to which the first server 100 that has requested data belongs. Here, the method of classifying the tenants by the second connector 240 may be the same as the method of classifying the tenants by the BI interface unit 210 in the previous embodiment. To this end, the second connector 240 in the present embodiment may further include a tenant separator (not shown). The service mode subscribed to by the first server 100 in the present embodiment may be a third service mode. In this case, the tenant needs only to extract data from the DW 230 and import the data to the first server 100. The operation of determining the service mode corresponding to the above may be omitted.

After dividing the tenants, the second connector 240 extracts data corresponding to the divided tenants from the DW 230 (S707) and encrypts the extracted data for transmission to the first server 100 (S709). ).

The second connector 240 transmits the encrypted data to the first connector 140 (S711), and the first connector 140 decrypts the data received from the second connector 240, and then decrypts the decrypted data. Meta data is generated by using (S713).

After generating the metadata, the first connector 140 provides metadata to the first BI service provider 110 (S715), and the first BI service provider 110 uses the metadata to apply the BI application. To generate (S717).

The first BI service providing unit 110 provides a BI service through a pre-generated BI application, through which the user terminal device 300 uses the BI service (S719).

Thereafter, data change may occur while using the BI service provided through the first BI service providing unit 110. In this case, steps S721 to S729 may be performed. Steps S721 to S729 are the same as steps S427 to S435 in FIG. 7. If no change of data occurs while the BI service is provided, this procedure ends when the provision of the BI service is terminated.

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 not only by the claims below but also by the equivalents of the claims.

100: first server 110: first BI service providing unit
120: BI connection 130: database
140: first connector 200: second server
210: BI interface unit 220: second BI service providing unit
230: DW 240: second connector

Claims (25)

A business intelligence service system comprising a first server and a second server,
The first server,
Includes an operational database that stores data for business intelligence services,
Receiving a business intelligence service request from at least one user terminal device, extracting the data necessary to provide the business intelligence service from the operational database to provide to the second server, the second server to provide a business intelligence service Request to
The second server,
Includes a data warehouse that stores data for business intelligence services,
When a business intelligence service is requested from the first server, an application for the business intelligence service is generated and executed from the data stored in the data warehouse and provided to the first server.
The first server is also,
Providing a business intelligence service to the user terminal device by an application generated and executed by the second server,
The second server is also,
When the first server receives a request to transmit data for a business intelligence service, the business intelligence service extracts the data requested by the first server from the data warehouse and transmits the requested data to the first server. system. The method of claim 1,
The second server generates metadata corresponding to a business intelligence service request from the first server from data stored in the data warehouse, generates an application using the generated metadata, and executes the application. And a service request from the first server. The method of claim 1,
And the second server converts the data received from the first server into a form that can be stored in the data warehouse and stores the converted data. delete delete The method of claim 1,
When the first server receives a business intelligence service request from a user terminal device, the first server requests and receives the second server to transmit data for the business intelligence service, and generates an application for the business intelligence service. A business intelligence service system, comprising: providing a service requested by a user terminal device by executing a generated application. A business intelligence connection unit for receiving a business intelligence service request from at least one user terminal device and requesting an external server having a business intelligence interface to provide the requested business intelligence service; And
Operational database; And
And a first connector extracting data necessary to provide the business intelligence service from the operational database and providing the data to the external server.
And the business intelligence connection unit provides a business intelligence service to the user terminal device by an application generated and executed by the external server. The method of claim 7, wherein
The first connector transmits the data extracted from the operation database to the second connector of the external server,
The second connector generates metadata using data provided from the first connector, and the application is generated using the metadata. The method of claim 7, wherein
The first connector transmits the data extracted from the operation database to a second connector of the external server,
The application is a server, characterized in that generated using the metadata received by the second connector. The method of claim 7, wherein
The external server includes a data warehouse, the first connector includes a synchronization unit for synchronizing the data stored in the operational database and the data stored in the data warehouse,
The application is a server, characterized in that generated from the data extracted from the data warehouse. The method of claim 7, wherein
The application executed by the external server, characterized in that the generated from the data provided through the first connector. The method of claim 7, wherein
Business intelligence service provider; further includes,
And the first connector requests and receives data for the requested business intelligence service from the external server at the request of the business intelligence service provider. The method of claim 12,
The first connector, the server, characterized in that for generating the metadata required for the operation and configuration of the application using the data received from the external server. The method of claim 13,
The business intelligence service provider, the server, characterized in that for generating an application for the business intelligence service using the metadata generated by the connector. 15. The method of claim 14,
And the business intelligence service providing unit executes the application to provide the requested business intelligence service. The method of claim 15,
The business intelligence service providing unit, if a change in data occurs in the business intelligence service, the server, characterized in that for requesting the external server to store the data in which the change occurs. A data warehouse that stores data for business intelligence services;
A connector for extracting data requested by the external server from the data warehouse and transmitting the extracted data to the external server when data for the business intelligence service is requested from an external server;
A business intelligence interface unit for receiving a business intelligence service request from the external server; And
And a business intelligence service provider for generating an application for a business intelligence service at the request of the business intelligence interface. The method of claim 17,
The connector includes a synchronization unit for synchronizing the data stored in the database of the external server and the data stored in the data warehouse with each other. The method of claim 17,
The data stored in the data warehouse is characterized in that the connector is received from the external server and stored. The method of claim 17,
The connector generates a metadata necessary for the operation and configuration of the application at the request of the business intelligence service provider, and provides it to the business intelligence service provider. 21. The method of claim 20,
The connector is a server, characterized in that to generate the metadata using the data received by requesting the data for the business intelligence service to the external server. 21. The method of claim 20,
The connector extracts data for the business intelligence service from the data warehouse at the request of the business intelligence service provider, and configures metadata for the operation and configuration of the application using the extracted data. Server. The method of claim 22,
The business intelligence service provider,
And if data changes in a business intelligence service, requesting the external server to store the data in which the change has occurred. In the business intelligence service method of a system comprising a first server and a second server,
Requesting, by the first server, a second server having a business intelligence interface to receive a business intelligence service request from at least one user terminal device and provide the requested business intelligence service;
Extracting, by the first server, data necessary for providing the business intelligence service from an operation database stored by the first server and providing the data to the second server; And
And providing, by the first server, a business intelligence service to the user terminal device by an application generated and executed by the second server. The method of claim 24,
The first server further includes requesting data for a business intelligence service from a second server.
And the first server receives data for a business intelligence service from the second server and generates an application for the business intelligence service from the received data.

Images