What's Really New with NewSQL?
Tóm tắt
A new class of database management systems (DBMSs) called NewSQL tout their ability to scale modern on-line transaction processing (OLTP) workloads in a way that is not possible with legacy systems. The term NewSQL was first used by one of the authors of this article in a 2011 business analysis report discussing the rise of new database systems as challengers to these established vendors (Oracle, IBM, Microsoft). The other author was working on what became one of the first examples of a NewSQL DBMS. Since then several companies and research projects have used this term (rightly and wrongly) to describe their systems.
Given that relational DBMSs have been around for over four decades, it is justifiable to ask whether the claim of NewSQL's superiority is actually true or whether it is simply marketing. If they are indeed able to get better performance, then the next question is whether there is anything scientifically new about them that enables them to achieve these gains or is it just that hardware has advanced so much that now the bottlenecks from earlier years are no longer a problem.
To do this, we first discuss the history of databases to understand how NewSQL systems came about. We then provide a detailed explanation of what the term NewSQL means and the different categories of systems that fall under this definition.
Từ khóa
Tài liệu tham khảo
AgilData Scalable Cluster for MySQL. http://www.agildata.com/. AgilData Scalable Cluster for MySQL. http://www.agildata.com/.
Altibase. http://altibase.com. Altibase. http://altibase.com.
Amazon Aurora. https://aws.amazon.com/rds/aurora. Amazon Aurora. https://aws.amazon.com/rds/aurora.
Apache Trafodion. http://trafodion.apache.org. Apache Trafodion. http://trafodion.apache.org.
ClearDB. https://www.cleardb.com. ClearDB. https://www.cleardb.com.
Clustrix. http://www.clustrix.com. Clustrix. http://www.clustrix.com.
CockroachDB. https://www.cockroachlabs.com/. CockroachDB. https://www.cockroachlabs.com/.
H-Store. http://hstore.cs.brown.edu. H-Store. http://hstore.cs.brown.edu.
HyPer. http://hyper-db.de. HyPer. http://hyper-db.de.
MariaDB MaxScale. https://mariadb.com/products/mariadb-maxscale. MariaDB MaxScale. https://mariadb.com/products/mariadb-maxscale.
MemSQL. http://www.memsql.com. MemSQL. http://www.memsql.com.
MySQL Fabric. https://www.mysql.com/products/enterprise/fabric.html. MySQL Fabric. https://www.mysql.com/products/enterprise/fabric.html.
MySQL Proxy. http://dev.mysql.com/doc/mysql-proxy/en/. MySQL Proxy. http://dev.mysql.com/doc/mysql-proxy/en/.
NuoDB. http://www.nuodb.com. NuoDB. http://www.nuodb.com.
ScaleArc. http://scalearc.com. ScaleArc. http://scalearc.com.
Splice Machine. http://www.splicemachine.com. Splice Machine. http://www.splicemachine.com.
VoltDB. http://www.voltdb.com. VoltDB. http://www.voltdb.com.
M. Aslett. How will the database incumbents respond to NoSQL and NewSQL? The 451 Group April 2011. M. Aslett. How will the database incumbents respond to NoSQL and NewSQL? The 451 Group April 2011.
M. Aslett. MySQL vs. NoSQL and NewSQL: 2011-2015. The 451 Group May 2012. M. Aslett. MySQL vs. NoSQL and NewSQL: 2011-2015. The 451 Group May 2012.
Baulier J., VLDB, 701
Corbett J. C., 2012, OSDI
DeWitt D. J., 1986, VLDB, 228
Fitzpatrick B., Distributed Caching with Memcached, Linux J., 2004, 5
Gartner. Hybrid Transaction/Analytical Processing Will Foster Opportunities for Dramatic Business Innovation. https://www.gartner.com/doc/2657815/ 2014. Gartner. Hybrid Transaction/Analytical Processing Will Foster Opportunities for Dramatic Business Innovation. https://www.gartner.com/doc/2657815/ 2014.
Gray J., 1978, Springer-Verlag
S. Kimball. Living without atomic clocks. https://www.cockroachlabs.com/blog/living-without-atomic-clocks/ February 2016. S. Kimball. Living without atomic clocks. https://www.cockroachlabs.com/blog/living-without-atomic-clocks/ February 2016.
Lamport L., 1978, The implementation of reliable distributed multiprocess systems, Computer Networks, 2, 95
Lehman T. J., 1986, University of Wisconsin-Madison
Marz N., 2013, Manning Publications
Reed D. P., 1979, MIT
Rosenberg A., 2006, Improving query performance in data warehouses, Business Intelligence Journal, 11
Shoup R., 2006, SD Forum
M. Stonebraker. New sql: An alternative to nosql and old sql for new oltp apps. BLOG@CACM June 2011. M. Stonebraker. New sql: An alternative to nosql and old sql for new oltp apps. BLOG@CACM June 2011.
Stonebraker M., 2007, VLDB, 1150
Tandem Database Group, 1987, Tandem
Whitney A., 1997, HPTS
R. Williams D. Daniels L. Haas G. Lapis B. Lindsay P. Ng R. Obermarck P. Selinger A. Walker P. Wilms and R. Yost. Distributed systems vol. ii: distributed data base systems. chapter R*: an overview of the architecture pages 435--461. 1986. R. Williams D. Daniels L. Haas G. Lapis B. Lindsay P. Ng R. Obermarck P. Selinger A. Walker P. Wilms and R. Yost. Distributed systems vol. ii: distributed data base systems. chapter R*: an overview of the architecture pages 435--461. 1986.
Zdonik S. B., 1990, Readings in Object-Oriented Database Systems. Morgan Kaufmann