A Model Architecture for Big Data applications using Relational Databases

被引:0
|
作者
Durham, Erin-Elizabeth A. [1 ]
Rosen, Andrew [1 ]
Harrison, Robert W. [1 ]
机构
[1] Georgia State Univ, Dept Comp Sci, Atlanta, GA 30303 USA
关键词
Relational database; SQL; query; query optimization; materialized view; Data Mining; Business Intelligence; Big Data analysis;
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Effective Big Data applications dynamically handle the retrieval of decisioned results based on stored large datasets efficiently. One effective method of requesting decisioned results, or querying, large datasets is the use of SQL and database management systems such as MySQL. But a problem with using relational databases to store huge datasets is the decisioned result retrieval time, which is often slow largely due to poorly written queries / decision requests. This work presents a model to re-architect Big Data applications in order to efficiently present decisioned results: lowering the volume of data being handled by the application itself, and significantly decreasing response wait times while allowing the flexibility and permanence of a standard relational SQL database, supplying optimal user satisfaction in today's Data Analytics world. In this paper we review a Big Data case study in the telecommunications field and use it to experimentally demonstrate the effectiveness of our approach.
引用
下载
收藏
页数:8
相关论文
共 50 条
  • [41] Beyond Relational Databases: Preserving the Data
    Ramalho J.C.
    Ferreira B.
    Faria L.
    Ferreira M.
    New Review of Information Networking, 2020, 25 (02) : 107 - 118
  • [42] Export of Relational Databases to RDF Databases by Model Transformations
    Rikacovs, Sergejs
    PERSPECTIVES IN BUSINESS INFORMATICS RESEARCH, 2011, 90 : 158 - 166
  • [43] From Databases to Big Data
    Madden, Sam
    IEEE INTERNET COMPUTING, 2012, 16 (03) : 4 - 6
  • [44] Managing Unstructured Data in Relational Databases
    Yafooz, Wael M. S.
    Abidin, Siti Z. Z.
    Omar, Nasiroh
    Idrus, Zanariah
    2013 IEEE CONFERENCE ON SYSTEMS, PROCESS & CONTROL (ICSPC), 2013, : 198 - 203
  • [45] Model-based vehicular prognostics framework using Big Data architecture
    Petrillo, Alberto
    Picariello, Antonio
    Santini, Stefania
    Scarciello, Biagio
    Sperli, Giancarlo
    COMPUTERS IN INDUSTRY, 2020, 115
  • [46] A Multiagent Architecture for Semantic Access to Legacy Relational Databases
    Polajnar, Desanka
    Zubayer, Mohammad
    Polajnar, Jernej
    2012 IEEE INTERNATIONAL SYSTEMS CONFERENCE (SYSCON), 2012, : 248 - 255
  • [47] Publishing Linked Data from Relational Databases Using Traditional Views
    Chen, Lei
    Yao, Nansheng
    PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 6, 2010, : 9 - 12
  • [48] Query Processing over Data Warehouse using Relational Databases and NoSQL
    Carniel, Anderson Chaves
    Sa, Aried de Aguiar
    Porto Brisighello, Vinicius Henrique
    Ribeiro, Marcela Xavier
    Bueno, Renato
    Ciferri, Ricardo Rodrigues
    de Aguiar Ciferri, Cristina Dutra
    2012 XXXVIII CONFERENCIA LATINOAMERICANA EN INFORMATICA (CLEI), 2012,
  • [49] Extraction and applications of statistical relationships in relational databases
    Hou, WC
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1996, 8 (06) : 939 - 945
  • [50] Algorithms and applications for universal quantification in relational databases
    Rantzau, R
    Shapiro, LD
    Mitschang, B
    Wang, Q
    INFORMATION SYSTEMS, 2003, 28 (1-2) : 3 - 32