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

DBMS > Altibase vs. Microsoft SQL Server

System Properties Comparison Altibase vs. Microsoft SQL Server

Please select another system to include it in the comparison.

Our visitors often compare Altibase and Microsoft SQL Server with MySQL, PostgreSQL and Oracle.

Editorial information provided by DB-Engines
NameAltibase  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparison
DescriptionAn enterprise grade, high-performance RDBMSMicrosofts relational DBMS
Primary database modelRelational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.45
Rank#139  Overall
#70  Relational DBMS
Score1075.87
Rank#3  Overall
#3  Relational DBMS
Websitealtibase.comwww.microsoft.com/­en-us/­sql-server
Technical documentationaltibase.com/­resources/­manualsdocs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentation
DeveloperAltibaseMicrosoft
Initial release19991989
Current release7.1, July 2017SQL Server 2019, November 2019
License infoCommercial or Open SourceOpen Source infosince February 2018commercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++
Server operating systemsAIX
HP-UX
Linux
Linux
Windows
Data schemeyesyes
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.noyes
Secondary indexesyesyes
SQL infoSupport of SQLANSI SQL-92yes
APIs and other access methodsJDBC
ODBC
Proprietary protocol
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesC
C++
Java
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresstored procedures and stored functionsTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingtables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes, but depending on the SQL-Server Edition
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes
Durability infoSupport for making data persistentyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
AltibaseMicrosoft SQL Server
Specific characteristicsAltibase is an enterprise grade open source DBMS . It allows for high performance...
» more
Competitive advantagesSince its inception, Altibase has been renowned for its in-memory capabilities. Altibase...
» more
Typical application scenariosAltibase has been deployed for over 6000 mission-critical use cases that demand hundreds...
» more
Key customersSince 1999, Altibase has served over 600 enterprise clients including 9 Fortune Global...
» more
Market metricsOver 600 global enterprise clients including 8 Fortune Global 500 companies Over...
» more
Licensing and pricing modelsNo License Cost Altibase is an open source DBMS which includes its sharding Subscription...
» 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
AltibaseMicrosoft SQL Server
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

Global In-memory Computing Market 2020-2026 IBM, Oracle, SAP, Altibase
31 July 2020, NJ MMA News

In-memory OLAP Database Market latest demand by 2020-2026 with leading players like – Altibase, IBM, Microsoft, Oracle, SAP SE
31 July 2020, Research Newspaper

Relational In-Memory Database Market Next Big Thing | Major Giants SAP, Teradata, Amazon
1 August 2020, Bulletin Line

In-Memory Computing (IMC) Market Foresight By 2028 | Key Companies- IBM, Oracle, SAP, Altibase, Giga Spaces
30 July 2020, The Daily Chronicle

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

provided by Google News

Global SQL Server Transformation Market Growth Rate and Economic Impact By Covid-19 Outbreak - Oracle, Actian Corporation, Microsoft, IBM, Alphabet, SAP SE etc.
3 August 2020, Market Research Posts

Understanding Columnstore Indexes in SQL Server
22 July 2020, Redmondmag.com

DH2i to Address How to Mitigate Microsoft SQL Server Costs Amidst Pandemic-Ravaged Budgets
28 July 2020, PRNewswire

Benchmarking SQL Server and Azure SQL with WorkloadTools | Data Exposed - Microsoft
21 July 2020, Channel 9

Amazon RDS for SQL Server reduces prices on Enterprise Edition in the Multi-AZ configuration
28 July 2020, idk.dev

provided by Google News

Job opportunities

Sql Server Developer
SDH Systems, Redmond, WA

SQL Server DBA
CGI Group, Inc., Belton, TX

SQL Server database developer
Health & Human Services Comm, Austin, TX

SQL Server DBA
DB Best Technologies, Redmond, WA

Claims Systems Specialist
EviCore, Remote

jobs by Indeed




Share this page

Featured Products

Neo4j logo

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

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.

Present your product here