DB-Tools.com - system comparision
3rd December 2020, Thursday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Azure Cosmos DB Hive
 Name Azure Cosmos DB --
 Version NA 3.1.2
 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 Can run only on Hadoop with mapreduce
 Advantages NA A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported .net, C#, Javascript --
 Website www.azure.microsoft.com/­services/­cosmos-db https://hive.apache.org
 XML Support no no
 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) The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage. A command line tool and JDBC driver are provided to connect users to Hive
 Database Model Key Value DB Tabular Data Model
 Technical Documentation docs.microsoft.com/­en-us/­azure/­cosmos-db --
 License commercial on azure cloud. --
 Cloud-based / SaaS Azure Cloud based --
 Implementation Language NA C,C++
 Operating System Supported Linux , OS X, Windows Linux, OS X,
 Options for Integration / Access API Rest API , MongoDB drivers -
 Consistency Eventual consistency Highly Consistent
 Foreign Keys No No
 Streaming Support No Yes
 Analytics Support NA --
 Data Storage Schema Multi Model Database --
 Notable Users -- -
 Key Differentiator -- Probably most Widely used reporting database in big data ecosystem . Has a web front end
 Concurrency -- Yes
 Partitioning -- Yes
 Replication -- Yes
 Secondary Indexes -- Yes
 SchemaLess -- --
 SQL Query -- No