DB-EnginesExtremeDB: the hard real time dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AnzoGraph DB vs. Ingres vs. RocksDB vs. Spark SQL

System Properties Comparison AnzoGraph DB vs. Ingres vs. RocksDB vs. Spark SQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAnzoGraph DB  Xexclude from comparisonIngres  Xexclude from comparisonRocksDB  Xexclude from comparisonSpark SQL  Xexclude from comparison
DescriptionScalable graph database built for online analytics and data harmonization with MPP scaling, high-performance analytical algorithms and reasoning, and virtualizationWell established RDBMSEmbeddable persistent key-value store optimized for fast storage (flash and RAM)Spark SQL is a component on top of 'Spark Core' for structured data processing
Primary database modelGraph DBMS
RDF store
Relational DBMSKey-value storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.16
Rank#297  Overall
#25  Graph DBMS
#13  RDF stores
Score6.10
Rank#69  Overall
#38  Relational DBMS
Score3.91
Rank#89  Overall
#15  Key-value stores
Score22.86
Rank#35  Overall
#21  Relational DBMS
Websitewww.cambridgesemantics.com/­anzographwww.actian.com/­data-management/­ingres-sql-rdbmsrocksdb.orgspark.apache.org/­sql
Technical documentationdocs.cambridgesemantics.com/­anzograph/­userdoc/­home.htmdocs.actian.com/­ingresgithub.com/­facebook/­rocksdb/­wikispark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperCambridge SemanticsActian CorporationFacebook, Inc.Apache Software Foundation
Initial release20181974 infooriginally developed at University Berkely in early 1970s20132014
Current release2.3, January 202111.0, April 20177.1.1, April 20223.2.0, October 2021
License infoCommercial or Open Sourcecommercial infofree trial version availablecommercialOpen Source infoBSDOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++Scala
Server operating systemsLinuxAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
Linux
OS X
Windows
Data schemeSchema-free and OWL/RDFS-schema supportyesschema-freeyes
Typing infopredefined data types such as float or dateyesnoyes
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.nono infobut tools for importing/exporting data from/to XML-files availablenono
Secondary indexesnoyesnono
SQL infoSupport of SQLSPARQL and SPARQL* as primary query language. Cypher preview.yesnoSQL-like DML and DDL statements
APIs and other access methodsApache Mule
gRPC
JDBC
Kafka
OData access for BI tools
OpenCypher
RESTful HTTP API
SPARQL
.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
C++ API
Java API
JDBC
ODBC
Supported programming languagesC++
Java
Python
C++
Java
Java
Python
R
Scala
Server-side scripts infoStored proceduresuser defined functions and aggregatesyesnono
Triggersnoyesnono
Partitioning methods infoMethods for storing different data on different nodesAutomatic shardinghorizontal partitioning infoIngres Star to access multiple databases simultaneouslynoneyes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication in MPP-ClusterIngres Replicatornonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsKerberos/HDFS data loadingnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency in MPP-ClusterImmediate Consistency
Foreign keys infoReferential integrityno infonot needed in graphsyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDyesno
Concurrency infoSupport for concurrent manipulation of datayesyes infoMVCCyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesno
User concepts infoAccess controlAccess rights for users and rolesfine grained access rights according to SQL-standardnono

More information provided by the system vendor

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
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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

More resources
AnzoGraph DBIngresRocksDBSpark SQL
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 Unveils AnzoGraph DB with Geospatial Analytics
19 June 2020, Solutions Review

Cambridge Semantics Announces AnzoGraph™ Graph-Based Online Analytics Support for Amazon Neptune and Graph Databases
15 February 2018, Business Wire

Global Metadata Management Tools Market Size, Share & Industry Trends Analysis Report, 2021 - 2027
9 May 2022, Yahoo Finance

provided by Google News

DataStax Astra DB gets Change Data Capture
25 April 2022, iProgrammer

Actian Launches Ingres as a Fully-Managed Cloud Service
24 September 2021, Integration Developers

Two Sizes Fit Most: PostgreSQL and ClickHouse – The New Stack
13 April 2022, thenewstack.io

Staying power: the growing impact of PostgreSQL on enterprise marks Postgres Vision 2021
15 June 2021, SiliconANGLE News

PostgreSQL 14 Is Here - A Look At Its Past And Future
1 October 2021, iProgrammer

provided by Google News

Did Rockset Just Solve Real-Time Analytics?
25 August 2021, Datanami

provided by Google News

Top online courses to learn Apache Spark
5 May 2022, Analytics India Magazine

Application Architects: Degree in Comp. Sc/Eng related. MS (2 yr)
18 May 2022, New Jersey Hills

Spark Gets Closer Hooks to Pandas, SQL with Version 3.2
26 October 2021, Datanami

Top 10 Business Intelligence Jobs in MNCs to Apply for in May
6 May 2022, Analytics Insight

Databricks SQL Now GA, Bringing Traditional BI to the Lakehouse
16 December 2021, Datanami

provided by Google News

Job opportunities

Technical Sales Specialist
Katana Graph, New York, NY

Technical Sales Specialist
Katana Graph, Austin, TX

Sr. Sales Engineer (Austin or US Remote)
Katana Graph, Austin, TX

Principal Software Engineer
Cambridge Semantics, San Diego, CA

Senior Software Engineer
Cambridge Semantics, San Diego, CA

Senior Database Administrator
SkyWater Technology Foundry, Inc., Bloomington, MN

Database Administrator III
Fred Hutchinson Cancer Research Center, Seattle, WA

Systems Analyst
Teradyne Infotech, Farmington Hills, MI

Systems/Software Engineer NASA NENSS
Metis Technology Solutions Inc, Wallops Island, VA

Intelligence Analyst
CACI, Dahlgren, VA

C# Back End Engineers
Divisions Maintenance Group, Remote

Senior Software Engineer - Go
Axoni, Remote

Engineer - Stores and Supply Chain (Full-Time Remote or Hybrid)
TARGET, Brooklyn Park, MN

Java / Scala Developer
Morgan Stanley, New York, NY

Software Engineer - Data
DFLabs, Remote

Python/Spark/SQL Data Egnineer
Zettalogix, Iselin, NJ

Data Engineer
Piper Companies, Remote

Big Data Engineer
VIR Consultant, Santa Clara, CA

ETL Tester
Cool Minds LLC, Remote

Associate Data & Machine Learning Engineer
Amazon Web Services, Inc., Irvine, CA

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

AllegroGraph logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

Neo4j logo

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

Present your product here