Database architectures for data transformations

Database architectures that are needed for data transformations in data science can be similar to architectures used in data warehousing. In many applications, they can also be almost the same as the architectures used for Extract-Transform-Load (ETL) in common data warehouse applications. In this section, we will go through the scenarios used for data transformation from the perspective of cooperating databases.

Direct source for data analysis

The least complicated database architecture is uses source data directly as a data source for further analysis. The following screenshot shows this scenario:

The only database in the preceding screenshot is used for both data manipulation...