CORRECTION, SYNCHRONIZATION, AND MIGRATION OF DATABASES

    公开(公告)号:US20220222213A1

    公开(公告)日:2022-07-14

    申请号:US17149115

    申请日:2021-01-14

    摘要: Aspects of the disclosure relate to management of databases in different server environments. In particular, various aspects of this disclosure relate to correction, synchronization, and/or migration of databases between different database servers. A feed file that is rejected from loading in a database associated with a source server may prioritized in a destination server. A feed file hierarchy of the rejected feed file may be determined and the destination server may process loading of the rejected feed file to a database based on the determine feed file hierarchy. Any corrections applied at the destination server may also be applied at the source server.

    Dynamic server pool data segmentation using dynamic ordinal partition key without locks

    公开(公告)号:US11176088B2

    公开(公告)日:2021-11-16

    申请号:US16985326

    申请日:2020-08-05

    摘要: Aspects described herein may relate to a data processing engine that executes on a computing device in order to store data from one or more feed files, which may be heterogeneous, to a destination data structure on a designated computing device. Because the files may be huge in size, it is important that the files be stored in a manner in order to reduce the time to move the data and to support an efficient mechanism for recovering from errors. A feed file may be dynamically partitioned into groups of contiguous rows based on a dynamic partitioning key, where data chunks are loaded into a plurality of clone tables and subsequently moved into a destination data structure. The data processing engine may determine a row size for the clone files and request for resources from a computing cloud to obtain those resources.

    Resource allocation tool
    5.
    发明授权

    公开(公告)号:US11055187B2

    公开(公告)日:2021-07-06

    申请号:US16238638

    申请日:2019-01-03

    摘要: A method includes receiving a plurality of data processing requests and assigning each data processing request to a group based on the source of the data. The method further includes generating a primary processing stack indicating a queue for processing the first data, wherein: the primary processing stack comprises a plurality of layers; each layer comprises a plurality of slices, wherein each slice represents a portion of the first data of at least one data processing request; and the plurality of slices are arranged within each layer based at least on the priority indicator corresponding to the first data that each slice represents. The method further includes receiving resource information about a plurality of servers, assigning each slice of the primary processing stack to one of the servers, and sending processing instructions comprising an identification of each slice of the primary processing stack assigned to the respective server.

    Dynamic Server Pool Data Segmentation Using Dynamic Ordinal Partition Key Without Locks

    公开(公告)号:US20200371991A1

    公开(公告)日:2020-11-26

    申请号:US16985326

    申请日:2020-08-05

    IPC分类号: G06F16/11 G06F16/16 G06F16/13

    摘要: Aspects described herein may relate to a data processing engine that executes on a computing device in order to store data from one or more feed files, which may be heterogeneous, to a destination data structure on a designated computing device. Because the files may be huge in size, it is important that the files be stored in a manner in order to reduce the time to move the data and to support am efficient mechanism for recovering from errors. A feed file may be dynamically partitioned into groups of contiguous rows based on a dynamic partitioning key, where data chunks are loaded into a plurality of clone tables and subsequently moved into a destination data structure. The data processing engine may determine a row size for the clone files and request for resources from a computing cloud to obtain those resources.

    Table prioritization for data copy in a multi- environment setup

    公开(公告)号:US12093145B2

    公开(公告)日:2024-09-17

    申请号:US18475033

    申请日:2023-09-26

    IPC分类号: G06F11/14 G06F9/48

    摘要: A system includes one or more source memory devices of a source computing environment that store a database comprising data files, wherein each of a plurality of data tables of the source computing environment includes data from one or more of the data files, one or more target memory devices of a target computing environment and at least one processor configured to receive a command to copy data files from the source memory devices to the target memory devices, detect that the target memory devices have insufficient memory, calculate a value coefficient for each data table, assign a priority index to each data table based on the value coefficient, order the data files in a copy queue based on the priority index of the data tables, and copy the ordered data files to the target memory devices.