DB-Tools.com - system comparision
23rd September 2020, Wednesday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Azure Cosmos DB Oracle DB
 Version NA 12c
 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 costly. You get comparable performance with open source rdbms databases
 Advantages NA Robust. Long proven history. Remote connections very stable
 Languages Supported .net, C#, Javascript C, C++
 Website www.azure.microsoft.com/­services/­cosmos-db https://www.oracle.com
 Name Azure Cosmos DB Oracle DB
 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) It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads
 Database Model Key Value DB Primarily a relational database
 Technical Documentation docs.microsoft.com/­en-us/­azure/­cosmos-db docs.oracle.com/en/database
 License commercial on azure cloud. Commercial
 Cloud-based / SaaS Azure Cloud based Available in AWS, Azure Clouds. Available as a SaaS option in Oracle Cloud
 Implementation Language NA C,C++
 Operating System Supported Linux , OS X, Windows AIX HP-UX Linux OS X Solaris Windows z/OS
 Options for Integration / Access API Rest API , MongoDB drivers Rest API (Oracle Lite), Oracle Call Interface (OCI) JDBC ODBC
 Consistency Eventual consistency Highly Consistent
 Foreign Keys No Yes
 Streaming Support No No
 Analytics Support NA Need to buy Exadata (high cost)
 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