跳到主要內容

臺灣博碩士論文加值系統

(44.200.171.74) 您好!臺灣時間:2022/08/12 08:53
字體大小: 字級放大   字級縮小   預設字形  
回查詢結果 :::

詳目顯示

我願授權國圖
: 
twitterline
研究生:林立鴻
研究生(外文):Li-Hung Lin
論文名稱:企業工作流程與異質性資料庫之整合架構-以XML為基礎
論文名稱(外文):An XML-Based Framework for Business Workflow and Heterogeneous Database Integrating
指導教授:曾守正曾守正引用關係
學位類別:碩士
校院名稱:國立高雄第一科技大學
系所名稱:資訊管理所
學門:電算機學門
學類:電算機一般學類
論文種類:學術論文
論文出版年:2002
畢業學年度:90
語文別:中文
論文頁數:99
中文關鍵詞:企業應用系統整合異質性資料庫整合工作流程XMLRosettaNet
外文關鍵詞:RosettaNetEnterprise Application IntegrationXMLHeterogeneous Database IntegrationWork-Flow
相關次數:
  • 被引用被引用:2
  • 點閱點閱:221
  • 評分評分:
  • 下載下載:0
  • 收藏至我的研究室書目清單書目收藏:2
二十一世紀,可謂是「資訊科技促使企業策略變革」(Information technology enabled business model change) 的年代,從企業資源規劃 (Enterprise Resource Planning, ERP)、供應鏈管理 (Supply Chain Management, SCM)、顧客關係管理 (Customer Relationship Management, CRM) 及知識管理 (Knowledge Management, KM) 等課題,足以證明資訊科技已儼然成為企業增加核心競爭力的不二法門。

企業藉由資訊科技的力量來強化企業營運能力,是大勢所趨。雖然目前對於企業整合與經營管理相關之文獻並不少見,而近年來亦不少對相關性議題進行整合性之研究,但大都著重於理論架構之探討及概念性之陳述或,是資訊科技技術層面之研究,而實例個案所涵蓋的範圍亦不夠廣泛,因而促成本文研究的動機。

在本研究中,我們利用具描述資料及跨平台特性的 XML 語言,做為電子資料交換的資訊載體,並提出一個以 XML 為基礎的企業工程流程與異質性資料庫整合之雛型系統架構。當使用者操作該系統時,系統會自動產生一份 XML 文件,而觸發相對應的工作流程,在跨組織工作流程或異質性資料庫系統間達到資訊傳遞與整合的功能。其文件主要承載的資訊包含:相關公文資訊、流程描述、流程核銷記錄。並結合系統定義的映對文件轉換規則,同時達到異質性資料庫整合的目的。

本研究主要的成果包含了:
1.整理 XML 的相關資訊,如:XML 相關技術、XML 與 Database 的關係
2.整理 XML 在電子商務上的應用,如:RosettaNet、BizTalk、ebXML
3.提出一份符合 XML 規則的映對文件範本,該份文件可用來描述兩個不同資料端的資料如何對映與轉換
4.延伸 Wf-XML 的規範,定義一份通用的工作流程樣版文件 (Template Document),並套用經濟部「加工出口區貨品運出區外處理查驗聯單」案例,做為跨組織間的資訊交換載體
5.在實務的應用上,結合 SQL Server 2000 與 BizTalk Server 2000,提出一個跨組織工作流程與異質性資料庫整合的雛型系統

最後,希望藉由本研究所提出的企業工作流程與異質性資料庫整合的系統架構,可協助企業運用最低成本與最少時間,快速且有效的建置企業應用整合系統,達到「電子化企業」(Electronic Business, e-Business) 的目標。
In the 21th century, an era of information technology enabling business model change, it has been shown that information technology is the only way to increase enterprise’s completions for the reasons of flourishing researches in the issue of Enterprise Resource Planning (ERP), Supply Chain Management (SCM), Customer Relationship Management (CRM) and Knowledge Management (KM).

Businesses use information technology to enhance their operation capabilities in this trend of business reengineering. Recently, a great number of articles and integrated researches appear in the related fields. However, most of them are focus on theoretical explorations and conceptual discussions on information technology researches.

