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