So far in this module, you have learnt about the different types of databases that are available for solving different problems. Now, what is the next step in the process? As you can see, we now need to get the data into the schema to perform relevant operations on it. You might be wondering how that is done. In the upcoming video, Prof. Chandrashekhar R will give you the answer to this question.
So, in the video, you were introduced to the SETL process, as follows:
SETL: Select, Extract, Transform and Load.
- Select: Identification of the data that you want to analyse.
- Extract: Connecting to the particular data source and pulling out the data.
- Transform: Modifying the extracted data to standardise it.
- Load: Pushing the data into the data warehouse.
This process includes the typical operations that are involved in selecting the required data, extracting data from multiple sources, operating on the data so that data from multiple sources is compatible, and loading this data into a data warehouse for analytical purposes.
In this way, you have understood the SETL. In the upcoming segments, you will understand the various constraints.