Development Application of A Data Mart Model Using ETL for B2B Systems in the Semiconductor Industry

碩士 === 元智大學 === 資訊工程學系 === 101 === As we know,the Semiconductor industry has been one of the most important industries in Taiwan. Therefore,how to maintain the semiconductor industry's competitive advantage is a considerable importance topic. In this highly competitive era,all semiconductor...

Full description

Bibliographic Details
Main Authors: Chung-Chang Chang, 張永昌
Other Authors: Chin-Feng Fan
Format: Others
Language:zh-TW
Online Access:http://ndltd.ncl.edu.tw/handle/78363034989793478400
Description
Summary:碩士 === 元智大學 === 資訊工程學系 === 101 === As we know,the Semiconductor industry has been one of the most important industries in Taiwan. Therefore,how to maintain the semiconductor industry's competitive advantage is a considerable importance topic. In this highly competitive era,all semiconductor companies and others have to use the supply chain way to get the common interest. Therefore,the competition of semiconductor industry can be thought as the competition between the semiconductor supply chains. Early on,enterprises are by phone,fax,or E-Mail way to process their data transmission. Today,most companies use the Peer to Peer B2B platform to perform the information transfer and integration. However,in today's very complex semiconductor supply chain situation,using the Peer to Peer B2B platform as the data integration strategy will face two major challenges: (1) Too many manufacturers are involved in the supply chain. Each semiconductor manufacturers need to do a lot of customization to meet the requirements. (2) Too many internal systems using the integrated data. All internal systems need to do a lots of customizations to fulfill the requirement of information transfer and integration. This paper is going to use the common Data Mart (E-R Model) B2B system to design a all-function business process integration mechanism.By "use ETL implementations heterogeneous systems integration" approach to handle the Supply Chain information integration issues.Our preliminary implementation results show that this approach is successful.It not only supports the close interaction、information sharing between different systems,but also enhances the scope of enterprise IT Services.