이수안 데이터 연구실

검색 :
RSS 구독 : 글 / 댓글 / 트랙백 / 글+트랙백

글 검색 결과

?ㅽ

2009/03/13 12:38, 글쓴이

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" 카테고리의 다른 글
2009/03/13 12:38 2009/03/13 12:38

맨 위로

Business Intelligence

2008/10/07 06:57, 글쓴이

Business intelligence (BI) refers to technologies, applications and practices for the collection, integration, analysis, and presentation of business information and sometimes to the information itself. The purpose of business intelligence--a term that dates at least to 1958--is to support better business decision making. Thus, BI is also described as a decision support system (DSS)

BI is sometimes used interchangeably with briefing books, report and query tools and executive information systems. In general, business intelligence systems are data-driven DSS.

BI systems provide historical, current, and predictive views of business operations, most often using data that has been gathered into a data warehouse or a data mart and occasionally working from operational data. Software elements support the use of this information by assisting in the extraction, analysis, and reporting of information. Applications tackle sales, production, financial, and many other sources of business data for purposes that include, notably, business performance management. Information may be gathered on comparable companies to produce benchmarks.



이올린에 북마크하기(0) 이올린에 추천하기(0)
"Database" 카테고리의 다른 글
2008/10/07 06:57 2008/10/07 06:57

맨 위로

?곗

2008/06/25 10:50, 글쓴이
<1遺
이올린에 북마크하기(0) 이올린에 추천하기(0)
"Data Warehouse" 카테고리의 다른 글
2008/06/25 10:50 2008/06/25 10:50

맨 위로