Automatic NoSQL to Relational Database Transformation with Dynamic Schema Mapping

Algorithm 3

Transformation and loading.

	Input: MongoDB connection information (info), Destination DB info (dest), Data location start point (start), length to read (limit), Batch size (batch_size)
	Output: Data loaded to destination SQL database.
	db ← createConnection(info)
	sql ← createConnection(dest)
	queries ← {}
	n ← 0
	while start < limit do
	docs ← db.readBatch(batch_size)
	foreach doc Є docs do
	queries ← queries ∪ createQuery(doc)
	n ← n + 1
	end
	execute(queries)
	start ← start + n
	end