TW201447782A - Real-time business intelligent system realized and designed by walking instruction reconfiguration of service-oriented architecture (SOA) - Google Patents

Abstract

A real-time business intelligent system realized and designed by walking instruction reconfiguration of service-oriented architecture (SOA) comprises a walking instruction reconfiguration module composed of an instruction reconfiguration and analysis module, a first service definition file, a second service definition file and an inheritance module. Source syntax of obtaining data is acquired real-time based upon the instruction reconfigured by the walking instruction reconfiguration module. Required data is then obtained by the source syntax from many operational systems or data warehouses, and the service is taken as orientation to obtain analysis environment and computation having multi-dimensional data of the data warehouse. After the user end changes demand, real-time changed data can be instantly acquired regardless of different dimensions, different operational systems or many operational systems and data warehouses or homogeneous or heterogeneous databases. The heterogeneous data source can be designed and integrated by the architecture of combining the first service definition file with the second service definition file.

Description

The design of the walk-through instruction reorganization with Service Oriented Architecture (SOA) is realized in the real-time business intelligence system.

The invention relates to a technical field of a business intelligence system, in particular to a technically provided service-oriented architecture (SOA) walk-through instruction reorganization design implemented in an instant business intelligence system, service-oriented, when the user needs to change the instruction reorganization And the profiling module provides the flexibility of the strain to obtain the analysis environment and calculation of the multi-dimensional data with data storage. After the user changes the demand, even different dimensions, different operating systems or multiple operating systems and data storage or homogeneity or heterogeneity The database can also immediately obtain the immediacy of the transformed data without having to write separate application-specific interfaces (APIs).

Press, see the first figure, the first picture is a current BIS (Business Intelligence System) standard system model, the process can be divided into three stages:

(1) Data collection: Use the ETL (Extract-Transform-Load) tool (see the second figure) to extract, convert and load the source database data source 10 into the Operational data store database; tired The accumulated data is stored in the data warehouse database.

(2) Data analysis: Extract the data of the data warehouse 24 using the ETL tool (refer to the second figure) and store it in the Data Mart database constructed based on the analysis (in some cases, the Data Mart can be omitted and directly From the trading system 20, take 21, convert 22, load 23 to obtain analytical data). Then use OLAP (Online Analytical Processing) or Data Mining technology for data analysis.

(3) Data presentation 13: Present the data analysis results to the user by means of a report tool output report or Web Portal.

And the problems faced by enterprises today, is it possible to achieve a dream of corporate BI by building a good BIS? Before the BIS voice shouted loudly, and the company invested a lot of resources, time and manpower resources, the benefits and expectations of users from BIS were useful for Information Quality (IQ) and the system. There is often a big gap in the use of information. At the end of the company, 90% of the employees in the company still use Excel to analyze the data, which makes the BI less effective. The invention is roughly summarized into the following two points on the cognitive level of the user's poor information quality:

(1) Data warehousing plays a core role in BIS and is the basis for all subsequent information analysis. However, with the rapid changes in the operating environment of enterprises, in the fierce competitive environment, the data in data warehousing cannot provide timely and stable decision makers. Information, so even if there is a good BIS, it can't satisfy the enterprise. Industry needs. On the other hand, the development of data warehousing must be an extremely large and complex investment, which is not only risky, but also requires a large amount of resources to be invested in the enterprise. If there is no clear business case, it may be a Long-term "work in progress" or "project black hole", so many companies are hesitant based on investment costs and risk factors; Gartner Group in 2004 from a smart enterprise (Intelligent Enterprise According to the survey, 55% of corporate users questioned that the information provided by their data warehousing did not hit the target. Another shortcoming is that development is quite time consuming. If the traditional system development method usually takes several years, if the demand will continue to increase during the development process, the prototype method will be used to make a prototype and then develop again. The time spent is not awkward; there is a significant gap between the benefits and expectations that the company has invested in a lot of cost and time.

(2) Many companies mistakenly believe that the introduction of BIS can smoothly operate to obtain the analytical data they deserve. However, companies have not thought that the data in the data warehousing will need to be adjusted as the analysis needs change and the type of the enterprise changes. On the other hand, IT personnel often spend huge amounts of time to integrate a large number of different heterogeneous data sources. In particular, data integration plays an important role in information quality (IQ), especially the information content quality ultimately affects the use of information; the effectiveness of BIS is its ability to provide timely business information, so BIS The success or failure of the import depends on the information available; when relying on IT staff The longer the time or the lack of IT skills, the longer the decision maker waits for the analysis, and the resulting analytical report is absolutely unable to meet the decision maker's needs (on on demand). The expectation, that is, it has been difficult to reflect the changes in the current operating environment, such a decision, did not make much sense.

In 2006, BI 2.0 proposed different thinking and advocated immediacy. However, there are indeed many gaps and obstacles in implementing BI 2.0 concept. According to the current BI application status of most enterprises, if the main requirements of BI 2.0 are compared one by one, It is not difficult to find that the gap between them can be said to be very large. What are the current BI obstacles? The following explains:

