DB-Tools.com - system comparision
26th November 2020, Thursday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Azure Cosmos DB Microsoft SQLServer
 Name Azure Cosmos DB Microsoft SQL Server
 Version NA Sqlserver 2017
 Drawbacks 1.Most often compared with MongoDB. Unlike Mongo DB does not support joins 2.Managed Database which can be used only within Azure/Microsoft framework 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 www.azure.microsoft.com/­services/­cosmos-db www.microsoft.com/en-us/sql-server
 XML Support no yes
 JSON Support yes yes
 Brief description 1.Globally distributed, horizontally scalable, multi-model database service 2.Earlier called Azure Document DB. Skype, Xbox uses this DB, Office, Active Directory and MSC (all Microsoft products) 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 Key Value DB 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 commercial on azure cloud. Commercial
 Cloud-based / SaaS Azure Cloud based Available in AWS, Azure Clouds. Available as a SaaS option in Microsoft Cloud
 Implementation Language NA C,C++
 Operating System Supported Linux , OS X, Windows Linux Windows
 Options for Integration / Access API Rest API , MongoDB drivers OLE DB, Tabular Data Stream (TDS), ADO.NET, JDBC, ODBC
 Consistency Eventual consistency Highly Consistent
 Foreign Keys No Yes
 Streaming Support No No
 Analytics Support NA Need to buy SQLServer Analytics Pack (SSAS)
 Data Storage Schema Multi Model Database 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