New approach for implementing big datamart using NoSQL key-value stores

被引:0
作者
Khalil, Abdelhak [1 ]
Belaissaoui, Mustapha [1 ]
机构
[1] Hassan First Univ Settat, LEFCG SIAD Lab, Settat, Morocco
来源
PROCEEDINGS OF 2020 5TH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING AND ARTIFICIAL INTELLIGENCE: TECHNOLOGIES AND APPLICATIONS (CLOUDTECH'20) | 2020年
关键词
DataMart; NoSQL; Decision support systems; Big Data;
D O I
10.1109/CloudTech49835.2020.9365897
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Nowadays, NoSQL technologies are gaining significant ground and considered as the future of data storage, especially when it comes to huge amount of data, which is the case of data warehouse solutions. NoSQL databases provide high scalability and good performance among relational ones, which are really time consuming and can't handle large data volume. The growing popularity of the term NoSQL these days and vaguely related phrases like big data make us think about using this technology in decision support systems. The purpose of this paper is to investigate the possibility to instantiate a big data mart under one of the most popular and least complicated types of NoSQL databases; namely key-value store, the main challenge is to make a good correlation between the old-school approach of data warehousing based on traditional databases that favor data integrity, and interesting opportunities offered by new generation of database management systems. The paper describes the transformation process from multidimensional conceptual schema to the logical model following three approaches, and outlines a list of strengths and weaknesses for each one based on practical experience under Oracle NoSQL Database.
引用
收藏
页码:131 / 136
页数:6
相关论文
共 21 条
  • [11] Dehdouh K, 2014, LECT NOTES COMPUT SC, V8748, P281, DOI 10.1007/978-3-319-11587-0_26
  • [12] KHALIL A., BENCHMARK GENERATOR
  • [13] Kimball R., 2013, KIMBALL DIMENSIONAL, P1, DOI [10.1016/B978-0- 12-411461-6.00009-5, DOI 10.1016/B978-0-12-411461-6.00009-5]
  • [14] Nayak Ameya., 2013, INT J APPL INFORM SY, V5, P16, DOI [10.5120/ijais12-450888, DOI 10.5120/IJAIS12-450888]
  • [15] Obay M. A. M., 2014, INT J COMPUT INF SCI, V3, P2279
  • [16] Pticek M, 2017, P 2017 INT C CLO BIG, P6
  • [17] Rahman M. N. A., 2011, INTELL SYST APPL, V2, P8854, DOI [10.1007/978-3-319-53480-0, DOI 10.1007/978-3-319-53480-0]
  • [18] Sellami G. F., 2018, TRANSFORMATION DATA, P410, DOI [10.1007/978-3-030-16660-1_41, DOI 10.1007/978-3-030-16660-1_41]
  • [19] TPC, 2015, NO TITL NO TITL
  • [20] Automatic Transformation of Data Warehouse Schema To NoSQL Data Base: Comparative Study
    Yangui, Rania
    Nabli, Ahlem
    Gargouri, Faiez
    [J]. KNOWLEDGE-BASED AND INTELLIGENT INFORMATION & ENGINEERING SYSTEMS: PROCEEDINGS OF THE 20TH INTERNATIONAL CONFERENCE KES-2016, 2016, 96 : 264 - 273