DB-Tools.com - system comparision
20th September 2021, Monday
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Exadata Hive
 Version x6-8 3.1.2
 Drawbacks Very costly. You get comparable performance with lower cost Can run only on Hadoop with mapreduce
 Advantages Robust. Comes from the Oracle Stable A file system can be loaded to a Hive data store AS-IS and can be queried using SQL
 Languages Supported All languages supported by Oracle Database --
 Website https://www.oracle.com/engineered-systems/exadata/index.html https://hive.apache.org
 XML Support -- no
 JSON Support -- yes
 Brief description -- 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 -- Tabular Data Model
 Technical Documentation -- --
 License -- --
 Cloud-based / SaaS -- --
 Implementation Language -- C,C++
 Operating System Supported -- Linux, OS X,
 Options for Integration / Access API -- -
 Consistency -- Highly Consistent
 Foreign Keys -- No
 Streaming Support -- Yes
 Analytics Support -- --
 Data Storage Schema -- --
 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