16 notable NoSQL and Newsql databases-reproduced

Original address: http://tech.it168.com/a2014/0929/1670/000001670840_all.shtml

"IT168 Review" the traditional relational database was born without taking into account today's booming mobile, social, and big data load types, and is not suitable for handling extreme-scale processing tasks. But you don't have to worry, 16 professional companies have brought us their respective next-generation NoSQL and Newsql options.

Why are companies increasingly opting for alternative alternatives to the leading relational database management system (RDMS) when dealing with new data types and extreme business-scale instances?

With this problem, we have communicated with the weather CIO Bryson Koehler, a company that is currently using the cloud weather forecast system based on the Riak NoSQL database to process data at a staggering rate of 20TB per day. His answer was very resolute:

"We know we need to operate on a global scale, and we know we need to deal with huge amounts of data at astronomical levels. I know that I need to think about how to set up this system from an essential perspective. I don't want to be implemented in an attached way, I don't want it to be an option, not the only answer, and I don't want to be forced to set up a technical team to work with a dedicated maintenance company. The traditional relational data processing scheme is cumbersome and complex, and it seems to me to be unable to deal with the scale of globalization. ”

In a large-scale cloud deployment system, the inclusion of NoSQL can provide us with strong support. We've also heard a lot about the benefits of nosql flexibility, architecture-agnostic data processing, and the ease of deployment of products such as MongoDB and Couchbase. Supporters believe that these solutions can capture mobile, social, clickstream, and sensor data, and in their view, adding JSON support to a traditional database is tantamount to painting a little pig with lipstick.

In the face of this real demand, many supporters may be able to make a nosql product--let's not say sql--is already a mature language, supporting various types of transactional and analytic instances. On the newsql side, there are already Clustrix, Memsql, and VOLTDB vendors offering such solutions, promising to ensure that nosql globalization expands without having to abandon SQL features.

So far, the NEWSQL option has been far less popular than the NoSQL class scenario, partly because of its relatively short time-to-date, and also because combining traditional solutions with data flexibility is no easy feat. Further, newsql suppliers are faced with competitive pressures from established SQL vendors, and customers are more inclined to use their familiar old ways to solve new problems in their business. But newsql manufacturers believe such a practice is a "costly mistake".

Today we will look closely at 16 of the most noteworthy NoSQL and Newsql database management systems. Today we temporarily exclude the graphics database, which is mainly used in very special network analysis environment, and not as a nosql or newsql is suitable for a wide range of applications. Also excluded are high-popularity products such as Redis and memcached, which are closer to the data cache layer than persistent data storage scenarios.

The collection today is different from the previous 16 top Big data analytics platform--although these products are also able to meet operational analytics processing needs, operational transactional applications are the core focus, and this is the main difference between the database and the analytics platform. We also did not use the word "top" in the headline, because the battle has yet to be settled, especially as the Newsql camp's competition remains to be seen.

Gossip less, let's look at these new options for modern data management requirements.

　　Aerospike memory supports real-time decision making

　　DBMS Type: Nosql

　　Description: Flash-Optimized, distributed in-memory database provides acid compliance and adjustable consistency

　　well-known customers: Appnexus, BlueKai (now held by Oracle), EBay

　　Company situation: Private Enterprise, established in 2009, formerly known as Citrusleaf Company.

　　Comments: Aerospike offers an in-memory speed advantage that attracts the attention of many ad networks and other Web-scale businesses that require millisecond response times. Aerospike is now aggressively moving into new business categories, including gaming, e-commerce, and security, all of which require high latency conditions. We will also keep an eye on the platform to see if aerospike can be a broader solution.

　Official website:http://www.aerospike.com/

　Cassandra is leading the way in global scalability competition

　　DBMS Type: Nosql

　　Description: Massively scalable partitioned row storage with multiple data center replication capabilities

　　well-known customers: Constant contact, EBay, Netflix

　　Company situation: Cassandra is an open source project supported by private company DataStax, founded in 2010

　　Comments: The main advantages of Apache Cassandra include flexibility, NOSQL data model, multi-datacenter support, and linear scalability on clustered commercial hardware. Commercial support and software distributions are now formally provided by DataStax. Cassandra has always enjoyed the reputation of the most scalable NoSQL database, but its high level of complexity has been criticised. DataStax, a financially rich company, is currently working to streamline the manageability of products at the enterprise user level while adding low latency in-memory functionality, and recently, Cassandra has integrated with Apache spark on demand. Both Couchbase and HBase are the main competitors of Cassandra, the latter running in a Hadoop environment and widely seen as one of the most critical potential threats.