(1) The purpose of traditional BIS is to convert data into information, and then convert the information into wisdom. If the company only introduces BIS in order to use BI, it is easy to be obsessed with the extension of the evaluation tool. Whoever has a fast calculation speed, the final BIS can only improve the accuracy, timeliness and integration of information acquisition. It may not be able to go deep into the operational management needs of enterprises, and the company will only realize the reality and expectation after introducing BIS. There is a significant gap between the two, and the benefits are difficult to assess; and the data integration IT staff is time-consuming and laborious, and finally BIS is a report generator, such as the use value, the benefits are naturally not too high, and far from the BI 2.0 appeal concept.

(2) Looking at the BI 2.0 argument, many scholars admit that it is really difficult to achieve. Especially in the decision-making of immediacy, the premise is that the detailed data in the complex information system of the enterprise has to be sorted and calculated. Material delivery also wastes some time, and sometimes seemingly simple requirements such as "adding one field" can take several working days. Therefore, immediate appeals are undoubtedly a major obstacle for policy makers, because once the time horizon of data integration is prolonged, it means that business decisions are based on non-instantaneous data, which is difficult to respond to. Changes in the operating environment, not to mention the decision-makers' needs for analysis will change at any time in response to rapid changes in the market. When the current data (data warehousing) cannot meet its needs, it must rely on IT personnel to re-enter A lot of time (when the IT staff's professional literacy is insufficient, the time for issuing the decision is undoubtedly delayed), and such a process does not make much sense for immediate decision-making needs.

Analytical data produced by the BI 2.0 environment must be embedded in different workflows. In the past, BIS was based on a specific application program interface (API), which was developed by IT staff through development of programs. Fei Zhouzhang took the analysis results. As for the new approach, the BIS analysis results can be easily obtained from any component in the workflow. The premise is to get rid of the IT staff to develop a separate API and change the service orientation. The way the architecture (SOA).

The design of the present invention provides an organization (enterprise) with benefits at the management and decision-making level, and introduces a smart "walking instruction reorganization" design based on the service-oriented architecture based on the enterprise transaction information system (operational IS), overcoming the organization (enterprise) Instantly obtained "with funding" in the absence of a data storage environment The analysis environment and calculation (drilldown, rollup, slice or pivoting, etc.) of multi-dimensional data storage realizes the demand for immediate decision-making, and has been actually imported into the internal information system (operational IS) to verify users and information. The need for source and BIS to achieve an immediate interaction relationship and the specific response in the evaluation of information quality and the degree of usefulness to the system, thereby improving the use of information and greatly improving the success of BIS; it is worth mentioning that the present invention is designed The SOA architecture, through the re-integration of services, becomes an innovative design architecture for new services, making it easy to integrate heterogeneous data.

The design architecture proposed by the present invention can immediately verify the key factors of the aforementioned BIS success from the internal operation information system (operational IS), that is, factors such as data integration, information quality and information usage, and not After waiting for a lot of resources, time and manpower resources, it is found that there is a big gap between the expected benefits; in addition, the data in the data warehouse has been cleaned before being provided to the user (cleaned) ), decoded, reorganized, and reordered. However, through the use of raw transactional data, corrupted and ugly data can be revealed together with good data during the analysis process. The person will have the opportunity to assess what is broken and why, so that there is an opportunity to solve it. Therefore, from the perspective of the benefit structure of IT development BIS, it can be expected that the value of such a design structure can improve the correlation between the degree of understanding of the problem and the key factors of the user's cognition, and greatly reduce the investment of the company to introduce instant BIS. Resources and after meeting Continued changes in user needs, providing users with the analytical data needed to improve the use efficiency of BIS information, and allowing IT staff to save time in intervention data integration, and more focused on other business processes of the enterprise. IT is the biggest benefit.

Therefore, under such a design architecture, the system has a highly scalable flexibility and implements the core spirit of the abstraction (abstraction), composability, and reusability emphasized by the SOA to implement the BI 2.0 real-time analysis service. To help companies achieve:

(1) Increase the company's profit or increase the competitiveness of the company.

(2) Provide a variable service type.

(3) Reduce the cost and time of enterprise import.

(4) Reduce the time for development services to achieve immediate demand.

(5) Integrate the enterprise's network service technology resources.

(6) Reduce overall risks and accidents.

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‧‧‧Source

11‧‧‧Extraction, conversion and loading

12‧‧‧Data storage

13‧‧‧Information presentation

20‧‧‧ trading system

21‧‧‧Select

22‧‧‧Conversion

23‧‧‧Load

24‧‧‧Data warehousing

[this invention]

30‧‧‧ trading system

31‧‧‧Data warehousing

40‧‧‧Service Oriented Architecture (SOA)

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 (DS)

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‧‧‧Homogeneous or heterogeneous database

49‧‧‧Cache memory (cache)

The first picture is the traditional business intelligence (BI) system architecture.

The second figure is the conventional data extraction conversion loading (ETL) architecture.

