Translate

Tuesday, June 15, 2021

ETL Framework for Document Databases & Relational Databases

The following two research papers are targeted to achieve ETL functionality between Document and RDBMS databases. For both researches, MongoDB and SQL Server were used as proof of concept.

the first research is about building a replication layer between the document and document databases. The basic architecture was displayed in the below figure.


During this research, CPU processes were compared as shown in the below figure.



You can see that when SQL Server processing % in the range of 70 - 100 while MongoDB is not even reached 1 %.
By using the findings in the above research, another research was done to define a ETL framework between DocumentDB and SQL Server. 

No comments:

Post a Comment