企業(yè)安全策略下的跨平臺(tái)數(shù)據(jù)同步中英文翻譯

1、 淮 海 工 學(xué) 院畢業(yè)設(shè)計(jì)(論文)外文資料翻譯系 （院）： 計(jì)算機(jī)科學(xué)系 專 業(yè)： 計(jì)算機(jī)科學(xué)與技術(shù) 姓 名： 王 琴 學(xué) 號(hào)： 3202000142 (用外文寫)外文出處： data synchronization over different platforms under enterprise security policy 附 件： 1.外文資料翻譯譯文；2.外文原文。 指導(dǎo)教師評(píng)語：外文資料的選材比較正確，內(nèi)容是企業(yè)安全策略下的跨平臺(tái)數(shù)據(jù)同步的方法。譯文基本準(zhǔn)確，該同學(xué)認(rèn)真地完成了外文資料翻譯任務(wù)。 簽名： 2004年 4月 16 日注：請(qǐng)將該封面與附件裝訂成冊(cè)。附件1：外文資料翻

2、譯譯文企業(yè)安全策略下的跨平臺(tái)數(shù)據(jù)同步摘 要：本文探討了跨平臺(tái)數(shù)據(jù)同步的方法，并舉例說明了在企業(yè)安全策略下實(shí)現(xiàn)跨平臺(tái)數(shù)據(jù)同步在設(shè)計(jì)intranet自動(dòng)化工具中的應(yīng)用。關(guān)鍵詞：企業(yè)安全策略、intranet自動(dòng)化工具、socket通信、組件化編程1. 引言關(guān)于b-s開發(fā)模式的好處已經(jīng)被討論了很多，intranet自動(dòng)化工具在現(xiàn)代企業(yè)辦公自動(dòng)化中的應(yīng)用正日益普及。隨著現(xiàn)代企業(yè)朝著國(guó)際化、集團(tuán)化的方向發(fā)展，現(xiàn)代企業(yè)內(nèi)部各部門之間出現(xiàn)了分工細(xì)密化和分布全球化的趨勢(shì)。分工細(xì)密化和分布全球化的趨勢(shì)使得各部門之間難以找到一個(gè)較完整的可共享的數(shù)據(jù)和可適用于各部門間獨(dú)立管理的工具，各部門在開發(fā)自己的intrane

3、t自動(dòng)化工具的時(shí)候會(huì)根據(jù)本部門的特點(diǎn)和資源條件選擇自己的intranet發(fā)布平臺(tái)。一方面，部門原有的數(shù)據(jù)發(fā)布平臺(tái)在一定程度上影響了部門對(duì)intranet發(fā)布平臺(tái)的選擇；另一方面，在選定了自己的intranet發(fā)布平臺(tái)的同時(shí)，原來與其他部門共享數(shù)據(jù)的部門也相應(yīng)地選擇了自己的數(shù)據(jù)發(fā)布平臺(tái)。同時(shí)，現(xiàn)代企業(yè)內(nèi)部各部門之間的協(xié)同工作也越來越密切，不同部門之間通常需要訪問的數(shù)據(jù)能同步更新，或者至少能在一定的時(shí)間間隔內(nèi)進(jìn)行數(shù)據(jù)同步。雖然大部分的數(shù)據(jù)庫產(chǎn)品都有自己的基于tcp/ip的訪問方式，但在企業(yè)安全的策略下，各部門通常會(huì)更改對(duì)ip端口的訪問方式的配置，并開發(fā)出自己的內(nèi)部數(shù)據(jù)訪問工具；有的部門即使使用了數(shù)