　　Official website:http://www.datastax.com/

　　Clustrix promises to bring web size to SQL

　　DBMS Type: Newsql

　　Description: distributed relational DBMS supports automatic partitioning and replication capabilities

　well-known customers: AOL, Rakuten, Symantec

　　Company situation: Private Enterprise, founded in 2006

　　Comments: The Clustrix has always been a major selling point for highly distributed features, scalable fault tolerance, and no need to sacrifice SQL or ACID transaction processing performance. The company has established a 21-node deployment scenario (as shown) for the customer Twoo.com website, which has also become "the world's largest scale-out SQL Department project." "Major Newsql suppliers are committed to reducing the difficulty of operational compliance in a large-scale deployment environment (compared to existing databases). Clustrix's challenges and competitors include Memsql, NuoDB, and Voltdb, both of which have their own differentiated advantages, while also relying on the advantages that can be quickly built to successfully attract large numbers of customers.

　　Official website:http://www.clustrix.com/

　　Couchbase tightly following the footsteps of mobile apps

　　DBMS Type: Nosql

　　Description: document-oriented database with mobile sync and embeddable database options

　　well-known customers: Concur, LinkedIN, Zynga

　　Company situation: Private Enterprise, founded in 2009

　　Comments: Couchbase has been committed to covering all types of business, promising to provide the advantages of document processing in MongoDB and the scalability benefits of Cassandra. The company's latest program is Couchbase Mobile, a project that was launched in May this year to ensure that mobile applications are always functioning in a networked or non-networked environment. The system combines the Couchbase lite embeddable device database with the Couchbase Sync gateway that connects to the central couchbase server. We will continue to focus on whether Couchbase can succeed on all fronts.

　　Official website:http://www.couchbase.com/

　　DYNAMODB provides support for large-scale cloud applications

　　DBMS Type: NoSQL Database Services

　　Description: adjustable extensible key-value service running on multiple Amazon availability zones with S3 backup mechanism

　　well-known customers: AdRoll, Elsevier, SmugMug

　　Company Status: officially listed since 1997

　　Comments: Amazon has developed dynamo to expand the scale of its burgeoning e-commerce business, and its 2007 corporate white Paper has inspired Cassandra, Riak, and other development projects such as NoSQL. The DYNAMODB database service was launched in 2012, and its appearance was a solo show, but the database service camp has gradually expanded. You can now choose to use multiple popular open source databases (such as Couchbase, MongoDB, Riak, and so on) in the same cloud environment, and migrate them to other clouds or internal environments if necessary. There are no internal or cloud alternatives available to replace DYNAMODB. If you already have full adoption of AWS in your enterprise, Dynamodb is undoubtedly a fast, flexible, and highly scalable solution option.

　　Official website:http://aws.amazon.com/dynamodb/

　HBase enables NoSQL on Hadoop

　　DBMS Type: Nosql

　　Description: wide-column database based on Hadoop Distributed File System (HDFS)

　　well-known customers: Bloomberg LP, Facebook, Nielsen

　　Company Status: None, HBase is a feature in open source Apache Hadoop

　　Comments: HBase is a set of NoSQL databases running on HDFs, so it gives users unique capabilities to work directly with data stored in Hadoop. Features include massive scalability (used in messaging systems for Facebook), read and write consistency, automatic table partitioning and configurable capabilities, and automatic failover. Until now, 2014, HBase is still in the 0.98.3 version, which has become a "major" cause of its continued inability to be widely used. There is no doubt that HBase has great potential for development, but its development process has lagged behind the rapid pace of development of the Hadoop framework. We will continue to focus on a range of related projects, including Hoya for yarn Support, Phoenix for SQL support, Kiji for application development, and a Facebook Hydrabase project that promises to build a more mature and practical hbase solution.

　　Official website: http://hbase.apache.org/

　　IBM hurried to win Cloudant, but what's next?

　　DBMS Type: cloud-based NoSQL DBMS service

　　Description: COUCHDB-based document storage database as a service

　　well-known customers: Expedia, DHL, Samsung

　　Company situation: Cloudant was acquired by IBM in February this year.

