DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Atos Standard Common Repository vs. Ingres vs. Teradata vs. TimescaleDB

System Properties Comparison Atos Standard Common Repository vs. Ingres vs. Teradata vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAtos Standard Common Repository  Xexclude from comparisonIngres  Xexclude from comparisonTeradata  Xexclude from comparisonTimescaleDB  Xexclude from comparison
This system has been discontinued and will be removed from the DB-Engines ranking.
DescriptionHighly scalable database system, designed for managing session and subscriber data in modern mobile communication networksWell established RDBMSA hybrid cloud data analytics software platform (Teradata Vantage)A time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelDocument store
Key-value store
Relational DBMSRelational DBMSTime Series DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Time Series DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.80
Rank#82  Overall
#44  Relational DBMS
Score44.87
Rank#22  Overall
#15  Relational DBMS
Score4.46
Rank#71  Overall
#5  Time Series DBMS
Websiteatos.net/en/convergence-creators/portfolio/standard-common-repositorywww.actian.com/­databases/­ingreswww.teradata.comwww.timescale.com
Technical documentationdocs.actian.com/­ingresdocs.teradata.comdocs.timescale.com
DeveloperAtos Convergence CreatorsActian CorporationTeradataTimescale
Initial release20161974 infooriginally developed at University Berkely in early 1970s19842017
Current release170311.2, May 2022Teradata Vantage 1.0 MU2, January 20192.15.0, May 2024
License infoCommercial or Open SourcecommercialcommercialcommercialOpen 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 languageJavaCC
Server operating systemsLinuxAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
hosted
Linux
Linux
OS X
Windows
Data schemeSchema and schema-less with LDAP viewsyesyesyes
Typing infopredefined data types such as float or dateoptionalyesyesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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.yesno infobut tools for importing/exporting data from/to XML-files availableyesyes
Secondary indexesyesyesyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash indexyes
SQL infoSupport of SQLnoyesyes infoSQL 2016 + extensionsyes infofull PostgreSQL SQL syntax
APIs and other access methodsLDAP.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesAll languages with LDAP bindingsC
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnoyesyes infoUDFs, stored procedures, table functions in paralleluser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersyesyesyesyes
Partitioning methods infoMethods for storing different data on different nodesSharding infocell divisionhorizontal partitioning infoIngres Star to access multiple databases simultaneouslySharding infoHashingyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesyesIngres ReplicatorMulti-source replication
Source-replica replication
Source-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of specific operationsACIDACIDACID
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 controlLDAP bind authenticationfine grained access rights according to SQL-standardfine 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

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

More resources
Atos Standard Common RepositoryIngresTeradataTimescaleDB
DB-Engines blog posts

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

show all

Recent citations in the news

Actian Launches Ingres 12.0 Database
4 June 2024, PR Newswire

Postgres pioneer Michael Stonebraker promises to upend the database once more
26 December 2023, The Register

New startup from Postgres creator puts the database at heart of software stack
12 March 2024, TechCrunch

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

Dr. Michael Stonebraker: A Short History of Database Systems
1 February 2019, The New Stack

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

TimescaleDB Is a Vector Database Now, Too
25 September 2023, Datanami

Timescale Acquires PopSQL to Bring a Modern, Collaborative SQL GUI to PostgreSQL Developers
4 April 2024, PR Newswire

Power IoT and time-series workloads with TimescaleDB for Azure Database for PostgreSQL
18 March 2019, azure.microsoft.com

Timescale Valuation Rockets to Over $1B with $110M Round, Marking the Explosive Rise of Time-Series Data
22 February 2022, Business Wire

Timescale announces $15M investment and new enterprise version of TimescaleDB
29 January 2019, TechCrunch

provided by Google News



Share this page

Featured Products

Neo4j logo

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

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

Present your product here