4、據(jù)庫產(chǎn)品的默認(rèn)設(shè)置，也很少公開數(shù)據(jù)庫訪問的用戶名和密碼。因此，在各部門之間通過數(shù)據(jù)庫客戶端訪問工具進(jìn)行直接的跨平臺(tái)數(shù)據(jù)訪問與同步幾乎不具備可行性。本文是筆者在摩托羅拉中國(guó)軟件中心實(shí)習(xí)期間參與開發(fā)intranet自動(dòng)化工具的設(shè)計(jì)開發(fā)過程中面臨的數(shù)據(jù)同步問題解決方案的總結(jié)。2. 幾種跨平臺(tái)數(shù)據(jù)同步方案在介紹常用跨平臺(tái)數(shù)據(jù)同步方法之前有必要簡(jiǎn)要介紹一下所開發(fā)的intranet自動(dòng)化工具的設(shè)計(jì)目的和狀況。所開發(fā)的intranet自動(dòng)化工具是運(yùn)行在windows nt平臺(tái)上的asp應(yīng)用程序，其設(shè)計(jì)目的是將本地windows nt平臺(tái)上的cr tracking（change request trackin

5、g, 變更需求跟蹤）access數(shù)據(jù)庫與美國(guó)unix平臺(tái)上含有cr跟蹤信息的rational clearddts（distributed defects tracking system, 分布式錯(cuò)誤跟蹤系統(tǒng)。以下簡(jiǎn)稱ddts）數(shù)據(jù)庫進(jìn)行同步更新，以實(shí)現(xiàn)與本項(xiàng)目相關(guān)的cr信息的本地web訪問和跟蹤。在數(shù)據(jù)同步中要求實(shí)現(xiàn)的功能包括：獲取ddts數(shù)據(jù)庫中的新數(shù)據(jù)用于access數(shù)據(jù)庫的添加、獲取ddts數(shù)據(jù)庫中指定紀(jì)錄的字段值用于access數(shù)據(jù)庫的更新。在接手進(jìn)一步開發(fā)intranet自動(dòng)化工具之前，本項(xiàng)目組已經(jīng)有了一個(gè)cr跟蹤的intranet工具，使用該工具可以進(jìn)行cr的輸入、修改、查詢和列表

6、統(tǒng)計(jì)。該intranet工具要求與cr相關(guān)的人員主動(dòng)使用ddts工具查詢相關(guān)cr的信息，并將信息在web錄入頁面上輸入到web服務(wù)器上的本地?cái)?shù)據(jù)庫，供cr跟蹤使用。這種intranet工具使用的數(shù)據(jù)同步方法是利用ddts數(shù)據(jù)訪問工具，手工數(shù)據(jù)同步。該數(shù)據(jù)同步的方法實(shí)現(xiàn)簡(jiǎn)單，但操作繁瑣，特別是在查詢時(shí)需要重復(fù)性地輸入類似的sql語句，使得這項(xiàng)工作顯得枯燥無味。從嚴(yán)格意義上講，這不能算是一種跨平臺(tái)數(shù)據(jù)同步的解決方案?？紤]到大部分的數(shù)據(jù)庫產(chǎn)品都有自己的基于tcp/ip的訪問方式，要求相關(guān)部門開放數(shù)據(jù)庫的ip端口訪問及受限的用戶名和密碼給intranet開發(fā)人員也許是一個(gè)簡(jiǎn)單的實(shí)現(xiàn)跨平臺(tái)數(shù)據(jù)同步的方法

7、。使用這種方法，只需在windows nt web服務(wù)器中安裝相應(yīng)的odbc驅(qū)動(dòng)程序，然后在設(shè)計(jì)asp程序時(shí)使用ado編程，進(jìn)行數(shù)據(jù)的簡(jiǎn)單查詢和添加、修改即可進(jìn)行跨平臺(tái)數(shù)據(jù)同步，設(shè)計(jì)十分簡(jiǎn)單。但這種方法存在兩方面的問題：一是在開放數(shù)據(jù)庫ip端口訪問的用戶名和密碼的同時(shí)，即給該數(shù)據(jù)庫所在部門帶來了安全隱患，一旦web服務(wù)器受到攻擊而使用戶名和密碼被竊取，開放的數(shù)據(jù)庫也就處在被攻擊的風(fēng)險(xiǎn)之中；二是有的部門使用的是第三方開發(fā)的基于數(shù)據(jù)庫的工具（如ddts工具），其部門本身并沒有數(shù)據(jù)庫的管理權(quán)限，因而也就無法添加用戶名和分配權(quán)限。在開發(fā)過程中，采用基于socket通信的跨平臺(tái)數(shù)據(jù)同步方法。3 .一種基

