DB-EngineseXtremeDB: 5 9's high availability databaseEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Altibase vs. Axibase vs. Microsoft SQL Server vs. TimescaleDB

System Properties Comparison Altibase vs. Axibase vs. Microsoft SQL Server vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAltibase  Xexclude from comparisonAxibase  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionAn enterprise grade, high-performance RDBMSScalable TimeSeries DBMS based on HBase with integrated rule engine and visualizationMicrosofts relational DBMSA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelRelational DBMSTime Series DBMSRelational DBMSTime Series DBMS
Secondary database modelsDocument store
Graph DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.50
Rank#142  Overall
#70  Relational DBMS
Score0.33
Rank#256  Overall
#19  Time Series DBMS
Score1062.76
Rank#3  Overall
#3  Relational DBMS
Score2.73
Rank#105  Overall
#6  Time Series DBMS
Websitealtibase.comaxibase.com/­products/­axibase-time-series-databasewww.microsoft.com/­en-us/­sql-serverwww.timescale.com
Technical documentationaltibase.com/­resources/­manualsgithub.com/­axibase/­atsddocs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentationdocs.timescale.com
DeveloperAltibaseAxibase CorporationMicrosoftTimescale
Initial release1999201319892017
Current release7.1, July 201715585SQL Server 2019, November 2019
License infoCommercial or Open SourceOpen Source infosince February 2018commercial infoCommunity Edition (single node) is free, Enterprise Edition (distributed) is paidcommercial inforestricted free version is availableOpen 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 languageC++JavaC++C
Server operating systemsAIX
HP-UX
Linux
LinuxLinux
Windows
Linux
OS X
Windows
Data schemeyesyesyesyes
Typing infopredefined data types such as float or dateyesyes infoshort, integer, long, float, double, decimal, stringyesnumerics, 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.nonoyesyes
Secondary indexesyesnoyesyes
SQL infoSupport of SQLANSI SQL-92SQL-like query languageyesyes infofull PostgreSQL SQL syntax
APIs and other access methodsJDBC
ODBC
Proprietary protocol
JDBC
Proprietary protocol (Network API)
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesC
C++
Java
Go
Java
PHP
Python
R
Ruby
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresstored procedures and stored functionsyesTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javauser 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 nodesShardingShardingtables can be distributed across several files (horizontal partitioning); sharding through federationyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesyesSource-replica replicationyes, but depending on the SQL-Server EditionSource-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
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.yesyesno
User concepts infoAccess controlfine 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
AltibaseAxibaseMicrosoft SQL ServerTimescaleDB
Specific characteristicsAltibase is an enterprise grade open source DBMS . It allows for high performance...
» more
Timescale is the creator of TimescaleDB , the first open-source relational database...
» more
Competitive advantagesSince its inception, Altibase has been renowned for its in-memory capabilities. Altibase...
» more
TimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosAltibase has been deployed for over 6000 mission-critical use cases that demand hundreds...
» more
DevOps and Infrastructure Monitoring All monitoring data is time-series data. Efficiently...
» more
Key customersSince 1999, Altibase has served over 600 enterprise clients including 9 Fortune Global...
» more
TransferWise, Maersk, AppDynamics, Walmart, Comcast, LaunchDarkly, IBM, NOV, Cisco,...
» more
Market metricsOver 600 global enterprise clients including 8 Fortune Global 500 companies Over...
» more
With over 9,000 GitHub stars and growing, 600,000 active databases, and an active...
» more
Licensing and pricing modelsNo License Cost Altibase is an open source DBMS which includes its sharding Subscription...
» more
TimescaleDB comes in 3 versions, including fully managed Cloud-hosted solutions*,...
» 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
3rd partiesNavicat for SQL Server gives you a fully graphical approach to database management and development.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

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

More resources
AltibaseAxibaseMicrosoft SQL ServerTimescaleDB
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

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

Increasing Huge Demand for Global In Memory Computing Market with Covid-19 Impact Analysis | IBM, SAP SE, Oracle, Microsoft, Altibase
8 September 2020, The Daily Chronicle

