Propagated deletion of database records and derived data

    公开(公告)号:US11822542B2

    公开(公告)日:2023-11-21

    申请号:US17208914

    申请日:2021-03-22

    CPC classification number: G06F16/2386 G06F16/2365 G06F16/2433 G06F16/254

    Abstract: In an embodiment, a data processing method comprises, using a distributed database system that is programmed to manage a plurality of different raw datasets and a plurality of derived datasets that have been derived from the raw datasets based on a plurality of derivation relationships that link the raw datasets to the derived datasets: from a first dataset that is stored in the distributed database system, determining a subset of records that are candidates for propagated deletion of specified data values; determining one or more particular raw datasets that contain the subset of records; deleting the specified data values from the particular raw datasets; based on the plurality of derivation relationships and the particular raw datasets, identifying one or more particular derived datasets that have been derived from the particular raw datasets; generating and executing a build of the one or more particular derived datasets to result in creating and storing the one or more particular derived datasets without the specified data values that were deleted from the particular raw datasets; repeating the generating and executing for all derived datasets that have derivation relationships to the particular raw datasets; wherein the method is performed using one or more processors.

    Propagated deletion of database records and derived data

    公开(公告)号:US10956406B2

    公开(公告)日:2021-03-23

    申请号:US15990338

    申请日:2018-05-25

    Abstract: Using a distributed database system that manages a plurality of different raw datasets and a plurality of derived datasets that have been derived from the raw datasets based on a plurality of derivation relationships that link the raw datasets to the derived datasets, a subset of records that are candidates for propagated deletion of specified data values is determined. One or more particular raw datasets that contain the subset of records is determined. The specified data values from the particular raw datasets is deleted. Based on the plurality of derivation relationships and the particular raw datasets, one or more particular derived datasets that have been derived from the particular raw datasets is identified. A build of one or more particular derived datasets to result in creating and storing one or more particular derived datasets without the specified data values deleted from the particular raw datasets is generated and executed.

    PROPAGATED DELETION OF DATABASE RECORDS AND DERIVED DATA

    公开(公告)号:US20210271670A1

    公开(公告)日:2021-09-02

    申请号:US17208914

    申请日:2021-03-22

    Abstract: Techniques for propagation of deletion operations among a plurality of related datasets are described herein. In an embodiment, a data processing method comprises, using a distributed database system that is programmed to manage a plurality of different raw datasets and a plurality of derived datasets that have been derived from the raw datasets based on a plurality of derivation relationships that link the raw datasets to the derived datasets: from a first dataset that is stored in the distributed database system, determining a subset of records that are candidates for propagated deletion of specified data values; determining one or more particular raw datasets that contain the subset of records; deleting the specified data values from the particular raw datasets; based on the plurality of derivation relationships and the particular raw datasets, identifying one or more particular derived datasets that have been derived from the particular raw datasets; generating and executing a build of the one or more particular derived datasets to result in creating and storing the one or more particular derived datasets without the specified data values that were deleted from the particular raw datasets; repeating the generating and executing for all derived datasets that have derivation relationships to the particular raw datasets; wherein the method is performed using one or more processors.

    Propagated deletion of database records and derived data

    公开(公告)号:US12229121B2

    公开(公告)日:2025-02-18

    申请号:US18486039

    申请日:2023-10-12

    Abstract: A method of enabling propagated deletion in a distributed database system comprises receiving a request to delete data in a distributed database system; causing a display of a relevant dataset and a switch between applying propagated deletion or not; receiving a first selection of a subset of records from the relevant dataset using one or more filter functions and a second selection of applying propagated deletion to the subset of records; and applying propagated deletion to the subset of records to generate a new dataset.

Patent Agency Ranking