Loading patent…
AssigneeBank of America Corporation
InventorsTao Huang, Sriharsha Jana
Estimating the term…
Aspects of the disclosure relate to transforming data structures and data objects. A computing platform may query a logical view of a data table associated with a first database maintained by a first database server in a first schema and may receive source data associated with the logical view. Subsequently, the computing platform may split the source data into a plurality of data chunks associated with the logical view. Next, the computing platform may move the plurality of data chunks to a plurality of nodes configured to receive and transform the plurality of data chunks from the first schema to a second schema different from the first schema. Then, the computing platform may command the plurality of nodes to transform the plurality of data chunks and may move the transformed data from the plurality of nodes to a second database maintained by a second database server in the second schema.
A computing platform, comprising:
A method, comprising:
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:
Dependencies are inferred from the claim text.
Drawings are temporarily unavailable. Open the PDF at USPTO
From the US filing history. Foreign family members aren’t listed.
Integrating or interfacing systems involving database management systems: data format conversion from or to a database
Design, administration or maintenance of databases: database migration support
Of query operations: unary operations; Data partitioning operations
Computing and data processing
About 11 years 4 months of term left · ends 16 Feb 2038 (estimated)
Aspects of the disclosure relate to data processing, database management, and transforming data structures and data objects. In particular, one or more aspects of the disclosure relate to transforming data structures and data objects to transfer data between databases having different schemas.
Enterprise organizations may maintain large amounts of data in various electronic resources, including large enterprise databases. As organizations seek to increase the performance, efficiency, and security of the information technology infrastructure that maintains this data, it may be necessary to migrate and/or otherwise transfer data between different databases that utilize different schemas. In many instances, however, transferring such data may be difficult, as such transferring may require consuming large amounts of computing power, network bandwidth, and other technological resources.
Aspects of the disclosure provide effective, efficient, scalable, and convenient technical solutions that address and overcome the technical problems associated with transferring data between different databases that utilize different schemas. In particular, some aspects utilize techniques in which a logical view is queried to read data from a source database and to facilitate node-based processing and transformation of the data into a different schema, as illustrated in greater detail below.
The present disclosure is illustrated by way of example and not limited in the accompanying figures in which like reference numerals indicate similar elements and in which:
FIGS. 1A and 1B depict an illustrative computing environment for transforming data structures and data objects to transfer data between databases having different schemas in accordance with one or more example embodiments;
FIGS. 2A, 2B, 2C, and 2D depict an illustrative event sequence for transforming data structures and data objects to transfer data between databases having different schemas in accordance with one or more example embodiments;
In the following description of various illustrative embodiments, reference is made to the accompanying drawings, which form a part hereof, and in which is shown, by way of illustration, various embodiments in which aspects of the disclosure may be practiced. It is to be understood that other embodiments may be utilized, and structural and functional modifications may be made, without departing from the scope of the present disclosure.
It is noted that various connections between elements are discussed in the following description. It is noted that these connections are general and, unless specified otherwise, may be direct or indirect, wired or wireless, and that the specification is not intended to be limiting in this respect.
Some aspects of the disclosure relate to transforming data structures and data objects to transfer data between databases having different schemas. In some arrangements discussed in greater detail below, a computing platform having at least one processor, a memory, and a communication interface may 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, the computing platform may receive, via the communication interface, from the first database server, source data associated with the logical view. Subsequently, the computing platform may split the source data associated with the logical view to produce a plurality of data chunks associated with the logical view. Next, the computing platform may move the plurality of data chunks associated with the logical view to a plurality of nodes associated with the computing platform, and each node of the plurality of nodes associated with the computing platform may be configured to receive a particular data chunk of the plurality of data chunks associated with the logical view and transform the particular data chunk of the plurality of data chunks associated with the logical view from the first schema to a second schema different from the first schema. Then, the computing platform may 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. Thereafter, the computing platform may 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 the second schema.