DB-Tools.com - system comparision
21st May 2019, Tuesday

 

Home > System Comparision

Oracle DB System Properties

Please Choose another system to see its propertiess Click here

Editorial information provided by DB-Tools
 System Oracle DB
  Db-Tools Ranking

Trend Rank   

Score : #11.07

Rank :  #5  Overall
       #5  Database
 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

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