8、于socket通信的跨平臺(tái)數(shù)據(jù)同步方法基于socket通信的跨平臺(tái)數(shù)據(jù)同步方法采用客戶機(jī)/服務(wù)器的概念，在分屬于不同部門的不同平臺(tái)的計(jì)算機(jī)上分別開發(fā)負(fù)責(zé)偵聽的socket服務(wù)器和負(fù)責(zé)連接的socket客戶端。以獲取ddts數(shù)據(jù)庫中指定紀(jì)錄的字段值為例，當(dāng)客戶端和服務(wù)器連接成功時(shí)，客戶端向服務(wù)器發(fā)送相關(guān)cr的關(guān)鍵字以及需要獲取的字段名，服務(wù)器通過調(diào)用ddts工具的相應(yīng)命令來獲得客戶端所需要的字段數(shù)據(jù)并發(fā)送給客戶端。socket服務(wù)器運(yùn)行在ddts所在的美國(guó)unix主機(jī)上，采用多進(jìn)程編程。編程過程中，對(duì)建立連接時(shí)產(chǎn)生的eintr錯(cuò)誤的處理和對(duì)sigchld信號(hào)的處理是關(guān)鍵，如果處理不好，將會(huì)出現(xiàn)無

9、法多次連接和連接關(guān)閉后導(dǎo)致僵死進(jìn)程的情況。在開發(fā)過程中，使用popen函數(shù)運(yùn)行一個(gè)perl腳本獲取所需的數(shù)據(jù)并將其通過管道返回程序，該腳本使用ddts工具來獲取數(shù)據(jù)。這種方法充分利用了已有工具和perl語言的靈活性，降低了開發(fā)難度。為了確保偵聽程序始終運(yùn)行，采用了在unix主機(jī)的系統(tǒng)crontab里添加了一條指令使得系統(tǒng)每隔一分鐘檢查偵聽程序scksvr是否正在運(yùn)行，并在因系統(tǒng)異常導(dǎo)致其中斷運(yùn)行的情況下重新啟動(dòng)?？蛻舳诉\(yùn)行在windows nt平臺(tái)上，采用microsoft visual c+的atl（active template library）模板com開發(fā)和mfc socket編程做成

10、一個(gè)com組件。使用com組件可以避免在多個(gè)asp文件中使用winsock activex控件進(jìn)行編程，實(shí)現(xiàn)代碼復(fù)用。該com組件還用于一些vbscript腳本，這些vbscript腳本使用該com組件并訪問本地?cái)?shù)據(jù)庫實(shí)現(xiàn)數(shù)據(jù)的同步，具體實(shí)現(xiàn)的是自動(dòng)獲取ddts上的當(dāng)天cr到本地?cái)?shù)據(jù)庫并發(fā)送e-mail給相關(guān)人員、指定條件獲取ddts上的cr到本地?cái)?shù)據(jù)庫并發(fā)送e-mail給相關(guān)人員、自動(dòng)更新正在進(jìn)行的cr的狀態(tài)、根據(jù)cr和人員進(jìn)行的工時(shí)收集、cr統(tǒng)計(jì)與跟蹤等任務(wù)，可以使用windows nt的schedule service來定時(shí)運(yùn)行這些vbscript腳本實(shí)現(xiàn)數(shù)據(jù)的定時(shí)自動(dòng)同步。4. 結(jié)束語

