-
公开(公告)号：US11216580B1
公开(公告)日：2022-01-04
申请号：US17232859
申请日：2021-04-16
Applicant: Snowflake Inc.
Inventor： Monica J. Holboke , Justin Langseth , Stuart Ozer , William L. Stratton, Jr.
Abstract: A secure machine learning system of a database system can be implemented to use secure shared data to train a machine learning model. To manage the model, a first user of the database can share data in an encrypted view with a second user of the database, and further share one or more functions of an application that accesses the data while the data is encrypted. The second user can access functions of the application and can call the functions to generate a trained machine learning model and further generate machine learning outputs (e.g., predictions) from the trained model.
-
公开(公告)号：US11216322B1
公开(公告)日：2022-01-04
申请号：US17390930
申请日：2021-07-31
Applicant: Snowflake Inc.
Inventor： Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F16/24 , G06F16/28 , G06F21/53 , G06F16/2455
Abstract: Disclosed are systems, methods, and non-transitory computer-readable media for a providing stored procedures in a network-based database system. A database system executes a stored procedure within a sandbox process. The sandbox process separates the stored procedure from the other services and processes of the database system and may also limit the resources (e.g., storage, memory, etc.) and functionality available to the stored procedure. Stored procedures are commonly designed to execute database queries that are processed by other components of the database system. To provide for secure communication between the stored procedure and the other components of the database system, the sandbox process is loaded with java database connectivity (JDBC) libraries (e.g., JDBC instance) that is modified to limit the communication abilities of the stored procedure.
-
公开(公告)号：US20210406310A1
公开(公告)日：2021-12-30
申请号：US17244349
申请日：2021-04-29
Applicant: Snowflake Inc.
Inventor： Polita Paulus , Aravind Ramarathinam , Saurin Shah , Sukruth Komarla Sukumar
IPC: G06F16/901 , G06F16/908 , G06F16/2455 , G06F16/955 , G06F16/22
Abstract: Disclosed herein are systems and methods for implementing a file-catalog table for a file stage. In an embodiment, a data platform receives, from a client, a request that the data platform create a file-catalog table for a file stage of a user account associated with the client, where the file stage contains one or more files at a storage location. The user account includes a file-stage object that corresponds to the file stage and that includes an indication of the storage location. In response to receiving the request, the data platform creates the file-catalog table for the file stage. The file-catalog table lists the one or more files in the file stage, and includes at least two different metadata properties of the files listed in the file-catalog table.
-
公开(公告)号：US20210390095A1
公开(公告)日：2021-12-16
申请号：US17462435
申请日：2021-08-31
Applicant: Snowflake Inc.
Inventor： Subramanian Muralidhar , Benoit Dageville , Thierry Cruanes , Nileema Shingte , Saurin Shah , Torsten Grabs , Istvan Cseri
IPC: G06F16/23 , G06F16/248 , G06F16/2458 , G06F3/06 , G06F16/25
Abstract: The subject technology receives a notification that a modification has been made to an external table, the modification comprising inserting at least one row of new data to the external table, the at least one row corresponding to a first micro-partition that includes a first portion of data from the external table prior to the inserting. The subject technology, in response to the notification indicating the modification to the external table, generates a new micro-partition different from the first micro-partition, the new micro-partition including the inserted at least one row of new data and the first portion of data from the external table. The subject technology generates a refreshed materialized view based at least in part on the generated new micro-partition such that the refreshed materialized view comprises a representation of the external table after the modification has been made.
-
公开(公告)号：US20210390094A1
公开(公告)日：2021-12-16
申请号：US17461208
申请日：2021-08-30
Applicant: Snowflake Inc.
Inventor： Istvan Cseri , Torsten Grabs , Benoit Dageville
Abstract: Systems, methods, and devices for executing a task on database data in response to a trigger event are disclosed. A method includes executing a transaction on a table comprising database data, wherein executing the transaction comprises generating a new table version. The method includes, in response to the transaction being fully executed, generating a change tracking entry comprising an indication of one or more modifications made to the table by the transaction and storing the change tracking entry in a change tracking stream. The method includes executing a task on the new table version in response to a trigger event.
-
Patent Agency Ranking
公开(公告)号：US20210390007A1
公开(公告)日：2021-12-16
申请号：US17461576
申请日：2021-08-30
Applicant: Snowflake Inc.
Inventor： Istvan Cseri , Isaac Kunen , Igor Zinkovsky
IPC: G06F9/54 , H04L29/08 , H04L29/06 , G06F16/242
Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.
-
公开(公告)号：US11188674B2
公开(公告)日：2021-11-30
申请号：US17228379
申请日：2021-04-12
Applicant: Snowflake Inc.
Inventor： Benoit Dageville , Peter Povinec , Philipp Thomas Unterbrunner , Martin Hentschel
Abstract: A method for encrypting database data includes generating an encryption key for a first file stored in a data store, wherein a table in a database comprises an entry pointing to the first file. The method includes generating a second file by encrypting the data the first file in the data store using the encryption key without modifying the first file. The method includes, in response to generating the second file, modifying the entry in the table to point to the second file, wherein the modification of the entry is performed atomically. A process for rekeying from the first file to the second file may happen in the background without blocking, interfering, or otherwise obstructing user interaction with a database system.
-
公开(公告)号：US20210357411A1
公开(公告)日：2021-11-18
申请号：US17388160
申请日：2021-07-29
Applicant: Snowflake Inc.
Inventor： Thierry Cruanes , Benoit Dageville , Ismail Oukid , Stefan Richter
IPC: G06F16/2455 , G06F16/9035 , G06F16/28 , G06F16/22 , G06F17/18
Abstract: A query directed at a source table organized into a set of batch units is received. The query includes a pattern matching predicate that specifies a search pattern. A set of N-grams are generated based on the search pattern. A pruning index associated with the source table is accessed. The pruning index comprises a set of filters that index distinct N-grams in each column of the source table. The pruning index is used to identify a subset of batch units to scan for matching data based on the set of N-grams generated for the search pattern. The query is processed by scanning the subset of batch units.
-
公开(公告)号：US20210349886A1
公开(公告)日：2021-11-11
申请号：US17384269
申请日：2021-07-23
Applicant: Snowflake Inc
Inventor： Torsten Grabs , Istvan Cseri , Benoit Dageville
IPC: G06F16/23 , G06F16/22 , G06F16/2455
Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.
-
公开(公告)号：US11165639B2
公开(公告)日：2021-11-02
申请号：US16919070
申请日：2020-07-01
Applicant: Snowflake Inc.
Inventor： Vineeth Narasimhan , Joshua Lambert , Thomas Herchek , Ryan Elliot Hope , Nitish Jha , Rahul Jain , Sumeet Singh
IPC: H04L12/24 , H04W4/50 , H04L29/06 , H04L12/58 , H04L29/08 , H04L12/26 , H04L12/911 , G06F9/06 , G06F9/50
Abstract: A cloud extension agent can be provided on a customer premise for interfacing, via an outbound secure connection, cloud based services.
-
-
-
-
-
-
-
-
-
Search Results
1749
records
(took 0.028 seconds)
