TWI609281B - Cloud Instant Business Intelligence Module - Google Patents

Description

Cloud Instant Business Intelligence Module

The invention provides a technical field of a database, in particular, a technology for providing a cloud real-time business intelligence module, which can save a customer's database without being stored in the cloud, and has less data transmission and fast speed, and rents a cloud service host. Space can also be greatly reduced.

According to the concerns of enterprises in the need of business intelligence in cloud solutions, most of them are information security, that is, the company's operational data is placed in cloud data storage. The in-memory technology of the BI technology developed in the market today is to load the data into the host memory, in addition to speeding up the operation, and providing self-service BI. Therefore, using the technology on the market today to apply to the cloud environment, in order to meet the needs of real-time analysis of enterprises, and to make good use of cloud services and computing resources, the primary problem to be solved is the concern of information security.

The inventor of the present invention previously implemented the application-oriented architecture (SOA) of the walk-through instruction reorganization of the service-oriented architecture (SOA) in the real-time business intelligence system, and the content is: a service-oriented architecture (SOA) walk-through The design of the command reorganization is implemented in an instant business intelligence system, including A service host includes a central processing unit, a plurality of memory, and a plurality of disk storage devices, wherein the service host carries: a service oriented architecture (SOA), a user terminal, and an information technology ( Information Technology, IT) personnel, the Service Oriented Architecture (SOA) includes a walk-through instruction reassembly module (ReSQL), and the walk-through instruction reassembly module (ReSQL) includes an instruction reassembly and parsing module, a first a service definition file (eistable.def), a second service definition file (valueSQL.def), and an inheritance module, the first service definition file (eistable.def) and the second service definition file (valueSQL.def) Simplely defined by the information technology (IT) staff, data is taken from the operating system or data is taken from multiple operating systems or data is taken from multiple operating systems and data warehousing, which is based on the relocation module (ReSQL) The restructured instruction obtains the source of the obtained data, and then obtains the required information from the data source. The service oriented architecture (SOA) further includes a grammar conversion module, and the grammar conversion module can communicate the reorganization and parsing of the instruction. group The homogenous or heterogeneous database of each operating system or data warehousing enables all data to be automatically accessible. The successor module can modify the needs of the user terminal through the inheritance of each service and re-engage through the service. A new service completes the integration of multiple data sources. The instruction reorganization and profiling module is responsible for the definition of the service and the parameter input of the user input. The operation mode of the recursive instruction reorganization is completed, and the service analysis is performed. When the user-side demand changes, the instruction reorganization and parsing module provides strain elasticity to obtain multi-dimensional data with data storage. Analyze the environment and calculations. After the user-side transforms the requirements, even if different dimensions, different operating systems or multiple operating systems and data warehousing or homogeneous or heterogeneous databases, the immutable data can be immediately obtained without any individuality. Write a separate, specific application interface (API).

However, if the previous case is imported to the client separately, the cost is quite expensive, and it can be afforded by non-senior small and medium-sized enterprises. If it can pass through the cloud service host, it can be rented to greatly reduce the installation cost, which can also reduce the space for hosting the cloud service host. The client database data is not used by the inventory cloud service host to reduce information security concerns.

Therefore, in view of the problems existing in the above-mentioned conventional structure, how to develop an innovative structure that is more ideal and practical, the consumers are eagerly awaiting, and the relevant industry must strive to develop the goal and direction of breakthrough.

In view of this, the inventor has been engaged in the manufacturing development and design experience of related products for many years. After detailed design and careful evaluation, the inventor has finally obtained the practical invention.

The main purpose of the present invention is to provide a cloud instant business intelligence module, wherein the client database does not need to be stored to the cloud service host, the cloud service host has a walking data management module, and the walking data management module captures the user requirements. , and then converted into the corresponding database syntax, and only the corresponding database syntax is transmitted to the corresponding database, and the returned data is compiled into a data table and a graph and provided to the user, so that the amount of data transmitted can be reduced. Fast, no need to store a large amount of data in the cloud service host, but also reduce the probability of data being stolen.

To achieve the above objective, the present invention provides a cloud real-time business intelligence module, which comprises: a gateway device (gateway) disposed at a client device and a client device, a walking data management module, and the walking data. The management module is set up on the cloud service host, and the mobile data management module of the cloud service host is connected with the client device by a gateway device, the user terminal and the cloud service host are connected by telecommunications, and the gateway device is responsible for the client device. The data source is dynamically generated by the mobile data management module of the cloud service host, which can achieve the purpose of real-time analysis. The mobile data management module of the cloud service host will learn according to the data of the user terminal operation process. The demand is converted into the database data query syntax, and the content transmitted by the client is limited to the demand scope summary data, which does not cause a large amount of data transmission problems, and does not need to upload the current enterprise database content to the cloud service host, overcoming the client pair. Information security concerns, and can significantly reduce the space for cloud service hosting leases, A small amount of file transfer time by.

