Title :
TSMC turnkey data mart
Author :
Hsieh, Dennys Sung-Ting ; Feng, Eric Cheng-Chin ; Liu, Wei-Ling ; Chung, I-Chieh
Author_Institution :
Taiwan Semicond. Manuf. Corp., Hsin-Chu, Taiwan
Abstract :
TSMC turnkey data mart is the collection of databases, designed to help managers make strategic decisions about their business. It focuses on operation management department and aid their managers and planners to get useful information from the system. The data mart creation service moves data from a variety of sources such as ERP system, B2B transaction system, Supply Chain Management system, EDA system and MES databases to build the Turnkey data mart. The data mart creation is used by IT administrators to deliver star or snowflake schemas, which present multi-dimensional models of data warehouses. The dimensional model contains the same information as found in a complex Entity Relationship model, but it makes the information easier to understand, facilitates querying and is resilient to change.
Keywords :
data warehouses; enterprise resource planning; management information systems; manufacturing systems; semiconductor device manufacture; supply chain management; EDA system; IT administrator; TSMC; data warehouses; entity relationship model; manufacturing execution system; multidimensional model; operation management department; snowflake schemas; star schemas; supply chain management system; transaction system; turnkey data mart; Assembly; Data warehouses; Electronic design automation and methodology; Enterprise resource planning; Radar; Semiconductor device manufacture; Subcontracting; Supply chain management; Testing; Transaction databases;
Conference_Titel :
Semiconductor Manufacturing Technology Workshop, 2002
Print_ISBN :
0-7803-7604-8
DOI :
10.1109/SMTW.2002.1197444