The third diagram is a diagram of the Service Oriented Architecture (SOA) system of the present invention.

The fourth figure is a system diagram of the walk-through instruction reassembly module (ReSQL) architecture of the present invention.

The fifth figure is the result of the implementation of the first example of the present invention: the 94-year quarterly consolidation data (not yet explored).

The sixth figure is the result of the implementation of the first example of the present invention: the data is collected to the dimension of the department.

The seventh figure is the result of the implementation of the first example of the present invention: the data is collected to the dimensions of the department.

The eighth figure is the result of the first example of the present invention: the data of the physician dimension is measured.

One of the ninth figures is the result of the first example of the present invention: the doctor sees the report details.

The ninth figure is the result of the first example of the present invention: the summary of the quarterly data.

The third figure is the result of the first example of the present invention: Drill-down drills the first quarter data to the month.

The fourth figure is the result of the first example of the present invention: Drill-down to February departmental summary data.

The fifth figure is the result of the first example of the present invention: Drill-down will summarize the data in February.

The sixth figure is the result of the first example of the present invention: Drill-down drills the February surgical summary data to the daily.

The tenth figure is the execution result of the second example of the present invention: inheriting the definition of the first example, Variable dimension attribute.

The eleventh figure is the result of the execution of the second example of the present invention: the summary data to the dimension of the payment category is drilled down.

The twelfth figure is the result of the implementation of the second example of the present invention: the data of the classification dimension of the inpatient case is down-tested.

The thirteenth figure is the result of the second example of the present invention: the pivotal analysis of the branch

The fourteenth figure is the result of the third example of the present invention: inheriting the definition of the first example, generating a new definition in the eistable.def.

The fifteenth figure is the result of the third example of the present invention: the summary data of the doctor's dimension is explored.

The sixteenth figure is the result of the third example of the present invention: the doctor's annual summary data.

One of the seventeenth aspects is an example 4 of the present invention: a multi-data source integration architecture diagram for performing measurement integration.

The seventeenth figure is a schematic diagram of the multiple data source integration architecture of the present invention, which performs dimensional integration.

The eighteenth figure is the result of the fourth example of the present invention: the integration of multiple data sources.

The nineteenth figure is the result of the implementation of the fourth example of the present invention: the integration of multiple data sources (the dimension is the department).

The twentieth figure is the result of the fourth example of the present invention: integration of multiple data sources (investigating to the physician details of the HR database).

One of the twenty-first figures is the result of the example four implementation of the present invention: multiple data source integration (compared with the same period last year), shown in general dimensions.

The twenty-first figure is the result of the fourth example of the present invention: multiple data source integration (compared with the same period of last year), displayed in the period dimension.

The twenty-first figure is the result of the fourth example of the present invention: multiple data source integration (compared with the same period of last year), the following dimensions are shown.

The present invention provides a design for implementing a service-oriented architecture (SOA) walk-through instruction reorganization to implement a real-time business intelligence system.

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 embodiments and the drawings are as follows: Referring to the third figure, the present invention provides a service-oriented architecture ( SOA)'s walk-through instruction reorganization is implemented in real-time business intelligence system, which includes: a service-oriented architecture (SOA) 40, a user terminal and an information technology (IT) staff, the service-oriented architecture. The (SOA) 40 includes a walk-through instruction reassembly module (ReSQL) 41. The walk-through instruction reassembly module (ReSQL) 41 includes an instruction reassembly and parsing module 411 and a first service definition file (eistable.def). 412. A second service definition file (valueSQL.def) 413 and an inheritance module 414, the first service definition file (eistable.def) 412 and the second service definition file (valueSQL.def) 413 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 reorganized instruction obtains the obtained data source, and then obtains the required data from the data source. The service oriented architecture (SOA) 40 further includes a grammar conversion module 43 by which the grammar conversion module 43 can communicate Reorganizing and parsing the module 411 with the homogenous or heterogeneous database 48 of each operating system or data repository, so that all the data is automatically accessible, and the inheritance module 414 can modify the user end through the inheritance manner among the services. The demand and the re-integration through the service become a new service. The instruction reorganization and analysis module 411 is responsible for realizing the immediate demand service analysis by defining the service and setting the parameter input by the user terminal in the operation mode of the walk instruction reorganization. And service-oriented, when the user end needs change, the instruction reorganization and parsing module 411 provides strain elasticity to obtain a data warehouse. The analysis environment and operation of the multi-dimensional data, after the user-side transformation requirements, even if different dimensions, different operating systems or multiple operating systems and data warehousing or homogeneous or heterogeneous databases 48, the converted data can be immediately obtained. Sex, without having to write separate application-specific interfaces (APIs).

The design of the walk-through instruction reorganization of the service-oriented architecture (SOA) 40 is implemented in an instant business intelligence system, wherein the instruction reorganization and parsing module 411 constructs a complete capture instruction, and the instruction reorganization and parsing module 411 More reorganized instruction optimization to shorten data acquisition time .

