데이터 웨어하우스 설계에서 다차원 모델링에 관한 연구 = A study on the Multi Dimensional Modeling in the Data Warehouse Design

다국어 초록 (Multilingual Abstract)

The definition of the data warehouse which is proposed is : A corporate data warehouse is a single integrated store of data which provides the infrastructural basis for informational software applications in the enterprise. The Corporate data warehouse may be defined in terms of six key characteristics which differentiate the data warehouse from other database systems in the enterprise.
(1) Available entirely for the task of making data available to be interrogated by business users.
(2) Separate from the operational system in the enterprise and populated by data from these systems.
(3) Integrated on the basis of a standard enterprise model.
(4) Time stamped and associated with defined periods of time, i. e. calendar periods or fiscal reporting periods.
(5) Subject oriented, most usually on the basis of 'Customer'.
(6) Accessible to users who have a limited knowledge of computer systems or data structures.
The multidimensional database systems differ from relational database systems in that they are currently highly proprietary in nature, typically do not directly support SQL, and can support significantly less volume of data than even an "average"RDBMS. However, multidimensional database systems may be an excellent option for a departmental instance if the functionality it provides is what the business requirements of the target user demand.
In the coming 'Age of Information', data will not just comprise entities in a database which have got attributes and relations but data will have texture through which hidden structures and patterns can be revealed. This will fundamentally transform our understanding of information from 'something we desire to know' to 'something which could never have otherwise been knowable'.

목차 (Table of Contents)

• Ⅰ. 서론
• Ⅱ. 데이터 웨어하우스의 정의와 등장 배경
• 1. 정의
• 2. 등장배경
• Ⅲ. 데이터 웨어하우스 설계를 위한 다차원 모델링
• 1. 관계형 DB의 한계와 다차원DB의 출현
• 2. 다차원 DB와 모델링
• 3. 관계형 테이터베이스와의 연계
• 4. 다차원 데이터 하우스의 설계
• Ⅳ. 결론
• 참고문헌
• Abstract