CN101840563A - Financial data service system - Google Patents
Financial data service system Download PDFInfo
- Publication number
- CN101840563A CN101840563A CN200910047944A CN200910047944A CN101840563A CN 101840563 A CN101840563 A CN 101840563A CN 200910047944 A CN200910047944 A CN 200910047944A CN 200910047944 A CN200910047944 A CN 200910047944A CN 101840563 A CN101840563 A CN 101840563A
- Authority
- CN
- China
- Prior art keywords
- data
- unit
- subsystem
- order
- esb
- 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.)
- Pending
Links
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a financial data service system, comprising an ETL unit, an OSD unit, a data warehouse DW, an on-line analysis processing unit OLAP and an enterprise service bus ESB. A data service subsystem set comprises a plurality of service subsystems which are used for processing relevant data of all subsystems; the enterprise service bus ESB is connected with the data service subsystem set, the ETL unit, the OSD unit and the on-line analysis processing unit for maintaining the same data in different subsystems in a plurality of subsystems at the same time. The financial data service system in the invention can effectively solve the problem of information island, ensure independence of all subsystems, reduce the maintaining cost of IT system and promote data safety, and the service ability of the IT system and utilization ability of all kinds of information reach new height.
Description
Technical field
The present invention relates to a kind of data service system, relate in particular to a kind of financial data service system.
Background technology
Along with the develop rapidly of China's finance industry, IT system has obtained widespread use in financial industry.Nowadays, IT system miscellaneous is served all kinds of financial companies, and indispensable role often plays the part of in these systems aspect some, and for example: transaction system guarantees daily financial transaction process fast and safely; Information flow between all departments of synergetic office work system maintenance enterprise; Call center and website allow financial company have Communication with Customer means efficiently.We can say that financial industry is that IT system is used the most deep industry, the system that a lot of financial companies are moving the dozens of difference in functionality simultaneously, provided by different software manufacturer.These systems constantly produce every day, in store and Various types of data information that financial company's day-to-day operations is closely related.
With the public offering fund company in the financial industry is example, roughly interior data information can be divided into following a few class:
Sales service information comprises customer information, marketing information, Customer Service Information;
Investment portfolio information comprises product information, market information, investing tip, risk control information;
Inner management information comprises 0A information, human resource information, financial information.
Above-mentioned information is very complicated, and because of historical reasons information leaves in respectively in the different independent utility systems, big and small information island (as shown in Figure 1) occurs, has had a strong impact on information integrity and consistance; And be subjected to all-environment influence, can't realize enough level of securitys and disaster tolerance degree.If revise oneself information as bank client in first information isolated island (as investment research class isolated island), the information of this modification can not be revised in other information islands the very first time effectively simultaneously, thereby has increased the cost of safeguarding.
Summary of the invention
Technical matters to be solved by this invention is: a kind of financial data service system is provided, can effectively reduces the maintenance cost of IT system, promote safety of data.
For solving the problems of the technologies described above, the present invention adopts following technical scheme:
A kind of financial data service system, this system connects a data, services subsystem collection, and this subsystem collection comprises some service subsystems, in order to handle the related data of each subsystem; Described system comprises ETL unit, OSD unit, data warehouse DW, on-line analytical processing unit OLAP, ESB ESB.The ETL unit connects each subsystem that described data, services subsystem is concentrated, in order to data pick-up, the conversion that will be distributed in each subsystem, clean, be loaded in the unified OSD unit; The OSD unit connects described ETL unit, in order to the data in this OSD unit are further processed, deposits among the data warehouse DW; Data warehouse DW connects described OSD unit, in order to store the data after described OSD unit processes; On-line analytical processing unit OLAP connects described data warehouse DW, with thinking that decision support system (DSS) DSS provides all kinds of report data services; ESB ESB connects data service subsystem collection, ETL unit, OSD unit, on-line analytical processing unit OLAP, uses so that be in same data maintenance simultaneously in a plurality of subsystems of different sub-systems.
As a preferred embodiment of the present invention, described data, services subsystem collection comprises call center's subsystem, transaction subsystem.
As a preferred embodiment of the present invention, described ETL unit will be distributed in each subsystem data pick-up, conversion, clean, be loaded in the unified OSD unit, and provide correct, complete, consistent information view on this basis.
As a preferred embodiment of the present invention, described system also comprises the user instrument module, in order to human-computer interaction interface to be provided, comprises report tool unit, project management unit, system monitoring unit; The report tool unit is in order to browse, show, store, to manage OLAP result; The project management unit is in order to select corresponding system configuration according to user's enterprise nature; The system configuration collection of metadata abstract be scheme, plurality of proposals is set, the system configuration collection of metadata that this scheme is corresponding certain in the system; ESB, ETL working condition can directly be checked in order to multiple view to be provided in the system monitoring unit, and the ruuning situation of other tasks of system.
As a preferred embodiment of the present invention, described system also comprises the ESB administration module, in order to realize information interaction between each data, services subsystem.
As a preferred embodiment of the present invention, described system also comprises the meta data definition module in order to the meta data definition function of high encapsulation degree to be provided, and it comprises task management unit, data, services definition unit; Other tasks in the described system are managed simultaneously in order to call the ETL task in the task management unit; The data, services definition unit is distributed on content on the ESB in order to standard.
As a preferred embodiment of the present invention, described system also comprises the total data storehouse, connects each data, services subsystem, OSD unit, data warehouse DW, ESB ESB.
A kind of financial data service system, this system comprises data, services subsystem collection, database, ESB ESB; Data, services subsystem collection comprises some service subsystems, in order to handle the related data of each subsystem; Database is in order to the data message of storage system; ESB ESB connects data service subsystem collection, database, uses so that be in same data maintenance simultaneously in a plurality of subsystems of different sub-systems in the database.
Beneficial effect of the present invention is: the financial data service system that the present invention proposes will effectively solve problem of detached island of information, guarantee the independence of each subsystem simultaneously, reduce the maintenance cost of IT system, promote safety of data, the ability of utilizing of the use ability of IT system and various information will reach a new height.
Description of drawings
Fig. 1 is the IT system Organization Chart of existing financial industry.
Fig. 2 is the composition synoptic diagram of financial data service system of the present invention.
Fig. 3 is the data flow synoptic diagram of data service system of the present invention.
Fig. 4 is the software frame figure of data service system of the present invention.
Embodiment
Describe the preferred embodiments of the present invention in detail below in conjunction with accompanying drawing.
Embodiment one
See also Fig. 2, Fig. 3, the present invention has disclosed a kind of financial data service system, and it mainly comprises data integration platform and ESB ESB.Two parts can independently be built, and also can be used in combination.The present invention abandons the thought of other technologies scheme sealing profit fully, and each submodule of system all can be selected separately; The product of increasing income both can be selected by fund company, also can select commercially produced product.Native system has all been done effective packing and isolation to each integrated products, and unified management and monitoring means are provided.
Described data integration platform comprises ETL unit, OSD unit, data warehouse DW, on-line analytical processing unit OLAP.The ETL unit connects a data, services subsystem collection, ETL unit, OSD unit, data warehouse DW, on-line analytical processing unit OLAP connect successively, and ESB ESB is connected with described data, services subsystem collection, ETL unit, OSD unit, on-line analytical processing unit OLAP.
Below above-mentioned each unit is described in detail.
Data, services subsystem collection comprises some service subsystems, comprises call center subsystem CC, transaction subsystem TA and other subsystems, and each subsystem is handled related data separately respectively.
The ETL unit in order to data pick-up, the conversion that will be distributed in each subsystem, clean, be loaded in the unified OSD unit; And provide correct, complete, consistent information view on this basis.For example be clue, concentrate the transaction represent the client, customer service, website visiting record etc. with the customer accounting code.
The OSD unit deposits among the data warehouse DW in order to the data in this OSD unit are further processed.
Data warehouse DW is in order to store the data after described OSD unit processes.
On-line analytical processing unit OLAP is with thinking that decision support system (DSS) DSS provides all kinds of report data services.
ESB ESB uses so that be in same data maintenance simultaneously in a plurality of subsystems of different sub-systems.The mode of safeguarding can for: revise oneself information as bank client in a subsystem (as call center's subsystem), the state of this information in other subsystems is set to can check, can not revise, and informs that this information of inquiry is in the modification state; After this information correction is finished, in the total system in all subsystems this information all be modified.
As shown in Figure 2, arrow A 1 expression ESB common interfaces, for example SOAP, JMS etc.; Data, for example data file, database etc. are extracted in arrow A 3 expressions from the traditional data source; Arrow A 4 expressions are extracted data by ESB; Dotted line inside is divided into the main composition of financial data service system of the present invention among Fig. 2.
The present invention uses ESB that each system is linked together, and integrated multiple business flow process fundamentally solves the problem that a plurality of systems of same data safeguard simultaneously.Allow the no longer worried customer manager's information of fund company how at CRM (Customer Relationship Management, Customer Profile Management System), Call Center (CC, call center), the website is synchronous between service system.Allow the information interactive interface between the different system obtain standard, improve the independence between each subsystem, lower the risk of system upgrade and replacing.In the independence of not sacrificing individual system and simultaneously targetedly, allow the CTO (chief technology officer) of fund company can plan the construction of whole company IT system from the aspect of global information stream.
Because ESB is open standard, the cooperation between the multiple IT system is placed among the ESB management has effectively avoided system's barrier, each system all is on the starting line of an equality.The interface of all IT system, the ODS that comprises financial data service system of the present invention and OLAP and ESB sees also the four-headed arrow A1 among Fig. 2.
Through above improvement, the financial data service system that the present invention discloses will effectively solve problem of detached island of information, guarantee the independence of each subsystem simultaneously, reduce the maintenance cost of IT system, promote safety of data, the ability of utilizing of the use ability of IT system and various information will reach a new height.
Embodiment two
Present embodiment is introduced system function design of the present invention.
For better realizing data and the service function in the product, the present invention makes full use of the technology integration ability of self, uses international advanced software architecture to make up, as Fig. 4.System mainly is made up of three parts, and what the user directly saw is an integrated control desk, and control desk has comprised three major function districts: user instrument, ESB management, meta data definition.
[user instrument]
Report tool, scenario manager, System Monitor have been comprised in the user instrument.
Report tool is primarily aimed at OLAP result, and OLAP result can be browsed, be showed, store, manage in financial company by report tool.
System Monitor provides multiple view, can directly check ESB, ETL working condition, and the ruuning situation of other tasks of system.
Scenario manager is a simplification instrument, financial industry comprises polytype company (stock trader, bank, insurance company, fund, futures etc.), there is huge difference in the system that dissimilar companies use, the IT system that the company of same kind is selected also can be different, though adopt every defining tool of financial data of the present invention service centre can realize flexibly comprehensively configuration, workload is huge.We with representative a kind of system configuration collection of metadata abstract be scheme, same scheme can directly be selected by the inner IT system similar enterprise that distributes, and then personalized the adjustment.Simultaneously also can propagate advanced management thought and means by this method.
[ESB management]
Powerful ESB middleware product flexibly provided by the invention, and encapsulated administration interface thereon, the coupling system monitor is realized information interaction between each information island.
[meta data definition]
Be to realize datamation, the present invention has developed task manager, and this task manager not only can call the ETL task, other tasks that also can the high-efficiency management system.
Preamble is mentioned data through behind the ETL, is introduced into ODS, further just changes DW over to after the processing, and data service center of the present invention can be in ODS and two aspects issues of OLAP service towards ESB.These will greatly improve each subsystem data value through the data, services of arrangement and analysis, effectively solve problem of detached island of information.The present invention is by a data service definition function, standard be distributed on content on the ESB.
In addition, the operation of each submodule is coordinated by a middleware operations manager that operates on the J2EE application program service by system, is the System Monitor window that gives information, the request of response task manager.
Embodiment three
The difference of present embodiment and embodiment one is that in the present embodiment, the data integration platform and the ESB ESB of financial data service system independently use.
Here description of the invention and application is illustrative, is not to want with scope restriction of the present invention in the above-described embodiments.Here the distortion of disclosed embodiment and change are possible, and the various parts of the replacement of embodiment and equivalence are known for those those of ordinary skill in the art.Those skilled in the art are noted that under the situation that does not break away from spirit of the present invention or essential characteristic, and the present invention can be with other forms, structure, layout, ratio, and realize with other elements, material and parts.Under the situation that does not break away from the scope of the invention and spirit, can carry out other distortion and change here to disclosed embodiment.
Claims (8)
1. a financial data service system is characterized in that, this system connects a data, services subsystem collection, and this subsystem collection comprises some service subsystems, in order to handle the related data of each subsystem;
Described system comprises:
The ETL unit connects each subsystem that described data, services subsystem is concentrated, in order to data pick-up, the conversion that will be distributed in each subsystem, clean, be loaded in the unified OSD unit;
The OSD unit connects described ETL unit, in order to the data in this OSD unit are further processed, deposits among the data warehouse DW;
Data warehouse DW connects described OSD unit, in order to store the data after described OSD unit processes;
On-line analytical processing unit OLAP connects described data warehouse DW, with thinking that decision support system (DSS) DSS provides all kinds of report data services;
ESB ESB connects data service subsystem collection, ETL unit, OSD unit, on-line analytical processing unit OLAP, uses so that be in same data maintenance simultaneously in a plurality of subsystems of different sub-systems.
2. financial data service system according to claim 1 is characterized in that:
Described data, services subsystem collection comprises call center's subsystem, transaction subsystem.
3. financial data service system according to claim 1 is characterized in that:
Described ETL unit will be distributed in each subsystem data pick-up, conversion, clean, be loaded in the unified OSD unit, and provide correct, complete, consistent information view on this basis.
4. financial data service system according to claim 1 is characterized in that:
Described system also comprises the user instrument module, in order to human-computer interaction interface to be provided, comprises the report tool unit, in order to browse, show, store, to manage OLAP result;
The project management unit is in order to select corresponding system configuration according to user's enterprise nature; The system configuration collection of metadata abstract be scheme, plurality of proposals is set, the system configuration collection of metadata that this scheme is corresponding certain in the system;
ESB, ETL working condition in order to multiple view to be provided, can directly be checked in the system monitoring unit, and the ruuning situation of other tasks of system.
5. financial data service system according to claim 1 is characterized in that:
Described system also comprises the ESB administration module, in order to realize information interaction between each data, services subsystem.
6. financial data service system according to claim 1 is characterized in that:
Described system also comprises the meta data definition module, and in order to the meta data definition function of high encapsulation degree to be provided, it comprises
Other tasks in the described system in order to call the ETL task, are managed simultaneously in the task management unit;
The data, services definition unit is distributed on content on the ESB in order to standard.
7. financial data service system according to claim 1 is characterized in that:
Described system also comprises the total data storehouse, connects each data, services subsystem, OSD unit, data warehouse DW, ESB ESB.
8. a financial data service system is characterized in that, this system comprises:
Data, services subsystem collection comprises some service subsystems, in order to handle the related data of each subsystem;
Database is in order to the data message of storage system;
ESB ESB connects data service subsystem collection, database, uses so that be in same data maintenance simultaneously in a plurality of subsystems of different sub-systems in the database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910047944A CN101840563A (en) | 2009-03-20 | 2009-03-20 | Financial data service system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910047944A CN101840563A (en) | 2009-03-20 | 2009-03-20 | Financial data service system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101840563A true CN101840563A (en) | 2010-09-22 |
Family
ID=42743920
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200910047944A Pending CN101840563A (en) | 2009-03-20 | 2009-03-20 | Financial data service system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101840563A (en) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103220326A (en) * | 2013-01-24 | 2013-07-24 | 华夏银行股份有限公司 | Heterogenous double-preposition application system architecture |
CN104036365A (en) * | 2014-06-26 | 2014-09-10 | 浪潮软件股份有限公司 | Method for constructing enterprise-level data service platform |
CN104361424A (en) * | 2014-10-11 | 2015-02-18 | 中国电子科技集团公司第十研究所 | Master data system integration method based on enterprise service bus (ESB) |
CN104392291A (en) * | 2014-09-05 | 2015-03-04 | 宁波和佳软件技术有限公司 | Financial service management information platform |
CN104809110A (en) * | 2014-01-23 | 2015-07-29 | 安徽海汇金融投资集团有限公司 | Large data system |
CN105631004A (en) * | 2015-12-28 | 2016-06-01 | 华夏银行股份有限公司 | Data processing method and system |
CN109669975A (en) * | 2018-11-09 | 2019-04-23 | 成都数之联科技有限公司 | A kind of industry big data processing system and method |
-
2009
- 2009-03-20 CN CN200910047944A patent/CN101840563A/en active Pending
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103220326A (en) * | 2013-01-24 | 2013-07-24 | 华夏银行股份有限公司 | Heterogenous double-preposition application system architecture |
CN103220326B (en) * | 2013-01-24 | 2017-11-10 | 华夏银行股份有限公司 | The double preposition application systems of isomery |
CN104809110A (en) * | 2014-01-23 | 2015-07-29 | 安徽海汇金融投资集团有限公司 | Large data system |
CN104036365A (en) * | 2014-06-26 | 2014-09-10 | 浪潮软件股份有限公司 | Method for constructing enterprise-level data service platform |
CN104392291A (en) * | 2014-09-05 | 2015-03-04 | 宁波和佳软件技术有限公司 | Financial service management information platform |
CN104361424A (en) * | 2014-10-11 | 2015-02-18 | 中国电子科技集团公司第十研究所 | Master data system integration method based on enterprise service bus (ESB) |
CN104361424B (en) * | 2014-10-11 | 2018-05-04 | 中国电子科技集团公司第十研究所 | Main data system integrated approach based on Enterprise Service Bus |
CN105631004A (en) * | 2015-12-28 | 2016-06-01 | 华夏银行股份有限公司 | Data processing method and system |
CN109669975A (en) * | 2018-11-09 | 2019-04-23 | 成都数之联科技有限公司 | A kind of industry big data processing system and method |
CN109669975B (en) * | 2018-11-09 | 2020-12-18 | 成都数之联科技有限公司 | Industrial big data processing system and method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101840563A (en) | Financial data service system | |
US8165993B2 (en) | Business intelligence system with interface that provides for immediate user action | |
Melchert et al. | Aligning process automation and business intelligence to support corporate performance management | |
AU2003231931B2 (en) | System and method for integrating, managing and coordinating customer activities | |
CN106372975B (en) | Invoice management system based on SOAP technology and ActiveX control technology | |
US7457807B2 (en) | Data migration and analysis | |
CN105512790A (en) | Integrated operation and maintenance management system | |
US8352958B2 (en) | Systems and methods for providing a generic audit trail service | |
CN101957865A (en) | Data exchange and sharing technology among heterogeneous systems | |
CN101086782A (en) | Public platform of collaborative electronic commercial system oriented to business service | |
US8321438B1 (en) | Integration layer for a data repository | |
CN101452485A (en) | Method and device for generating multidimensional cubic based on relational database | |
CN102867282A (en) | Implementation method for mobile Internet-based customer service quality analysis system | |
CN104657808A (en) | System and method capable of realizing real-time inquiry and management of fund data of enterprise | |
US20070239587A1 (en) | System and Method For Dynamically Utilizing and Managing Financial, Operational, and Compliance Data | |
CN102024010A (en) | Data processing system and data processing method | |
CN101877110A (en) | Product management system and application method thereof | |
Fahim-Nader et al. | Foreign direct investment in the United States | |
CN102346666B (en) | Capturing and processing data generatid in ERP interim phase | |
Schneider | SAP Performance Optimization Guide | |
CN103218691A (en) | Embedded type business intelligent information management system and management method | |
CN105512829A (en) | Web service protocol-based card value multidimensional cost accumulation method | |
CN108228578A (en) | Financial data service system | |
Davis | Right-Time Business Intelligence: Optimizing the Business Decision Cycle | |
White | Building the real-time enterprise |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20100922 |