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 AWS Redshift 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