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

DBMS > MarkLogic vs. Microsoft Azure SQL Database vs. Oracle vs. searchxml vs. Teradata

System Properties Comparison MarkLogic vs. Microsoft Azure SQL Database vs. Oracle vs. searchxml vs. Teradata

Editorial information provided by DB-Engines
NameMarkLogic  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonOracle  Xexclude from comparisonsearchxml  Xexclude from comparisonTeradata  Xexclude from comparison
DescriptionOperational and transactional Enterprise NoSQL databaseDatabase as a Service offering with high compatibility to Microsoft SQL ServerWidely used RDBMSDBMS for structured and unstructured content wrapped with an application serverA hybrid cloud data analytics software platform (Teradata Vantage)
Primary database modelDocument store
Native XML DBMS
RDF store infoas of version 7
Search engine
Relational DBMSRelational DBMSNative XML DBMS
Search engine
Relational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Document store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
Vector DBMS infosince Oracle 23
Document store
Graph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.18
Rank#63  Overall
#11  Document stores
#1  Native XML DBMS
#1  RDF stores
#7  Search engines
Score76.78
Rank#16  Overall
#11  Relational DBMS
Score1244.08
Rank#1  Overall
#1  Relational DBMS
Score0.03
Rank#390  Overall
#7  Native XML DBMS
#24  Search engines
Score44.87
Rank#22  Overall
#15  Relational DBMS
Websitewww.marklogic.comazure.microsoft.com/­en-us/­products/­azure-sql/­databasewww.oracle.com/­databasewww.searchxml.net/­category/­productswww.teradata.com
Technical documentationdocs.marklogic.comdocs.microsoft.com/­en-us/­azure/­azure-sqldocs.oracle.com/­en/­databasewww.searchxml.net/­support/­handoutsdocs.teradata.com
DeveloperMarkLogic Corp.MicrosoftOracleinformationpartners gmbhTeradata
Initial release20012010198020151984
Current release11.0, December 2022V1223c, September 20231.0Teradata Vantage 1.0 MU2, January 2019
License infoCommercial or Open Sourcecommercial inforestricted free version is availablecommercialcommercial inforestricted free version is availablecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++C and C++C++
Server operating systemsLinux
OS X
Windows
hostedAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Windowshosted
Linux
Data schemeschema-free infoSchema can be enforcedyesyes infoSchemaless in JSON and XML columnsschema-freeyes
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.yesyesyesyesyes
Secondary indexesyesyesyesyesyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash index
SQL infoSupport of SQLyes infoSQL92yesyes infowith proprietary extensionsnoyes infoSQL 2016 + extensions
APIs and other access methodsJava API
Node.js Client API
ODBC
proprietary Optic API infoProprietary Query API, introduced with version 9
RESTful HTTP API
SPARQL
WebDAV
XDBC
XQuery
XSLT
ADO.NET
JDBC
ODBC
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
RESTful HTTP API
WebDAV
XQuery
XSLT
.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
Supported programming languagesC
C#
C++
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
C++ infomost other programming languages supported via APIsC
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
Server-side scripts infoStored proceduresyes infovia XQuery or JavaScriptTransact SQLPL/SQL infoalso stored procedures in Java possibleyes infoon the application serveryes infoUDFs, stored procedures, table functions in parallel
Triggersyesyesyesnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingSharding, horizontal partitioningnoneSharding infoHashing
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes, with always 3 replicas availableMulti-source replication
Source-replica replication
yes infosychronisation to multiple collectionsMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infovia Hadoop Connector, HDFS Direct Access and in-database MapReduce jobsnono infocan be realized in PL/SQLnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infocan act as a resource manager in an XA/JTA transactionACIDACID infoisolation level can be parameterizedmultiple readers, single writerACID
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.yes, with Range Indexesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'noyes
User concepts infoAccess controlRole-based access control at the document and subdocument levelsfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardDomain, group and role-based access control at the document level and for application servicesfine 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
3rd partiesDevart ODBC driver for Oracle accesses Oracle databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32 and 64-bit Windows, macOS, and Linux.
» more

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

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

More resources
MarkLogicMicrosoft Azure SQL Database infoformerly SQL AzureOraclesearchxmlTeradata
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

show all

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

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

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

show all

Conferences, events and webinars

Oracle Cloud World
Las Vegas, 9-12 September 2024

Recent citations in the news

MarkLogic “The NoSQL Database”. In the MarkLogic Query Console, you can… | by Abhay Srivastava | Apr, 2024
22 April 2024, Medium

Database Platform to Simplify Complex Data | Progress Marklogic
7 February 2023, Progress Software

ABN AMRO Moves Progress-Powered Credit Store App to Azure Cloud; Achieves 40% Faster Data Processing, Lower ...
12 March 2024, GlobeNewswire

AI can make logistics data as valuable as intelligence or operational data for mission success
17 April 2024, Breaking Defense

Seven Quick Steps to Setting Up MarkLogic Server in Kubernetes
1 February 2024, release.nl

provided by Google News

Copilot in Azure SQL Database in Private Preview
27 March 2024, InfoQ.com

Microsoft unveils Copilot for Azure SQL Database
27 March 2024, InfoWorld

Azure SQL Database migration to OCI - resources estimation and migration approach
11 January 2024, blogs.oracle.com

Why migrate Windows Server and SQL Server to Azure: ROI, innovation, and free offers
25 April 2024, microsoft.com

Expand the limits of innovation with Azure data
21 March 2024, microsoft.com

provided by Google News

Understanding the different Oracle Database options under the OCI-Microsoft Azure partnership
21 May 2024, blogs.oracle.com

Announcing Oracle Database 23ai : General Availability
2 May 2024, blogs.oracle.com

Oracle and Microsoft bring Oracle Database@Azure to Europe
14 March 2024, blogs.oracle.com

Oracle Plans to Open Two Public Cloud Regions in Morocco
30 May 2024, PR Newswire

Unveiling the Power of Oracle Globally Distributed Database: Oracle Database 23ai Advancements
2 May 2024, blogs.oracle.com

provided by Google News

Big Data News: Cloudera, Splunk, Clustrix, Teradata
31 May 2024, Data Center Knowledge

Is There Now An Opportunity In Teradata Corporation (NYSE:TDC)?
28 May 2024, Yahoo Finance

Should You Be Excited About Teradata Corporation's (NYSE:TDC) 78% Return On Equity?
27 May 2024, Simply Wall St

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

Prepare and load Amazon S3 data into Teradata using AWS Glue through its native connector for Teradata Vantage ...
30 November 2023, AWS Blog

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.

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

Milvus logo

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

Present your product here