Amazon Athena vs. Oracle Database Cloud Service

If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.

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

• Nested Schemas like JSON data structure
• Ability to adapt the data model to fit your queries better
• Performance Improvement

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

• Query manager can incoperate GUI based query designer
• Auto-completion engine sometimes overwrite the query
• Time range selection should be implicit

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

Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.

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

• Easy to query terabytes of data with faster response
• Pricing model is also cheap
• No indexing and partitioning

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