The above-mentioned objects, structures and features of the present invention will be described in detail with reference to the preferred embodiments of the present invention. .

10‧‧‧Gateway device

20‧‧‧Client device

21‧‧‧Database

30‧‧‧Cloud Service Host

40‧‧‧A walking data management module

41‧‧‧Walking Instruction Reassembly Module (ReSQL)

411‧‧‧Instruction Reorganization and Profiling Module

412‧‧‧First Service Definition File (eistable.def)

413‧‧‧Second service definition file (valueSQL.def)

414‧‧‧Inheritance module

42‧‧‧ data set

43‧‧‧Syntax conversion module

44‧‧‧Multiple Data Source Integration Module

45‧‧‧Dimensional Integration Module

461‧‧‧User interface output module

462‧‧‧User interface control module

47‧‧‧Filter

48‧‧‧Cache memory

50‧‧‧User side

51‧‧‧ computer

52‧‧‧ Tablet PC

53‧‧‧Mobile phones

a‧‧‧Users request to the cloud service host

b‧‧‧Client device authorization check whitelist

c‧‧‧After the data management module needs to retrieve the corresponding database syntax

d‧‧‧Transfer to the client device corresponding database

e‧‧‧A walking data management module to obtain the required information

f‧‧‧Automatic typesetting of walking data management module

G‧‧‧ Exported to the cloud service host for user-side extraction

The first figure is a block diagram of the action flow of an embodiment of the present invention.

The second figure is a system flow block diagram of an embodiment of the present invention.

The third figure is a structural flow chart of the walking data management module of the present invention.

The fourth figure is a schematic diagram of the system architecture of the application of the invention in the customer complaint management system.

The fifth figure is a schematic diagram of the position of the product interrelated state of an embodiment of the present invention.

The invention provides a designer of a cloud instant business intelligence module.

In order to enable the reviewing committee to have a better understanding and understanding of the purpose, features and functions of the present invention, the implementation and the detailed description are as follows: Referring to the fifth figure, the present invention provides a cloud real-time business intelligence module. The group includes: a gateway device (Gateway) 10, the gateway device 10 is installed in front of a client device 20. The client device 20 has an authorized whitelist first, and the client device 20 includes multiple homogeneous devices. Or a heterogeneous database 21; a cloud service host 30, the cloud service host 30 internally constructs a walk-through data management module 40, the cloud service host 30 connects to the gateway device 10, and the gateway device 10 connects the client device 20; The majority of the user terminals 50, the user terminal 50 logs in to the cloud service host 30 to request, and the cloud service host 30 performs authorization check on the client device 20 via the gateway device 10 to verify whether it is a white list, and the verification passes the walk data management module. 40: The user terminal 50 needs to be converted into a database schema of the homogeneous or heterogeneous database 21 of the corresponding client device, and the database syntax is transmitted to the database 21 corresponding to the client device 20 for data capture. The data is required to be automatically typeset, and the typesetting data is sent out to the cloud service host 30 for the user to extract.

Referring to the fifth embodiment, the cloud instant business intelligence module, wherein the user terminal 50 can be a computer 51, a notebook computer, a tablet computer 52, a mobile phone 53 or a smart TV.

Referring to the second figure, the cloud instant business intelligence module, wherein the gateway device (Gateway) 10 includes an authorization setting white list, an authorization check, a database connection setting, and a data capture control. The walk-through data management module 40 performs data capture, and causes the client device 20 to perform service execution through the database syntax, and the data is loaded into the data set to be provided to the user terminal 50. The cloud service host 30 authorizes, and the authorized cloud service host 30 can execute the generated authorization code. After the authorization code is added to the whitelist of the gateway device 10, the request sent by the cloud service host 30 carries the authorization code. Can pass the verification.

Referring to the fourth figure, it is an application example of the present invention for complaint management, wherein the cloud service host 30 is provided with a walk-through data tube. In the module 40, the user terminal 50 may be a user or a company employee or a supervisor. When the user terminal 50 enters the cloud service host 30 during the request period, the product, and the return rate, the client device 20 verifies whether it is a whitelist. After the verification is passed, the walk-through data management module 40 transmits the demand-to-conversion corresponding database syntax to the gateway device 10, and the gateway device 10 retrieves the data from the client device 20, and then remits the data to the The cloud service host 30 is extracted by the user terminal 50, and the user terminal can see the return rate table of the related products in the relevant period, and if there are three different databases of the north, middle and south branches, related products during the relevant period. The return rate can also be integrated into a table display, and once the data is extracted, there will be no cloud service host 30, which can ensure the security of the data. The database does not need to exist in the cloud service host 30, and the cloud service host 30 rental fee can be greatly reduced. And the transmission is only for the database syntax and the required range of data, the data volume can be transmitted less quickly.

