Snowflake inc. (20250139076). DISTRIBUTED IN-DATABASE VECTORIZED OPERATIONS USING USER DEFINED TABLE FUNCTIONS
DISTRIBUTED IN-DATABASE VECTORIZED OPERATIONS USING USER DEFINED TABLE FUNCTIONS
Organization Name
Inventor(s)
Pradeep Dorairaj of Fremont CA US
Garrett Frere of Long Island City NY US
Mengjia Xia of Philadelphia PA US
DISTRIBUTED IN-DATABASE VECTORIZED OPERATIONS USING USER DEFINED TABLE FUNCTIONS
This abstract first appeared for US patent application 20250139076 titled 'DISTRIBUTED IN-DATABASE VECTORIZED OPERATIONS USING USER DEFINED TABLE FUNCTIONS
Original Abstract Submitted
the subject technology receives first data. the subject technology transforms first data to a wide format, the wide format comprising a second table. the subject technology splits a set of rows into a set of shards of rows. the subject technology, for each shard from the set of shards, sends a particular user defined table function (udtf), including a particular shard of rows, to a different execution node to perform a set of operations for determining a rolling correlation over a window size. the subject technology provides a set of output values of each particular udtf corresponding to each shard from the set of shards in a second udtf. the subject technology sends the second udtf to a particular execution node to perform an aggregate operation. the subject technology receives a value of the rolling correlation from the particular execution node based on the aggregate operation.