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 条
  • [1] Optimization of Relational Database Usage Involving Big Data A Model Architecture for Big Data applications
    Durham, Erin-Elizabeth A.
    Rosen, Andrew
    Harrison, Robert W.
    [J]. 2014 IEEE SYMPOSIUM ON COMPUTATIONAL INTELLIGENCE AND DATA MINING (CIDM), 2014, : 454 - 462
  • [2] A Reference Architecture for Supporting Secure Big Data Analytics over Cloud-Enabled Relational Databases
    Cuzzocrea, Alfredo
    [J]. PROCEEDINGS 2016 IEEE 40TH ANNUAL COMPUTER SOFTWARE AND APPLICATIONS CONFERENCE WORKSHOPS (COMPSAC), VOL 2, 2016, : 356 - 358
  • [3] On extending the relational data model for relational databases with incomplete information
    Motzkin, D.
    [J]. Mathematical Modelling and Scientific Computing, 1993, 2 (sectiob):
  • [4] Studies of Big Data metadata segmentation between relational and non-relational databases
    Golosova, M. V.
    Grigorieva, M. A.
    Klimentov, A. A.
    Ryabinkin, E. A.
    Dimitrov, G.
    Potekhin, M.
    [J]. 21ST INTERNATIONAL CONFERENCE ON COMPUTING IN HIGH ENERGY AND NUCLEAR PHYSICS (CHEP2015), PARTS 1-9, 2015, 664
  • [5] Inductive databases in the relational model: The data as the bridge
    Kramer, Stefan
    Aufschild, Volker
    Hapfelmeier, Andreas
    Jarasch, Alexander
    Kessler, Kristina
    Reckow, Stefan
    Wicker, Joerg
    Richter, Lothar
    [J]. KNOWLEDGE DISCOVERY IN INDUCTIVE DATABASES, 2006, 3933 : 124 - 138
  • [6] Big data: Using databases and registries
    Jacob-Brassard, Jean
    de Mestral, Charles
    [J]. SEMINARS IN VASCULAR SURGERY, 2022, 35 (04) : 413 - 423
  • [7] Using relational databases for time series data
    Telnarova, Zdenka
    [J]. INTERNATIONAL CONFERENCE OF COMPUTATIONAL METHODS IN SCIENCES AND ENGINEERING 2018 (ICCMSE-2018), 2018, 2040
  • [8] Qualitative and quantitative temporal constraints and relational databases: theory, architecture, and applications
    Dipartmento Informatica, Università di Torino, Corso Svizzera 185, 10149 Torino, Italy
    不详
    不详
    [J]. IEEE Trans Knowl Data Eng, 6 (948-968):
  • [9] Qualitative and quantitative temporal constraints and relational databases: Theory, architecture, and applications
    Brusoni, V
    Console, L
    Terenziani, P
    Pernici, B
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1999, 11 (06) : 948 - 968
  • [10] Access control in very loosely structured data model using relational databases
    Pan, Ying
    Tang, Yong
    Liu, Hai
    [J]. Tien Tzu Hsueh Pao/Acta Electronica Sinica, 2012, 40 (03): : 600 - 606