Invention Grant
- Patent Title: Stored procedures in a network based database system
-
Application No.: US17536173Application Date: 2021-11-29
-
Publication No.: US11321154B1Publication Date: 2022-05-03
- Inventor: Isaac Kunen , Srinath Shankar , Zihan Li , Khushboo Bhatia , Edward Ma
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F9/54
- 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.
Information query