The design of the walk-through instruction reorganization of the service-oriented architecture (SOA) is implemented in an instant business intelligence system, wherein the user accesses the data mode, including Drill-down and Roll-up. , pivot analysis (Pivot) or slice (Slice).

The service-oriented architecture (SOA) walk-through instruction reorganization is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) 40 further includes a multiple data source integration module 44, and the multiple data source integration module The group 44 is connected to the walk-through instruction reassembly module (ReSQL) 41, the grammar conversion module 43 and the homogenous or heterogeneous database 48, and the multi-data source integration module 44 performs multi-data calculation and integration.

The design of the service-oriented architecture (SOA) of the walk-through instruction reorganization is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) 40 further includes a data set (DS, dataset) 42 and a cache memory. (cache) 49, the data set 42 is linked to the walk-through instruction reassembly module (ReSQL) 41, the multiple data source integration module 44, the homogenous or heterogeneous database 48 and the user end, and the instructions are reorganized and then entered into the data set. 42. When the data set 42 cannot be found by the cache 49, the data will be retrieved from the homogenous or heterogeneous database 48 corresponding to the instruction.

The design of the service-oriented architecture (SOA) of the walk-through instruction reorganization is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) 40 further includes a one-dimensional integration module 45, and the dimension integration module 45 The data set (DS, dataset) 42 and the user end, the dimension integration module 45 integrates the data of the measurement value and the analysis dimension dispersed in different databases, and the integrated data is displayed on the user end.

The design of the service-oriented architecture (SOA) of the walk-through instruction reorganization is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) 40 further includes a filter 47, and the filter 47 is connected to the dimension integration module. And the user terminal, the filter 47 filters out the redundant portion of the integrated data of the dimension integration module 45 under the condition set by the user end, and displays the filtered data on the user end.

The design of the service-oriented architecture (SOA) of the walk-through instruction reorganization is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) 40 further includes a user interface control module 462, and the user interface control module The group 462 connects the user terminal, the IT staff, the walk-through command reassembly module (ReSQL) 41, the data set 42 and the filter 47. The user interface control module 462 accepts the user terminal control input. And sending the input signal to the relevant IT personnel, the walking command reassembly module (ReSQL) 41, the data set 42 and the filter 47, or receiving the IT personnel end, the walking instruction reorganization module ( ReSQL) 41. The data set 42 and the filter 47 signal control the output to the user end.

The design of the service-oriented architecture (SOA) of the walk-through instruction reorganization is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) 40 further includes a user interface output module 461, the user interface. The output module 461 is coupled to the filter 47, the user interface control module 462, and the user terminal. The user interface output module 461 can output data to the user terminal display.

The Service Oriented Architecture (SOA) consists of different components that can be placed in different processes for different purposes to complete the on demand service. The architecture of its design is summarized into three levels:

(1) The BIS designed by the present invention is constructed on the operational IS of the enterprise (such as online trading system, ERP, MES, CRM...), which saves time for data conversion and integration into data storage and provides the most timely analysis data ( The development of data warehousing is often an extremely large investment in money, people and time).

(2) Based on the changes in the external environment and the increasing pressure of competition, enterprises must rely on real-time data to make real-time analysis and decision-making. On the other hand, IT personnel must support and satisfy decision-makers in the shortest possible time. In addition, since the source of the analysis is not from the Data warehouse, the "state" data or the data from the online transaction at that time need to integrate different materials such as homogeneous or heterogeneous databases. Source, so in order to obtain the "analysis environment and operations (drilldown, rollup, slice or pivot, etc.) with data storage multi-dimensional data", the present invention designs a service-oriented architecture (SOA) walk-through instruction reassembly module. (ReSQL), the IT staff provides real-time analysis services through simple definition settings in a very short period of time according to the needs of decision makers. Dimensional exploration, roll-up, slicing, annual comparison, multiple data source integration and comparison, annual trend, detailed dimension analysis of detailed data... This moving instruction reorganization module (ReSQL) dynamically reorganizes optimization instructions dynamically And correctly parsing the source of the data, providing immediate information and achieving immediate decision analysis.

(3) Since the data warehousing is the “historical data” after the reorganization, it can predict the future trends and results and provide the decision-makers with quick analysis data, or the data warehousing has been built within the enterprise, based on the enterprises' different elastic demand factors. The Redirection Module (ReSQL) can support data sources from data warehousing. On the other hand, when the data comes from data warehousing, the decision makers need to view more detailed real-time data (raw data or some degree of remitted data) in the process of analysis. However, the data does not exist in the data. In warehousing, based on this, Service Oriented Architecture (SOA) support can instantly and continuously connect to the trading system to present complete details while browsing data from data warehousing.

In Service Oriented Architecture (SOA), software resources are encapsulated into services, and this service is modularized to provide standard business functions. In order to support shared business processes, services can be viewed as building a building block to communicate with other services to support shared business processes; services are a small part of the functionality in Service Oriented Architecture (SOA) With some important features, including services are autonomous, services hide underlying logic, services are loosely coupled (Services are loosely Coupled) and the complete service definition (Services are well defined). Service Oriented Architecture (SOA) provides a flexible architecture, modular application to service. In addition, Service Oriented Architecture (SOA) allows companies to create, deploy, and integrate multiple services. So in this way, Service Oriented Architecture (SOA) can provide the flexibility and agility of enterprise users, and defining services can be integrated and reused as key blocks to promote continuous and ever-changing business needs.

