research and implementation of middleware of heterogeneous financial system

1、<p>　　Research and Implementation of Middleware of Heterogeneous Financial System</p><p>　　Abstract: In order to solve heterogeneity of financial system and make the group access financial systems of ea

2、ch subsidiary, the paper proposes to integrate Agent and XML into middleware models of heterogeneous financial system. There have been some theoretical researches applying Agent technology to middleware at home and abroa

3、d, 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 inte</p><p>　　Key words: heterogeneous fin

4、ancial system, Agent, middleware, XML, mapping dictionary, conversion algorithm </p><p>　　1 Introduction </p><p>　　The paper makes the?secondary?development based on the coexistence of existing

5、financial software, which has great practical significance. In order to make finance personnel of enterprise group headquarters realize real-time monitor and master basic financial information and operation status of sub

6、sidiaries by remote query such as voucher, detailed account, leger, general account, balance sheet and profit report, the paper introduces Agent technology and XML technology into heterogeneous financi</p><p&g

7、t;　　2. Middleware Model of Heterogeneous Financial System </p><p>　　In order to play intelligent features of Agent, the paper uses hybrid Agent model. The design of middleware model of heterogeneous financia

8、l system in the 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 ef

9、fectively reduces the complexity of heterogeneous financial system integration, and meets the requirements of groups. </p><p>　　2.1 Introducing Agent technique </p><p>　　As mentioned above, as a

10、 new research filed, Agent has achieves some research results in research?field?of?computer?application, and has been widely applied in many fields. In recent years, Agent technique not only develops rapidly in network e

11、nvironment, 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

12、 indicate that Agent technique has a</p><p>　　Introducing Agent into database middleware can solve the problems of data interaction rate and system load balance of the original database. </p><p>

13、;　　2.2 Design of middleware system architecture </p><p>　　For the functions of middleware, middleware of heterogeneous financial system integration is established on financial database and under user level.

14、It uses multi-Agent technique and XML technique to construct a middleware of heterogeneous financial system integration, which not only shields heterogeneity of financial systems of subsidiaries, but also realizes transp

15、arent share of enterprise group headquarters on financial system information of subsidiaries. </p><p>　　The middleware encapsulates application service logic. And the middleware, application layer and financ

16、ial system of subsidiaries compose three-layer structure of client/server. The design of middleware system includes two parts, generation of mapping dictionary of financial database information in subsidiaries and operat

17、ion of middleware system query, which are the process of asynchronous operation. </p><p>　　2.3Operation process of middleware system </p><p>　　● Generation of mapping dictionary of financial dat

18、abase information </p><p>　　Generation of mapping dictionary of financial database information in subsidiaries is the key to heterogeneous financial system integration. The query submitted by the user is dif

19、ferent from list structure, field and property of financial system of subsidiaries, which needs a map from querying normal fields to non-standard fields. So the mapping dictionary generated in the middleware system inclu

20、des metadata of financial databases, and the map from standard fields of financial statement to non-s</p><p>　　● Operation of middleware system query </p><p>　　The operation of system query mean

21、s 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, as follows. 　　The midd

22、leware 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.

23、</p><p>　　A.Using HashTable to collect query information of the user, and then passing it to distribution Agent. </p><p>　　B.Distribution Agent refers to mapping dictionary with the form of XML

24、delivered by information management Agent for determining objective financial database queried by the use. And the financial database information is achieved, and the non-standard fields corresponding to standard fields

25、in financial sheets are encapsulated into XML document and are sent to conversion Agent. </p><p>　　C.After receiving query information, conversion Agent analyzes query documents, and extracts query parameter

26、s, which are organized to be query statements which can be recognized by objective financial database and are sent to purpose information Agent. </p><p>　　D.After information Agent receives information, the

27、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 encapsulated to be message with the format of XML a

28、nd are sent to conversion Agent. </p><p>　　E. Conversion Agent refers to mapping dictionary. The non-standard XML documents are converted into standard XML documents, and are sent to integration Agent. </

29、p><p>　　F.After integration Agent receives result documents with the format of XML, the documents are encapsulated into ListView display of Data Set binding client interface. </p><p>　　In middlewar

30、e system, mapping dictionary, query results and result documents make data interaction with the format of XML, and the advantages are as follows. </p><p>　　(1)It makes data exchange keep the principle of sys

31、tem independence, reduces coupling?and improves the reusing possibility. </p><p>　　(2)It makes middleware hide the details of data storage and acquisition. And it makes the user hide the application and disp

32、lay of data on the middleware. </p><p>　　(3) The required network transmission bandwidth is lower. The bandwidth for XML document transmission is lower than that of HTML document with the same data specifica

33、tion. </p><p>　　(4) The results of XML document make the user easy to make?local?process on data. </p><p>　　3. Heterogeneous Financial Data Layer </p><p>　　As the financial system o

34、f subsidiaries is heterogeneous, and 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 u

35、ses the activity, reactivity and intelligence of Agent, 　　And the logic structure is shown in Figure 2. </p><p>　　4 Conclusion </p><p>　　With the expansion of application?range of enterprises,

36、the requirements of enterprises on information increases, and more and more enterprise applications need to access various heterogeneous data sources. For enterprise application, it not only is the requirement of interna

37、l development of enterprises, 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 backgro

38、und </p><p>　　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

39、of data conversion and interaction, which not only solves the data integration of heterogeneous financial system, but also provides support for group user querying financial information of subsidiaries and supervising fi

40、nancial operation status of subsidiaries. </p><p>　　Reference </p><p>　　[1] Li Jimei, Du Meijie, Heterogeneous financial information integration algorithm based on XBRL [J], Journal?of Jilin?Uni

41、versity(Engineering edition) ,2012,S1:266-270. </p><p>　　[2] Zhang Zhikun, Wu Xiaopeng, Xing Chengjie, Deng Changming, Yuan Ling, Financial data warehouse based on actual constellation model [J], Journal of

42、Wuhan University (Science edition), 2012,S1:251-256. </p><p>　　[3] Shen Limin, Li Zhiwei, Research on flexible heterogeneous data integration model based on service [J], Journal of Yanshan University, 2013,0

43、2:117-123. </p><p>　　[4] Na Lichun, Chen Qingkui, Financial supervision data?canalization and funnel model based on concurrent workflow [J], Computer Engineering, 2009,10:62-65. </p><p>　　[5] Ti