AnXML-BasedFrameworkforBusinessWorkflowandHeterogeneousDatabaseIntegrating

[[abstract]]二十一世紀，可謂是「資訊科技促使企業策略變革」(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) 的目標。[[abstract]]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