The purpose of Service Oriented Architecture (SOA) is to build a flexible and reusable integrated interface for enterprises. The elements of the combination usually include software components, services and processes. When decision makers face new demands, the process is responsible for defining the processing steps required by the decision maker; the service includes all the program components of a particular step, and the software component is responsible for the program that performs the work. The following describes how the design architecture of the present invention is based on a Service Oriented Architecture (SOA) to implement a BI 2.0 real-time analysis environment.

The third diagram is the Service Oriented Architecture (SOA) BIS architecture, in which the Remoting Instruction Reassembly Module (ReSQL) plays a key role in the real-time analysis environment in the Service Oriented Architecture (SOA), which is responsible for constructing the user requirements (services) definition. The multi-dimensional data environment and processing flow required to provide decision maker analysis services on the fly; undoubtedly, the instruction reorganization and profiling modules need to construct a complete capture instruction, and also need to optimize the reorganized instructions. In order to shorten the time taken for data acquisition; during the decision-makers, according to their analysis mode (or decision makers demand service), such as drilldown, rollup or pivot, etc. The service-oriented architecture (SOA) is designed to dynamically load data into a data set (DS, dataset) through the design of the Remoting Module (ReSQL) and the communication link to achieve immediate response to user needs and changes; Furthermore, the walk-through instruction reassembly module (ReSQL) can quickly solve the problems mentioned above when the analysis data is a combination of different data sources (homogeneous or heterogeneous databases).

The data set (DS, dataset) data loading in the Service Oriented Architecture (SOA) is based on the server's cache key-value design concept. When the command is reorganized, the key obtained is not in the cache. The system database retrieves data.

Referring to the fourth figure, the fourth figure illustrates the design architecture of the operation of the Retirement Command Reassembly Module (ReSQL). The invention designs a first service definition file (eistable.def) corresponding to the transaction system 30 or the data storage 31 and the second service definition file (valueSQL.def) corresponding to the transaction system 30 or data under the walk-through instruction reorganization module (ReSQL). The warehousing 31 is an entry point (or service interface) of the service process, and is mainly responsible for the data environment and process steps required by the IT staff to define the requirement (service) through the interface and the behavior attribute according to the needs of the user end, as a description, Accessing, transmitting, and understanding the elements of each service; the present invention proposes a service innovation design framework that includes different definitions (services) that can be used to modify the decision maker's needs through the inheritance module and become a new through the re-integration of services. Service. The walk-through instruction reassembly module (ReSQL) is responsible for setting the definition of the service and the user parameters to "walking instructions". The “restructuring” design method completes the immediate demand (service) analysis; and the service-oriented concept, when the user needs change, the instruction reorganization and the parsing module provide the flexibility of the strain. From the fourth figure, the walk-through instruction reorganization module can be known. (ReSQL) is the core of the entire Service Oriented Architecture (SOA), providing a hands-on analysis model to achieve an immediate analysis environment.

The following is an introduction to the actual hospital internal operational IS development information system (EIS) as an example to illustrate the architecture and implementation results of the instruction reorganization and profiling module design under the service oriented architecture (SOA):

(1) Behavior attribute setting of the first service definition file (eistable.def) - Multi-dimensional data body (Data cube)

The following example shows how an IT staff can define user analysis requirements (services) in the first service definition file. Table 1 is the attribute of the service in the first service definition file, the attribute setting value and the meaning of the representative, and the “hospital date”, “Ministry”, “Department”, etc. are corresponding to the dimension attribute name and the measurement attribute expression respectively. . When the service definition is completed, the instruction reorganization and parsing module will obtain the definition content by the first service definition file (National Fan Fan 1) function, and combine the user parameter setting, reorganize the data operation acquisition instruction to load the data into the data set. (DS), as shown in the fifth figure; then provide the multi-dimensional data analysis environment according to the user's analysis needs, and perform the following operations such as drilldown or rollup, the command reorganization and parsing module can Identify the current dimension of the dynamic and provide real-time analysis data, making the hierarchical landscape easy, please refer to the sixth to eighth diagrams for the results; even in different In the dimension, you can view the details of the layer or perform pivoting analysis. For the results, please refer to the figure IX. It can be seen from Table 1 that the IT staff only needs to understand the internal database structure and simple SQL instructions to simply write the first service definition file, and can quickly construct multi-dimensional data with data storage combined with the service oriented architecture (SOA) of the present invention. The analysis environment provides decision makers such as drilldown, rollup and other analytical operations. In addition, the instruction recombination and parsing module 411 generates a command (commands of ReSQL, COR) whose structure is described in the figure (10). The COR in the figure is packaged by the resql() function, and the user moves according to the analysis. Demand, COR has a multi-stage nested resql (nested resql) combination, the main purpose is to construct a multi-dimensional modeling analysis environment.