　　Comment: when IBM acquired coudant (the specific terms were not disclosed), experts said the deal was centred on acquiring the latter's database-as-a-service technology and expertise. An IBM executive also talked about the importance of the underlying open source Couchdb DBMS (don't confuse the Couchdb DBMS with COUCHDB). Features of the DBMS include scalability, availability, durability, read and write consistency, plus flexible data processing capabilities, including JSON, full-text, and geospatial data. But couchdb in recent years seems to have taken the limelight from other NoSQL rivals. It is puzzling that IBM has even established an important partnership with the NoSQL market leader MongoDB. Needless to say, we will see IBM take the next step in this regard. I bet we'll see more database-as-a-service scenarios that take advantage of the cloudant feature.

　　Official website:https://cloudant.com/

　　MarkLogic brings sophisticated, flexible data management solutions

　　DBMS Type: Nosql

　　Description: document-oriented database supporting acid-compliant transactional and built-in search capabilities

　　well-known customers: DowJones, Citigroup, Boeing

　　Company situation: Private Enterprise, founded in 2001

　　Comments: MarkLogic has a long history as a successful XML database before the NoSQL concept is widely popularized. MarkLogic is widely used in heavyweight areas of large-scale technical, financial, legal, medical, and scientific applications that require flexible management and new use of information. This architecture-agnostic, highly scalable, clustered DBMS is widely used as a NoSQL document storage solution. The company has been working for many years to build enterprise-class capabilities, including replication, rollback, automated failover, point-in-time recovery, and backup/restore. MarkLogic already has a number of high-end (most concentrated in the publishing industry) customers. Can the company further expand its reach under MongoDB's ring? Please wait and see.

　　Official website:http://www.marklogic.com/

　　Memsql combines in-memory performance with SQL

　　DBMS Type: Newsql

　　Description: A large-scale memory insider storage solution that has recently added a column-style analysis feature.

　　well-known customers: Comcast, CPXI, Shutterstock

　　Company situation: Private Enterprise, founded in 2011

　　Comment: as the name implies, the main difference between Memsql and other large-scale nosql scenarios is that it combines in-memory mechanisms, acid-compliant transactional performance, and SQL compatibility. In addition to adding a relational interface to the in-memory data tier, MEMSQL recently supported the compression-column storage mechanism in Flash and disk storage options to enable deep historical analysis capabilities. Memsql's main competitor is the veteran program Voltdb (and other newsql databases), so the ongoing competition will expand NEWSQL status and customer acceptance while competing.

　　Official website:http://www.memsql.com/

　　MongoDB calls for modern developers to join

　　DBMS Type: Nosql

　　Description: Document Storage DBMS

　　well-known customers: Cisco, EBay, Intuit, MetLife

　　Company situation: Private Enterprise, founded in 2007, originally named 10Gen

　　Comment: open source MongoDB is currently the most popular NoSQL database and currently has more than 7 million downloads, as well as hundreds of thousands of real-world deployment cases. The biggest selling point for MongoDB is a simple development process and the flexibility to handle modern data from mobile, social, and Web applications. MongoDB ushered in the 2.6 release this May, which further simplifies management, strengthens security, and improves analytics. This version also increases scalability to narrow this gap with rivals such as Cassandra, Couchbase, and Riak. However, in contrast to scalability, MongoDB is able to provide excellent processing speed, ease of development, and flexible data management mechanisms for a broad range of global, petabyte-scale, and hundreds of use-case-wide deployment scenarios, all of which are enough to win new customers.

　　Official website:http://www.mongodb.com/

　　NuoDB SQL with a cloud

　　DBMS Type: Newsql

　　Description: scale-out relational DBMS supports continuous availability, geographic distribution, and cloud deployment scenarios

　　well-known customers: AutoZone, dropship Commerce, NorthPoint Solutions

　　Company situation: Private Enterprise, founded in 2010

　　Comments: NuoDB is another newsql emerging enterprise and is committed to providing customers with scalability, geographically distributed deployments, and a variety of well-known SQL features. Predictably, it has good high availability, thermal upgrades, data redundancy, and disaster recovery capabilities. A major development twist for NuoDB is the emphasis on cloud deployment scenarios with built-in multitenant support capabilities. It is a promising product, but as a young newsql supplier, NuoDB still needs to prove its excellence to its customers.

　　Official website:http://www.nuodb.com/

　　Oracle NoSQL database: Old vendors, new solutions

　DBMS Type: Nosql

　　Description: distributed key-value store database, originating from BerkeleyDB

　　well-known customers: Catalyst IT Services, Passoker, payback

　　Company Status: listed in 1986

