CN107748760A - A kind of Construction of Data Warehouse method based on ESB - Google Patents
A kind of Construction of Data Warehouse method based on ESB Download PDFInfo
- Publication number
- CN107748760A CN107748760A CN201710871545.3A CN201710871545A CN107748760A CN 107748760 A CN107748760 A CN 107748760A CN 201710871545 A CN201710871545 A CN 201710871545A CN 107748760 A CN107748760 A CN 107748760A
- Authority
- CN
- China
- Prior art keywords
- data
- esb
- theme
- data warehouse
- warehouse
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
Abstract
The invention discloses a kind of Construction of Data Warehouse method based on ESB, including step：(1) ESB respectively obtains original medical data from each application system of medical institutions, and the original medical data that (2) obtain step (1) provide the conversion of data by ESB, adaptation, is transferred to data warehouse.(3) what the business datum for transmitting step (2) by ESB did not had to postpone collect and be stored in data warehouse.Present invention can apply to numerous areas such as Hospitals of Enterprises mechanisms, it is with a wide range of applications.
Description
Technical field
The present invention is a kind of Construction of Data Warehouse method based on ESB, in particular in multi-heterogeneous system being present, and
Family hospital of enterprise for needing real time data statistical analysis, data effectively can be imported into data bins when business occurs
Storehouse, belong to areas of information technology.
Background technology
As scope of the enterprise increases, increasingly increase for the shared of information and using demand, cause to generate more and more
The heterogeneous system being good in subdivision field.But also increase difficulty for integration of the enterprise for information simultaneously.
In the decision-making level of enterprise, increasingly analysis and statistics of the concern by data, carry out Added Management personnel to enterprise
Operation situation carry out decision-making, the analysis of everything is required for the foundation based on data warehouse.
Data warehouse is different from the database of application system, and its construction is divided according to the theme of data, and source can
Can be varied, often the data source of a theme is in multiple heterogeneous applications systems.
The construction of data warehouse at present is carried out by ETL, and the data that ETL is extracted are larger to database pressure, and
There is certain hysteresis quality, it is more difficult to when business occurs with regard to business datum is collected and preserved at once.
The content of the invention
The purpose of the present invention is to be directed to the demand of instant Data Collection, there is provided a kind of data warehouse and the number of ESB bindings
According to construction of warehouse scheme.Concrete technical scheme
A kind of Construction of Data Warehouse method based on ESB, comprises the following steps：
(1) ESB obtains original medical data from each application system of medical institutions,
(2) the original medical data that step (1) obtains are passed through into configured data format converter and data warehouse gateway
ESB carry out the conversion of data, adaptation etc. is transferred to Data Data repository interface.
(21) theme defined in data warehouse and its data structure, its theme is exactly by company information on higher level
Data in system are integrated, sort out and an abstract concept of analysis and utilization, each theme correspond to a macroscopic view substantially
Analysis field.
(22) theme and its data structure according to defined in data warehouse in (21) in ESB, to configure the service of correlation
(3) what the business datum for transmitting step (2) by ESB did not had to postpone carries out collecting and being stored in data bins
In storehouse
(4) subscription service is created in ESB, whenever data warehouse data change, is then taken change data-pushing to subscription
In business.
When our data warehouse does not postpone, and System is with preserving：
(1) data that current ETL is extracted are larger to database pressure, and have certain hysteresis quality, in order in business
With regard to business datum is collected and is stored in data warehouse at once during generation.
(2) theme and its data structure first defined in data warehouse, its theme is exactly by enterprise on higher level
Data in information system are integrated, sort out and an abstract concept of analysis and utilization, each theme correspond to one substantially
The analysis field of macroscopic view.
(3) medical institutions are heterogeneous system entirely, and ESB data transfer, message are needed when heterogeneous system is integrated
Protocol translation, three big Core Features are route, theme and its data structure according to defined in data warehouse in (2), are added in ESB
Data format converter and data warehouse gateway.
(4) theme defined in data warehouse accesses the authority of data for service, it is allowed to which service in ESB is toward data
Inserted or updated data in warehouse.
(5) subscription service is created in ESB, whenever data warehouse data change, is then taken change data-pushing to subscription
In business.
Beneficial effect
The invention discloses a kind of Construction of Data Warehouse method based on ESB, when business occurs just at once by business number
According to being collected and preserved.Present invention can apply to numerous areas such as enterprise's medical treatment, it is with a wide range of applications.
Brief description of the drawings
Fig. 1 is the overall architecture schematic diagram of the present invention.
Fig. 2 is the ESB configuration diagrams of the present invention.
The data warehouse framework schematic diagram of Fig. 3 positions present invention.
Embodiment
The present invention is further described below in conjunction with the accompanying drawings.
Fig. 1 is the overall architecture schematic diagram of the present invention.Comprise the following steps that：
(1) ESB obtains original medical data from each application system of medical institutions,
(2) the original medical data that step (1) obtains are passed through into configured data format converter and data warehouse gateway
ESB carry out the conversion of data, adaptation etc. is transferred to Data Data repository interface.
(21) theme defined in data warehouse and its data structure, its theme is exactly by company information on higher level
Data in system are integrated, sort out and an abstract concept of analysis and utilization, each theme correspond to a macroscopic view substantially
Analysis field.
(22) theme and its data structure according to defined in data warehouse in (21) in ESB, to configure the service of correlation
(3) what the business datum for transmitting step (2) by ESB did not had to postpone carries out collecting and being stored in data bins
In storehouse
(4) subscription service is created in ESB, whenever data warehouse data change, is then taken change data-pushing to subscription
In business.
Fig. 2 is ESB configuration diagram.Comprise the following steps that：
(1) ESB is attached by the connector in establishing device with external application.
(2) message receiver in establishing device defines receiving endpoint according to connector and receives external data.
(3) data conversion that the message transformer in establishing device is used between message and component institute identification data type.
(4) the preposition router of router is passed to by message transformer change data.
(5) preposition router transfers data to application component processing again.
(6) data that application component has been handled are sent to establishing device by the rearmounted route of router.
(7) data that the message sender in establishing device receives define sending endpoint according to connector and are sent to data warehouse
Interface.
The data warehouse framework schematic diagram of Fig. 3 positions present invention.
(1) it is transferred to after data warehouse interface from ESB and is stored with detail data.Comprise the following steps that：
(2) detail data in data warehouse builds data model according to the changes in demand of data warehouse.
(3) data assembling in data model stores into according to theme storage form.
Described above is only the preferred embodiment of the present invention, it should be pointed out that：For the ordinary skill people of the art
For member, under the premise without departing from the principles of the invention, some improvements and modifications can also be made, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (3)
- A kind of 1. Construction of Data Warehouse method based on ESB, it is characterised in that step is as follows：(1) ESB obtains original medical data from each application system of medical institutions；(2) the original medical data that step (1) obtains are passed through into configured data format converter and the ESB of data warehouse gateway To carry out the conversion of data, adapted transmission to Data Data repository interface；(3) what the business datum for transmitting step (2) by ESB did not had to postpone carries out collecting and being stored in data warehouse In；(4) subscription service is created in ESB, whenever data warehouse data change, then will change data-pushing into subscription service.
- 2. the method as described in claim 1, it is characterised in that the step (2) is specific as follows：(21) theme defined in data warehouse and its data structure, its theme is exactly by enterprise information system on higher level In data integrated, sorted out and an abstract concept of analysis and utilization, each theme corresponds to a macroscopical point substantially Analysis field；(22) theme and its data structure according to defined in data warehouse in (21) in ESB, to configure the service of correlation.
- 3. the method as described in claim 1, it is characterised in that in the step (3), when data warehouse does not postpone, in real time When collecting and preserving, step is as follows：(31) data that current ETL is extracted are larger to database pressure, and have certain hysteresis quality, in order to occur in business When with regard to business datum is collected and is stored in data warehouse at once；(32) theme and its data structure first defined in data warehouse, its theme is exactly by company information on higher level Data in system are integrated, sort out and an abstract concept of analysis and utilization, each theme correspond to a macroscopic view substantially Analysis field；(33) medical institutions are heterogeneous system entirely, and ESB data transfer, messaging protocol are needed when heterogeneous system is integrated Conversion, three big Core Features are route, theme and its data structure according to defined in data warehouse in (2), add data in ESB Format converter and data warehouse gateway；(34) theme defined in data warehouse accesses the authority of data for service, it is allowed to which service in ESB is toward data bins Inserted or updated data in storehouse；(35) subscription service is created in ESB, whenever data warehouse data change, then will change data-pushing to subscription service In.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710871545.3A CN107748760A (en) | 2017-09-25 | 2017-09-25 | A kind of Construction of Data Warehouse method based on ESB |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710871545.3A CN107748760A (en) | 2017-09-25 | 2017-09-25 | A kind of Construction of Data Warehouse method based on ESB |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107748760A true CN107748760A (en) | 2018-03-02 |
Family
ID=61254774
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710871545.3A Withdrawn CN107748760A (en) | 2017-09-25 | 2017-09-25 | A kind of Construction of Data Warehouse method based on ESB |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107748760A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817945A (en) * | 2021-03-03 | 2021-05-18 | 江苏汇鑫融智软件科技有限公司 | Medical heterogeneous system data warehouse construction method based on ESB |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050033588A1 (en) * | 2003-08-04 | 2005-02-10 | Mario Ruiz | Information system comprised of synchronized software application moduless with individual databases for implementing and changing business requirements to be automated |
| CN104361424A (en) * | 2014-10-11 | 2015-02-18 | 中国电子科技集团公司第十研究所 | Master data system integration method based on enterprise service bus (ESB) |
| CN105701181A (en) * | 2016-01-06 | 2016-06-22 | 中电科华云信息技术有限公司 | Dynamic heterogeneous metadata acquisition method and system |
| CN106339509A (en) * | 2016-10-26 | 2017-01-18 | 国网山东省电力公司临沂供电公司 | Power grid operation data sharing system based on large data technology |
| CN106709269A (en) * | 2017-03-13 | 2017-05-24 | 山东众阳软件有限公司 | Creation method and system for medical big data warehouse |
-
2017
- 2017-09-25 CN CN201710871545.3A patent/CN107748760A/en not_active Withdrawn
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050033588A1 (en) * | 2003-08-04 | 2005-02-10 | Mario Ruiz | Information system comprised of synchronized software application moduless with individual databases for implementing and changing business requirements to be automated |
| CN104361424A (en) * | 2014-10-11 | 2015-02-18 | 中国电子科技集团公司第十研究所 | Master data system integration method based on enterprise service bus (ESB) |
| CN105701181A (en) * | 2016-01-06 | 2016-06-22 | 中电科华云信息技术有限公司 | Dynamic heterogeneous metadata acquisition method and system |
| CN106339509A (en) * | 2016-10-26 | 2017-01-18 | 国网山东省电力公司临沂供电公司 | Power grid operation data sharing system based on large data technology |
| CN106709269A (en) * | 2017-03-13 | 2017-05-24 | 山东众阳软件有限公司 | Creation method and system for medical big data warehouse |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112817945A (en) * | 2021-03-03 | 2021-05-18 | 江苏汇鑫融智软件科技有限公司 | Medical heterogeneous system data warehouse construction method based on ESB |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107644644A (en) | The method that Voice command smart home is realized based on wearable device | |
| CN102938770A (en) | Method for realizing uniform interface for multi-protocol messages and related device and system | |
| CN103391295A (en) | Data exchange mechanism for performing real-time security communication with public security in-network system | |
| CN105046567A (en) | Community service system based on socialization | |
| CN108334315A (en) | A kind of master data distribution administrative mechanism based on ESB | |
| CN108924228B (en) | Industrial internet optimization system based on edge calculation | |
| CN114785842B (en) | Robot scheduling method, device, equipment and medium based on voice exchange system | |
| CN108566369A (en) | Data collecting system based on industrial big data and method | |
| CN103701945A (en) | Address translation method and address translation device | |
| CN102360473A (en) | Data sharing method for land-saving power dispatching automation systems | |
| CN107748760A (en) | A kind of Construction of Data Warehouse method based on ESB | |
| CN106102027B (en) | Short message batch based on MapReduce submits method | |
| CN102916872A (en) | Communication proxy gateway | |
| CN105515947B (en) | A kind of method, server and the system of the heterogeneous terminals message intercommunication based on XMPP | |
| CN101471846A (en) | Network event analysis and management system | |
| CN207817705U (en) | New-energy grid-connected power station relates to net performance on-line monitoring system | |
| CN103369294A (en) | Substation video monitoring system based on SIP protocol and video transmission method | |
| CN107678293A (en) | A kind of smart home health management information data-pushing management method | |
| CN114844738A (en) | Data management method based on service gateway | |
| CN106888113A (en) | A kind of method and device for intelligent substation business configuration | |
| CN103780412B (en) | Realization method and apparatus for virtual southbound interface and internet of thing management platform | |
| CN106789208B (en) | A kind of network forensics facility network tube model based on the reversed through-transmission technique of UDT | |
| CN101364931A (en) | Platform and method for data transmission between different information systems | |
| CN104202174A (en) | Implementation method of precisely forwarding IP (Internet Protocol) specific source multicast data | |
| WO2023120786A1 (en) | Gas facility safety management operation method using standard data model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 210000 13th floor, phase I building, Yangtze River science and Technology Park, No. 40, Nanchang Road, Gulou District, Nanjing City, Jiangsu Province Applicant after: Jiangsu Huixin Rongzhi Software Technology Co. Ltd. Address before: 210000 13 / F, South Gate, Yangtze River science and Technology Park, No. 40, Nanchang Road, Gulou District, Nanjing City, Jiangsu Province Applicant before: Jiangsu Huixin Rongzhi Software Technology Co. Ltd. |
|
| CB02 | Change of applicant information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Chu Shengxiang Inventor after: Ou Ruiyin Inventor before: Chu Shengxiang Inventor before: Deng Wei Inventor before: Ou Ruiyin Inventor before: Li Chao |
|
| CB03 | Change of inventor or designer information | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20180302 |
|
| WW01 | Invention patent application withdrawn after publication |