Research Article
Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping
Table 3
ETL time for MongoDB to MySQL and PostgreSQL using the proposed solution and the baseline method.
| Record size | MySQL | PostgreSQL | Baseline | Proposed | Baseline | Proposed |
| 100k | 43.15 | 31.12 | 25.32 | 23.99 | 30.93 | 31.79 | 25.60 | 24.12 | 35.37 | 31.78 | 25.39 | 25.70 | Average | 36.48 | 31.56 | 25.44 | 24.60 | 500k | 210.75 | 75.49 | 150.79 | 37.40 | 200.29 | 96.03 | 144.57 | 49.97 | 201.19 | 74.11 | 148.62 | 53.37 | Average | 204.08 | 81.88 | 147.99 | 46.91 | 1000k | 333.41 | 131.62 | 234.40 | 65.13 | 329 | 134.78 | 239.69 | 74.66 | 324.55 | 133.50 | 234.85 | 65.66 | Average | 328.99 | 133.3 | 236.31 | 68.48 | 5000k | 1615.36 | 586.18 | 1225.37 | 190.99 | 1647.16 | 587.60 | 1189.66 | 231.76 | 1632.93 | 605.69 | 1240.32 | 189.83 | Average | 1631.82 | 593.16 | 1218.45 | 204.19 |
|
|