US 11,726,976 B1
Database encoding and decoding for database functions
Elliott Brossard, Kirkland, WA (US); Chong Han, Bellevue, WA (US); and Igor Zinkovsky, Redmond, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Nov. 30, 2022, as Appl. No. 18/60,085.
Claims priority of provisional application 63/366,282, filed on Jun. 13, 2022.
Int. Cl. G06F 16/22 (2019.01); G06F 16/248 (2019.01); G06F 16/27 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2291 (2019.01) [G06F 16/221 (2019.01); G06F 16/248 (2019.01); G06F 16/258 (2019.01); G06F 16/27 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by at least one hardware processor, a database query specifying a user-defined function (UDF) to apply on one or more tables in a distributed database;
identifying, by the at least one hardware processor, the one or more tables in the distributed database, the one or more tables associated with an initial set of data types native to the distributed database;
converting the one or more tables to database data comprising data types of the UDF;
executing, on the distributed database, the UDF on the database data to generate results data;
converting the results data to table results data, the table results data associated with the initial set of data types; and
storing the table results data in the distributed database.