Amazon Aurora

Website

aws.amazon.com

Release Date

2014 October

Categories

#Databases #Relational Databases #Tool #NoSQL Databases

Oracle Database 12c

Website

oracle.com

Release Date

-

Categories

#Databases #Relational Databases #NoSQL Databases #Tool

Amazon Aurora features and specs

• High Performance
  Amazon Aurora is designed to provide up to five times the throughput of standard MySQL and three times the throughput of standard PostgreSQL databases.
• Scalability
  Aurora scales storage automatically, growing from 10GB up to 128TB with no downtime. This automatic scaling makes it ideal for applications with fluctuating workloads.
• High Availability and Durability
  Aurora automatically replicates six copies of data across three availability zones and continuously backs up data to Amazon S3, ensuring durability.
• Security
  Aurora offers multiple layers of security including network isolation using Amazon VPC, encryption at rest using keys that you create and control through AWS Key Management Service (KMS), and encryption of data in transit using SSL.
• Fully Managed
  Aurora is fully managed by AWS, which automates time-consuming administrative tasks such as hardware provisioning, database setup, patching, and backups.
• Compatibility
  Aurora is compatible with MySQL and PostgreSQL, making it easier to migrate existing applications to Aurora with minimal changes.

Possible disadvantages of Amazon Aurora

• Cost
  Aurora can be more expensive than traditional RDS instances, particularly for workloads that do not fully utilize its high performance and scalability features.
• Complexity
  The numerous features and configurations can make Aurora complex to manage and tune, especially for those who are not familiar with AWS services.
• Vendor Lock-in
  Adopting Aurora ties you into the AWS ecosystem, which can make it difficult to migrate to other cloud providers or on-premises systems.
• Cold Start Latency
  Aurora Serverless can experience latency during cold starts, which can be problematic for applications requiring instant scalability.
• Limited to AWS Environment
  Aurora is only available within the AWS environment, which can be limiting if your infrastructure spans multiple cloud providers.

Oracle Database 12c features and specs

• Multi-tenant Architecture
  Oracle Database 12c introduces a multi-tenant architecture that allows a single container database to hold many pluggable databases, which makes it easier to consolidate databases and manage them collectively.
• In-Memory Processing
  This feature allows data to be stored in memory, significantly improving query performance and providing real-time analytics capabilities.
• Advanced Security
  Enhanced security features, including data redaction, key management, and robust auditing, ensure compliance with regulatory requirements and protect sensitive data.
• Automated Management
  Oracle Database 12c offers advanced automation capabilities for routine tasks such as backup, patching, and tuning, reducing administrative overhead and operational costs.
• Scalability
  This version supports scalability and high availability features, including Real Application Clusters (RAC) and Data Guard, making it suitable for enterprise-level applications.

Possible disadvantages of Oracle Database 12c

• Complexity
  Oracle Database 12c is complex to set up and manage, requiring specialized knowledge and skills, which can result in increased operational complexity.
• Cost
  The licensing and maintenance costs for Oracle Database 12c can be prohibitively high, especially for small and mid-sized enterprises.
• Resource Intensive
  The database system is resource-intensive, necessitating high-performing hardware and considerable memory and storage resources.
• Compatibility Issues
  There may be compatibility issues with older versions of applications and databases that do not support or integrate well with Oracle Database 12c.
• Learning Curve
  Due to its extensive feature set and complex architecture, there is a steep learning curve for new users and administrators, which may require comprehensive training and certification.

Introduction to Amazon Aurora - Relational Database Built for the Cloud - AWS

More videos:

Koenig Solutions Training Review For Oracle Database 12c and Oracle EBS Training

More videos: