【摘要】：產(chǎn)業(yè)鏈協(xié)同商務(wù)業(yè)務(wù)云平臺(tái)(以下簡(jiǎn)稱平臺(tái))是以汽車及零部件行業(yè)的各協(xié)同業(yè)務(wù)流程為基礎(chǔ),面向整車制造企業(yè)、零件供應(yīng)商、零件經(jīng)銷商、維修服務(wù)商構(gòu)建的產(chǎn)業(yè)鏈上各企業(yè)業(yè)務(wù)流程融合、各企業(yè)信息系統(tǒng)之間互聯(lián)互通的產(chǎn)業(yè)價(jià)值鏈協(xié)作體系,現(xiàn)已成為近萬(wàn)家協(xié)作企業(yè)的業(yè)務(wù)云平臺(tái)。然而,平臺(tái)現(xiàn)有的數(shù)據(jù)交互解決方案忽視了平臺(tái)中存在實(shí)時(shí)性業(yè)務(wù)對(duì)數(shù)據(jù)實(shí)時(shí)交互的需求,將之處理為常規(guī)的定時(shí)數(shù)據(jù)交互,影響了平臺(tái)業(yè)務(wù)處理速度;同時(shí)現(xiàn)有解決方案中的數(shù)據(jù)交互配置不易擴(kuò)展,對(duì)平臺(tái)的動(dòng)態(tài)可擴(kuò)展性造成了阻礙。因此,改進(jìn)和創(chuàng)新平臺(tái)中現(xiàn)有數(shù)據(jù)交互解決方案來(lái)滿足平臺(tái)業(yè)務(wù)對(duì)實(shí)時(shí)性和動(dòng)態(tài)可擴(kuò)展性的要求,并保證數(shù)據(jù)交互解決方案的穩(wěn)定可靠,就顯得非常有價(jià)值和意義。本文首先通過(guò)對(duì)平臺(tái)中的協(xié)作業(yè)務(wù)進(jìn)行舉例研究,分析了協(xié)作業(yè)務(wù)對(duì)數(shù)據(jù)交互的需求,得出了平臺(tái)中現(xiàn)有的數(shù)據(jù)交互解決方案存在的不足和問(wèn)題。在這些不足和問(wèn)題的基礎(chǔ)上,本文構(gòu)建了一種基于JSON格式和數(shù)據(jù)庫(kù)觸發(fā)器利用消息隊(duì)列進(jìn)行可靠交付的實(shí)時(shí)數(shù)據(jù)交互模型,并結(jié)合原有方案中的計(jì)時(shí)器方式,設(shè)計(jì)了基于平臺(tái)的實(shí)時(shí)數(shù)據(jù)交互解決方案。本文著重分析了關(guān)系模式同JSON文檔之間的轉(zhuǎn)換,并利用這種異構(gòu)數(shù)據(jù)轉(zhuǎn)換方案設(shè)計(jì)了基于發(fā)布訂閱模式的動(dòng)態(tài)可擴(kuò)展數(shù)據(jù)交互配置柔性化定制方案。本文設(shè)計(jì)的實(shí)時(shí)數(shù)據(jù)交互解決方案在數(shù)據(jù)交互配置所制定規(guī)則的指導(dǎo)下,數(shù)據(jù)交互工作程序利用多種數(shù)據(jù)監(jiān)控方式進(jìn)行業(yè)務(wù)數(shù)據(jù)變更的檢測(cè),然后將需要交互的數(shù)據(jù)通過(guò)打包、加密、冗余校驗(yàn)后交由消息隊(duì)列進(jìn)行可靠性交付,另一節(jié)點(diǎn)接收到交互數(shù)據(jù)后進(jìn)行相反的操作然后在數(shù)據(jù)交互配置所制定規(guī)則的指導(dǎo)下將數(shù)據(jù)匹配應(yīng)用到本地?cái)?shù)據(jù)庫(kù)中。本文設(shè)計(jì)的實(shí)時(shí)數(shù)據(jù)交互解決方案通過(guò)將數(shù)據(jù)交互的流程歸納總結(jié),將定時(shí)方式與實(shí)時(shí)方式進(jìn)行歸納,同時(shí)實(shí)現(xiàn)了實(shí)時(shí)數(shù)據(jù)交互與傳統(tǒng)數(shù)據(jù)交互。本文設(shè)計(jì)的解決方案考慮了數(shù)據(jù)交互的實(shí)時(shí)性、準(zhǔn)確性、安全性和可靠性,滿足了平臺(tái)對(duì)數(shù)據(jù)交互原有的需求和新發(fā)掘的需求。在文章最后針對(duì)設(shè)計(jì)的實(shí)時(shí)數(shù)據(jù)交互解決方案進(jìn)行了功能驗(yàn)證,并獲得了良好的效果。
[Abstract]:The industry chain collaborative business cloud platform (hereinafter referred to as "the platform") is based on the various collaborative business processes of automobile and parts industry, facing the whole car manufacturing enterprises, parts suppliers, parts dealers, The cooperation system of industrial value chain constructed by maintenance service provider has become the business cloud platform of nearly ten thousand cooperative enterprises. However, the existing data interaction solutions ignore the requirement of real-time data interaction in the platform, and treat it as regular timing data interaction, which affects the processing speed of platform business. At the same time, the data interaction configuration in the existing solutions is not easy to extend, which hinders the dynamic scalability of the platform. Therefore, it is of great value and significance to improve and innovate the existing data interaction solutions to meet the real-time and dynamic scalability requirements of the platform business, and to ensure the stability and reliability of the data interaction solutions. In this paper, first of all, through the research of the collaborative services in the platform, we analyze the demand of the collaborative services for the data interaction, and get the shortcomings and problems of the existing data interaction solutions in the platform. On the basis of these shortcomings and problems, this paper constructs a real-time data interaction model based on JSON format and database trigger, which uses message queue for reliable delivery, and combines the timer mode in the original scheme. The solution of real-time data exchange based on platform is designed. This paper focuses on the transformation between relational schema and JSON document, and designs a flexible customization scheme based on publish / subscribe mode for dynamic extensible data interaction configuration using this heterogeneous data conversion scheme. Under the guidance of the rules of data interaction configuration, the real-time data interaction solution designed in this paper uses a variety of data monitoring methods to detect the change of business data, and then packages the data needed to interact. After encryption, redundancy check is handed over to message queue for reliability delivery. The other node receives the interactive data and performs the opposite operation. Under the guidance of the rules of data interaction configuration, the data matching is applied to the local database. The solution of real-time data interaction designed in this paper is to sum up the process of data interaction, sum up the timing mode and real-time mode, and realize real-time data interaction and traditional data interaction at the same time. The solution designed in this paper considers the real-time, accuracy, security and reliability of the data interaction, and meets the original demand and the newly excavated demand of the platform. At the end of the paper, the design of real-time data interaction solution is verified, and good results are obtained.
【學(xué)位授予單位】：西南交通大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2017
【分類號(hào)】：F426.471;TP393.09

【參考文獻(xiàn)】

相關(guān)期刊論文 前10條

1 王珊;薩師煊;;數(shù)據(jù)庫(kù)系統(tǒng)概論(第5版)[J];中國(guó)大學(xué)教學(xué);2014年09期

2 劉麗娟;吳達(dá)勝;;關(guān)于MySQL數(shù)據(jù)庫(kù)中觸發(fā)器的學(xué)習(xí)探討[J];計(jì)算機(jī)時(shí)代;2014年04期

3 沈敬偉;周廷剛;溫永寧;羅潔瓊;孫晨陽(yáng);;基于面向?qū)ο髷?shù)據(jù)庫(kù)的空間數(shù)據(jù)管理[J];西南大學(xué)學(xué)報(bào)(自然科學(xué)版);2013年04期

4 林U，

本文編號(hào)：2348830