Month: November 2021
Indexes – Relational Databases in Azure
Indexes Consider the index at the end of this book. Its purpose is to sort keywords and provide each keyword’s location in the book. Database indexes work very similarly in that they sort a list of values and provide pointers to the physical locations of those values. Ideally, indexes are designed to optimize the way …
Extract – Core Data Concepts
Extract The first phase of an ETL process involves extracting data from different source systems and storing it in a consolidated staging layer that is easier for the transformation tools to access. Data sources are typically heterogenous and are represented by a wide variety of data formats. The staging layer can be transient to cut …