Open Access Open Access  Restricted Access Subscription or Fee Access

Data Warehouse Development Based on Cloud Computing Using IBM Informix and IBM Cognos for Multifinance Industry

Dion Darmawan(1*), Chrissandy Fernando(2), Andree Gunawan(3), Julian Ivandi(4)

(1) Bina Nusantara University, Indonesia
(2) Bina Nusantara University, Indonesia
(3) Bina Nusantara University, Indonesia
(4) Bina Nusantara University, Indonesia
(*) Corresponding author



The purpose of this research is to design a cloud-based data warehouse system based on cloud computing in the multi finance industry, especially on the subject of sales area aimed at improving the operational performance of the system. There are two software used in designing a data warehouse system: IBM Informix Warehouse Feature Design Studio which is used for Extract, Transform, and Load (ETL) process and IBM Cognos Report Studio which is used for dashboard report sales area. The research methodology of this research is as follows: analysis through literature review, interviews, and observations. The data warehouse was designed using Ralph Kimball’s 9 stage of designing the data warehouse. The output of this research is a product of cloud-based data warehouse system that can be used by the finance industry on the sales subject area.
Copyright © 2016 Praise Worthy Prize - All rights reserved.


Data Warehouse; Cloud Computing; Multi-Finance; IBM Informix; IBM Cognos

Full Text:



Goswami, V., Patra, S. S., and Mund, G. B., Optimal Management of Cloud Centers with Different Arrival Modes for Cloud Computing Environment, International Journal of Cloud Applications and Computing, Vol. 2, n. 3, pp. 86-97, 2012.

Gandhi, V. C., Prajapati, J. A., and Darji, P. A., Cloud Computing with Data Warehousing, International Journal of Emerging Trends & Technology in Computer Science, Vol. 1, n. 3, pp. 72-73, 2012.

Aljabre, A., Cloud Computing for Increased Business Value. International Journal of Business and Social Science, Vol. 3, n.1, pp. 234-239, 2012.

Inmon, W.H., Hackathorn, and R.D., Using the data warehouse. (Somerset: Wiley-QED Publishing, 1994).

Jindal, R., & Taneja, S., Comparative Study Of Data Warehouse Design Approaches: A Survey. International Journal of Database Management Systems ( IJDMS ), Vol. 4, n. 1, pp. 33-45, 2012

W. H. Inmon, Building the Data Warehouse. (New York: John Wiley Sons Inc., 2005).

Ouf, S., & Nasr, M. The Cloud Computing: The Future of BI in the Cloud. International Journal of Computer Theory and Engineering. Vol. 3, n. 6, pp. 750-754, 2011.

Williams, B. K., & Sawyer, S. C., Using Information Technology. (New York: McGraw-Hill, 2011).

Connolly, T. M., & Begg, C. E., Database Systems A Practical Approach to Design, Implementation, and Management (Harlow: Pearson Education Limited, 2005).

O'Brien, J. A., & Marakas, G. M., Introduction to Information Systems. (New York: McGraw-Hill/Irwin, 2010).

Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., & Becker, B., The Data Warehouse Lifecycle Toolkit (Indianapolis: Wiley, 2008).

Gour, V., Sarangdevot, S. S., Tanwar, G. S., & Sharma, A., Improve Performance of Extract, Transform and Load (ETL) in Data Warehouse. International Journal on Computer Science and Engineering, Vol. 2, n. 3, pp. 786-789, 2010.

Reddy, G., Srinivasu, R., M., P. C., & Rikkula, S. R., Data Warehousing, Data Mining, OLAP, and OLTP Technologies are Essential Elements to Support Decision-Making Process in Industries. International Journal of Computer Science and Engineering. Vol. 2, n. 9, pp. 2865-2873, 2010.

Barathi, K. K., & Sree, K. S., Recent Developments on Data Warehouse and Data Mining In Cloud Computing. International Journal of Computer Science Engineering and Technology (IJCSET), Vol. 5, n.2, pp. 31-34, 2015

Gandhi, V. C., Prajapati, J. A., and Darji, P. A.. Cloud Computing with data warehousing and Analysis Market June 2009. International Journal of Emerging Trends & Technology in Computer Science (IJETTCS), Vol. 1, n. 3, 2012

Reynaud, C., Pernelle, N., & Rousset, M., Data Extraction, Transformation and Integration Guided by an Ontology. International Journal of Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction, Vol. 1, n. 6, pp. 17-37, 2012

Verma, H., Data-warehousing on Cloud Computing. International Journal of Advanced Research in Computer Engineering & Technology (IJARCET), Vol. 2, n. 2, 2013

Wilder, B., Cloud Architecture Patterns (Sebastopol: O'Reilly Media, 2012).

Cognos Business Intelligence and Enterprise Performance Management, Retrieved September 13, 2016, from

Kirankumar, G., Sunil, K. J., Avinash, R. K., Analysis of Using a Business Intelligence Tool (COGNOS) in a Company to Result in More Efficient and Intuitive Company in the Current Era. Business Intelligence Journal, Vol. 5, n.2, 2012

Nabri, H., Ouazar, D., Hasnaoui, M., Spatial Data Warehouse Modeling at the Watershed Scale. Part 1: Design Aspects, (2015) International Journal on Information Technology (IREIT), 3 (4), pp. 124-130.


  • There are currently no refbacks.

Please send any question about this web site to
Copyright © 2005-2022 Praise Worthy Prize