APJ - ISV - Database

Types of Managed Databases Most types of databases you find out in the field are also offered as managed databases. Additionally, cloud vendors have also developed their own cloud native databases, following common industry trends and offering performance benefits. The major types of sup‐ ported databases include the following: Relational databases As mentioned earlier, some cloud databases are managed ver‐ sions of popular databases in widespread use. For instance, Azure offers Microsoft's traditional SQL Server. Amazon sup‐ ports MariaDB, MySQL, Oracle, PostgreSQL, and SQL Server through its Amazon Relational Database Service (RDS). Such offerings help you to move databases more easily from on- premises installations. In addition, vendors have created databases of their own. For instance, Azure provides Azure Cosmos DB, Google Cloud offers Cloud Spanner, and AWS offers Amazon Aurora. Data warehouses Although these are typically relational databases, they differ from the transaction-oriented databases internally and in their offerings. For instance, transaction-oriented databases usually store all the columns of a single row together so that you can quickly retrieve multiple columns about a customer or product. In contrast, data warehouses in the cloud tend to be columnar, meaning that they store data by column instead of by row. This greatly speeds up common warehouse queries like, "give me the ages of all customers who live in California." The tools offered by cloud vendors with data warehouses focus on fast ingestion and extraction, facilitating their use in big data applications. Amazon Redshift, Google's BigQuery, and Azure's SQL Data Warehouse are examples of these offerings. Nonrelational databases This term is commonly used to cover a variety of different data stores that, unlike traditional relational databases, are built for special-application use cases. Cloud vendors offer a variety of these for different purposes: • Key/value databases offer quick storage and retrieval of val‐ ues without support for more sophisticated operations. Types of Managed Databases | 7

• Cover
• Table of Contents
• Chapter 1. Database Options in the Cloud
• High-Level Effects of Moving to the Cloud
• Self-Managed Versus Managed Databases
• Cloud Native Databases
• Types of Managed Databases
• When a Managed Database Might Not Be a Good Fit
• Role of the DBA in a Managed Database
• Chapter 2. The Changing Role of the DBA in the Cloud
• How DBA Tasks Change in the Cloud
• DBA Tasks That Are Taken Over by the Vendor
• DBA Tasks That Remain but with Changes
• New Tasks for the DBA in the Cloud
• Security for Data and Applications in the Cloud
• Access Control and Identity and Access Management
• Network Isolation
• Data Encryption
• Infrastructure as Code: Making the Most of the Cloud
• Chapter 3. Moving Your Databases to the Cloud
• Planning
• Factors in a Migration
• Major Migration Tasks
• Readiness Assessment
• Checking for Incompatibilities
• Data Movement
• Migrating the Database
• Migrating Applications
• Post-Migration Checks
• Optimization
• Availability
• Performance Optimization
• Adapting to Differences in the Cloud
• Conclusion
• Chapter 4. Conclusion
• About the Authors