11、本文分析了在企業(yè)安全策略下跨平臺(tái)數(shù)據(jù)同步面臨的問題和幾種數(shù)據(jù)同步方法，在分析手工同步和開放數(shù)據(jù)庫訪問ip端口的利弊基礎(chǔ)上提出了一種基于socket通信的數(shù)據(jù)同步解決方案。在實(shí)現(xiàn)基于socket通信的數(shù)據(jù)同步時(shí)，服務(wù)器端充分利用了已有的工具和perl語言的靈活性；根據(jù)實(shí)現(xiàn)intranet自動(dòng)化工具的需要，客戶端使用了visual c+的atl模板設(shè)計(jì)了一個(gè)socket客戶端com組件。在設(shè)計(jì)的自動(dòng)化工具中，利用windows nt的schedule service實(shí)現(xiàn)cr的定時(shí)自動(dòng)同步、更新及發(fā)送通知e-mail等任務(wù)，使用asp設(shè)計(jì)對(duì)本地?cái)?shù)據(jù)庫訪問的交互頁面進(jìn)行cr跟蹤。在實(shí)際使用中，這種方案

12、很好地滿足了設(shè)計(jì)目的，與原有intranet工具相比，大大降低了所有項(xiàng)目組成員在cr跟蹤上所貢獻(xiàn)的時(shí)間和精力。附件2：外文原文（復(fù)印件）data synchronization over different platforms under enterprise security policyabstract: this paper discusses methods of data synchronization over different platforms. then it gives an example to illuminate the application of impleme

13、ntation of data synchronization over different platforms under enterprise security policy in the design of intranet automatic tools.key words: enterprise security policy, intranet automatic tools, socket communication, componential programming1. introduction have been discussed as for b- s developpi

14、ng the advantage of the mode a lot of, the intranet automation tool transacts the application in the automation in the modern business enterprise increasingly universal.along with modern business enterprise towards the direction that internationalization, group turn develops, modern business enterpr

15、ise internal and each section a trend for appearing cent work closely turning with distributing world turning.the cent work is close to turn to turn to make with the world that distribute the trend each section a data for hardly finding out aly more completely sharing with applicably the tool of the

16、 independence management among each section, each section will choose with the resources term according to the characteristics of this section at the time of developping own intranet automating the tool own intranet announces the terrace.on the other hand, the original data in section announces the

17、terrace to affected the section to announce the choice of the terrace to the intranet on the certain degree;on the other hand, at make selection own intranet announce the terrace at the same time, share with other section the section of the data originally too the ground of cowgirl chose own data an

18、nounces the terrace.at the same time, modern business enterprise internal and each section a data for being in conjunction with work too more and more closely, different section usually needing visitting can renew synchronously, or at least can in certain time partition the proceeding data is synchr

19、onous.although big and part of databases product has own according to tcp/ ip interview method, the strategy in enterprise security is next, each section will usually change to install to the port of ip interview method, combining to develop an own internal data interview tool;the section of having

20、used even the tacit approval of the database product establishes, and also few public the customer of the database interview with password.therefore, pass the database between each each section the customer carry to visit the tool proceed the direct cross-platform data interview with do not have the

21、 possibility synchronously and almost.this text is summary that the synchronous problem in data solution that the writer faces in motor pull period of chinese software center practice participate intranet that develop design development process automate tool.2. synchronous project in data in a few c

22、ross-platformshave the necessary synopsis introduction before introducing synchronous method in data in in common use cross-platform once an intranet for developping automates the design purpose of the tool with the condition.an intranet for developping automation tool is a rational to circulates in

23、 the applied procedure in windows nt the asp on the terrace, its design purpose is ascend with the unix terrace of the united states the native windows nt the cr on the terrace tracking( change request tracking, change need follow) the database of access to imply cr follow the information clearddts(

24、 distributed defects tracking system, the distribute type mistake follows the system.below brief name ddts) the database proceeds the synchronous renewal, toing realize with the native web of the related the information of cr in this item visit with follow.request synchronously and inside in the dat

25、a the function that realizes include:the new data that obtain the ddts database middle finger the database of access ddts database inside useds for the word a value increase, obtains the record settles the renewal useds for the database of access.before taking up further development intranet automat

