Title :
A model architecture for Big Data applications using relational databases
Author :
Durham, Erin-Elizabeth A. ; Rosen, Arye ; Harrison, Robert W.
Author_Institution :
Dept. of Comput. Sci., Georgia State Univ., Atlanta, GA, USA
Abstract :
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.
Keywords :
Big Data; SQL; query processing; relational databases; software architecture; Big Data applications; MySQL; data analytics; data handling; database management systems; decision requests; decisioned result retrieval time; model architecture; optimal user satisfaction; querying; response wait times; standard relational SQL database; stored large datasets; Big data; Companies; Databases; Modems; Software; Standards; Big Data analysis; Business Intelligence; Data Mining; Relational database; SQL; materialized view; query; query optimization;
Conference_Titel :
Big Data (Big Data), 2014 IEEE International Conference on
Conference_Location :
Washington, DC
DOI :
10.1109/BigData.2014.7004462