Journal of the Korea Society of Computer and Information (한국컴퓨터정보학회논문지)

Korean Society of Computer Information (한국컴퓨터정보학회)
권호 표지
DOI QR코드

DOI QR Code

Development of the Design Methodology for Large-scale Data Warehouse based on MongoDB

  • Lee, Junho (Dept. of Computer Science, Soonchunhyang University) ;
  • Joo, Kyungsoo (Dept. of Computer Software Engineering, Soonchunhyang University)
  • Received : 2017.12.06
  • Accepted : 2018.03.08
  • Published : 2018.03.30
Download PDF
⟨ Previous Next ⟩

Abstract

A data warehouse is a system that collectively manages and integrates data of a company. And provides the basis for decision making for management strategy. Nowadays, analysis data volumes are reaching critical size challenging traditional data ware housing approaches. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we extend the data warehouse design methodology based on relational database using star schema, and have developed a consistent design methodology from information requirement analysis to data warehouse construction for large scale data warehouse construction based on MongoDB, one of NoSQL.

Keywords

References

  1. Jacobs, A., "The pathologies of big data," Communications of the ACM, 52(8), pp. 36-44, 2009. https://doi.org/10.1145/1536616.1536632
  2. Stonebraker, M., "New Opportunities for New SQL," Communications of the ACM, Vol.55, issue11 pp. 10-11, 2012 https://doi.org/10.1145/2366316.2366319
  3. Cuzzocrea, Alfredo, Ladjel Bellatreche, and Il-Yeol Song., "Data warehousing and OLAP over big data: current challenges and future research directions," Proceedings of the sixteenth international workshop on Data warehousing and OLAP. ACM, 2013.
  4. Dehdouh, Khaled, Omar Boussaid, and Fadila Bentayeb., "Columnar nosql star schema benchmark," International Conference on Model and Data Engineering. Springer, Cham, 2014.
  5. Chevalier M, El Malki M, Kopliku A, Teste O, Tournier R., "Implementing Multidimensional Data Warehouses into NoSQL," 17th International Conference on Enterprise Information Systems, Vol.1, pp. 172-183, 2015.
  6. W.H.Inmon., "Building the Data Warehouse." John Wiley & Sons, 2002.
  7. Pereira, Daniel, Paulo Oliveira, and Fatima Rodrigues. "Data warehouses in MongoDB vs SQL Server: A comparative analysis of the querie performance." Information Systems and Technologies (CISTI), 2015 10th Iberian Conference on. IEEE, 2015.
  8. Bicevska, Zane, and Ivo Oditis. "Towards NoSQL-based Data Warehouse Solutions." Procedia Computer Science 104, pp 104-111, 2017. https://doi.org/10.1016/j.procs.2017.01.080
  9. Michael Dirolf, "MongoDB The Definitive Guide." O'ReillyMedia, 2013.
  10. Christopher Adamson, "Star Schema The Complete Reference," McGraw-Hill Osborne, 2010.
  11. Mamenko, J. "Introduction to data modeling and msaccess," Lecture Notes on Information Resources, 2004.
  12. Hoberman, S., "DataModeling for MongoDB," Technics Publications, 2014.