26、ion tool, this item a the tool of intranet for thering has been a cr following, use that tool can proceed the cr importation, modification, search with row form statistics.the intranets tool requests to search with active usage in related personnel in cr ddts tool the information of the related cr,

27、combining to input information to the server of web native database in web recording into page, providing the cr follow the usage.the synchronous method in data of this kind of intranet tool usage is to makes use of the ddts data the interview the tool, handicraft data is synchronous.the synchronous

28、 method in that data realizes simple, but the operation is tedious, especially while searching the demand repeats sex a sql for inputting similarly language sentence, make this work seemed to be dull.speak from the strict meaning, there in no be regarded as the synchronous solution in data in a kind

29、 of cross-platform.in consideration of big and part of databases product has own according to tcp/ ip interview method, request the ip port interview related section opens the database and is customer by the limit develops the intranet the personnel with the password perhaps is a realizes in brief s

30、ynchronous method in data in cross-platform.use this kind of method, a simple search for needing in windows nt web server installing homologous odbc driving procedure, then while designing asp procedure usage ado weaving distance, proceeding data with increase, the modification can immediately proce

31、ed the cross-platform data synchronous, design very and in brief.but this kind of method exsits the problem of the both side:while ising in customer a risk for with password at the same time, then bringing the databases place section safe getting, once the server of web suffering attack and usage na

32、me of account with password burglarizing taking, liberal database too being placed in drive attackstoning that open database ip port interview;two what certain sections uses are the third square the development of according to the tool( such as the tool of ddts) of the database, its section oneself

33、management without database legal power, as a result also cant increase customer with assign the legal power.in develop process, adoption according to the cross-platform data that socket correspondence synchronous method.3. a kind of according to socket correspondence of cross-platform data synchron

34、ous methodaccording to socket correspondence of cross-platform data synchronous the method adopts the concept of customers machine/ server, the calculation accordinglying belong to in the different section in different terrace is on board distinguish development responsible for the server of socket

35、that hear with responsible for the copular the customer of socket carries.regard obtaining the word a value that ddts database middle finger settle record as word a that a key word for, being customer carrying with server linking success, customer carrying sending out to server related cr and demand

36、s obtain, the server pass to adjust to acquire with the tool of ddts cowgirl order the word that customer need when carrying a data erupts to give the customer carries.the server of socket circulates the united states in the place of ddts unix host the top, adoption many progress plait distance.plai

37、t distance process inside, produces to handles falsely with handles to the signal of sigchld to the hour of conjunction that establish the eintr is circumstance that key, if handle not good, willing appear cant link with link to cause the progress after closing many times.in develop process, the usa

38、ge popen function circulates a perl the data that script need when obtaining combines its pass the piping return the procedure, that script usage ddts tool to obtain the data.this kind of method made use of to there has been the tool well with the perl phonetic and vivid, lowering the difficulty of

39、development.for insuring the hears the procedure to circulate always, adopting to increase in system in the host of unix crontab an instruction make the each in system penny clock check 偵 hear the procedure scksvr whether in the movement, and start afresh under the situation of causing break among t

40、hem the movement unusually because of the system.the customer carries to circulate on the terrace of windows nt, adoption microsoft visual c+ of the atl( active template library) template com development makes into a com module with the mfc socket plait distance.the usage com module can avoid using

41、in several asps document the winsock activex controls the piece proceeds to weave the distance, realizing the code reply to use.the coms module still useds for the some the script of vbscript, these the script of vbscriptses use the coms module and visit the native database realizes data of synchron

42、ous, realizes in a specific way of obtain the top of ddts that very day cr automatically the native database erupt to send to e- mail to related personnel and specify the cr term obtain the top of ddts the native database erupts to send to e- mail to related personnel and renew automatically under way of cr appearance, according to cr is with the man-hour that personnel proceed collect, the cr statisticses with fol