Referring to the third embodiment, the cloud real-time business intelligence module, wherein the walking data management module 40 is installed in the cloud service host 30 (refer to the fifth figure), the walking data management module 40 includes There is a walk-through instruction reassembly module (ReSQL) 41, and the aforementioned walk-through instruction reassembly module (ReSQL) 41 includes an instruction reorganization and parsing module 411, a first service definition file (eistable.def) 412, and a second service. The definition file (valueSQL.def) 413 and an inheritance module 414 further comprise a grammar conversion module 43, a data set 42, a multiple data source integration module 44, and a dimension. The integration module 45, a user interface control module 462, a user interface output module 461, a filter 47 and a cache memory 48, the user interface control module 462 and the user interface output module 461 are a user terminal 50 and a walk-through data management module 40. The communication medium, and the aforementioned walk-through instruction reassembly module (ReSQL) 41, the grammar conversion module 43, the data set 42, the multiple data source integration module 44, the dimension integration module 45, the filter 47, the cache memory 48 Then, the corresponding database syntax can be generated, and the required data is obtained from the related database 21 and provided to the user terminal 50.

Referring to the first figure, a block diagram of an action flow of an embodiment of the present invention, wherein (a) the client 50 proposes a request to the cloud service host 30, and (b) the client device 20 authorizes checking the whitelist if If it is a whitelist, it is rejected in the cloud service host 30. (c) The walk-through data management module 40 needs to retrieve the corresponding database syntax, and transfer the database syntax (d) to the client device. 20 corresponding database 21, (e) walking data management module 40 obtains the required data, (f) walking type data management module 40 automatic layout and table, (g) remitted to the cloud service host 30 for the user End 50 is extracted.

It can be seen from the above that the cloud instant business intelligence module of the present invention is indeed the first in the industry and meets the novel requirements of the invention patent, and its comprehensive and innovative design conforms to the progressive requirements of the invention patent, and the enterprise does not have to The data is moved outside the enterprise environment, but it can make good use of cloud computing resources. In addition to reducing the cost of hardware environment construction, it can also obtain the operational analysis of the business operation data content, create advanced business intelligence value, and for the group. The operating company, the decentralized operational database of each region, adopts the mobile data management module, and obtains the integrated operational information in real time with the Internet, instead of the fragmented data, the real-time integration analysis of the sales status and inventory status of the sales outlets. It is more immediate to conduct merchandise dispatching or promotion, which can increase turnover and reduce the consumption of current products, which is in line with better industrial utilization.

The present invention has been described with reference to the preferred embodiments of the present invention. However, those skilled in the art can change and modify the present invention without departing from the spirit and scope of the invention. Such changes and modifications shall be covered in the scope defined by the following patent application.

In summary, the present invention provides a cloud real-time business intelligence module, which has indeed achieved all the purposes of the present invention, and the spatial type of the combined structure is not found in the same type of products, nor has it been disclosed before the application, and has been in compliance with the patent. The provisions of the law, 提出 apply in accordance with the law.

a‧‧‧Users request to the cloud service host

b‧‧‧Client device authorization check whitelist

c‧‧‧After the data management module needs to retrieve the corresponding database syntax

d‧‧‧Transfer to the client device corresponding database

e‧‧‧A walking data management module to obtain the required information

f‧‧‧Automatic typesetting of walking data management module

G‧‧‧ Exported to the cloud service host for user-side extraction

Claims (1)

A cloud real-time business intelligence module includes: a gateway device (Gateway), the gateway device is installed in front of a client device, and the client device first has an authorized white list, and the client device includes multiple homogeneous or A heterogeneous database; a cloud service host, the cloud service host internally builds an ambulatory data management module, the cloud service host connects the gateway device, and the gateway device connects the client device; most of the user terminals and the user end log in to the cloud The service host proposes the request, and the cloud service host performs authorization check on the client device through the gateway device to verify whether the whitelist is verified. After the verification, the walkthrough data management module converts the user end demand into the data of the corresponding client database. The library grammar, the database grammar is transmitted to the database corresponding to the client for data capture, the required data is obtained and the data is automatically typeset, and the typesetting data is sent out to the cloud service host for user end extraction; the user The end can be a computer, a notebook computer, a tablet computer, a mobile phone or a smart The gateway device (Gateway) includes an authorization setting white list, an authorization check, a database connection setting, and a data capture control; the walk-through data management module includes a walk-through instruction reassembly module (ReSQL), which moves around. Reorganization module (ReSQL) includes instruction reorganization and parsing module, a first service definition file (eistable.def), and a second service. The definition file (valueSQL.def) and an inheritance module are formed. The walking data management module further comprises a grammar conversion module, a data set, a multiple data source integration module, a one-dimensional integration module, and a use. Interface control module, a user interface output module, a filter and a cache memory, the user interface control module and the user interface output module communicate with the user interface and the walk data management module Media, and the aforementioned walk-through instruction reassembly module (ReSQL), grammar conversion module, data set, multiple data source integration module, dimension integration module, filter, cache memory can generate corresponding database syntax And obtaining the required data from the foregoing client device related database to provide to the user end.