1、1Research and Implementation of Middleware of Heterogeneous Financial SystemAbstract: In order to solve heterogeneity of financial system and make the group access financial systems of each subsidiary, the paper proposes to integrate Agent and XML into middleware models of heterogeneous financial sy
2、stem. There have been some theoretical researches applying Agent technology to middleware at home and abroad, but there is no deep study on the application of heterogeneous database middleware. Combined with the features of Agent, the paper introduces Agent into database integration middleware, and
3、applies it to heterogeneous financial system of groups, which solves financial supervision problem of groups on subsidiary. Key words: heterogeneous financial system, Agent, middleware, XML, mapping dictionary, conversion algorithm 1 Introduction The paper makes the?secondary?development based on th
4、e coexistence of existing financial software, which has great practical significance. In order to make finance personnel of enterprise group headquarters realize real-time monitor and 2master basic financial information and operation status of subsidiaries by remote query such as voucher, detailed a
5、ccount, leger, general account, balance sheet and profit report, the paper introduces Agent technology and XML technology into heterogeneous financial system integration, which not only plays intelligent features of Agent and effectively reduces the complexity of heterogeneous information system int
6、egration, but also meets the requirements of information construction of group enterprise. 2. Middleware Model of Heterogeneous Financial System In order to play intelligent features of Agent, the paper uses hybrid Agent model. The design of middleware model of heterogeneous financial system in the
7、paper introduces Agent technique and XML technique, which plays intelligent features of Agent and plays the advantage that XML is easy for ideography and crossing platform in data application, but also effectively reduces the complexity of heterogeneous financial system integration, and meets the re
8、quirements of groups. 2.1 Introducing Agent technique As mentioned above, as a new research filed, Agent has achieves some research results in research?field?of?computer?application, and has been widely 3applied in many fields. In recent years, Agent technique not only develops rapidly in network en
9、vironment, but also achieves results for Internet information retrieval, information collection or acquisition, network index, information distribution service and electronic commerce. The literatures at home and abroad indicate that Agent technique has achieved results, but there is no deep researc
10、h on applying it to database system integration as middleware technique. With wide application of computers and network, database middleware system attracts more and more attentions in research institution and industrial circles. Database middleware solves the problems of access of?integrated data,
11、constraint of users accessing database and transparent access of heterogeneous data source. But the existing database middleware system has the above defects such as data interaction rate and system load balance. As Agent has intelligent characteristics of autonomy, perception and activity, it can b
12、e introduced into database middleware system to solve the defect of the existing database middleware. Introducing Agent into database middleware can solve the problems of data interaction rate and system load balance of the original database. 42.2 Design of middleware system architecture For the fun
13、ctions of middleware, middleware of heterogeneous financial system integration is established on financial database and under user level. It uses multi-Agent technique and XML technique to construct a middleware of heterogeneous financial system integration, which not only shields heterogeneity of f
14、inancial systems of subsidiaries, but also realizes transparent share of enterprise group headquarters on financial system information of subsidiaries. The middleware encapsulates application service logic. And the middleware, application layer and financial system of subsidiaries compose three-laye
15、r structure of client/server. The design of middleware system includes two parts, generation of mapping dictionary of financial database information in subsidiaries and operation of middleware system query, which are the process of asynchronous operation. 2.3Operation process of middleware system Ge
16、neration of mapping dictionary of financial database information Generation of mapping dictionary of financial database information in subsidiaries is the key to heterogeneous financial system integration. The query submitted by the user 5is different from list structure, field and property of finan
17、cial system of subsidiaries, which needs a map from querying normal fields to non-standard fields. So the mapping dictionary generated in the middleware system includes metadata of financial databases, and the map from standard fields of financial statement to non-standard fields of database. And th
18、e flow chart is shown in Figure1. Operation of middleware system query The operation of system query means the active procedure of the middleware system in the process of group user interacting with middleware. And the principal function is to provide service for sharing heterogeneous financial data
19、, as follows. The middleware system presents a client-query page to the user, and enterprise group headquarters submit query through query page. After receiving query conditions of the user, the middleware system makes the following process. A.Using HashTable to collect query information of the user
20、, and then passing it to distribution Agent. B.Distribution Agent refers to mapping dictionary with the form of XML delivered by information management Agent for determining objective financial database queried by the use. And the financial database information is achieved, and the 6non-standard fie
21、lds corresponding to standard fields in financial sheets are encapsulated into XML document and are sent to conversion Agent. C.After receiving query information, conversion Agent analyzes query documents, and extracts query parameters, which are organized to be query statements which can be recogni
22、zed by objective financial database and are sent to purpose information Agent. D.After information Agent receives information, the legitimacy of information is inspected, and SQL query statements are extracted to be connected with financial database to execute query. Then, DataSet query results are
23、encapsulated to be message with the format of XML and are sent to conversion Agent. E. Conversion Agent refers to mapping dictionary. The non-standard XML documents are converted into standard XML documents, and are sent to integration Agent. F.After integration Agent receives result documents with
24、the format of XML, the documents are encapsulated into ListView display of Data Set binding client interface. In middleware system, mapping dictionary, query results and result documents make data interaction with the format of XML, 7and the advantages are as follows. (1)It makes data exchange keep
25、the principle of system independence, reduces coupling?and improves the reusing possibility. (2)It makes middleware hide the details of data storage and acquisition. And it makes the user hide the application and display of data on the middleware. (3) The required network transmission bandwidth is l
26、ower. The bandwidth for XML document transmission is lower than that of HTML document with the same data specification. (4) The results of XML document make the user easy to make?local?process on data. 3. Heterogeneous Financial Data Layer As the financial system of subsidiaries is heterogeneous, an
27、d database types, list structure and filed is different, a distributed heterogeneous database system forms. In order to integrate the data of heterogeneous financial system, the paper uses the activity, reactivity and intelligence of Agent, And the logic structure is shown in Figure 2. 4 Conclusion
28、With the expansion of application?range of enterprises, the requirements of enterprises on information increases, and more 8and more enterprise applications need to access various heterogeneous data sources. For enterprise application, it not only is the requirement of internal development of enterp
29、rises, but also is the requirement of enterprises adapting to external environment. Query supervision of groups on heterogeneous financial system of subsidiaries is an important application background of heterogeneous data source integration. The heterogeneous database sharing integration based on m
30、iddleware technique will become a widely used heterogeneous database integration method. The paper makes deep study on the emphasis and difficulty of heterogeneous financial system integration of groups, and proposes realization plans and verifies the feasibility and real time of integrated middlewa
31、re system by experiments. The paper researches heterogeneous financial data integration based on multi-Agent, makes full use of intelligence, collaboration and autonomy of Agent, and uses XML as the intermediate format of data conversion and interaction, which not only solves the data integration of
32、 heterogeneous financial system, but also provides support for group user querying financial information of subsidiaries and supervising financial operation status of subsidiaries. 9Reference 1 Li Jimei, Du Meijie, Heterogeneous financial information integration algorithm based on XBRL J, Journal?of
33、 Jilin?University(Engineering edition) ,2012,S1:266-270. 2 Zhang Zhikun, Wu Xiaopeng, Xing Chengjie, Deng Changming, Yuan Ling, Financial data warehouse based on actual constellation model J, Journal of Wuhan University (Science edition), 2012,S1:251-256. 3 Shen Limin, Li Zhiwei, Research on flexibl
34、e heterogeneous data integration model based on service J, Journal of Yanshan University, 2013,02:117-123. 4 Na Lichun, Chen Qingkui, Financial supervision data?canalization and funnel model based on concurrent workflow J, Computer Engineering, 2009,10:62-65. 5 Tian Ye, Design of financial digital management system in universities J, Journal of Henan Normal University (Science Edition), 2011,06:158-160.
