Book Image

Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS)

By : Angelo Bobak
Book Image

Connecting the Data: Data Integration Techniques for Building an Operational Data Store (ODS)

By: Angelo Bobak

Overview of this book

When organizations change or enhance their internal structures, business data integration is a complex problem that they must resolve. This book describes the common hurdles you might face while working with data integration and shows you various ways to overcome these challenges. The book begins by explaining the foundational concepts of ODS. Once familiar with schema integration, you?ll learn how to reverse engineer each data source for creating a set of data dictionary reports. These reports will provide you with the metadata necessary to apply the schema integration process. As you progress through the chapters, you will learn how to write scripts for populating the source databases and spreadsheets, as well as how to use reports to create Extract, Transform, and Load (ETL) specifications. By the end of the book, you will have the knowledge necessary to design and build a small ODS.
Table of Contents (17 chapters)
Free Chapter
1
Section 1: Site Reliability Engineering – A Prescriptive Way to Implement DevOps
6
Section 2: Google Cloud Services to Implement DevOps via CI/CD
Appendix: Getting Ready for Professional Cloud DevOps Engineer Certification

Psychological safety

One of the key pillars of SRE is to accept failure as normal. This implies that failures are imminent, but the key is to learn from the failures and ensure that the same mistake is not repeated the next time. As a result, SRE promotes open communication within teams and between members of the team and its leaders to ensure that a failure is evaluated objectively from a process standpoint and not from an individual standpoint. The core idea is to provide a sense of psychological safety, which is extremely important to implement the practice of Blameless Postmortems.

SRE defines psychological safety as the belief that a manager or an individual contributor will not be singled out, humiliated, ridiculed or punished for the following:

  • Committing a mistake that could result in a potential incident or a problem
  • Bringing up a concern related to a decision with respect to design, implementation, or process that could later have adverse impacts
  • Asking...