After the TEDAMOH ExMeX Framework Core has loaded data into the data warehouse for many days, weeks, months and perhaps even years, questions arise for the data modeler or the operator: What is the state of individual streams or Load Process Steps (LPS) over time or what does the system do on the first four days of each month? Or how can I present a continuous monitoring of my current load?
With the help of the Data Logistic Data Mart of the ExMeX Logging Framework, a uniform and stable access layer exists in the form of a star schema to access all this information and to be able to provide answers to the most diverse questions.
In the following sections the dimensions and facts of the Data Logistic Data Mart of the ExMeX Logging Framework are described in detail.
(Photo by Luke Chesser on Unsplash)
The data model shown here gives an overview of the star schema of the Data Logistic Data Mart of the ExMeX Logging Framework.
With the date dimension (Dim Date) the consumer of the data can limit the facts to e.g. year, month and day, with the time dimension (Dim Time) to a certain time period of a day.
In addition, the consumer can restrict the facts to a single batch or its hierarchy tree (Dim Batch), to a specific target table or even to only a single LPS (Dim Load Process Step).