-
公开(公告)号:US11948025B2
公开(公告)日:2024-04-02
申请号:US18326905
申请日:2023-05-31
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F16/2455 , G06F16/28 , G06F21/53
CPC classification number: G06F9/547 , G06F16/2455 , G06F16/289 , G06F21/53
Abstract: Methods, systems, and computer programs are presented for providing stored procedures stored within a database to invoke specified functionality in a cloud data platform. A response to a database query is received at a compute node of a cloud data platform. A java database connectivity (JDBC) instance executing within a sandbox process converts the response into a remote procedure call. The remote procedure call is provided to a stored procedure executing within the sandbox process as the response to the database query.
-
公开(公告)号: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.
-
公开(公告)号:US11487597B1
公开(公告)日:2022-11-01
申请号:US17658530
申请日:2022-04-08
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F21/53 , G06F16/28 , 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.
-
公开(公告)号:US11321154B1
公开(公告)日:2022-05-03
申请号:US17536173
申请日:2021-11-29
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F21/53 , G06F16/2455 , G06F16/28
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.
-
公开(公告)号:US12190181B2
公开(公告)日:2025-01-07
申请号:US18429367
申请日:2024-01-31
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F16/2455 , G06F16/28 , G06F21/53
Abstract: A database system configured to manage and execute stored procedures within a secure sandbox process. The system receives a response to a database query and, through an Application Programming Interface (API) executing within the sandbox process, converts the response into a remote procedure call. The sandbox process is modified to restrict communication with external networks while enabling communication with a designated execution node, which facilitates interaction between the stored procedure and database system components. The stored procedure, executing within the confines of the sandbox process, directs the API to communicate with the execution node. The execution node, in turn, submits the database query to the database system component.
-
公开(公告)号:US20240168834A1
公开(公告)日:2024-05-23
申请号:US18429367
申请日:2024-01-31
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F16/2455 , G06F16/28 , G06F21/53
CPC classification number: G06F9/547 , G06F16/2455 , G06F16/289 , G06F21/53
Abstract: A database system configured to manage and execute stored procedures within a secure sandbox process. The system receives a response to a database query and, through an Application Programming Interface (API) executing within the sandbox process, converts the response into a remote procedure call. The sandbox process is modified to restrict communication with external networks while enabling communication with a designated execution node, which facilitates interaction between the stored procedure and database system components. The stored procedure, executing within the confines of the sandbox process, directs the API to communicate with the execution node. The execution node, in turn, submits the database query to the database system component.
-
公开(公告)号:US20230305910A1
公开(公告)日:2023-09-28
申请号:US18326905
申请日:2023-05-31
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zhihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F16/2455 , G06F16/28 , G06F21/53
CPC classification number: G06F9/547 , G06F16/2455 , G06F16/289 , G06F21/53
Abstract: Methods, systems, and computer programs are presented for providing stored procedures stored within a database to invoke specified functionality in a cloud data platform. A response to a database query is received at a compute node of a cloud data platform. A java database connectivity (JDBC) instance executing within a sandbox process converts the response into a remote procedure call. The remote procedure call is provided to a stored procedure executing within the sandbox process as the response to the database query.
-
公开(公告)号:US11704176B2
公开(公告)日:2023-07-18
申请号:US18051075
申请日:2022-10-31
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F16/2455 , G06F16/28 , G06F21/53
CPC classification number: G06F9/547 , G06F16/2455 , G06F16/289 , G06F21/53
Abstract: Disclosed are systems, methods, and non-transitory computer-readable media for receiving a remote procedure call from a stored procedure executing within a sandbox process. A database system converts the remote procedure call into a database query, and a sandbox process separates the stored procedure from the other services and processes the database query on a database.
-
公开(公告)号:US20230082040A1
公开(公告)日:2023-03-16
申请号:US18051075
申请日:2022-10-31
Applicant: Snowflake Inc.
Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
IPC: G06F9/54 , G06F16/2455 , G06F16/28 , G06F21/53
Abstract: Disclosed are systems, methods, and non-transitory computer-readable media for receiving a remote procedure call from a stored procedure executing within a sandbox process. A database system converts the remote procedure call into a database query, and a sandbox process separates the stored procedure from the other services and processes the database query on a database.
-
-
-
-
-
-
-
-