Patents by Inventor Igor Zinkovsky
Igor Zinkovsky 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: 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
-
Publication number: 20220129335Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: ApplicationFiled: January 10, 2022Publication date: April 28, 2022Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Publication number: 20220100758Abstract: External functions can provide users of a database system the ability to invoke external services while operating from inside the database system. The techniques described herein address may detect throttling by the external system and automatically adjust or modify a request rate accordingly. Also, the techniques described herein may increase the request rate to optimize the use of the resources provided by the external system. These techniques allow the database system to improve efficiency when working with external services, which may or may not be elastic or scalable. Moreover, these techniques can decrease query execution times and reduce costs.Type: ApplicationFiled: September 30, 2020Publication date: March 31, 2022Inventors: Elliott Brossard, Istvan Cseri, Isaac Kunen, Nitya Kumar Sharma, Igor Zinkovsky
-
Patent number: 11249829Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: GrantFiled: August 30, 2021Date of Patent: February 15, 2022Assignee: Snowflake Inc.Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Patent number: 11243947Abstract: A query referencing an external table function provided by a remote software component is received. Requests to execute the external table function on input data are sent to a proxy service. A first request includes a batch of input rows from the input data. A first response to the first request received from the proxy service includes a first portion of result data and a pagination token. The pagination token indicates that at least a second portion of the result data corresponding to the first batch of input rows is to be obtained from the remote software component. Based on the pagination token, a second request is sent to obtain the second portion of the result data. One or more responses are received from the proxy service that comprise at least the second portion of the result data. The result data is processed according to the query.Type: GrantFiled: July 29, 2021Date of Patent: February 8, 2022Assignee: Snowflake Inc.Inventors: Srilakshmi Chintala, Istvan Cseri, Albert L. Hu, Isaac Kunen, Nitya Kumar Sharma, Igor Zinkovsky
-
Patent number: 11216421Abstract: The subject technology determines, using a stream object provided by a network-based database system separate from an external system, a set of offsets of each shard of a set of shards, the set of offsets being determined by executing a user defined function (UDF) included in the stream object, the stream object and the UDF being implemented in a particular programming language different than a database query language. The subject technology identifies an operation to perform on the set of shards. The subject technology, based on the set of shards and the set of offsets, performs, using the UDF included in the stream object, the operation on an external data source hosted by the external system. The subject technology increments a property indicating a different version of the stream object after performing the operation on the external data source, the property being included in the stream object.Type: GrantFiled: June 11, 2021Date of Patent: January 4, 2022Assignee: Snowflake Inc.Inventors: Istvan Cseri, Tyler Jones, Dinesh Chandrakant Kulkarni, Igor Zinkovsky
-
Publication number: 20210406311Abstract: 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: August 31, 2021Publication date: December 30, 2021Inventors: 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: 20210390007Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: ApplicationFiled: August 30, 2021Publication date: December 16, 2021Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Publication number: 20210318994Abstract: The subject technology determines, using a stream object provided by a network-based database system separate from an external system, a set of offsets of each shard of a set of shards, the set of offsets being determined by executing a user defined function (UDF) included in the stream object, the stream object and the UDF being implemented in a particular programming language different than a database query language. The subject technology identifies an operation to perform on the set of shards. The subject technology, based on the set of shards and the set of offsets, performs, using the UDF included in the stream object, the operation on an external data source hosted by the external system. The subject technology increments a property indicating a different version of the stream object after performing the operation on the external data source, the property being included in the stream object.Type: ApplicationFiled: June 11, 2021Publication date: October 14, 2021Inventors: Istvan Cseri, Tyler Jones, Dinesh Chandrakant Kulkarni, Igor Zinkovsky
-
Patent number: 11138192Abstract: A query referencing an external table function provided by a remote software component is received. Requests to execute the external table function on input data are sent to a proxy service. A first request includes a batch of input rows from the input data. A first response to the first request received from the proxy service includes a first portion of result data and a pagination token. The pagination token indicates that at least a second portion of the result data corresponding to the first batch of input rows is to be obtained from the remote software component. Based on the pagination token, a second request is sent to obtain the second portion of the result data. One or more responses are received from the proxy service that comprise at least the second portion of the result data. The result data is processed according to the query.Type: GrantFiled: April 30, 2021Date of Patent: October 5, 2021Assignee: Snowflake Inc.Inventors: Srilakshmi Chintala, Istvan Cseri, Albert L. Hu, Isaac Kunen, Nitya Kumar Sharma, Igor Zinkovsky
-
Patent number: 11132243Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: GrantFiled: March 31, 2021Date of Patent: September 28, 2021Assignee: Snowflake Inc.Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Patent number: 11126484Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: GrantFiled: April 23, 2021Date of Patent: September 21, 2021Assignee: Snowflake Inc.Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Publication number: 20210240557Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: ApplicationFiled: April 23, 2021Publication date: August 5, 2021Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Publication number: 20210216385Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: ApplicationFiled: March 31, 2021Publication date: July 15, 2021Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Patent number: 11055262Abstract: The subject technology determines a set of shards corresponding to an external data source accessible via a network, the external data source being hosted by an external system separate from a network-based database system. The subject technology determines, using a stream object, a set of offsets of each shard of the set of shards. The subject technology identifies an operation to perform on the set of shards, the operation comprising a read operation or a write operation. The subject technology, based on the set of shards and the set of offsets, performs the operation on the external data source.Type: GrantFiled: March 9, 2020Date of Patent: July 6, 2021Assignee: Snowflake Inc.Inventors: Istvan Cseri, Tyler Jones, Dinesh Chandrakant Kulkarni, Igor Zinkovsky
-
Patent number: 11010410Abstract: A request associated with a data item is received. A data grouping corresponding to the data item is identified. The identified data grouping belongs to a data grouping container that has been assigned a plurality of data groupings. Any one data grouping of the plurality of data groupings is individually reassignable to a different data grouping container. At least one data center where the identified data grouping is stored among a plurality of data centers is determined. A processing of the request is managed based on the determined data center that stores the identified data grouping.Type: GrantFiled: October 12, 2018Date of Patent: May 18, 2021Assignee: Facebook, Inc.Inventors: Muthukaruppan Annamalai, Kaushik Ravichandran, Igor A. Zinkovsky, Harish Srinivas
-
Patent number: 10997005Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: GrantFiled: September 22, 2020Date of Patent: May 4, 2021Assignee: Snowflake Inc.Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Publication number: 20210124633Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: ApplicationFiled: September 22, 2020Publication date: April 29, 2021Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky
-
Patent number: 10846157Abstract: A query referencing a function associated with a remote software component is received by a network-based data warehouse system. Temporary security credentials corresponding to a role at a cloud computing service platform are obtained. The role has permission to send calls to a web endpoint corresponding to the remote software component. A request comprising input data and electronically signed using the temporary security credentials is sent to a web Application Programming Interface (API) management system of the cloud computing service platform. The request, when received by the web API management system, causes the web API management system to invoke external functionality provided by the remote software component at the web endpoint with respect to the input data. A response comprising a result of invoking the external functionality is received from the web API management system, and the result data is processed according to the query.Type: GrantFiled: July 29, 2020Date of Patent: November 24, 2020Assignee: Snowflake Inc.Inventors: Istvan Cseri, Isaac Kunen, Igor Zinkovsky