In-Memory Computing (IMC) Market 2020 Key vendors Analysis with Industry Opportunities: IBM, Oracle, SAP, Altibase, Giga Spaces, Hazelcast, Microsoft| Forecast Report Till 2025
22 September 2020, Crypto Daily

Altibase Is Chosen for MOIS's Public Safety LTE for its Reliability and Resilience
21 October 2019, PRNewswire

Global In-memory Computing Market Expected to reach growth rate of XX% CAGR by 2025 (Pandamic Impact Analysis): IBM, Oracle, SAP, Altibase, Giga Spaces, Grid Gain Systems
23 September 2020, The Market Records

In-memory OLAP Database Market 2020 Analysis by Current Industry Status & Growth Opportunities by Top Key Players (Altibase, IBM, Microsoft, Oracle, SAP SE, Exasol, Jedox, Kognitio, Mcobject, MemSQL etc.) Target Audience and Forecast till 2025
22 September 2020, The Market Records

provided by Google News

Time Series Analysis Software Market to Witness Massive Growth by 2025 | Azure Time Series Insights, Trendalyze, Seeq, SensorMesh, Anodot, Shapelets, SenX, TrendMiner, AxiBase Enterprise Reporter (AER)
18 September 2020, SG Research Sphere

Time Series Databases Software Market Size Estimated to Observe Significant Growth with InfluxData, Trendalyze, Amazon Timestream, DataStax, Prometheus, QuasarDB, Warp 10, InfluxDB
22 September 2020, Unica News

Time Series Intelligence Software Market 2020 Predictable to Witness Sustainable Evolution Over 2026 with Anod
19 August 2020, openPR

Time Series Intelligence Software Market 2020 Global Analysis, Trends, Forecast
25 August 2020, News.MarketSizeForecasters.com

Time Series Analysis Software Market Research Report, Growth Forecast 2025
30 May 2020, News by aeresearch

provided by Google News

Hybrid Disaster Recovery Scenarios for SQL Server | Data Exposed - Microsoft
22 September 2020, Channel 9

NoSQL Market to Witness Huge Growth by 2026 | Microsoft SQL Server, MySQL, MongoDB
23 September 2020, The Daily Chronicle

An Introduction to Microsoft Hybrid SQL Server Solutions - Microsoft
15 September 2020, Channel 9

SQL Server Performance Monitoring Tools and Software Market 2020 Trends and Top Players Covered are Solarwinds, dbForge Monitor by Devart, Heroix Longitude, Idera, Sentry One (SQL Sentry), Lepide, Red-Gate, SQL Power Tools, Navicat Monitor
23 September 2020, The Daily Chronicle

Amazon RDS for SQL Server now supports SQL Server 2019
26 August 2020, idk.dev

provided by Google News

TimescaleDB Delivers Another Option for Time-Series Analytics
17 October 2019, Datanami

Database Heterogeneity Helps Address IoT Analytics Challenges
22 September 2020, IoT World Today

Timescale Brings Powerful Time-Series Data Analysis to Developers Worldwide, Now Available in 75+ Cloud Regions
12 August 2020, Business Wire

Timescale Database Now Available in 76 Cloud Regions
12 August 2020, Datanami

The First Complete Life-Cycle Database Management Solution for TimescaleDB
16 April 2019, PRNewswire

provided by Google News

Job opportunities

MS SQL Server DBA 2
Spartan Technologies, Fort Washington, PA

SQL Server Developer
Systems Plus, Washington, DC

Jr. SQL Server Database Administrator (DBA)
AgileRank, LLC, Charlotte, NC

Implementation Consultant - Colorado
Deacom, Inc., Centennial, CO

SQL SERVER DATABASE ADMINISTRATOR
InspiHER Tech, Chicago, IL

Software Engineers Multiple Levels – Cloud Infrastructure Predictive Analytics
PCI, Fort Meade, MD

Hydrological Software Engineer
University of Massachusetts Amherst, Amherst, MA

Software Engineer Cloud Analytics
PCI, Fort Meade, MD

Systems Reliability Engineer
PacketFabric, Culver City, CA

Automation Developer / DevOps Engineer
NVIDIA, Santa Clara, CA

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here