DB-Tools.com - system comparision
25th January 2022, Tuesday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System CouchDB Microsoft SQLServer
 Name CouchDB Microsoft SQL Server
 Version 3.3.5 Sqlserver 2017
 Drawbacks 1 Does not have capabilities present in an RDF data store e.g does not support SparQL high license costs. Applicable for transaction systems in large enterprises
 Advantages NA ACID compliant. Easy to use User Interface
 Languages Supported .net, C#, Javascript C# C++ Delphi Go Java JavaScript (Node.js) PHP Python R (Microsoft R) Ruby Visual Basic
 Website apache.couchdb.org www.microsoft.com/en-us/sql-server
 XML Support NA yes
 JSON Support yes yes
 Brief description Open Source Transactional database with native graph storage and processing As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).
 Database Model Property Graph Primarily a relational database
 Technical Documentation docs.microsoft.com/­en-us/­azure/­cosmos-db docs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentation
 License Community license can be run on 1 node.Enterprise License supports multi-node cluster deployment Commercial
 Cloud-based / SaaS Amazon AMI available, On Prem can be installed Available in AWS, Azure Clouds. Available as a SaaS option in Microsoft Cloud
 Implementation Language Java API C,C++
 Operating System Supported Linux , OS X, Windows Linux Windows
 Options for Integration / Access API Rest API OLE DB, Tabular Data Stream (TDS), ADO.NET, JDBC, ODBC
 Consistency NA Highly Consistent
 Foreign Keys No Yes
 Streaming Support No No
 Analytics Support No Need to buy SQLServer Analytics Pack (SSAS)
 Data Storage Schema Key Value Store presented as Document DB Relational Database
 Notable Users -- Most of the Fortune 500 Companies
 Key Differentiator -- Highly reliable as a transactional database
 Concurrency -- Yes
 Partitioning -- No
 Replication -- Yes
 Secondary Indexes -- Yes
 SchemaLess -- No
 SQL Query -- Yes