DB-EnginesExtremeDB: is hard real time possible with a dbms?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AnzoGraph DB vs. PouchDB vs. SingleStore

System Properties Comparison AnzoGraph DB vs. PouchDB vs. SingleStore

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAnzoGraph DB  Xexclude from comparisonPouchDB  Xexclude from comparisonSingleStore infoformer name was MemSQL  Xexclude from comparison
DescriptionScalable graph database built for online analytics and data harmonization with MPP scaling, high-performance analytical algorithms and reasoning, and virtualizationJavaScript DBMS with an API inspired by CouchDBMySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table type
Primary database modelGraph DBMS
RDF store
Document storeRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.33
Rank#264  Overall
#21  Graph DBMS
#12  RDF stores
Score2.98
Rank#99  Overall
#18  Document stores
Score6.66
Rank#59  Overall
#33  Relational DBMS
Websitewww.cambridgesemantics.com/­anzographpouchdb.comwww.singlestore.com
Technical documentationdocs.cambridgesemantics.com/­anzograph/­userdoc/­home.htmpouchdb.com/­guidesdocs.singlestore.com
DeveloperCambridge SemanticsApache Software FoundationSingleStore Inc.
Initial release201820122013
Current release2.3, January 20217.1.1, June 20197.6, November 2021
License infoCommercial or Open Sourcecommercial infofree trial version availableOpen Sourcecommercial infofree developer edition available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SingleStore Managed Service: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities
Implementation languageJavaScriptC++, Go
Server operating systemsLinuxserver-less, requires a JavaScript environment (browser, Node.js)Linux info64 bit version required
Data schemeSchema-free and OWL/RDFS-schema supportschema-freeyes
Typing infopredefined data types such as float or datenoyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesnoyes infovia viewsyes
SQL infoSupport of SQLSPARQL and SPARQL* as primary query language. Cypher preview.noyes infobut no triggers and foreign keys
APIs and other access methodsApache Mule
gRPC
JDBC
Kafka
OData access for BI tools
OpenCypher
RESTful HTTP API
SPARQL
HTTP REST infoonly for PouchDB Server
JavaScript API
Cluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
ODBC
Supported programming languagesC++
Java
Python
JavaScriptBash
C
C#
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresuser defined functions and aggregatesView functions in JavaScriptyes
Triggersnoyesno
Partitioning methods infoMethods for storing different data on different nodesAutomatic shardingSharding infowith a proxy-based framework, named couchdb-loungeSharding infohash partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication in MPP-ClusterMulti-source replication infoalso with CouchDB databases
Source-replica replication infoalso with CouchDB databases
Source-replica replication infostores two copies of each physical data partition on two separate nodes
MapReduce infoOffers an API for user-defined Map/Reduce methodsKerberos/HDFS data loadingyesno infocan define user-defined aggregate functions for map-reduce-style calculations
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency in MPP-ClusterEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integrityno infonot needed in graphsnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyes, multi-version concurrency control (MVCC)
Durability infoSupport for making data persistentyesyes infoby using IndexedDB, WebSQL or LevelDB as backendyes infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes
User concepts infoAccess controlAccess rights for users and rolesnoFine grained access control via users, groups and roles
More information provided by the system vendor
AnzoGraph DBPouchDBSingleStore infoformer name was MemSQL
Specific characteristicsSingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» more
Competitive advantagesSingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» more
Typical application scenariosDriving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» more
Key customersIEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» more
Market metricsCustomers in various industries worldwide including US and International Industry...
» more
Licensing and pricing modelsF ree Tier and Enterprise Edition
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
AnzoGraph DBPouchDBSingleStore infoformer name was MemSQL
DB-Engines blog posts

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Conferences and events

Distributed SQL Architecture: A Primer on Rowstore and Columnstore Databases
Webinar, 10am PST, 1 February 2022

Databases and DevOps. TechTalk with Joe Karlsson (SingleStore) and Rizel Scarlett (GitHub)
Webinar, 9 am PST, 9 February 2022

Migrating from PostgreSQL to Drive 20-100x Faster Performance
Webinar, 10am PST, 15 February 2022

Recent citations in the news

AnzoGraph review: A graph database for deep analytics
15 April 2019, InfoWorld

Cambridge Semantics Announces Major Upgrades to Its Award-Winning AnzoGraph® DB, Including Free Edition for Commercial Use
23 January 2020, Business Wire

Cambridge Semantics Announces AnzoGraph Support for Amazon Neptune and Graph Databases
15 February 2018, Database Trends and Applications

Cambridge Semantics Fits AnzoGraph DB with More Speed, Free Access
23 January 2020, Solutions Review

The 12 Best Graph Databases to Consider for 2022
22 December 2021, Solutions Review

provided by Google News

Getting Started with PouchDB Client-Side JavaScript Database
7 September 2016, SitePoint

Synchronizing Offline App Data with PouchDB
25 September 2015, SitePoint

Speeding up IndexedDB reads and writes
22 August 2021, nolanlawson.com

Cross Platform Storage and Sync with Ionic Framework, Couchbase, and PouchDB
13 November 2015, DZone News

provided by Google News

Real-time database platform SingleStore raises $80M more, now at a $940M valuation
8 September 2021, TechCrunch

What's Next: Managing Data in Cloud Native Environments – The New Stack
18 January 2022, thenewstack.io

Database startup SingleStore raises $80M
8 September 2021, VentureBeat

What's Changed: 2021 Gartner Magic Quadrant for Cloud Database Management Systems
13 January 2022, Solutions Review

SingleStore says it's the world's first database to support analytical and transactional workloads
23 June 2021, SiliconANGLE News

provided by Google News

Job opportunities

Technical Sales Specialist
Katana Graph, New York State

Sr. Sales Engineer
Katana Graph, Austin, TX

Streaming Data Engineer
Medidata Solutions, Remote

Sales Engineer/Senior Sales Engineer (North Central)
TigerGraph, Saint Paul, MN

Senior Streaming Data Engineer
Medidata Solutions, New York, NY

Software Engineer, University Graduate
SingleStore, Seattle, WA

Distributed Database Administrator, Core Technology Infrastructure
Bank of America, Charlotte, NC

Data Analyst (Remote Available)
PRICE WATERHOUSE COOPERS, Remote

Senior Front Office C# Developer
Natixis North America Inc., United States

Data Modeler
FirstEnergy Corp, Akron, OH

jobs by Indeed



Share this page

Featured Products

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here