수안이의 컴퓨터 연구실 :: 스타 스키마 데이터베이스 설계 (Designing the Star Schema Database)

By Craig Utley

Introduction

Creating a Star Schema Database is one of the most important, and sometimes the final, step in creating a data warehouse. Given how important this process is to our data warehouse, it is important to understand how me move from a standard, on-line transaction processing (OLTP) system to a final star schema (which here, we will call an OLAP system).

This paper attempts to address some of the issues that have no doubt kept you awake at night. As you stared at the ceiling, wondering how to build a data warehouse, questions began swirling in your mind:

What is a Data Warehouse? What is a Data Mart?
What is a Star Chema Database?
Why do I want/need a Star Schema Database?
The Star Schema looks very denomalized Won't I get in trouble for that?
Should I repaint the ceiling?

These are certainly burning questions. This paper will attempt to answer these questions, and show you how to build a star schema database to support decision support within your organization.

스타 스키마(Star schema) 설계에 대해서 정리하기 위해 글을 쓰다가 인터넷을 잠깐 검색해 보니, 아주 잘 씌여진 글이 있어서 웹 페이지와 파일 링크를 통해서 대신한다.

웹 페이지

http://ciobriefings.com/publications/wh ··· ult.aspx

파일

Designing the Star Schema Database.doc