Steven Lim


Abstract : The purpose of this research is to design a data warehouse in accordance with the requirements of PT. Lippo Karawaci, Tbk. The company is engaged in the field of property ranging from land acquisition through construction and its maintenance. Designing a data warehouse is limited to the sale. The use of data warehouse is expected to support the information needs of executives in business decisions quickly. The method used is the method of analysis and design. Method of analysis was done through literature study and interviews with relevant parties. Design method is done by determining the process, grain, dimensions, facts, measure, and the mapping OLTP to data warehouse, which is followed by physical design. The results of this study is a data warehouse application systems that include data warehousing, OLAP cube, and an application system that is used to access the data warehouse. Implementation of data warehouse has been evaluated by the evaluation results associated with the display, the benefits and accuracy of application data.

Keyword : Data warehouse, Cube, Measure, Dimention, Data Transformation Service (DTS)


Data warehouse; Cube; Measure; Dimention; Data Transformation Service (DTS);

Full Text:



Connolly, Thomas dan Begg, Carolyn. 2005. Database Systems: A Pratical Approach to

Design, Implementation, and Management. Fourth Edition. Eddison-Westley:

Harlow England.

Hutabarat,Bernaridho. 2005. Datawarehousing dengan SQL Server 2005. PT Elex

Media Komputindo,Jakarta

Inmon, W.H. 2005. Building the Data Warehouse. Fourth Edition. John Wiley & Sons,

Inc, Amerika.

Kimball, Ralph. 2002. The Data Warehouse Toolkit. Second Edition. John Wiley &

Sons, Inc, Amerika.

Markus, 2007, Bussiness Intelligence dengan SQL Server 2005,

Mulyadi. 2001. Sistem Akutansi. Edisi ke-3. Salemba Empat, Jakarta.

Mundy,J.,Thornthwaite,W., dan Kimball,R. 2006. The Microsoft Data Warehouse

Toolkit: With SQL Server 2005 and the Microsoft Bussiness Inteligence

Toolset. Wiley Publishing, Inc, Indiana.

Rob,Peter dan Coronel,Carlos.2002. Database Systems : Design, Implementation, &

Management. 5th Edition. Thomson Learning.


Article Metrics

Abstract view : 524 times
PDF - 3069 times


  • There are currently no refbacks.

Copyright (c) 2015 SISFOTENIKA

Badan Pengelola Jurnal Ilmiah Sistem Informasi dan Teknik Informatika (SISFOTENIKA) STMIK Pontianak.


Jurnal Ilmiah SISFOTENIKA terindex di :











ISSN Printed : 2087-7897

ISSN Online : 2460-5344


Jurnal Ilmiah SISFOTENIKA Terakreditasi Peringkat Empat


Partners & Co-Organizers:

Lisensi Creative Commons

Jurnal Ilmiah SISFOTENIKA: STMIK Pontianak Online Journal ISSN Printed (2087-7897) - ISSN Online (2460-5344) licensed under a Lisensi Creative Commons Atribusi 4.0 Internasional. Flag Counter

View My Stats>