Perbandingan Penggunaan Database OLTP dan Data Warehouse

Main Article Content

Spits Warnars

Abstract

As a permanent storage for business process transaction, database is a crucial and the needed for the system. Using database often does not match with the ability and functionality and even is it possible as theory said about using transaction database and beyond the advantages and disadvantages, separating using between transactional database and database for decision making will mine the ability and the powerful database as much as possible. Beside that daily transaction will increase the database capacity month by month and year by year and will decrease the performance, especially for customer daily services. Separating between database transaction and database for decision making will decrease connection to daily database transaction and increase daily database transaction as which is run by application and will implicate the increasing customer satisfaction. Moreover making the strategic reports for decision making never ever become a nightmare and unimportant thing. Differentiation efficiency for saving the amount of data byte and effectiveness the query speed in sql statement in order to make the decision making reports will be used as an approach for justification.

Downloads

Download data is not yet available.

Article Details

How to Cite
[1]
S. Warnars, “Perbandingan Penggunaan Database OLTP dan Data Warehouse”, CCIT (Creative Communication and Innovative Technology) Journal, vol. 8, no. 1, pp. 83-100, Sep. 2014.
Section
Articles

References

[1] Elmasri R. & Navathe S.B.,”Fundamentals of Database Systems”,Edisi4,Addison-Wesley,2003
[2] Wikramanayake G.N.& Goonetillake J.S., “Managing Very Large Databasesand Data Warehousing”, Sri Lankan Journal of Librarianship and Information Management, Vol. 2, No.1, pp. 22-29, 2006
[3] Porter M.E., “Strategy and the Internet”, Harvard Business Review, pp. 6278,2001.
[4] Ward J. & Peppard J.,”Strategic planning for Information Systems”,Edisi3,John Willey & Sons, Ltd, West Sussex, England,2003
[5] Ponniah P.,”Data Warehousing Fundamentals”, John Willey & Sons, Inc,New York, USA,2001
[6] Bara A., Lungu I., Velicanu M.,Botha I., “Improving query performance inVirtual Data Warehouses”, WSEAS transactions on Information Science and Applications, Vol.5, No.5,pp.632-641,2008.
[7] Chaudhuri S. & Dayal U.,”An overview of data warehousing and olaptechnology”, ACM SIGMOD Record, Vol. 26, No. 1, pp.65-74, 1997
[8] Pedersen T.B., Jensen C.S., Dyreson C.E.,”A foundation for capturing andquerying complex multidimensional data”, Information Systems, Vol. 26, No.5, pp.383-423, 2001
[9] Skyt J., Jensen C.S., Pedersen T.B., “Specification-based data reduction indimensional data warehouses”, Information Systems, Vol 33, No.1,pp. 3663, 2008
[10] Silva F.S.C., Panigassi R., Hulot C.,”Learning Management SystemsDesiderata for Competitive Universities”, European Journal of Open, Distance and E-Learning, Vol. 2, 2007