DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > SAP IQ vs. Stardog vs. TempoIQ vs. Teradata

System Properties Comparison SAP IQ vs. Stardog vs. TempoIQ vs. Teradata

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameSAP IQ infoformer name: Sybase IQ  Xexclude from comparisonStardog  Xexclude from comparisonTempoIQ infoformerly TempoDB  Xexclude from comparisonTeradata  Xexclude from comparison
TempoIQ seems to be decommissioned. It will be removed from the DB-Engines ranking.
DescriptionColumnar RDBMS optimized for Big Data analyticsEnterprise Knowledge Graph platform and graph DBMS with high availability, high performance reasoning, and virtualizationScalable analytics DBMS for sensor data, provided as a service (SaaS)A hybrid cloud data analytics software platform (Teradata Vantage)
Primary database modelRelational DBMS infocolumn-orientedGraph DBMS
RDF store
Time Series DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.64
Rank#108  Overall
#52  Relational DBMS
Score2.07
Rank#122  Overall
#11  Graph DBMS
#6  RDF stores
Score44.87
Rank#22  Overall
#15  Relational DBMS
Websitewww.sap.com/­products/­technology-platform/­sybase-iq-big-data-management.htmlwww.stardog.comtempoiq.com (offline)www.teradata.com
Technical documentationhelp.sap.com/­docs/­SAP_IQdocs.stardog.comdocs.teradata.com
DeveloperSAP, formerly SybaseStardog-UnionTempoIQTeradata
Initial release1994201020121984
Current release16.1 SPS04, April 20197.3.0, May 2020Teradata Vantage 1.0 MU2, January 2019
License infoCommercial or Open Sourcecommercialcommercial info60-day fully-featured trial license; 1-year fully-featured non-commercial use license for academics/studentscommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJava
Server operating systemsAIX
HP-UX
Linux
Solaris
Windows
Linux
macOS
Windows
hosted
Linux
Data schemeyesschema-free and OWL/RDFS-schema supportschema-freeyes
Typing infopredefined data types such as float or dateyesyesyesyes
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 infoImport/export of XML data possiblenoyes
Secondary indexesyesyes infosupports real-time indexing in full-text and geospatialyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash index
SQL infoSupport of SQLyesYes, compatible with all major SQL variants through dedicated BI/SQL Servernoyes infoSQL 2016 + extensions
APIs and other access methodsADO.NET
JDBC
ODBC
RESTful HTTP API
GraphQL query language
HTTP API
Jena RDF API
OWL
RDF4J API
Sesame REST HTTP Protocol
SNARL
SPARQL
Spring Data
Stardog Studio
TinkerPop 3
HTTP API.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
Supported programming languagesC
C#
C++
Java
Perl
PHP
Python
Ruby
.Net
Clojure
Groovy
Java
JavaScript
Python
Ruby
C#
Java
JavaScript infoNode.js
Python
Ruby
C
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
Server-side scripts infoStored proceduresyesuser defined functions and aggregates, HTTP Server extensions in Javanoyes infoUDFs, stored procedures, table functions in parallel
Triggersyesyes infovia event handlersyes infoRealtime Alertsyes
Partitioning methods infoMethods for storing different data on different nodesshared disk or shared nothing architectures with SAP IQ MultiplexernoneSharding infoHashing
Replication methods infoMethods for redundantly storing data on multiple nodesSAP/Sybase Replication ServerMulti-source replication in HA-ClusterMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsHadoop integrationnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency in HA-ClusterImmediate Consistency
Foreign keys infoReferential integrityyesyes inforelationships in graphsnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
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.noyesnoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and rolessimple authentication-based access controlfine 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

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

More resources
SAP IQ infoformer name: Sybase IQStardogTempoIQ infoformerly TempoDBTeradata
DB-Engines blog posts

Teradata is the most popular data warehouse DBMS
2 April 2013, Paul Andlinger

show all

Recent citations in the news

New Services for SAP HANA Cloud Database
7 April 2021, SAP News

SAP Products & Services Data Portfolio
2 July 2021, Datamation

SAP Scales Out HANA In-Memory For Clouds
6 March 2014, EnterpriseAI

Using SAP Hana as a data warehouse
17 August 2015, ComputerWeekly.com

2021 SAP Data and Analytics Virtual Forum
27 April 2021, SAP News

provided by Google News

No-Code Internet of Things Development Platform
29 October 2015, Automation World

provided by Google News

Teradata Stock: Much More Enticing Now Than Last Year, But Uncertainty Lingers (NYSE:TDC)
14 June 2024, Seeking Alpha

Is There Now An Opportunity In Teradata Corporation (NYSE:TDC)?
11 June 2024, Simply Wall St

Teradata Stock Analysis: Don't Let the Amazon News Fool You Into Buying Now
10 June 2024, InvestorPlace

Schroder Investment Management Group Cuts Stake in Teradata Co. (NYSE:TDC)
12 June 2024, Defense World

Lakehouse dam breaks after departure of long-time Teradata CTO
1 May 2024, The Register

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

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

Neo4j logo

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

Present your product here