Automating the Modern Data Warehouse

Book description

The opportunity to modernize and improve the enterprise data warehouse is one of the best reasons for moving your application to the cloud. A data warehouse can access a greater diversity of use cases and practices than is possible in an existing environment. In this report, researcher and analyst Stephen Swoyer offers a comprehensive overview of the benefits and challenges of implementing a cloud-based data warehouse.

Senior IT decision makers, chief data officers, and data professionals will learn about the shifts and new trends in the data management landscape. Explore ways to improve data management, build a data warehouse strategy, and learn how to modernize a data warehouse effectively.

  • Understand how AI, machine learning, self-service data integration, and built-in developer-oriented services have transformed the data warehouse role
  • Use data warehouses to work with cloud-based data lakes for end-to-end data management and data governance
  • Explore how data warehouse platforms as a service (PaaS) pave the way to automation
  • Migrate, manage, and secure a data warehouse in a hybrid or multicloud environment

Table of contents

  1. Introduction
    1. Migration, Modernization, and Transformation
    2. This Text Is a Guidebook for the Perplexed
  2. 1. Finding Signals in the Midst of Noise
    1. The Lives of Analytics
    2. Analytics as a Site of Rapid and Ongoing Transformation
    3. Diagnosing the Present, Predicting the Future
    4. Taking Action, Maximizing Outcomes
    5. Putting It All Together
  3. 2. Modern Data Management
    1. Data Management Explained
    2. Modern Data Management Explained
    3. The Data Lake: A Complement to the Data Warehouse
    4. Modern Data Warehouse
    5. Modern Data Management and the Cloud
  4. 3. Machine Learning, AI, and Intelligent Data Management
    1. Automation and the Cloud Data Warehouse
    2. The PaaS Data Warehouse
    3. Using ML-Driven AI to Automate, Improve, and Secure the Cloud Data Warehouse
    4. ML and AI Take to (and Take Off in) the Cloud
    5. The Multimodel Data Warehouse in the Cloud
  5. 4. Migrating Your Data Warehouse to the Cloud
    1. The Many Modalities of Cloud
    2. Cloud Data Warehouse Use Cases
      1. The Enterprise Data Warehouse
      2. ML, Predictive Analytics, and Other Emergent Use Cases
      3. The Data Mart or Departmental Data Warehouse
      4. The Data Lake
    3. The Cloud Data Management Stack
    4. Contextualizing Data in the Cloud
      1. Data Virtualization
      2. Data Catalogs
      3. Graph Databases
  6. 5. The Data Warehouse in the Cloud
    1. Cloud Data Warehouse Topologies
      1. Hybrid Cloud
      2. Multicloud
      3. The Local Cloud, the On-Premises Public-Private Cloud
    2. Selecting a Provider
    3. Configuring and Managing the Data Warehouse in the Cloud
    4. Securing the Data Warehouse in the Cloud
  7. Conclusion
    1. Final Thoughts

Product information

  • Title: Automating the Modern Data Warehouse
  • Author(s): Steve Swoyer
  • Release date: March 2021
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9781098102838