Transforming data structures and data objects for migrating data between databases having different schemas

A method, comprising:

• at a computing platform comprising at least one processor, memory, and a communication interface:
• querying, by the at least one processor, a logical view of a data table associated with a first database maintained by a first database server in a first schema;
• responsive to querying the logical view of the data table associated with the first database maintained by the first database server in the first schema, receiving, by the at least one processor, via the communication interface, from the first database server, source data associated with the logical view;
• splitting, by the at least one processor, the source data associated with the logical view to produce a plurality of data chunks associated with the logical view;
• moving, by the at least one processor, the plurality of data chunks associated with the logical view to a plurality of nodes associated with the computing platform;
• commanding, by the at least one processor, the plurality of nodes associated with the computing platform to transform the plurality of data chunks associated with the logical view to produce transformed data;
• and
• moving, by the at least one processor, the transformed data from the plurality of nodes associated with the computing platform to a second database maintained by a second database server in a second schema different from the first schema,
• wherein splitting the source data associated with the logical view to produce the plurality of data chunks associated with the logical view comprises identifying one or more available nodes and determining a uniform size of the plurality of data chunks associated with the logical view based on the one or more available nodes,
• wherein a numerical column included in the logical view of the data table associated with the first database maintained by the first database server provides an index indicative of a total size of the source data associated with the logical view, and
• wherein splitting the source data associated with the logical view to produce the plurality of data chunks associated with the logical view comprises splitting the source data associated with the logical view based on the numerical column to balance processing load across the one or more available nodes.

One or more non-transitory computer-readable media storing instructions that, when executed by a computing platform comprising at least one processor, memory, and a communication interface, cause the computing platform to:

• query a logical view of a data table associated with a first database maintained by a first database server in a first schema;
• responsive to querying the logical view of the data table associated with the first database maintained by the first database server in the first schema, receive, via the communication interface, from the first database server, source data associated with the logical view;
• split the source data associated with the logical view to produce a plurality of data chunks associated with the logical view;
• move the plurality of data chunks associated with the logical view to a plurality of nodes associated with the computing platform;
• command the plurality of nodes associated with the computing platform to transform the plurality of data chunks associated with the logical view to produce transformed data;
• and
• move the transformed data from the plurality of nodes associated with the computing platform to a second database maintained by a second database server in a second schema different from the first schema,
• wherein splitting the source data associated with the logical view to produce the plurality of data chunks associated with the logical view comprises identifying one or more available nodes and determining a uniform size of the plurality of data chunks associated with the logical view based on the one or more available nodes,
• wherein a numerical column included in the logical view of the data table associated with the first database maintained by the first database server provides an index indicative of a total size of the source data associated with the logical view, and
• wherein splitting the source data associated with the logical view to produce the plurality of data chunks associated with the logical view comprises splitting the source data associated with the logical view based on the numerical column to balance processing load across the one or more available nodes.