Invention Publication
- Patent Title: USER DEFINED FUNCTION MEMOIZATION
-
Application No.: US18477694Application Date: 2023-09-29
-
Publication No.: US20240028591A1Publication Date: 2024-01-25
- Inventor: Raja Suresh Krishna Balakrishnan , Thierry Cruanes , Yujie Li , Subramanian Muralidhar , David Schultz , Jiaqi Yan
- Applicant: Snowflake Inc
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc
- Current Assignee: Snowflake Inc
- Current Assignee Address: US MT Bozeman
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F21/53

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.
Information query