Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2004.11D.4.967

Proposal And Application of An OLAP View For the Definition of the Users Requirements  

Choi, Sung-Kyo (삼척대학교 컴퓨터공학과)
Park, Jong-Mo (단국대학교 대학원 전산통계학과)
Publication Information
The KIPS Transactions:PartD / v.11D, no.4, 2004 , pp. 967-974 More about this Journal
Abstract
An OLAP system is the decision support tool with which a user can analyze the information interactively in the various aspects. However, the traditional existing construction of an OLAP system has the inefficiency problem of increasing the time and cost caused by the frequent changes of the users requirements. In this paper, we analyse existing construction procedure of OLAP systems and propose a prototyping OLAP View based on the star schema which can help and guide the designer In supporting efficiently of users requirements. Through an implementation of S shopping mall using the OLAP View, we show that our proposal is able to support OLAP construction strategy and provide accurate understanding of data resources. With an OLAP View, we can reduce the required time and cost of implementing OLAP system.
Keywords
OLAP(OnLine-Analysis Process); Datawarehouse; OLAP View; Star Schema;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Tryfoan, N., Busborg, F. and Chritiansen, J. G. B., 'starER : A conceptual Model for Data Warehouse Design,' Proc. of DOLAP, 1999   DOI
2 MS Enterprise 2001, '삼성몰 분석CRM 사례', 위세아이텍, October, 2001
3 Pendse, N. and Creeth, R., 'The OLAP Report : Succeeding with on line analytical processing,' Vol.1, Business Intelligence
4 Kimball, R., Reeves. L., Roos, M. and Thornthwaite, W., 'The Data Warehouse LifeCycle Toolkit,' New York : John Wiley and Sons Inc., 1998
5 Poe, V., 'Building a Data Warehouse for Decision Support,' Upper Saddle River, Prentice Hall, 1996
6 Immon, W. H., Building the Data Warehouse, 2nd Ed. New York : John Wiley and Sons Inc., 1996
7 Gray Mogyorodi, 'What is Requriement based Testing?,' Technology Builder Inc, http://www.tbi.com/products/asq/
8 Dean Leffingwell, 'Calculating Your Return on Investment from More Effective Requirements Management,' Rational Software Corporaton, http://www.rational.com/products/reqpro/whitepapers.jsp, 1997
9 M. Golfarelli and S. Rizzi, 'A Methodological Framework for Data Warehouse Design,' Proc. of DOLAP, pp.3-9, 1998   DOI
10 Kimball, R., 'A Dimensional Manifesto,' DBMS, August, 1997
11 Microsoft 구축사례, 'SQP 서버 2000 기반의 DW/OLAP', 삼양사, http://www.microsoft.com/korea/sql/evaluation/casestudies/2000/samyang.asp, December, 2001
12 권오주, 'OLAP Solutions + ${\alpha}$', 대림출판사, 2001