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

fYear

2002

fDate

10-11 Dec. 2002

Firstpage

267

Lastpage

270

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Semiconductor Manufacturing Technology Workshop, 2002

Print_ISBN

0-7803-7604-8

Type

conf

DOI

10.1109/SMTW.2002.1197444

Filename

1197444