The data loading in the data set (DS) mentioned above is based on the cache key-value design concept of the server. When the key obtained after the instruction reorganization is not in the cache memory, the data is retrieved from the operating system database. In order to speed up the reading time, the first service definition file will be loaded into the cache memory (when the first service definition file is modified, the relevant key-values in the cache memory will be automatically removed).

(2) Service definition inheritance module design

The invention incorporates the object-oriented inheritance feature, allowing the sub-definition to modify the decision maker's needs by inheriting the parent definition (the sub-definition field setting can be override or extend the parent-defined setting), and the inheritance method is Two (1) inheritance does not generate a new definition in the first service definition file. (2) A new definition is generated in the first service definition file after inheritance. The following describes the two ways of inheritance: after inheritance, no new definition is generated in the first service definition file: if the data requirements of the decision makers are adjusted, the IT staff obtains the definition content of the example and redefines it through the eistable function. The drilldown setting is modified to the dimensions required by the decision maker, as shown in Table 2. The tenth to twelfth figures respectively illustrate the changes in the dimension of the downsizing after inheritance, but the source of the data maintains the setting of the first example. It is also worth mentioning that if the dimension of the downside does not include the dimension of the original analysis, such as the decision maker needs to look at the ministry. The collection data of the section can be entered into the details. The instruction reorganization and analysis module will recombine the acquisition instructions to the operating system database for detailed information, and provide decision makers with pivot analysis (dimension analysis). Please refer to the tenth Three pictures.

Inherit the definition of the original example one, and generate a new definition in the first service definition file (allowing it to be inherited again): If the dimension attribute is to be modified into a department and a physician, please refer to Table 3 and Figure 14 to Figure 15. In the description of the figure, in Table 3, “ref=Guofan Fanyi” will inherit all the definitions of Guoke Fanyi and “xcols=Medical” will specify the first dimension attribute as the division, and “drilldown=Medical, Physician" overrides the definition of the parent definition to redefine the dimension genus Sex. In addition, the instruction reorganization and profiling module supports the user to provide analysis services between different dimensions (please refer to the annual analysis data of the sixteenth figure).

(3) Second service definition file (valueSQL.def) - Multiple data source integration: There are often different trading system operations in the business operation environment. These systems use different database management systems (DBMS) due to different construction time. Even the data naming, data representation, data encoding, data content, and data scaling on different systems are inconsistent. A BI solution must be seamlessly integrated with the enterprise's overall information environment. It is a difficult challenge to quickly integrate multiple data sources into a single, real-time analysis environment without the need to build data warehousing or physical data repository to provide decision makers with immediate analysis. The task; on the other hand, IT staff often spend a lot of time to complete the integration work. The service-oriented architecture (SOA) introduced by the present invention becomes a new service innovation design framework through the re-integration of services, which makes heterogeneous system integration easy, not only quickly solves the problem of heterogeneous data integration that enterprises often face, but also satisfies The dynamic process requirements of the enterprise support the innovation of the business model. Table 4 shows examples of hospitalization declarations The database (EIS1) and the personnel database (HR), EIS1 stores the transaction information of the hospitalized patients in the hospital every day, and each transaction records which doctor in the hospital is seen by the doctor and the required medication (MedFee) Part of the patient's burden (PortFee) and application fee (AppFee). The HR database stores information about each doctor's personnel data and grades. In order to analyze data related to medical expenses, BIS must be structured in a multi-dimensional model data storage environment, as shown in Table 5. The Data Mart C uses ETL (Extraction, Transformation, and Load) to obtain information from the EIS1 and HR databases, respectively, in order to reach a decision across all relevant medical analysis dimensions and based on existing and available operational data. Process. The doctor's dimension integrates the doctor's data sheet from the EIS1 and HR databases. Once multi-dimensional data warehousing is completed, OLTP tools are typically used to allow users to analyze data according to different dimensions. On the contrary, if the data storage is not established, it is assumed that the information of the doctors of the grade A (Chief Physician) in the past three years will be collected into a single analysis environment to provide the decision makers with immediate analysis data. Highly complex and challenging tasks.

