The week's pick
Random Articles
Reseach Article
A Preliminary Study of OLAP Queries under different Database Models
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 153 - Number 8 |
| Year of Publication: 2016 |
| Authors: Cesar De Carvalho, Eduardo Ogasawara, Ana Beatriz Cruz Silva |
10.5120/ijca2016912127
|
Cesar De Carvalho, Eduardo Ogasawara, Ana Beatriz Cruz Silva . A Preliminary Study of OLAP Queries under different Database Models. International Journal of Computer Applications. 153, 8 ( Nov 2016), 1-5. DOI=10.5120/ijca2016912127
Abstract
From the continuous growth of data that arises in this new era of Big Data, the old assumption of one size fits all solutions is no longer valid. There is a huge effort in development alternatives for relational model. Generally, the study of these databases models targets in providing solutions that increase performance of different applications. For example, in nowadays applications, such as Big Table analysis, analytic queries typically encompass aggregations of huge datasets. To allow for data analysis to occur in a feasible time, it is necessary for database systems to offer good performance in ETL (extract, transform, and load) operations. This paper briefly presents the performance of some representative database models in addressing a set of analytical queries.
References
- Min Chen, Shiwen Mao, and Yunhao Liu. Big data: A survey. Mobile Networks and Applications, 19(2):171–209, 2014.
- HV Jagadish, Johannes Gehrke, Alexandros Labrinidis, Yannis Papakonstantinou, JigneshMPatel, Raghu Ramakrishnan, and Cyrus Shahabi. Big data and its technical challenges. Communications of the ACM, 57(7):86–94, 2014.
- ABM Moniruzzaman and Syed Akhter Hossain. Nosql database: New era of databases for big data analyticsclassification, characteristics and comparison. arXiv preprint arXiv:1307.0191, 2013.
- Eric Brewer. Cap twelve years later: How the” rules” have changed. Computer, 45(2):23–29, 2012.
- Ioannis Alagiannis, Renata Borovica, Miguel Branco, Stratos Idreos, and Anastasia Ailamaki. Nodb: efficient query execution on raw data files. In Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data, pages 241–252. ACM, 2012.
- Amir Gandomi and Murtaza Haider. Beyond the hype: Big data concepts, methods, and analytics. International Journal of Information Management, 35(2):137–144, 2015.
- Shashi Shekhar, Viswanath Gunturi, Michael R Evans, and KwangSoo Yang. Spatial big-data challenges intersecting mobility and cloud computing. In Proceedings of the Eleventh ACM International Workshop on Data Engineering for Wireless and Mobile Access, pages 1–6. ACM, 2012.
- Nikos Pelekis and Yannis Theodoridis. Mobility data management and exploration. Springer, 2014.
- Hasso Plattner. A common database approach for oltp and olap using an in-memory column database. In Proceedings of the 2009 ACM SIGMOD International Conference on Management of data, pages 1–2. ACM, 2009.
- Daniel J Abadi, Samuel R Madden, and Nabil Hachem. Column-stores vs. row-stores: how different are they really? In Proceedings of the 2008 ACM SIGMOD international conference on Management of data, pages 967–980. ACM, 2008.
- Abraham Silberschatz, Henry F Korth, S Sudarshan, et al. Database system concepts, volume 4. McGraw-Hill Singapore, 1997.
- Ramez Elmasri and Shamkant B Navathe. Fundamentals of database systems. Pearson, 2014.
- Mike Stonebraker, Daniel J Abadi, Adam Batkin, Xuedong Chen, Mitch Cherniack, Miguel Ferreira, Edmond Lau, Amerson Lin, Sam Madden, Elizabeth O’Neil, et al. C-store: a column-oriented dbms. In Proceedings of the 31st international conference on Very large data bases, pages 553–564. VLDB Endowment, 2005.
- Eelco Plugge, Tim Hawkins, and Peter Membrey. The Definitive Guide to MongoDB: The NoSQL Database for Cloud and Desktop Computing. Apress, Berkely, CA, USA, 1st edition, 2010.
- Michael Stonebraker. Sql databases v. nosql databases. Communications of the ACM, 53(4):10–11, 2010.
- Kristina Chodorow. MongoDB: the definitive guide. ” O’Reilly Media, Inc.”, 2013.
- Surajit Chaudhuri and Umeshwar Dayal. An overview of data warehousing and olap technology. ACM Sigmod record, 26(1):65–74, 1997.
- TPC. The TPC Benchmark H. http://www.tpc.org/ tpch/, 2016.
- TPC. TPC - Current Specifications. http: //www.tpc.org/tpc_documents_current_versions/ current_specifications.asp/, 2016.
- Fay Chang, Jeffrey Dean, Sanjay Ghemawat,Wilson C Hsieh, Deborah AWallach, Mike Burrows, Tushar Chandra, Andrew Fikes, and Robert E Gruber. Bigtable: A distributed storage system for structured data. ACM Transactions on Computer Systems (TOCS), 26(2):4, 2008.
- The PostgreSQL Global Development Group. PostgreSQL: The world’s most advanced open source database. https: //www.postgresql.org/, November 2016.
- MonetDB B.V. The column-store pioneer — MonetDB. https://www.monetdb.org/, 2016.
- MongoDB Inc. MongoDB for GIANT Ideas — MongoDB. http://www.mongodb.org, 2016.
- Elif Dede, Madhusudhan Govindaraju, Daniel Gunter, Richard Shane Canon, and Lavanya Ramakrishnan. Performance evaluation of a mongodb and hadoop platform for scientific data analysis. In Proceedings of the 4th ACM Workshop on Scientific Cloud Computing, Science Cloud ’13, pages 13–20, New York, NY, USA, 2013. ACM.
Index Terms
Keywords