Research Article
Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping
Table 4
Throughput (record per second) of the ETL job for MongoDB to relational databases (MySQL and PostgreSQL) using the proposed and baseline methods.
| Record size | MySQL | PostgreSQL | Baseline | Proposed | Baseline | Proposed |
| 100k | 2317 | 3213 | 3949 | 4168 | 3233 | 3146 | 3906 | 4146 | 2827 | 3147 | 3939 | 3891 | Average | 2793 | 3169 | 3931 | 4068 | 500k | 2372 | 6623 | 3316 | 13369 | 2496 | 5207 | 3459 | 10006 | 2485 | 6747 | 3364 | 9369 | Average | 2451 | 6192 | 3380 | 10915 | 1000k | 2999 | 7598 | 4266 | 15354 | 3040 | 7419 | 4172 | 13394 | 3081 | 7491 | 4258 | 15230 | Average | 3040 | 7503 | 4232 | 14659 | 5000k | 3095 | 8530 | 4080 | 26179 | 3036 | 8509 | 4203 | 21574 | 3062 | 8255 | 4031 | 26339 | Average | 3064 | 8431 | 4105 | 24698 |
|
|