EFFICIENT DEDUPLICATION OF RANDOMIZED FILE PATHS

    公开(公告)号:US20240086381A1

    公开(公告)日:2024-03-14

    申请号:US18513163

    申请日:2023-11-17

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/215 G06F16/24552 G06F16/24573 G06F16/248

    Abstract: Disclosed are techniques for deduplicating files to be ingested by a database. A bloom filter may be built for each of a first set of files to be ingested into a data exchange to generate a set of bloom filters, wherein each of the set of bloom filters is built with a number of hash functions that is based on a desired false positive rate. The set of bloom filters may be stored in the metadata storage of the data exchange. In response to receiving a set of candidate files to be ingested, identifying using the set of bloom filters, candidate files from the set of candidate files that are duplicative of a file in the first set of files and pruning from the set of candidate files, each candidate file identified as being duplicative of a file in the first set of files using the set of bloom filters.

    Column hiding management system
    179.
    发明授权

    公开(公告)号:US11809591B1

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

    申请号:US18172404

    申请日:2023-02-22

    Applicant: Snowflake Inc.

    CPC classification number: G06F21/6227 G06F2221/2141

    Abstract: Systems and methods for managing column hiding are provided. The systems and methods receive, from a client device, a query associated with a table. The systems and methods determine an access restriction associated with the client device. The systems and methods identify a column of the table that is restricted by the access restriction associated with the client device. In response to identifying the column of the table that is restricted by the access restriction associated with the client device, the systems and methods provide a result of the query that excludes data corresponding to the column.

    Function memoization in query processing system

    公开(公告)号:US11809425B1

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

    申请号:US17819758

    申请日:2022-08-15

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/24539 G06F21/53 G06F2221/034

    Abstract: A data platform that implements memoizable functions for database objects. The data platform detects a first execution of a memoizable function and generates a first key based on metadata of one or more database objects operated on by the memoizable function and generates a first result for the memoizable function based on the one or more database objects. The data platform detects a second execution of the memoizable function and generates a second key based on the metadata of the one or more database objects operated on by the memoizable function. When the first key and the second key are equal, the data platform reuses the first result of the memoizable function. When the first key and second key do not match, the data platform generates a second result for the second execution of the memoizable function.

Patent Agency Ranking