DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AnzoGraph DB vs. Oracle vs. SAP IQ

System Properties Comparison AnzoGraph DB vs. Oracle vs. SAP IQ

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAnzoGraph DB  Xexclude from comparisonOracle  Xexclude from comparisonSAP IQ infoformer name: Sybase IQ  Xexclude from comparison
DescriptionScalable graph database built for online analytics and data harmonization with MPP scaling, high-performance analytical algorithms and reasoning, and virtualizationWidely used RDBMSColumnar RDBMS optimized for Big Data analytics
Primary database modelGraph DBMS
RDF store
Relational DBMSRelational DBMS infocolumn-oriented
Secondary database modelsDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.36
Rank#313  Overall
#27  Graph DBMS
#17  RDF stores
Score1257.41
Rank#1  Overall
#1  Relational DBMS
Score4.26
Rank#87  Overall
#45  Relational DBMS
Websitecambridgesemantics.com/­anzographwww.oracle.com/­databasewww.sap.com/­products/­technology-platform/­sybase-iq-big-data-management.html
Technical documentationdocs.cambridgesemantics.com/­anzograph/­userdoc/­home.htmdocs.oracle.com/­en/­databasehelp.sap.com/­docs/­SAP_IQ
DeveloperCambridge SemanticsOracleSAP, formerly Sybase
Initial release201819801994
Current release2.3, January 202121c, January 202116.1 SPS04, April 2019
License infoCommercial or Open Sourcecommercial infofree trial version availablecommercial inforestricted free version is availablecommercial
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.
Implementation languageC and C++
Server operating systemsLinuxAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
AIX
HP-UX
Linux
Solaris
Windows
Data schemeSchema-free and OWL/RDFS-schema supportyes infoSchemaless in JSON and XML columnsyes
Typing infopredefined data types such as float or dateyesyes
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.noyesno
Secondary indexesnoyesyes
SQL infoSupport of SQLSPARQL and SPARQL* as primary query language. Cypher preview.yes infowith proprietary extensionsyes
APIs and other access methodsApache Mule
gRPC
JDBC
Kafka
OData access for BI tools
OpenCypher
RESTful HTTP API
SPARQL
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
ADO.NET
JDBC
ODBC
RESTful HTTP API
Supported programming languagesC++
Java
Python
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
C
C#
C++
Java
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresuser defined functions and aggregatesPL/SQL infoalso stored procedures in Java possibleyes
Triggersnoyesyes
Partitioning methods infoMethods for storing different data on different nodesAutomatic shardingSharding, horizontal partitioningshared disk or shared nothing architectures with SAP IQ Multiplexer
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication in MPP-ClusterMulti-source replication
Source-replica replication
SAP/Sybase Replication Server
MapReduce infoOffers an API for user-defined Map/Reduce methodsKerberos/HDFS data loadingno infocan be realized in PL/SQLHadoop integration
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency in MPP-ClusterImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityno infonot needed in graphsyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infoisolation level can be parameterizedACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'no
User concepts infoAccess controlAccess rights for users and rolesfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard

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 partiesNavicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

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

More resources
AnzoGraph DBOracleSAP IQ infoformer name: Sybase IQ
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Recent citations in the news

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

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

Cambridge Semantics Announces Major Upgrades to Its Award ...
23 January 2020, Business Wire

Back to the future: Does graph database success hang on query ...
5 March 2018, ZDNet

Knowledge graph evolution: Platforms that speak your language
30 January 2020, ZDNet

provided by Google News

IBM Teams Up With Amazon for Cloud Database Service
3 December 2023, The Motley Fool

Oracle Cloud Infrastructure Utilized by Microsoft for Bing ...
7 November 2023, Oracle

Oracle and Microsoft partner to meet demand for AI services
7 November 2023, Technology Magazine

Microsoft to use Oracle’s OCI Supercluster for Bing conversational searches
7 November 2023, InfoWorld

A look at computer industry trends and the bidirectional effects of ...
10 November 2023, Marquette Today

provided by Google News

A look inside the SAP IQ column-oriented database
10 March 2016, TechTarget

RDBMSをデータウエアハウスに使う際の性能劣化、OLTP用途との ...
24 November 2023, 日本経済新聞

New Services In SAP HANA Cloud Lower TCO For Customers In ...
9 April 2021, MarTech Series

What's new in SAP HANA Cloud Services and why it matters
27 June 2019, TechTarget

Arcion CTO on building effective data pipelines – Blocks and Files
28 June 2022, Blocks & Files

provided by Google News

Job opportunities

Senior Associate, Data Governance - Ontology and Data Modeling
Capital One, New York, NY

Senior Manager, Ontology and Data Modeling
Capital One, McLean, VA

Director, Ontology and Data Modeling
Capital One, McLean, VA

Manager, Data Governance - Ontology and Data Modeling
Capital One, New York, NY

Principal Associate, Ontology and Data Modeling
Capital One, New York, NY

Data Entry Technician - Textbooks
Prince George's County Public Schools, Capitol Heights, MD

Oracle Database Administrator
Navisite, United States

Oracle Cloud Engineers
Advent Infotech, New Jersey

Oracle Database Administrator DBA
Tata Technologies, Remote

Lead Database Engineer
Centene, Missouri

Production Area Lead- Merge & Insert
Giesecke+Devrient, Twinsburg, OH

jobs by Indeed



Share this page

Featured Products

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Redis logo

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

Present your product here