Model-Driven Engineering: From SQL Relational Database to Column-Oriented Database in Big Data Context

被引：0
|
作者：
Belkadi, Fatima Zahra [1 ]
Esbai, Redouane [1 ]
机构：
[1] Mohammed First Univ, Oujda, Morocco
来源：
NETWORKING, INTELLIGENT SYSTEMS AND SECURITY | 2022年 / 237卷
关键词：
D O I：
10.1007/978-981-16-3637-0_47
中图分类号：
TP18 [人工智能理论];
学科分类号：
081104 ; 0812 ; 0835 ; 1405 ;
摘要：
The growth of application architectures in all areas (e.g., astrology, meteorology, E-commerce, social network, etc.) has resulted in an exponential increase in data volumes, now measured in Petabytes. Managing these volumes of data has become a problem that relational databases are no longer able to handle because of the acidity properties. In response to this scaling up, new concepts have emerged such as NoSQL. In this paper, we show how to design and apply transformation rules to migrate from an SQL relational database to a big data solution within NoSQL. For this, we use the model driven architecture (MDA) and the transformation languages like as MOF 2.0 QVT (Meta-Object Facility 2.0 Query-View-Transformation) and Acceleo which define the meta-models for the development of transformation model. The transformation rules defined in this work can generate, from the class diagram, a CQL code for creation column-oriented NoSQL database.
引用
收藏
页码：667 / 678
页数：12
相关论文
共 40 条
  • [31] SQL2XMI: Reverse Engineering of UML-ER Diagrams from Relational Database Schemas
    Alalfi, Manar H.
    Cordy, James R.
    Dean, Thomas R.
    [J]. FIFTEENTH WORKING CONFERENCE ON REVERSE ENGINEERING, PROCEEDINGS, 2008, : 187 - 191
  • [32] Data model for engineering design and its implementation using a link-oriented database'
    [J]. 1600,
  • [33] Gene-disease relationship discovery based on model-driven data integration and database view definition
    Yilmaz, S.
    Jonveaux, P.
    Bicep, C.
    Pierron, L.
    Smail-Tabbone, M.
    Devignes, M. D.
    [J]. BIOINFORMATICS, 2009, 25 (02) : 230 - 236
  • [34] Comparison and benchmarks for import of VPF geographic data from object-oriented and relational database files
    Arctur, D
    Anwar, E
    Alexander, J
    Chakravarthy, S
    Chung, MY
    Cobb, M
    Shaw, K
    [J]. ADVANCES IN SPATIAL DATABASES, 1995, 951 : 368 - 384
  • [35] Model-driven data mining engineering: from solution-driven implementations to 'composable' conceptual data mining models
    Cuzzocrea, Alfredo
    Mazon, Jose-Norberto
    Trujillo, Juan
    Zubcoff, Jose
    [J]. INTERNATIONAL JOURNAL OF DATA MINING MODELLING AND MANAGEMENT, 2011, 3 (03) : 217 - 251
  • [36] MDA Process to Extract the Data Model from Document-oriented NoSQL Database
    Brahim, Amal Ait
    Ferhat, Rabah Tighilt
    Zurfluh, Gilles
    [J]. PROCEEDINGS OF THE 21ST INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS (ICEIS), VOL 1, 2019, : 141 - 148
  • [37] Towards Model-Driven Engineering for Big Data Analytics - An Exploratory Analysis of Domain-Specific Languages for Machine Learning
    Breuker, Dominic
    [J]. 2014 47TH HAWAII INTERNATIONAL CONFERENCE ON SYSTEM SCIENCES (HICSS), 2014, : 758 - 767
  • [38] Binospec@MMT: A Database Driven Model of Operations, from Planning of Observations to Data Reduction and Archiving
    Chilingarian, Igor
    Moran, Sean
    Paegert, Martin
    Fabricant, Daniel
    Kansky, Jan
    Brown, Warren
    [J]. ASTRONOMICAL DATA ANALYSIS SOFTWARE AND SYSTEMS XXVIII, 2019, 523 : 629 - 632
  • [39] Data-driven thermal comfort model via support vector machine algorithms: Insights from ASHRAE RP-884 database
    Zhou, Xiang
    Xu, Ling
    Zhang, Jingsi
    Niu, Bing
    Luo, Maohui
    Zhou, Guangya
    Zhang, Xu
    [J]. ENERGY AND BUILDINGS, 2020, 211
  • [40] Designing and building an object-relational geoscientific database using the North American Conceptual Geology Map Data Model (NADM-C1) from an Australian perspective
    Simons, B
    Ritchie, A
    Bibby, L
    Callaway, G
    Welch, S
    Miller, B
    [J]. GIS and Spatial Analysis, Vol 1and 2, 2005, : 929 - 934
1234