MEMORY EFFICIENT POLICY-BASED FILE DELETION SYSTEM

    公开(公告)号:US20190065510A1

    公开(公告)日:2019-02-28

    申请号:US15693352

    申请日:2017-08-31

    Abstract: Disclosed are some implementations of systems, apparatus, methods and computer program products for facilitating policy-based file deletion. Policy-based file deletion is implemented via a tiered system that includes a master computing system and a plurality of slave computing systems. The master computing system distributes policies among the slave computing systems, which each applies assigned policies to cause deletion of files that satisfy those policies.

    Incremental addition of data to partitions in database tables

    公开(公告)号:US11567957B2

    公开(公告)日:2023-01-31

    申请号:US16582759

    申请日:2019-09-25

    Abstract: A method and system for accessing updated data from a database in response to a user query has been developed. First, multiple transaction logs are generated for a database. Each transaction log contains a record of actions executed by a database management system and referenced according to the specified date of the actions. Data updates are received and stored with the database. An incremental database partition is created for each data update. Each incremental database partition is stored with reference to a corresponding transaction log for the date of the data update. The updated data is accessed through the incremental database partition in response to an outdated user query. The outdated user query contains a data access request for a date earlier than the receipt of data updates.

    INCREMENTAL ADDITION OF DATA TO PARTITIONS IN DATABASE TABLES

    公开(公告)号:US20210089527A1

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

    申请号:US16582759

    申请日:2019-09-25

    Abstract: A method and system for accessing updated data from a database in response to a user query has been developed. First, multiple transaction logs are generated for a database. Each transaction log contains a record of actions executed by a database management system and referenced according to the specified date of the actions. Data updates are received and stored with the database. An incremental database partition is created for each data update. Each incremental database partition is stored with reference to a corresponding transaction log for the date of the data update. The updated data is accessed through the incremental database partition in response to an outdated user query. The outdated user query contains a data access request for a date earlier than the receipt of data updates.

    ADDING A PARTITION TO AN EXISTING TABLE STORED ON A DISTRIBUTED FILE SYSTEM

    公开(公告)号:US20190236169A1

    公开(公告)日:2019-08-01

    申请号:US15885489

    申请日:2018-01-31

    Abstract: Systems and methods are described for registering a new column in an existing table on a distributed file system as a partition. In response to receiving a request to add a new column to a selected table, a new table may be created that includes all fields of the selected table, the new column, and a new partition, and the selected table may be renamed within the distributed file system. A view may then be created that points to data in the new table and the renamed selected table, the created view being a virtual table that receives and processes queries. All data from the renamed selected table may be transferred the new table. When the transfer is complete, the new table may be renamed to an original name of the selected table, and any data received after the renaming may be included in the renamed new table.

Patent Agency Ranking