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

DBMS > Adabas vs. Datastax Enterprise vs. Linter vs. Microsoft Azure AI Search vs. Microsoft Azure Synapse Analytics

System Properties Comparison Adabas vs. Datastax Enterprise vs. Linter vs. Microsoft Azure AI Search vs. Microsoft Azure Synapse Analytics

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonDatastax Enterprise  Xexclude from comparisonLinter  Xexclude from comparisonMicrosoft Azure AI Search  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformDataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.RDBMS for high security requirementsSearch-as-a-service for web and mobile app developmentElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelMultivalue DBMSWide column storeRelational DBMSSearch engineRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Search engine
Vector DBMS
Spatial DBMSVector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.79
Rank#102  Overall
#2  Multivalue DBMS
Score5.93
Rank#56  Overall
#4  Wide column stores
Score0.12
Rank#350  Overall
#152  Relational DBMS
Score5.52
Rank#59  Overall
#6  Search engines
Score19.93
Rank#31  Overall
#19  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlwww.datastax.com/­products/­datastax-enterpriselinter.ruazure.microsoft.com/­en-us/­services/­searchazure.microsoft.com/­services/­synapse-analytics
Technical documentationdocs.datastax.comlearn.microsoft.com/­en-us/­azure/­searchdocs.microsoft.com/­azure/­synapse-analytics
DeveloperSoftware AGDataStaxrelex.ruMicrosoftMicrosoft
Initial release19712011199020152016
Current release6.8, April 2020V1
License infoCommercial or Open Sourcecommercialcommercialcommercialcommercialcommercial
Cloud-based only infoOnly available as a cloud servicenononoyesyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Datastax Astra DB: Astra DB simplifies cloud-native Cassandra application development for your apps, microservices and functions. Deploy in minutes on AWS, Google Cloud, Azure, and have it managed for you by the experts, with serverless, pay-as-you-go pricing.
Implementation languageJavaC and C++C++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
Linux
OS X
AIX
Android
BSD
HP Open VMS
iOS
Linux
OS X
VxWorks
Windows
hostedhosted
Data schemeyesschema-freeyesyesyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nonononono
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewaySQL-like DML and DDL statements (CQL); Spark SQLyesnoyes
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
Proprietary protocol infoCQL (Cassandra Query Language)
TinkerPop Gremlin infowith DSE Graph
ADO.NET
JDBC
LINQ
ODBC
OLE DB
Oracle Call Interface (OCI)
RESTful HTTP APIADO.NET
JDBC
ODBC
Supported programming languagesNaturalC
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
C#
C++
Java
Perl
PHP
Python
Qt
Ruby
Tcl
C#
Java
JavaScript
Python
C#
Java
PHP
Server-side scripts infoStored proceduresin Naturalnoyes infoproprietary syntax with the possibility to convert from PL/SQLnoTransact SQL
Triggersnoyesyesnono
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaSharding infono "single point of failure"noneSharding infoImplicit feature of the cloud serviceSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event Replicatorconfigurable replication factor, datacenter aware, advanced replication for edge computingSource-replica replicationyes infoImplicit feature of the cloud serviceyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Tunable Consistency infoconsistency level can be individually decided with each write operation
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesnono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraints
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoAtomicity and isolation are supported for single operationsACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Access rights for users can be defined per objectfine grained access rights according to SQL-standardyes infousing Azure authenticationyes
More information provided by the system vendor
Adabas infodenotes "adaptable data base"Datastax EnterpriseLinterMicrosoft Azure AI SearchMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Specific characteristicsDataStax Enterprise is scale-out data infrastructure for enterprises that need to...
» more
Competitive advantagesSupporting the following application requirements: Zero downtime - Built on Apache...
» more
Typical application scenariosApplications that must be massively and linearly scalable with 100% uptime and able...
» more
Key customersCapital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
» more
Market metricsAmong the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
» more
Licensing and pricing modelsAnnual 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

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

More resources
Adabas infodenotes "adaptable data base"Datastax EnterpriseLinterMicrosoft Azure AI SearchMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Recent citations in the news

Re-evaluating legacy: Should you leave Adabas (and Natural) behind?
30 May 2024, ITWeb

State agency proves DevOps and mainframes can coexist
12 April 2024, SiliconANGLE News

IBM buys 50-year-old Software AG's enterprise tech units for €2.13B in cash
18 December 2023, The Register

Michael E. Jakes Obituary (1941 - 2023)
26 October 2023, Legacy.com

Is it the end of the road for Software AG after selling its integration business to IBM?
12 January 2024, diginomica

provided by Google News

DataStax previews new Hyper Converged Data Platform for enterprise AI
15 May 2024, VentureBeat

DataStax Launches New Hyper-Converged Data Platform Giving Enterprises the Complete Modern Data Center Suite ...
15 May 2024, Business Wire

DataStax and LlamaIndex Partner to Make Building RAG Applications Easier than Ever for GenAI Developers
20 February 2024, insideBIGDATA

DataStax Introduces Enhanced RAG Capabilities Through Astra DB and NVIDIA Tech
19 March 2024, Datanami

DataStax goes vector searching with Astra DB
20 July 2023, Blocks and Files

provided by Google News

Announcing updates to Azure AI Search to help organizations build and scale generative AI applications
4 April 2024, Microsoft

Azure OpenAI Service: Transforming legal practices with generative AI solutions
12 June 2024, Microsoft

Public Preview of Azure OpenAI and AI Search in-app connectors for Logic Apps (Standard) | Azure updates
2 April 2024, Microsoft

Raise the bar on AI-powered app development with Azure Database for PostgreSQL
5 June 2024, Microsoft

Microsoft’s Azure AI Search updated with increased storage, vector index size
5 April 2024, InfoWorld

provided by Google News

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA | Azure updates
8 April 2024, azure.microsoft.com

Azure Synapse Runtime for Apache Spark 3.2 End of Support | Azure updates
22 March 2024, azure.microsoft.com

Azure Synapse Analytics: Everything you need to know about Microsoft's cloud analytics platform
24 September 2023, DataScientest

Migrate Microsoft Azure Synapse Analytics to Amazon Redshift using AWS SCT | Amazon Web Services
18 October 2023, AWS Blog

Azure Synapse vs. Databricks: Data Platform Comparison 2024
26 March 2024, eWeek

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