The present invention utilizes the following examples to illustrate how to have multiple data sources integrated quickly by analyzing the environment and operations of data warehousing multi-dimensional data without building data warehousing. Assume that the source of the data in the above example is the EIS1 database (hospital declaration database), where “medical expenses” refers to the total cost of medical treatment required to be reported to the health insurance bureau (including medical expenses). , medical expenses, inspection fees and instrument usage fees, etc.), based on the supervisor's analytical perspective, “medical expenses” should include all the resources involved in the department (including nurses, administrative staff or some undiagnosed doctors in the department). Resources), and the supervisor wants to know the total number of physicians in the department in order to analyze whether there is a gap between the income and the cost of payment, and further to make certain decisions; however, to obtain the total number of physicians can not be obtained from the EIS1 single database, must also Another database can get complete information. The following will explain how to become a new service through the re-integration of services to achieve the integration of multiple data: Table 6 is the service mechanism designed by the second service definition file provided by the present invention to deal with multiple data integration, wherein "specialist" refers to The source name of the service is set by the source of the information, that is, the number of all the doctors in the department mentioned above (assuming that there are doctors who see and do not see the doctor in the month). The source of the information is from the HR database; Specialist.setting" Refers to the data source attribute setting. If the source of the data in this example is the HR database and the details to be traced to the physician, it is specified in the <RawSelect></RawSelect> tag (if ID_DOCTOR_NAME is the name of the physician); After the IT staff completes the settings, they can integrate the services defined in the first service definition file into a single data set (DS) to complete the integration of different data sources, as shown in Table 7. The data definition of the first service definition file in this example 4 is inherited from the definition of the third example, and only the "specialist" is added ("+") to the vcols to be integrated into the data set (DS), and the subsequent can be Other measurement attributes are calculated (such as the average number of visits); then, in different dimensions, the user reorganizes and parses the module to reorganize the capture instructions of two different sources based on the current dimension to achieve numerical integration. Please refer to the integrated architecture description in Figure 17. In addition, the above-mentioned information on the classification of the doctors is from the HR database in Table 4. It is assumed that the data of the doctors of the grade A in the past three years will be collected into the analysis environment of a single OLAP, please refer to the table. 8. The definition of the integration of the classification of Table IX, please refer to Figure 17 bis for the integrated architecture diagram; even the comparative data of different years can be quickly integrated into the data set (DS), please refer to the nineteenth to the The results of the twenty-first figure execution.

In addition, how to effectively solve the problems mentioned in the aforementioned data integration such as attribute naming, data representation and other inconsistencies. The invention describes the solution method by taking the attribute naming inconsistency as an example. If the attribute name or data representation of the key (dimension) between multiple sources in Figure 18 The method is inconsistent; for example, assume that the attribute name of the data source key defined in the first service definition file is xyz, xyz1, ..., and the attribute name of the data source key defined by the second service definition file is abc, abc1, ... The way of designing the invention is to define the mapping of the attributes in the second service definition file, and the agreement can be reached. Please refer to the settings in Table 10; if there is a conflict in the data representation (data type), you can use the functions provided by the database management system (such as convert, substring, ...) or custom functions (such as: t0_char, :substr ,...), as shown in Table 10, xyz=:to_char(abc), converted to a consistent data type.

Another example is to illustrate the combination of the second service definition file and the first service definition file service to solve the problem of different types of multiple data integration. Suppose the decision maker needs an analysis data, which needs to be aggregated from two different databases according to different down-search dimensions (may add up, average other operations), and some field values in different data tables (fields) The names are not necessarily consistent. As long as Table 6 defines two data sources (assuming DS1 and DS2) in the second service definition file, then DS1 and DS2 are added to vcols in the first service definition file (as shown in Table 7). The "specialist"), then use the compute (such as the "average number of visits" in Table 7) to achieve integration.

In view of the above-mentioned second service definition file design purposes, in addition to the rapid integration of data sources from different databases, in some cases, more complex operations are required, as long as they are defined in the second service definition file and then combined with the first service definition file. To achieve the purpose of integration, please refer to Table 11 for a more in-depth discussion of this innovative design architecture, as defined in Table 6 "Specialist "In fact, it represents the design concept of an object, and this object can be used in any service definition process in the first service definition file (as long as the service process and the object are connectable), through the communication The link achieves integration and object reusability, and it also echoes the previously described services that can be combined into a new service.

The combination of the second service definition file and the first service definition file service definition described above quickly accomplishes different service requirements of the user, and solves more complicated problems and quickly achieves multiple data source integration. It is also worth mentioning that the architecture can easily extend the definition of different service processes, complete different service functions, and also describe the walk-through instruction reassembly module (ReSQL) based on the Remoting Instruction Reassembly Module (ReSQL). Rigorous architectural design, complete integration and high cohesion.

(3) Data warehousing and online trading system data synchronization

In the foregoing, the necessity of data storage has some degree of support or the establishment of data warehousing within the enterprise. Based on the different elastic demand factors, the service oriented architecture (SOA) designed by the present invention is also applicable to the data warehousing foundation. In addition, the data warehouse (or Cube) and transaction system data can be integrated at the same time. The integration method is shown in Table 12. Specify in the data source start setting which database system the source is from, such as CUBE1=summary one (assuming CUBE1 data source is data storage environment); EIS1=immediate One (assuming that the source of EIS1 is the hospital filing transaction system), and the acquisition of data in the trading system can be specified from EIS1, as described in Table 12, Cube1.RawDataDB=EIS1 and EIS1.IsCubeDB=false. The modified example 1 of the present invention explains how to integrate the data storage (Cube) and the transaction system data in the first service definition file; please refer to Table 13. "table.cube=eiscubeview(DTLFBC)" means that the source of the dimension attribute is from The data sheet "DTLFBC" in CUBE1 is obtained, while the source of real-time transaction data is from EIS1. The definitions of the data sources listed in the second to fourth examples are the definitions of the inheritance example 1. Once the definition of the first example is modified, all the examples of inheritance are modified. Since the current data after CUBE1 is consistent with the data of the above example is the result of EIS1, there is no need to provide an integrated result screen.

