ABSTRACT
In this paper, I describe some of the recent developments in the database management area, in particular the NoSQL phenomenon and the hoopla associated with it. The goal of the paper is not to do an exhaustive survey of NoSQL systems. The aim is to do a broad brush analysis of what these developments mean - the good and the bad aspects! Based on my more than three decades of database systems work in the research and product arenas, I will outline what are many of the pitfalls to avoid since there is currently a mad rush to develop and adopt a plethora of NoSQL systems in a segment of the IT population, including the research community. In rushing to develop these systems to overcome some of the shortcomings of the relational systems, many good principles of the latter, which go beyond the relational model and the SQL language, have been left by the wayside. Now many of the features that were initially discarded as unnecessary in the NoSQL systems are being brought in, but unfortunately in ad hoc ways. Hopefully, the lessons learnt over three decades with relational and other systems would not go to waste and we wouldn't let history repeat itself with respect to simple minded approaches leading to enormous pain later on for developers as well as users of the NoSQL systems!
Caveat: What I express in this paper are my personal opinions and they do not necessarily reflect the opinions of my employer.
- Choy, D., Mohan, C. Locking Protocols for Two-Tier Indexing of Partitioned Data, Proc. International Workshop on Advanced Transaction Models and Architectures, Goa, August--September 1996.Google Scholar
- Mohan, C. Interactions Between Query Optimization and Concurrency Control, Proc. 2nd International Workshop on Research Issues on Data Engineering: Transaction and Query Processing, Tempe, February 1992.Google ScholarCross Ref
- Mohan, C. Less Optimism About Optimistic Concurrency Control, Proc. 2nd International Workshop on Research Issues on Data Engineering: Transaction and Query Processing, Tempe, February 1992.Google ScholarCross Ref
- Mohan, C. Repeating History Beyond ARIES, Proc. 25th International Conference on Very Large Data Bases, Edinburgh, September 1999. Google ScholarDigital Library
- Mohan, C. The NoSQL Hoopla... What is NonsenSQL about it, Series of blog posts, http://cmohan.tumblr.com/, April 2012.Google Scholar
- Mohan, C., Barber, R., Watts, S., Somani, A., Zaharioudakis, M. Evolution of Groupware for Business Applications: A Database Perspective on Lotus Domino/Notes, Proc. 26th International Conference on Very Large Databases, Cairo, September 2000. Google ScholarDigital Library
- Mohan, C., Haderle, D. Algorithms for Flexible Space Management in Transaction Systems Supporting Fine-Granularity Locking, Proc. 4th International Conference on Extending Database Technology, Cambridge, March 1994. Google ScholarDigital Library
- Mohan, C., Haderle, D., Lindsay, B., Pirahesh, H., Schwarz, P. ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging, ACM Transactions on Database Systems, Vol. 17, No. 1, March 1992. Google ScholarDigital Library
- Tweed, R., James, G. A Universal NoSQL Engine, Using a Tried and Tested Technology, http://www.mgateway.com/docs/universalNoSQL.pdf, 2010.Google Scholar
- Wikipedia. NoSQL, http://en.wikipedia.org/wiki/NoSQLGoogle Scholar
- Lamb, C. Oracle NoSQL Database, Presentation at International Workshop on High Performance Transaction Systems (HPTS), Asilomar, October 2011, http://hpts.ws/sessions/cwl-hpts-for-website.pdfGoogle Scholar
- Marcus, A. The NoSQL Ecosystem, In The Architecture of Open Source Applications, A. Brown and G. Wilson (Eds.), 2011, http://www.aosabook.org/en/nosql.htmlGoogle Scholar
- Marcus, A. The NoSQL Ecosystem, Presentation at International Workshop on High Performance Transaction Systems (HPTS), Asilomar, October 2011, http://hpts.ws/sessions/nosql-ecosystem.pdfGoogle Scholar
- Ellis, J. Apache Cassandra Present and Future, Presentation at International Workshop on High Performance Transaction Systems (HPTS), Asilomar, October 2011, http://hpts.ws/sessions/Cassandra_HPTS_2011.pdfGoogle Scholar
- Muthukkaruppan, K. Storage Infrastructure Behind Facebook Messages, Presentation at International Workshop on High Performance Transaction Systems (HPTS), Asilomar, October 2011, http://mvdirona.com/jrh/TalksAndPapers/KannanMuthukkaruppan_StorageInfraBehindMessages.pdfGoogle Scholar
- Cockcroft, A. Netflix Global, Presentation at International Workshop on High Performance Transaction Systems (HPTS), Asilomar, October 2011, http://hpts.ws/sessions/GlobalNetflixHPTS.pdfGoogle Scholar
- Anand, S. Netflix's Transition to High-Availability Storage Systems, Netflix Document, October 2010, https://bitly.com/bhOTLuGoogle Scholar
- Edlich, S. List of NoSQL Databases, http://nosql-database.org/Google Scholar
- Srinivasan, V., Bulkowski, B. Citrusleaf: A Real-Time NoSQL DB which Preserves ACID, Proc. 37th International Conference on Very Large Databases, Seattle, August 2011.Google Scholar
- Wayner, P. 7 Hard Truths about the NoSQL Revolution, InfoWorld, 16 July 2012.Google Scholar
- Popescu, A. myNoSQL -- NoSQL Databases and Polyglot Persistence: A Curated Guide, http://nosql.mypopescu.comGoogle Scholar
- Edlich, S. The State of NoSQL, November 2012, http://www.infoq.com/articles/State-of-NoSQLGoogle Scholar
Index Terms
- History repeats itself: sensible and NonsenSQL aspects of the NoSQL hoopla
Recommendations
Incorporating NoSQL into a database course
This article introduces the concepts of Big Data and NoSQL and describes a semester long web-based project that uses both a relational database (Oracle 11g) and a NoSQL (MongoDB) database for an undergraduate database course. The relational database ...
Sinew: a SQL system for multi-structured data
SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of DataAs applications are becoming increasingly dynamic, the notion that a schema can be created in advance for an application and remain relatively stable is becoming increasingly unrealistic. This has pushed application developers away from traditional ...
Comparing NoSQL MongoDB to an SQL DB
ACMSE '13: Proceedings of the 51st ACM Southeast ConferenceNoSQL database solutions are becoming more and more prevalent in a world currently dominated by SQL relational databases. NoSQL databases were designed to provide database solutions for large volumes of data that is not structured. However, the ...
Comments