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

Jun-Ho Lee; Joo Kyung-Soo

doi:https://doi.org/10.9708/jksci.2018.23.03.049

Journal of The Korea Society of Computer and Information

Abbr : JKSCI
2018, 23(3), pp.49-54
DOI :https://doi.org/10.9708/jksci.2018.23.03.049
Publisher : The Korean Society Of Computer And Information
Research Area : Computer Science

Jun-Ho Lee ¹ , Joo Kyung-Soo ²

¹ 순천향대학교
² 순천향대학교

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

Data warehouse , NoSQL , MongoDB , Design Methodology
REFERENCES (12)

[journal] Jacobs, A. / 2009 / The pathologies of big data / Communications of the ACM 52 (8) : 36~44

[journal] Stonebraker, M. / 2012 / New Opportunities for New SQL / Communications of the ACM 55 (11) : 10~11

[confproc] Cuzzocrea, Alfredo / 2013 / Data warehousing and OLAP over big data: current challenges and future research directions / Proceedings of the sixteenth international workshop on Data warehousing and OLAP

[confproc] Dehdouh, Khaled / 2014 / Columnar nosql star schema benchmark / International Conference on Model and Data Engineering

[confproc] Chevalier M / 2015 / Implementing Multidimensional Data Warehouses into NoSQL / 17th International Conference on Enterprise Information Systems 1 : 172~183

[book] W.H.Inmon / 2002 / Building the Data Warehouse / John Wiley & Sons

[confproc] Pereira, Daniel / 2015 / 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

[journal] Bicevska, Zane / 2017 / Towards NoSQL-based Data Warehouse Solutions / Procedia Computer Science 104 : 104~111 / 10.1016/j.procs.2017.01.080

[book] Michael Dirolf / 2013 / MongoDB The Definitive Guide / O'ReillyMedia

[book] Christopher Adamson / 2010 / Star Schema The Complete Reference / McGraw-Hill Osborne

[confproc] Mamenko, J. / 2004 / Introduction to data modeling and msaccess / Lecture Notes on Information Resources

[book] Hoberman, S. / 2014 / DataModeling for MongoDB / Technics Publications
KCI Citation (0)

KJC Korea
Journal Central

Statistics

Tools