(4) Integrate the definition files of other service functions

Based on the above description, the Remoting Instruction Reassembly Module (ReSQL) designed by the present invention truly implements the core spirit of Service Oriented Architecture (SOA), that is, emphasizes abstraction, composability, and reusability. (reusability) to implement BI 2.0 real-time analysis services.

40‧‧‧Service Oriented Architecture (SOA)

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 (DS)

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‧‧‧Homogeneous or heterogeneous database

49‧‧‧Cache memory (cache)

Claims (9)

A service-oriented architecture (SOA) walk-through instruction reorganization is implemented in an instant business intelligence system, including: a service-oriented architecture (SOA), a client, and an information technology (IT) staff. 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 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) are used by the information technology (IT) personnel Simple definition, data taken from the operating system or data taken from multiple operating systems or data taken from multiple operating systems and data warehousing, which are obtained immediately from the reorganized instructions of the Remoting Reassembly Module (ReSQL) Source, and then obtain the required information from the source. The Service Oriented Architecture (SOA) further includes a grammar conversion module through which the grammar conversion module can communicate the reorganization and analysis of the module and the various operating systems or materials. The storage of a homogenous or heterogeneous database enables all data to be automatically accessible. The inheritance module can modify the needs of the client through inheritance in each service and become a new service through the re-integration of the services. The integration of multiple data sources, the instruction reorganization and analysis module is responsible for the definition of the service and the parameter input of the user input to complete the real-time demand service analysis in the operation mode of the walk-through instruction reorganization, and the service-oriented, when the user End demand changes, the order is reorganized and cut The analysis module provides the flexibility of strain to obtain the analysis environment and calculation of multi-dimensional data with data storage. After the user transforms the requirements, even different dimensions, different operating systems or multiple operating systems and data storage or homogeneity or The heterogeneous database can also immediately obtain the immediacy of the transformed data without having to write separate application-specific interfaces (APIs). The design of the service-oriented architecture (SOA) walk-through instruction reorganization described in the first application of the patent scope is implemented in an instant business intelligence system, wherein the instruction reorganization and profiling module constructs a complete capture instruction, and the instruction reorganization And the profiling module has more reorganized instruction optimization to shorten the data acquisition time. The design of the walk-through instruction reorganization of the service-oriented architecture (SOA) as described in the first application of the patent scope is implemented in an instant business intelligence system, wherein the user access data method, including Drill-down, Roll-up, Pivot, or Slice. The design of the service-oriented architecture (SOA) mobile command reorganization as described in claim 1 is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) further includes a multiple data source integration module. The multiple data source integration module connects the walk-through instruction reassembly module (ReSQL), the grammar conversion module, and the homogenous or heterogeneous database, and uses the multiple data source integration module to perform multiple data calculation and integration. The design of the walk-through instruction reorganization of Service Oriented Architecture (SOA) as described in item 4 of the patent application scope is realized in the real-time business intelligence system. The service oriented architecture (SOA) further includes a data set (DS, dataset) and a cache memory (cache), the data set is linked to the walk-through instruction reassembly module (ReSQL), and the multiple data source integration module The group, the homogeneous or heterogeneous database and the user end, the instruction is reorganized and then entered into the data set, and the data set is not found by the cache memory (cache) until the data corresponding to the instruction is retrieved. The design of the service-oriented architecture (SOA) walk-through instruction reorganization described in item 5 of the patent application is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) further includes a one-dimensional integration module, and the dimension integration The module connects the data set (DS, dataset) and the user end, and the dimension integration module integrates the data of the measurement value and the analysis dimension dispersed in different databases, and then displays the integrated data on the user end. The design of the walk-through instruction reorganization of the service-oriented architecture (SOA) as described in claim 6 is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) further includes a filter that links the The dimension integration module and the user end, the filter filters out the redundant portion of the integrated data of the dimension integration module by using the condition set by the user terminal, and displays the filtered data on the user end. The design of the walk-through instruction reorganization of the service-oriented architecture (SOA) as described in claim 7 is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) further includes a user interface control module. The user interface control module connects the user end, the IT staff, The walk-through instruction reassembly module (ReSQL), the data set and the filter, the user interface control module accepts the user-side control input, and sends the input signal to the relevant IT personnel, the walking instruction Reorganizing the module (ReSQL), the data set and the filter, or receiving the IT personnel, the walking command reassembly module (ReSQL), the data set, and the filter signal to control the output of the user end. The design of the service-oriented architecture (SOA) mobile command reorganization as described in claim 8 is implemented in an instant business intelligence system, wherein the service-oriented architecture (SOA) further includes a user interface output module. The user interface output module connects the filter, the user interface control module and the user end, and the user interface output module can output data to the user terminal display.