Many times Relational Databases fails due to lack of support for handling the vast unstructured semantics of Big Data .Applications generating Big data are not efficient with relational databases in term of storage Space, database load time , query run time and application flexibility . When to use NOSQL data bases and which NOSQL database is good choice among the available NOSQL DB like Key-Value store, document store, column oriented DB, Graph DB or time Series DB needs to be evaluated carefully to get optimal performance in term of storage and query execution. This paper is about the Cloud based NOSQL –columnar oriented Database performance evaluation along with other NOSQL services like DynamoDB. Many prominent cloud providers like Google Cloud, AWS cloud and Microsoft azure Cloud they all provide NOSQL data bases as a service. These Databases are schema less, ACID free and flexible with full governance support for specific application need. This paper mainly focuses on cloud based column oriented data base performance with AWS Redshift.

NOSQL, AWS Redshift, AWS Athena, Columnar Databases, Key value DB

[1] Jagdev Bhogal and Imran Choksi “ Handling Big Data using NOSQL” ,IEEE 29th International confrence on Advanced Information Networking and applications workshop,2015
[2] Vandana Bhagat, Arpita Gopal, “Comparative Study of Row and Column Oriented Database”, IEEE, 2012, Available at: https://ieeexplore.ieee.org/document/6495251
[3] Daniel Abadi, Peter Boncz, Samuel Madden, “The Design and Implementation of Modern Column Oriented Database Systems”, IEEE, 2013.
[4] Daniel J. Abadi, Daniel S. Myers, David J. DeWitt, Samuel R. Madden, “Materialization Strategies in a Column-Oriented DBMS”, IEEE, 2007.
[5] Suryawanshi Harshal, Rokade Chakrapani, Ambhore Ajay, Rathod Sharad, “Compiler as Service over Cloud”, International Journal of Computer Applications,Volume 70– No.1, May 2013.
[6] Uday Chauhan, Mayuri Patole, Yogita Mokashi, SaurabhPadalikar “Online Cloud Based Compilers System”, Computer Society Of India ,February 2016.
[7] DBMS Musings, “Apache Arrow vs. Parquet and ORC”, 2017, Available at: http://dbmsmusings.blogspot.com/2017/10/apache-arrow- vs-parquet-a nd-orc-do-we.html
[8] TeachMeHANA, “Difference between Row Store and Column Store”, May, Available at: http://teachmehana.com/row-store-vs-column-store/
[9] Ansari Mohd. Arshad, Arshiya Khan, Shaikh Sana, Er. Zainab Mirza, “Compilers on Cloud”, IJERT, 2013.
[10] Pat Research, “Top 9 Column-Oriented Databases”, 2019, Available at https://www.predictiveanalyticstoday.com/top-wide-
[11] columnar-store-d atabases/ Jon Tong, “Demystifying Columnar Databases”, April2012, Available at: https://www.youtube.com/watch?v=wYl_YxqTof4
[12] Parallalxinc, “Cloud-Compiler“, GitHub, 2015, Available at :https://github.com/parallaxinc/Cloud-Compiler
[13] Jyoti Kharade, Anil Rama Kale, Dhanaji S. Kharade, “NOSQL Database: Opportunities and Applications”, International Journal of Computer Sciences and Engineering, Vol.-6, Issue-5, May 2018.
[14] Jared Hilam,“What is a Columnar Database?”, Available at https://www.youtube.com/watch?v=8KGVFB3kVHQ
[15] https://docs.aws.amazon.com/redshift/latest/mgmt/welcome.ht ml
[16] https://aws.amazon.com/blogs/aws/new-auto-scaling-for- amazon-dynamodb/
[17] V. S. Dhaka and M. Zainab, “Big Data Management as a Service ( BDMaaS ) using NOSQL model from Cloud,” no. 3, pp. 18–22, 201
[18] V.S.Dhaka and M.zainab “Big Data Analytics as a Service (BDAaaS) System Layer” INDIACom-2017; IEEE Conference
[19] Academind, “SQL vs NoSQL or MySQL vs MongoDB“,2018, Available at: https://www.youtube.com/watch?v=ZS_kXvOeQ5Y&t=11
[20] Suryawanshi Harshal, Rokade Chakrapani, Ambhore Ajay, Rathod Sharad, “Compiler as Service over Cloud”, International Journal of Computer Applications,Volume 70– No.1, May 2013.