이수안 데이터 연구실

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.

?ㅽ

(0) (0)

"Data Warehouse" 카테고리의 다른 글

• ?ㅽ (0)2009/03/13
• ?곗 (0)2008/06/25

트랙백 없음 | 댓글 없음

트랙백+댓글 | 트랙백 | 댓글