Patents by Inventor Elliott Brossard
Elliott Brossard has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20240012819Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.Type: ApplicationFiled: September 20, 2023Publication date: January 11, 2024Inventors: Elliott Brossard, Srilakshmi Chintala, Istvan Cseri, Rodger N. Kline, Nitya Kumar Sharma, Igor Zinkovsky
-
Publication number: 20230409552Abstract: A method includes detecting, by at least one hardware processor, an upload of a user application within a database system. The user application includes user-defined function (UDF) code. A plurality of dependencies of the user application is determined by the at least one hardware processor. A plurality of execution environments corresponding to the plurality of dependencies is generated by the at least one hardware processor. The plurality of execution environments is associated with a corresponding plurality of data types of the UDF. A database query is decoded. The database query specifies database data of a data type of the plurality of data types of the UDF. The database query is processed using at least one of the plurality of execution environments to generate results data. The at least one of the plurality of execution environments corresponds to the data type of the plurality of data types of the UDF.Type: ApplicationFiled: June 21, 2023Publication date: December 21, 2023Inventors: Elliott Brossard, Chong Han, Igor Zinkovsky
-
Patent number: 11803552Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.Type: GrantFiled: July 19, 2022Date of Patent: October 31, 2023Assignee: Snowflake Inc.Inventors: Elliott Brossard, Srilakshmi Chintala, Istvan Cseri, Rodger N. Kline, Nitya Kumar Sharma, Igor Zinkovsky
-
Publication number: 20230297350Abstract: Embodiments described herein provide techniques for in-line compiling of UDFs in other programming languages. These techniques enable faster programming iterations because it allows users to compile directly in the cloud processing system. Moreover, it allows the UDFs to tie into existing libraries. The compiled results are treated as sensitive and handled with appropriate security policies, as with any other user data in the system.Type: ApplicationFiled: May 26, 2023Publication date: September 21, 2023Inventors: Elliott Brossard, Siddharth Kulkarni, Isaac Kunen
-
Patent number: 11726976Abstract: A database query specifies a user-defined function (UDF) to apply to one or more tables in a distributed database. The one or more tables are identified in the distributed database. The one or more tables are associated with an initial set of data types native to the distributed database. The one or more tables are converted to database data comprising data types of the UDF. The UDF is executed on the database data to generate results data. The results data is converted to table results data. The table results data is associated with the initial set of data types. The table results data is stored in the distributed database.Type: GrantFiled: November 30, 2022Date of Patent: August 15, 2023Assignee: Snowflake Inc.Inventors: Elliott Brossard, Chong Han, Igor Zinkovsky
-
Patent number: 11704100Abstract: Embodiments described herein provide techniques for in-line compiling of UDFs in other programming languages. These techniques enable faster programming iterations because it allows users to compile directly in the cloud processing system. Moreover, it allows the UDFs to tie into existing libraries. The compiled results are treated as sensitive and handled with appropriate security policies, as with any other user data in the system.Type: GrantFiled: August 31, 2022Date of Patent: July 18, 2023Assignee: Snowflake Inc.Inventors: Elliott Brossard, Siddharth Kulkarni, Isaac Kunen
-
Patent number: 11645243Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF signatures and interfaces (e.g., classes, sub-classes) that can be called by other users. Upon a UDF being called, one or more interface objects (e.g., InputStream) can be created and requests transferred to a execution node via a network channel. The execution node can implement multiple threads that are authorized and download file data from a staging location (e.g., internal stage, external stage) concurrently.Type: GrantFiled: November 9, 2021Date of Patent: May 9, 2023Assignee: Snowflake Inc.Inventors: Elliott Brossard, Sukruth Komarla Sukumar, Isaac Kunen, Ju-yi Kuo, Jonathan Lee Leang, Edward Ma, Schuyler James Manchester, Polita Paulus, Saurin Shah, Igor Zinkovsky
-
Publication number: 20230139362Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.Type: ApplicationFiled: July 19, 2022Publication date: May 4, 2023Inventors: Elliott Brossard, Srilakshmi Chintala, Istvan Cseri, Rodger N. Kline, Nitya Kumar Sharma, Igor Zinkovsky
-
Publication number: 20230097756Abstract: A method includes decoding, by at least one hardware processor, a request for a user-defined function (UDF). The request includes a reference to one or more files. The method further includes generating, by the at least one hardware processor, the UDF based on the request. The UDF includes a file reference object with file path information corresponding to the reference. The file path information identifies a file path to the one or more files. A UDF call into the UDF is detected. The UDF call specifies the file path information. The UDF call is processed to generate result data using the one or more files.Type: ApplicationFiled: December 8, 2022Publication date: March 30, 2023Inventors: Elliott Brossard, Sukruth Komarla Sukumar, Isaac Kunen, Ju-yi Kuo, Jonathan Lee Leang, Edward ma, Schuyler James Manchester, Polita Paulus, Saurin Shah, Igor Zinkovsky
-
Patent number: 11550845Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF interfaces and file reference objects that can be called by other users. Upon a UDF being called, files on a stage, one or more interface objects (e.g., InputStream), and file reference objects can be implemented by execution nodes of the distributed database system. The execution nodes can implement multiple threads that are authenticated and can download file data from a staging location concurrently.Type: GrantFiled: March 31, 2022Date of Patent: January 10, 2023Assignee: Snowflake Inc.Inventors: Elliott Brossard, Sukruth Komarla Sukumar, Isaac Kunen, Ju-yi Kuo, Jonathan Lee Leang, Edward Ma, Schuyler James Manchester, Polita Paulus, Saurin Shah, Igor Zinkovsky
-
Publication number: 20220413816Abstract: Embodiments described herein provide techniques for in-line compiling of UDFs in other programming languages. These techniques enable faster programming iterations because it allows users to compile directly in the cloud processing system. Moreover, it allows the UDFs to tie into existing libraries. The compiled results are treated as sensitive and handled with appropriate security policies, as with any other user data in the system.Type: ApplicationFiled: August 31, 2022Publication date: December 29, 2022Inventors: Elliott Brossard, Siddharth Kulkarni, Isaac Kunen
-
Publication number: 20220391357Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF signatures and interfaces (e.g., classes, sub-classes) that can be called by other users. Upon a UDF being called, one or more interface objects (e.g., InputStream) can be created and requests transferred to a execution node via a network channel. The execution node can implement multiple threads that are authorized and download file data from a staging location (e.g., internal stage, external stage) concurrently.Type: ApplicationFiled: November 9, 2021Publication date: December 8, 2022Inventors: Elliott Brossard, Sukruth Komarla Sukumar, Isaac Kunen, Ju-yi Kuo, Jonathan Lee Leang, Edward Ma, Schuyler James Manchester, Polita Paulus, Saurin Shah, Igor Zinkovsky
-
Patent number: 11461080Abstract: Embodiments described herein provide techniques for in-line compiling of UDFs in other programming languages. These techniques enable faster programming iterations because it allows users to compile directly in the cloud processing system. Moreover, it allows the UDFs to tie into existing libraries. The compiled results are treated as sensitive and handled with appropriate security policies, as with any other user data in the system.Type: GrantFiled: July 30, 2021Date of Patent: October 4, 2022Assignee: Snowflake Inc.Inventors: Elliott Brossard, Siddharth Kulkarni, Isaac Kunen
-
Patent number: 11423081Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF signatures and interfaces (e.g., classes, sub-classes) that can be called by other users. Upon a UDF being called, one or more interface objects (e.g., InputStream) can be created and requests transferred to a execution node via a network channel. The execution node can implement multiple threads that are authorized and download file data from a staging location (e.g., internal stage, external stage) concurrently.Type: GrantFiled: August 1, 2021Date of Patent: August 23, 2022Assignee: Snowflake Inc.Inventors: Elliott Brossard, Sukruth Komarla Sukumar, Isaac Kunen, Ju-Yi Kuo, Jonathan Leang, Edward Ma, Schuyler James Manchester, Polita Paulus, Saurin Shah, Igor Zinkovsky
-
Patent number: 11403298Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.Type: GrantFiled: October 29, 2021Date of Patent: August 2, 2022Assignee: Snowflake Inc.Inventors: Elliott Brossard, Srilakshmi Chintala, Istvan Cseri, Rodger N. Kline, Nitya Kumar Sharma, Igor Zinkovsky
-
Publication number: 20220237231Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF interfaces and file reference objects that can be called by other users. Upon a UDF being called, files on a stage, one or more interface objects (e.g., InputStream), and file reference objects can be implemented by execution nodes of the distributed database system. The execution nodes can implement multiple threads that are authenticated and can download file data from a staging location concurrently.Type: ApplicationFiled: March 31, 2022Publication date: July 28, 2022Inventors: Elliott Brossard, Sukruth Komarla Sukumar, Isaac Kunen, Ju-yi Kuo, Jonathan Lee Leang, Edward Ma, Schuyler James Manchester, Polita Paulus, Saurin Shah, Igor Zinkovsky
-
Patent number: 11361026Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF interfaces and file reference objects that can be called by other users. Upon a UDF being called, files on a stage, one or more interface objects (e.g., InputStream), and file reference objects can be implemented by execution nodes of the distributed database system. The execution nodes can implement multiple threads that are authenticated and can download file data from a staging location concurrently.Type: GrantFiled: August 31, 2021Date of Patent: June 14, 2022Assignee: Snowflake Inc.Inventors: Elliott Brossard, Sukruth Komarla Sukumar, Isaac Kunen, Ju-yi Kuo, Jonathan Lee Leang, Edward Ma, Schuyler James Manchester, Polita Paulus, Saurin Shah, Igor Zinkovsky
-
Patent number: 11347527Abstract: A system comprises at least one hardware processor and a memory storing instructions. When executed, the instructions cause the at least one hardware processor to perform operations comprising receiving, in a computing process, a Java user-defined table function (Java UDTF), the Java UDTF including code related to a process method to be performed that includes receiving one or more input tables and transforming the one or more input tables to an output table; determining, using at least a security policy, whether performing one or more portions of the process method are permitted; and performing portions of the process method determined to be permitted.Type: GrantFiled: July 30, 2021Date of Patent: May 31, 2022Assignee: Snowflake Inc.Inventors: Elliott Brossard, Istvan Cseri, Derek Denny-Brown, Filip Drozdowski, Isaac Kunen, Edward Ma
-
Patent number: 11347485Abstract: A system comprises at least one hardware processor and a memory storing instructions. When executed, the instructions cause the at least one hardware processor to perform operations comprising receiving, in a compiling process, a request to create a Java user-defined table function (Java UDTF), the Java UDTF including code related to receiving one or more input tables and transforming the one or more input tables to an output table; verifying a construct of the Java UDTF in the request is correct; and compiling to generate execution code that includes the Java UDTF when the construct of the Java UDTF is correct.Type: GrantFiled: July 30, 2021Date of Patent: May 31, 2022Assignee: Snowflake Inc.Inventors: Elliott Brossard, Istvan Cseri, Derek Denny-Brown, Filip Drozdowski, Isaac Kunen, Edward Ma
-
Patent number: 11295009Abstract: The subject technology receives, in a computing process, a user defined function, the user defined function including code related to at least one operation to be performed. The subject technology determines by a security manager whether performing the at least one operation is permitted, the security manager determines restrictions, based at least in part on a security policy. The subject technology performs the at least one operation. The subject technology sends a result of the at least one operation to the computing process, where sending the result of the at least one operation utilizes a data transport mechanism that supports a network transfer of columnar data.Type: GrantFiled: June 18, 2021Date of Patent: April 5, 2022Assignee: Snowflake Inc.Inventors: Elliott Brossard, Derek Denny-Brown, Isaac Kunen, Soumitr Rajiv Pandey, Jacob Salassi, Srinath Shankar, Haowei Yu, Andong Zhan