Building and Maintaining a Data Warehouse


Book Description

As it is with building a house, most of the work necessary to build a data warehouse is neither visible nor obvious when looking at the completed product. While it may be easy to plan for a data warehouse that incorporates all the right concepts, taking the steps needed to create a warehouse that is as functional and user-friendly as it is theoreti







Warehouse Operations


Book Description





Book Description




Building a Columnar Database on RAMCloud


Book Description

This book examines the field of parallel database management systems and illustrates the great variety of solutions based on a shared-storage or a shared-nothing architecture. Constantly dropping memory prices and the desire to operate with low-latency responses on large sets of data paved the way for main memory-based parallel database management systems. However, this area is currently dominated by the shared-nothing approach in order to preserve the in-memory performance advantage by processing data locally on each server. The main argument this book makes is that such an unilateral development will cease due to the combination of the following three trends: a) Today’s network technology features remote direct memory access (RDMA) and narrows the performance gap between accessing main memory on a server and of a remote server to and even below a single order of magnitude. b) Modern storage systems scale gracefully, are elastic and provide high-availability. c) A modern storage system such as Stanford’s RAM Cloud even keeps all data resident in the main memory. Exploiting these characteristics in the context of a main memory-based parallel database management system is desirable. The book demonstrates that the advent of RDMA-enabled network technology makes the creation of a parallel main memory DBMS based on a shared-storage approach feasible.




Building the Data Warehouse


Book Description

The new edition of the classic bestseller that launched thedata warehousing industry covers new approaches and technologies,many of which have been pioneered by Inmon himself In addition to explaining the fundamentals of data warehousesystems, the book covers new topics such as methods for handlingunstructured data in a data warehouse and storing data acrossmultiple storage media Discusses the pros and cons of relational versusmultidimensional design and how to measure return on investment inplanning data warehouse projects Covers advanced topics, including data monitoring andtesting Although the book includes an extra 100 pages worth of valuablecontent, the price has actually been reduced from $65 to $55







Building Cloud Data Platforms Solutions


Book Description

"Building Cloud Data Platforms Solutions: An End-to-End Guide for Designing, Implementing, and Managing Robust Data Solutions in the Cloud" comprehensively covers a wide range of topics related to building data platforms in the cloud. This book provides a deep exploration of the essential concepts, strategies, and best practices involved in designing, implementing, and managing end-to-end data solutions. The book begins by introducing the fundamental principles and benefits of cloud computing, with a specific focus on its impact on data management and analytics. It covers various cloud services and architectures, enabling readers to understand the foundation upon which cloud data platforms are built. Next, the book dives into key considerations for building cloud data solutions, aligning business needs with cloud data strategies, and ensuring scalability, security, and compliance. It explores the process of data ingestion, discussing various techniques for acquiring and ingesting data from different sources into the cloud platform. The book then delves into data storage and management in the cloud. It covers different storage options, such as data lakes and data warehouses, and discusses strategies for organizing and optimizing data storage to facilitate efficient data processing and analytics. It also addresses data governance, data quality, and data integration techniques to ensure data integrity and consistency across the platform. A significant portion of the book is dedicated to data processing and analytics in the cloud. It explores modern data processing frameworks and technologies, such as Apache Spark and serverless computing, and provides practical guidance on implementing scalable and efficient data processing pipelines. The book also covers advanced analytics techniques, including machine learning and AI, and demonstrates how these can be integrated into the data platform to unlock valuable insights. Furthermore, the book addresses an aspects of data platform monitoring, security, and performance optimization. It explores techniques for monitoring data pipelines, ensuring data security, and optimizing performance to meet the demands of real-time data processing and analytics. Throughout the book, real-world examples, case studies, and best practices are provided to illustrate the concepts discussed. This helps readers apply the knowledge gained to their own data platform projects.




Building a Data Warehouse


Book Description

Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse and explores how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. It also details testing and how to administer data warehouse operation.