In this thesis, an XML-based prototypical structure for business workflow and heterogeneous database integration has been proposed. XML is a popular information media, which describes data and cross-platform property for electronic data interchange over the Internet. The system automatically generates an XML document and triggers corresponding to a well-defined workflow process, which integrates information and transfers between inter-organization workflows and heterogeneous database systems. The information included in an XML document is related to official document’s information, flow description, flow to cancel and verification. The system objective defines mapping transferring rules to integrate heterogeneous database simultaneously.

The contributions of this thesis includes:
1.A detailed survey on XML-related infromation, including the related techinques between XML and Databases.
2.A prototype system to promote the XML applications for E-Commance.
3.Exploreing the rules of XML mapping model which describes two different databases to be mapped and inter-changeably.
4.To extend Wf-XML’s standard to define a genernal workflow template document. We also apply an example workflow application of “Economic Processing Zone Adminisation Ministry of Economic Affairs” for a testbed of inter-organization information interchage.
5.Practically applying SQL Server 2000 and BizTalk Server 2000 to establish a prototype for inter-organization workflow and heterogeneous database integration.

By our proposed business workflow and integrated heterogeneous database system architecture, enterprises are supposed to reduce their cost to establish business workflow and heterogeneous database system integration.
壹、緒論1
一、研究背景與動機2
二、研究問題與研究目的4
三、研究流程6
四、論文架構7
貳、相關研究9
一、XML 簡介9
(一)XML 相關技術與特性9
(二)XML 與 EDI14
(三)XML 與 Database17
(四)XML 在電子商務上的應用20
二、異質性資料庫25
(一)異質性簡介25
(二)建立異質性資料庫系統27
(三)異質性綱要的整合問題28
三、工作流程29
(一)WfMC 之工作流程參考模式29
(二)Wf-XML Message Set31
(三)工作流程之路徑32
參、系統架構與建置34
一、系統模組介紹34
二、「映對文件」規範38
三、「工作流程表單」的規劃47
肆、以 XML 做異質性資料庫整合機制與案例51
一、異質性資料庫整合案例51
二、案例說明56
三、MAPPING DOCUMENT 整合機制58
四、XSL 整合機制60
(一)SQL Server 以 XML 格式發佈 (Publishing) 之架構61
(二)綱要結構差異的解決方案61
伍、跨組織工作流程管理與資訊交換架構66
一、以 WF-XML 為基礎的通用性工作流程管理系統設計架構66
二、案例說明68
三、加工出口區工作流程定義69
四、加工出口區的資訊載體格式說明70
陸、工作流程與異質性資料庫整合系統實作探討73
一、發展環境73
二、案例說明73
(一)資料庫設計74
(二)請購流程定義76
三、系統實作77
(一)系統文件流程圖77
(二)BizTalk Server 的訊息傳遞79
(三)SQL Server 擷取 XML文件資訊匯入關聯表81
四、系統表單說明82
(一)請購單的資訊載體功能說明82
(二)映對文件說明84
(三)轉換後文件 (orders.xml) 說明87
柒、結論與後續研究89
一、結論89
二、後續研究90
【參考文獻】91
[1]ACM Computing Surveys, A Special Issue on Heterogeneous Database, Vol.22, No. 3, Sep. 1990.[2]Alf Inge Wang., “Experience paper: Using XML to implement a workflow tool,” In 3rd Annual IASTED International Conference Software Engineering and Applications, Scottsdale, Arizona, USA, 6-8 October 1999.[3]Anand R. et al,. "Implementing Distributed Workflow Systems from XML Specifications,”.[4]Bergholz, A., “Extending Your Markup: An XML Tutorial,” IEEE Internet Computing, Vol. 4, No. 4, July-August 2000, pp.74-79.[5]Bertino, Elisa and Barbara Catania, “Integrating XML and Databases,” IEEE Computer, Vol. 5, No. 4, 2001, pp. 84-88.[6]Bosak, J., T. Bray, D. Connolly, E. Maler, G. Nicol, C.M. Sperberg-McQueen, L. Wood, and J. Clark, “W3C XML Specification DTD”, http://www.w3.org/XML/1998/06/xmlspec-report-19980910.htm[7]Bourret, R. et al; “A generic load/extract utility for data transfer between XML documents and relational databases,” Advanced Issues of E-Commerce and Web-Based Information Systems, 2000. WECWIS 2000. Second International Workshop on, 2000, pp.134 —143.[8]Bray, T., C. Frankston, A. Malhotra, “Document Content Description for XML”, http://www.w3.org/TR/NOTE-dcd[9]Bray, T., J. Paoli, C.M. Sperberg-McQueen, “Extensible Markup Language (XML) 1.0”, http://www.w3.org/TR/REC-xml.[10]Breitbart, Y., “Multidatabase Interoperability,” SIGMOD Record, Vol. 19, No. 3, 1990, pp. 53-60.[11]Breitbart, Y., P.L. Olson, and G.R. Thompson, “Database Integration in a Distributed Heterogeneous Database System,” Proc. of IEEE International Conference on Data Engineering, 1986, pp. 301-310.[12]Bukhres, O.A. and A.K. Elmagarmid (Eds.), Object-Oriented Multidatabase Systems: Solutions for Advanced Applications, Prentice-Hall, 1996.[13]Chan S. et al, “Applying a mediator architecture employing XML to retail inventory control,” Parallel and Distributed Processing Symposium, Proceedings 15th International , 2001, pp.1727 —1733.[14]Cheung, D. et al, “Distributed and scalable XML document processing architecture for E-commerce systems,” Advanced Issues of E-Commerce and Web-Based Information Systems, 2000. WECWIS 2000. Second International Workshop on , 2000, pp.152 —157.[15]CN 研究報告,” XML應用模式引介報告”,http://www.nii.org.tw/cnt/info/Report/20010202.htm[16]CN 研究報告,”XMLEDI 研究報告”, http://www.nii.org.tw/cnt/info/Report/20010102.htm[17]Czejdo, B., M. Rusinkiewicz, and D.W. Embley, “An Approach to Schema Integration and Query Formulation in Federated Database Systems,” Proc. of IEEE International Conf. on Data Engineering, 1987, pp. 477-484.[18]D. Skogan., “UML as a schema language for XML based data interchange,” Proc. of the 2nd International Conference on The Unified Modeling Language, 1999. [19]David C. Fallside, “XML Schema Part 0: Primer”, http://www.w3.org/TR/2001/REC-xmlschema-0-20010502/[20]David RR Webber, Using ebXML and Web Services,http://www.xmlglobal.com/xmlgupdate/Webber.pdf[21]Dayal, U. and H.Y. Hwang, “View Definition and Generalization for Database Integration in a Multi-database System,” IEEE Trans. on Software Engineering, Vol. 10, No. 6, 1984, pp. 628-644.[22]Deen, S.M., R.R. Amin, and M.C. Taylor, “Data Integration in Distributed Databases,” IEEE Trans. on software Engineering, Vol. 13, No. 7, 1987, pp. 860-864.[23]Deutsch, M., D. Fernandez, D. Florescu, A. Levy, D. Suciu, “XML-QL: A Query Language for XML”, http://www.w3.org/TR/NOTE-xml-ql.[24]Draper, D., A.Y. HaLevy, and D.S. Weld, “The Nimble XML data integration system”, Proceedings of 17th International Conference on Data Engineering, 2001, pp.155 —160.[25]Elmargamid, A. and C. Pu (Eds.), Special Issue on Heterogeneous Databases in A CM Computing Surveys, Vol. 22, No. 3, 1990.[26]eXcelon Corporation, eXcelon B2B Integration Server, http://www.exceloncorp.com/products/index.html.[27]G. Kappel et al, “XML and Relational Database Systems - A Comparison of Concepts,” International Conference on Internet Computing, Las Vegas, USA, June 2001, CSREA Press, 2001[28]German Shegalov et al, “XML-enabled Workflow Management for E-Services across Heterogeneous Platforms,” Proceedings of International Conference on Very Large Data Bases-VLDB[29]Heimbigner, D., D. McLeod, “A Federated Database Architecture for Information Management,” ACM Transactions on Office Information Systems, Vol. 3, No. 3, 1985, pp. 253-278.[30]Heinlein, C., “Workflow and process synchronization with interaction expressions and graphs,” Proc. 17th International Conference on Data Engineering, 2001, pp.243 —252.[31]Hsiao, D., “Tutorial on Federated Databases and Systems (Part 1)”, The International Journal on Very Large Data Bases─The VLDB Journal, Vol. 1, No. 1, 1992, pp. 127-179.[32]Hsiao, D., “Tutorial on Federated Databases and Systems (Part 2),” The International Journal on Very Large Data Bases─The VLDB Journal, Vol. 1, No. 2, 1992, pp. 285-322.[33]IBM Corporation, DB2 XML Extender, http://www.ibm.com, http://www-4.ibm.com/software/data/db2/extenders/xmlext/.[34]IEEE Computer, A Special Issue on Heterogeneous Distributed Database Systems, Vol. 24, No. 12, Dec., 1991.[35]Inmon, W.H., Building the Data Warehouse, New York, NY: John Wiley and Sons, 1993.[36]The Workflow Management Coalition,http://www.wfmc.org/[37]Kim, W., and J. Seo, “Classifying Schematic and Data Heterogeneity in Multidatabase Systems,” IEEE Computer, Vol. 24, No. 12, 1991, 12-18.[38]Klusch, Matthias, “Information agent technology for the Internet: A survey,” Data and Knowledge Engineering, Vol. 36, Issue: 3, March, 2001, pp. 337-372.[39]L. M. Haas et al, “Transforming heterogeneous data with database middleware: Beyond integration,” Data Engineering Bulletin, 1999.[40]Lee, B., et al., “Hypertext Markup Language: A Representation of Textual Information and Meta-information for Retrieval and Interchange”, IEEE Computer, 1994.[41]Litwin, W. and A. Abdellatif, “An Overview of the Multi-Database Manipulation Language MDSL,” Proc. of the IEEE, Vol. 75, No. 5, 1987, pp. 621-632.[42]Margaret A.Emmelhainz, Ph.D., Electronic Data Interchange, Van Nostrand Reinhold, 1990[43]Maryanski, F.J. and H.-J. Schek (Eds.) IEEE Computer, Special Issue on Distributed Heterogeneous Databases, Vol. 24, No. 12, 1991.[44]Michael zur Muehlen, A Framework for XML-based Workflow Interoperability The AFRICA Project, 2000.[45]Minrong Song and John Miller, “Repox: Xml Repository For Workflow Designs And Specifications,” Ismailcem Arpinar, August 2001.[46]Motro, A., “Superviews: Virtual Integration of Multiple Databases,” IEEE Trans. on Software Engineering, Vol. 13, No. 7, 1987, pp. 785-798.[47]Oracle Corporation, Internet File System (iFS), http://www.oracle.com/database/options/ifs.[48]R. Bourret, XML and Database, tech. report, Technical Univ. Darmstadt, 2000, http://www.rpbourret.com/xml/XMLAndDatabase.htm[49]Reddy, M.P., B.E. Prasad, P.G. Reddy, and A. Gupta, “A Methodology for Integration of Heterogeneous Databases,” IEEE Transactions on Knowledge and Data Engineering, Vol. 6, No. 6, 1994, pp. 920-933.[50]Robert J et al, “An XML framework for agent-based E-commerce,” Communications of the ACM, Volume: 42, Issue: 3, March 1999. [51]Robin Cover , RosettaNet, http://xml.coverpages.org/rosettaNet.html[52]Roussev, V. et al, “Integrating XML and object-based programming for distributed collaboration, Enabling Technologies: Infrastructure for Collaborative Enterprises, Proeedings.” IEEE 9th International Workshops on, 2000, pp. 254 —259.[53]Roy, J. and A. Ramanujan, “XML schema language: taking XML to the next level”, IEEE IT Professional, Vol. 3, No.2, Mar/Apr 2001, pp. 37-40.[54]Roy, J. and A. Ramanujan, “XML: Data''s Universal Language”, IEEE IT Professional, Vol. 2, No. 3, May-June 2000, pp.32-36.[55]Royappa, Andrew V., “Implementing Catalog Clearinghouses with XML and XSL”, Proc. the 1999 ACM Symposium on Applied Computing, Sept. 1999, pp.616-621.[56]Rys, M., “Bringing the Internet to your database: using SQL Server 2000 and XML to Build Loosely-Coupled Systems”, Proc. IEEE International Conf. on Data Engineering, 2001, pp. 465-472.[57]Seligman, L. and A. Rosenthal, “XML''s impact on databases and data sharing”, IEEE Computer, Vol. 34, No. 6, Jun. 2001, pp. 59-67.[58]Shanmugasundaram, J. et al, “Efficiently Publishing Relational Data as XML Documents,” Proc. International Conference on Very Large Data Bases, 2000.[59]Shi-Ming Huang, Kwan, I., Yen, D.C., Shang-Yuen Hsueh, “Developing an XML gateway for business-to-business commerce,” Web Information Systems Engineering, 2000. Proceedings of the First International Conference on, Volume: 2 , 2000, pp.67 —74.[60]Software AG Corp., Tamino native XML database management system, http://www.softwareag.com/tamino/technical/description.htm.[61]The BizTalk Framework Overview, http://www.biztalk.org/home/framework.asp[62]Timothy M. Chester, “Cross-Platform Integration with XML and SOAP”, IT Pro., 9-10, 2001[63]Tseng, F.S.C., A.L.P. Chen and W.P. Yang, “Answering Heterogeneous Database Queries with Degrees of Uncertainty,” Distributed and Parallel Databases─An International Journal, Vol.1, No.1, 1993, pp.281-302.[64]Tseng, F.S.C., J.J. Chiang and W.P. Yang, “Integration of Relations with Conflicting Schema Structures in Heterogeneous Database Systems,” Data and Knowledge Engineering, Vol.27, No.2, 1998, pp. 231-248.[65]W. van der Aalst., “Interorganizational workflows: An approach based on message sequence charts and Petri nets,” System Analysis and Modeling, Vol. 34, No. 3, 1999, pp.335-367.[66]W.M.P. van der Aalst and A. Kumar, "XML Based Schema Definition for Support of Inter-organizational Workflow," University of Colorado and University of Eindhoven report, 2000.[67]Workflow Management Coalition, “Workflow and Internet: Catalysts for Radical Change”, A WfMC White Paper [68]Workflow Management Coalition, “Workflow Standard ─ Interoperability Wf-XML Binding”, WfMC-TC-1023, Version 1.0, May 2000[69]Yan Zhang; Meilin Shi; Chunyu Miao; Zixin Zhuang; Xinxiang Chen, “Workflow interoperability - enabling e-business,” Computer Supported Cooperative Work in Design, The Sixth International Conference on, 2001, pp.403 —408.[70]Zisman, A., “An overview of XML”, Journal of Computing & Control Engineering, Vol. 11, No. 4, Aug. 2000, pp. 165-167.[71]林立鴻,曾守正與莊文模,以XML為基礎之跨組織工作流程管理與資訊交換架構之研究,第十三屆國際資訊管理學術研討會,五月,2002[72]侯君溥、羅偉碩著,”企業電子化與電子商務對我國中小企業的影響之探討”,電子商務暨企業電子化應用實務研討會,2001[73]梁定澎,電子商務理論與實務,台北:華泰,2000[74]陳會安,XML 網頁製作徹底研究,台北:旗標,2000/11[75]曾守正、周韻寰,資料庫系統進階實務,台北:儒林,1999[76]曾守正與林立鴻,Heterogeneous Database Integration Through XML for Data Warehouse Creation, 第七屆國際資訊管理研究暨實務研討會論文集,十二月,2001[77]曾守正與林立鴻,電子化企業的工作流程與異質性資料庫整合之研究,第一屆資訊時代管理研討會論文集,崑山大學主辦,五月,2002[78]黃逸華譯,e-Business 8 大原則‧5 步驟,台北,城邦文化,2002[79]樂為良譯,數位神經系統─與思考等快的明日世界,台北,商周出版,1999/03[80]鄭淑芬,電子商務整合方案實作─BizTalkServer 2000 與 XML,台北:培生,2001[81]蕭百齡,無廢話 XML,兩隻老虎工作室,http://www.2tigers.net[82]羅宜柔譯,快速回應:工作流程的魅力,台南:大偉
QRCODE
 
 
 
 
 
                                                                                                                                                                                                                                                                                                                                                                                                               
第一頁 上一頁 下一頁 最後一頁 top