Invention Application
- Patent Title: STORED PROCEDURES IN A DATABASE
-
Application No.: PCT/US2022/072772Application Date: 2022-06-06
-
Publication No.: WO2022261617A1Publication Date: 2022-12-15
- Inventor: BHATIA, Khushboo , KUNEN, Isaac , LI, Zihan , MA, Edward , SHANKAR, Srinath
- Applicant: SNOWFLAKE INC.
- Applicant Address: Suite 3A, 106 East Babcock Street
- Assignee: SNOWFLAKE INC.
- Current Assignee: SNOWFLAKE INC.
- Current Assignee Address: Suite 3A, 106 East Babcock Street
- Agency: SCHEER, Bradley W. et al.
- Priority: US63/197,760 2021-06-07
- Main IPC: G06F9/54
- IPC: G06F9/54
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