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