　　Comments: There are leaders in the NoSQL market who say they never see Oracle's NOSQL database as a competitive solution, but believe it will soon change. The target audience of the product is clearly composed of loyal Oracle program buyers, which is also in line with the supply and demand of most leading manufacturers. You can download the community version of this scalable, distributed key-value storage solution for free, or buy technical support services for the Community edition and the more complete Enterprise Edition. The database is also tied to Oracle Big Data appliance and is integrated with its Cloudera-based Hadoop distribution. Oracle's NoSQL technology community does not actually publish announcements or organize events, but there is a sizable group of Oracle's customers who see it as a flexible and scalable nosql alternative.

　　Official website:http://www.oracle.com/us/products/database/nosql/overview/index.html

　　Riak toward a large-scale environment, to the cloud

　　DBMS Type: Nosql

　　Description: distributed key-value storage scheme with multi-data center replication and auto-balancing function

　　well-known customers: Best Buy, Ideeli, the Weather company

　　Company situation: Open source project supported by private enterprise Basho Company, founded in 2007

　　Comment: The open source Riak is designed primarily for high scalability, availability, fault tolerance, and ease of operation. The Riak Enterprise and Raik CS editions supported by Basho also include support for enterprise-class features and the ability to be compatible with Amazon Web Services S3 cloud storage. The Weather Channel introduces Riak into the Amazon cloud, with its simplicity, scalability, and always-on availability as a key selling point. Riak's Ring node Cluster scheme (shown) allows users to arbitrarily add or remove virtual nodes and redistribute the data accordingly. Basho company claims to have a Cassandra scale advantage and greater operational convenience. Basho has made significant operational gains over the past year, but we expect its revenues to stabilize in the future, and Basho will continue to drive cloud deployments with ease of use as a feature.

　　Official website:http://basho.com/

　　Splice machine pushes transactional SQL to Hadoop

　DBMS Type: Newsql

　　Description: Sql-on-hadoop RDBMS, supporting transactional and analytical processing tasks

　　well-known customers: Harte Hanks

　　Company situation: Private Enterprise, founded in 2012

　　Commentary: The Sql-on-hadoop solution is now on the market, but emerging enterprise splice machine clearly has its own secret-the solution can run transactional applications on top of Hadoop and support analytic applications at the same time. Its client, Harte Hanks, says they currently run a large number of applications designed specifically for traditional databases, including IBM UNICA, COgnos Bi, and ab initio data integration software. This is a very young company, the list of well-known customers is also a bit shabby. But running transactional applications on top of Hadoop is a unique idea, and it's enough to keep the company focused on the Newsql market for talented Ruzizi.

　　Official website:http://www.splicemachine.com/

　　Translattice PostgreSQL to Flourish

　　DBMS Type: Newsql

　　Description: distributed relational DBMS with cloud and device deployment options

　　well-known customers: Oakland Raiders

　　Company situation: Private Enterprise, founded in 2007

　　Comments: Translattice started out as a large-scale distributed PostgreSQL-derived version, initially named Translattice Elastic database, which can be deployed internally, on a device, or in a cloudy environment. The company acquired Stormdb in 2013, a commitment to expand PostgreSQL, and use its intellectual property to create postgres-xl--, a scalable, massively parallel Analytics database. The acquisition is translattice in the hope that most postgres users will be able to implement the extended tasks of big data OLTP and analytics in a familiar way. The thin public client reference list shows that translattice, like many newsql suppliers, still needs to prove its market appeal.

　　Official website:http://www.translattice.com/index.shtml

　　Voltdb high-speed streaming data

　　DBMS Type: Newsql

　　Description: an in-memory relational database that conforms to the acid and SQL principles

　　well-known customers: Booyah, Novatel Networks, Qualityhealth

　　Company situation: Private Enterprise, founded in 2009

　　Comments: Voltdb has a large-scale, high-speed transaction processing capability thanks to its high-distributed in-memory architecture. Voltdb is able to handle fast streaming data from telecommunications, mobile ad networks and gaming companies as a solution that is open to the GNU licensed DBMS and co-founder/dbms Daniel Michael Stonebraker. The Voltdb 4.0, released earlier this year, also upgraded analytical processing capabilities, resulting in higher query data execution capabilities, support for concurrent user operations, and deeper SQL time-series analysis capabilities. Voltdb's immediate rivals include Memsql, NuoDB, and Clustrix, but this year Oracle and Microsoft have joined the team, hoping to use their existing database management systems to remain competitive in the market with the advantage of being more familiar to customers.

　　Official website:http://voltdb.com/

Link to the original English:NoSQL, Newsql Databases to Watch

16 notable NoSQL and Newsql databases-reproduced