Google Cloud Spanner vs. Oracle Database Cloud Service

Google Cloud Spanner is suited for limitless horizontal scaling while maintaining strong consistency which needs to support ACID. NoSQL databases work in scaling but no ACID support. RDBMS support ACID, but horizontal scaling is not as great. The API it provides result in some limitations to related areas of the code, such as connection pools or database linking framework. So high # of connection pools can vary.

Incentivized

• Cost Effective & Flexible: Customers can start as low as a single OCPU VM up to 24 OCPUs. Customers pay only for OCPUs and Storage used.
• Ease Of Getting Started: Customers can easily create Oracle Certified, full-featured, fully supported 11g, 12c (both 12.1 & 12.2) databases with choice of any database edition.
• Built-in High Availability Constructs: Customers can easily deploy 2-node RAC configurations with all the VM shapes. For example: Easily deploy a 2-node RAC configuration with 2 core Virtual Machines and shared block storage of up to 40 TB.
• Durable & Scalable Storage: Customers can use remote storage starting at 256GB up to 40 TB. Storage can be scale up with no downtime.
• Secure: Customers still get all the advantages of our Oracle IAM for management control and VCN Security lists for securing their database environments.

Incentivized

• Super high availability
• Scales automatically
• High standard SLA

Incentivized

• Eliminates the requirement of hardware and installation.
• Minimizes the cost of operation and maintenance.
• Scalable to meet the increase in requirements.
• Enhances integrity, connectivity and performance of our applications.
• Reliable in terms of data security.
• Improved speed of querying and searching.

Incentivized

• Support for Views
• Support for more databases (schemas).
• More index types that can be supported (Functional)
• Backups (ie table/data backup) if data is deleted or truncate by accident.

Incentivized

• When we restart the DBaaS instance, it seems like we had to add the NIC network back again. I'm not sure if it's specific to our instance configuration!

Incentivized

At that point, we were looking at something [that] can hold our relational database, [...] provide stable connection, and maintain high ACID transition. BigTable is for nonrelational database so it was out of our [sight] very quickly. BigQuery is a data warehouse that can hold huge amount of data but not ideal for transition. AWS RDS is [...] similar to Spanner but because most of our services are already on GCP, so we went with Spanner.

Incentivized

I would prefer the oracle database as service where my complete implementation is on Oracle Cloud Platform and as BI Implementation where datawarehouse is built on oracle database.

Incentivized

• Backups specifically if transactional data is deleted. Restoring made us lose time.
• Sharding on Horizontal level was quick and easy. Deployment and increasing nodes is easy
• Large dataset handling.
• ACID compliance

Incentivized

• Billing on Hosted Environment per hour, OCPU per hour, block volumes, object storage, etc.
• Costing & maintenance, patching.
• Security & TDE cycles.
• Backups & recovery.
• The features are complemented by database lifecycle management features, like configuration management, performance management, patch automation, etc. which make the solution complete from a DBaaS administrator’s perspective as well.
• Manager 12c covers all the major use cases for DBaaS, which yield significant business benefits and high ROI.

Incentivized