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 Oracle DB
 Version 12c
 Drawbacks costly. You get comparable performance with open source rdbms databases
 Advantages Robust. Long proven history. Remote connections very stable
 Languages Supported C, C++
 Website https://www.oracle.com
 Name Oracle DB
 XML Support yes
 JSON Support yes
 Brief description It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads
 Database Model Primarily a relational database
 Technical Documentation docs.oracle.com/en/database
 License Commercial
 Cloud-based / SaaS Available in AWS, Azure Clouds. Available as a SaaS option in Oracle Cloud
 Implementation Language C,C++
 Operating System Supported AIX HP-UX Linux OS X Solaris Windows z/OS
 Options for Integration / Access API Rest API (Oracle Lite), Oracle Call Interface (OCI) JDBC ODBC
 Consistency Highly Consistent
 Foreign Keys Yes
 Streaming Support No
 Analytics Support Need to buy Exadata (high cost)
 Data Storage Schema 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