Patents by Inventor Alexander Tsukerman
Alexander Tsukerman 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).
-
Patent number: 10936616Abstract: A storage system communicatively coupled to a database management system (DBMS performs storage-side scanning of data sources that are not stored in native database storage format of the DBMS. Data sources for external tables are accessible in a storage system referred to as a distributed data access system (DDAS), e.g. a Hadoop Distributed File System. To execute a query that references an external table, a DBMS first generates an execution plan. The DDAS supplies the DBMS with information that specifies each portion of the data source, and specifies which data node to use to access the portion. The DBMS sends a request for each portion to the respective data node, requesting that the data node generate rows from data in the portion. The request may specify scanning criteria, specifying one or more columns to project and/or filter on, and code modules for the data node to execute to generate records.Type: GrantFiled: June 8, 2015Date of Patent: March 2, 2021Assignee: Oracle International CorporationInventors: Dmitry Mikhailovich Potapov, Krishnan Meiyyappan, Alexander Tsukerman, Kothanda Umamageswaran, Semen Ustimenko, Wei Zhang, Adrian Tsz Him Ng, Daniel McClary, Allen Brumm, James Stenoish, Robert K. Abbott
-
Patent number: 10742560Abstract: A method and apparatus for intelligent network resource manager for distributed computing systems is provided. A first priority is assigned to a first virtual channel set that includes at least two virtual channels of a plurality of virtual channels associated with a physical communication channel. A second priority is assigned to a second virtual channel set that includes at least one virtual channel of the plurality of virtual channels. The first virtual channel set has more virtual channels than the second virtual channel set. Outbound messages of the first priority are directed to virtual channels of the first virtual channel set. Outbound messages of the second priority are directed to virtual channels of the second virtual channel set. The virtual channels are processed in a round-robin order, where processing includes sending the outbound messages over the physical communication channel.Type: GrantFiled: February 27, 2019Date of Patent: August 11, 2020Assignee: Oracle International CorporationInventors: Vijay Sridharan, Richard Frank, Jia Shi, Kothanda Umamageswaran, Juan Loaiza, Alexander Tsukerman, Bang Nguyen, Sumanta Chatterjee
-
Publication number: 20200169508Abstract: A method and apparatus for intelligent network resource manager for distributed computing systems is provided. A first priority is assigned to a first virtual channel set that includes at least two virtual channels of a plurality of virtual channels associated with a physical communication channel. A second priority is assigned to a second virtual channel set that includes at least one virtual channel of the plurality of virtual channels. The first virtual channel set has more virtual channels than the second virtual channel set. Outbound messages of the first priority are directed to virtual channels of the first virtual channel set. Outbound messages of the second priority are directed to virtual channels of the second virtual channel set. The virtual channels are processed in a round-robin order, where processing includes sending the outbound messages over the physical communication channel.Type: ApplicationFiled: February 27, 2019Publication date: May 28, 2020Inventors: VIJAY SRIDHARAN, RICHARD FRANK, JIA SHI, KOTHANDA UMAMAGESWARAN, JUAN LOAIZA, ALEXANDER TSUKERMAN, BANG NGUYEN, SUMANTA CHATTERJEE
-
Patent number: 10528590Abstract: Techniques for optimizing a query with an extrema function are provided. In main memory, a data summary is maintained for a plurality of extents stored by at least one storage server. The data summary includes an extent minimum value and an extent maximum value for one or more columns. A storage server request is received, from a database server, based on a query with an extrema function applied to a particular column of a particular table. The data summaries for a set of relevant extents are processed by maintaining at least one global extrema value corresponding to the extrema function and, for each relevant extent of the set of relevant extents, determining whether to scan records of the relevant extent based on at least one of the global extrema value and an extent summary value of the data summary of the relevant extent.Type: GrantFiled: May 29, 2015Date of Patent: January 7, 2020Assignee: Oracle International CorporationInventors: Adrian Ng, Krishnan Meiyyappan, Alexander Tsukerman, Dmitry Potapov
-
Patent number: 10430338Abstract: Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, d) whether the I/O request is associated with an offloaded filter provided by the database server to the storage system, or e) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.Type: GrantFiled: January 21, 2010Date of Patent: October 1, 2019Assignee: Oracle International CorporationInventors: Kothanda Umamageswaran, Juan R. Loaiza, Umesh Panchaksharaiah, Alexander Tsukerman, Timothy L. Shetler, Bharat C. V. Baddepudi, Boris Erlikhman, Kiran B. Goyal, Nilesh Choudhury, Susy Fan, Poojan Kumar, Selcuk Aya, Sue-Kyoung Lee
-
Patent number: 10387447Abstract: Techniques herein are for creating a database snapshot by creating a sparse database. A method involves receiving a creation request to create a sparse database. The creation request has an identity of a parent database. The creation request is processed to create a sparse database. The sparse database has the identity of the parent database. The sparse database does not contain data copied from the parent database. A write request to write data into the sparse database is received. The write request is processed by writing the data into the sparse database. The parent database does not receive the data.Type: GrantFiled: August 11, 2015Date of Patent: August 20, 2019Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Nilesh Choudhury, Scott Martin, Zuoyu Tao, Jia Shi, Alexander Tsukerman, Kothanda Umamageswaran
-
Patent number: 10346362Abstract: Techniques herein are for accessing non-materialized blocks of a sparse file. A method involves a storage system receiving a storage command to access a sparse file. A combined content of a set of materialized blocks and a header that identifies one or more non-materialized blocks is assembled. The combined content does not comprise a content of the one or more non-materialized blocks. Responsive to the assembling, the combined content is transferred between the storage system and a computer system.Type: GrantFiled: September 9, 2015Date of Patent: July 9, 2019Assignee: Oracle International CorporationInventors: Zuoyo Tao, Nilesh Choudhury, Scott Martin, Mingmin Chen, Jia Shi, Alexander Tsukerman, Kothanda Umamageswaran
-
Publication number: 20190199639Abstract: A method and apparatus for intelligent network resource manager for distributed computing systems is provided. A first priority is assigned to a first virtual channel set that includes at least two virtual channels of a plurality of virtual channels associated with a physical communication channel. A second priority is assigned to a second virtual channel set that includes at least one virtual channel of the plurality of virtual channels. The first virtual channel set has more virtual channels than the second virtual channel set. Outbound messages of the first priority are directed to virtual channels of the first virtual channel set. Outbound messages of the second priority are directed to virtual channels of the second virtual channel set. The virtual channels are processed in a round-robin order, where processing includes sending the outbound messages over the physical communication channel.Type: ApplicationFiled: February 27, 2019Publication date: June 27, 2019Inventors: VIJAY SRIDHARAN, RICHARD FRANK, JIA SHI, KOTHANDA UMAMAGESWARAN, JUAN LOAIZA, ALEXANDER TSUKERMAN, BANG NGUYEN, SUMANTA CHATTERJEE
-
Patent number: 10250510Abstract: A method and apparatus for intelligent network resource manager for distributed computing systems is provided. A first priority is assigned to a first virtual channel set that includes at least two virtual channels of a plurality of virtual channels associated with a physical communication channel. A second priority is assigned to a second virtual channel set that includes at least one virtual channel of the plurality of virtual channels. The first virtual channel set has more virtual channels than the second virtual channel set. Outbound messages of the first priority are directed to virtual channels of the first virtual channel set. Outbound messages of the second priority are directed to virtual channels of the second virtual channel set. The virtual channels are processed in a round-robin order, where processing includes sending the outbound messages over the physical communication channel.Type: GrantFiled: September 16, 2014Date of Patent: April 2, 2019Assignee: Oracle International CorporationInventors: Vijay Sridharan, Richard Frank, Jia Shi, Kothanda Umamageswaran, Juan Loaiza, Alexander Tsukerman, Bang Nguyen, Sumanta Chatterjee
-
Patent number: 9772793Abstract: In a write by-peer-reference, a storage device client writes a data block to a target storage device in the storage system by sending a write request to the target storage device, the write request specifying information used to obtain the data block from a source storage device in the storage system. The target storage device sends a read request to the source storage device for the data block. The source storage device sends the data block to the target storage device, which then writes the data block to the target storage device. The data block is thus written to the target storage device without the storage device client transmitting the data block itself to the target storage device.Type: GrantFiled: September 18, 2014Date of Patent: September 26, 2017Assignee: Oracle International CorporationInventors: Vijay Sridharan, Alexander Tsukerman, Jia Shi, Kothanda Umamageswaran
-
Patent number: 9405694Abstract: Techniques are provided for using an intermediate cache between the shared cache of an application and the non-volatile storage of a storage system. The application may be any type of application that uses a storage system to persistently store data. The intermediate cache may be local to the machine upon which the application is executing, or may be implemented within the storage system. In one embodiment where the application is a database server, the database system includes both a DB server-side intermediate cache, and a storage-side intermediate cache. The caching policies used to populate the intermediate cache are intelligent, taking into account factors that may include which object an item belongs to, the item type of the item, a characteristic of the item, or the type of operation in which the item is involved.Type: GrantFiled: September 16, 2014Date of Patent: August 2, 2016Assignee: Oracle Internation CorporationInventors: Kiran Badrinarain Goyal, Neil J. S. Macnaughton, Eugene Ho, Adam Y. Lee, Vipin Gokhale, Wei-Ming Hu, Juan R. Loaiza, Kothanda Umamageswaran, Bharat C. V. Baddepudi, Boris Erlikhman, Alexander Tsukerman, Selcuk Aya, Roger Hansen, Adrian Ng
-
Patent number: 9361232Abstract: Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, or d) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.Type: GrantFiled: March 15, 2013Date of Patent: June 7, 2016Assignee: Oracle International CorporationInventors: Kothanda Umamageswaran, Juan R. Loaiza, Umesh Panchaksharaiah, Alexander Tsukerman, Timothy L. Shetler, Bharat C. V. Baddepudi, Boris Erlikhman, Kiran B. Goyal, Nilesh Choudhury, Susy Fan, Poojan Kumar, Selcuk Aya, Sue-Kyoung Lee
-
Publication number: 20160092507Abstract: Techniques for optimizing a query with an extrema function are provided. In main memory, a data summary is maintained for a plurality of extents stored by at least one storage server. The data summary includes an extent minimum value and an extent maximum value for one or more columns. A storage server request is received, from a database server, based on a query with an extrema function applied to a particular column of a particular table. The data summaries for a set of relevant extents are processed by maintaining at least one global extrema value corresponding to the extrema function and, for each relevant extent of the set of relevant extents, determining whether to scan records of the relevant extent based on at least one of the global extrema value and an extent summary value of the data summary of the relevant extent.Type: ApplicationFiled: May 29, 2015Publication date: March 31, 2016Inventors: ADRIAN NG, KRISHNAN MEIYYAPPAN, ALEXANDER TSUKERMAN, DMITRY POTAPOV
-
Publication number: 20160092534Abstract: Techniques herein are for creating a database snapshot by creating a sparse database. A method involves receiving a creation request to create a sparse database. The creation request has an identity of a parent database. The creation request is processed to create a sparse database. The sparse database has the identity of the parent database. The sparse database does not contain data copied from the parent database. A write request to write data into the sparse database is received. The write request is processed by writing the data into the sparse database. The parent database does not receive the data.Type: ApplicationFiled: August 11, 2015Publication date: March 31, 2016Inventors: Nilesh Choudhury, Scott Martin, Zuoyu Tao, Jia Shi, Alexander Tsukerman, Kothanda Umamageswaran
-
Publication number: 20160092454Abstract: Techniques herein are for accessing non-materialized blocks of a sparse file. A method involves a storage system receiving a storage command to access a sparse file. A combined content of a set of materialized blocks and a header that identifies one or more non-materialized blocks is assembled. The combined content does not comprise a content of the one or more non-materialized blocks. Responsive to the assembling, the combined content is transferred between the storage system and a computer system.Type: ApplicationFiled: September 9, 2015Publication date: March 31, 2016Inventors: Zuoyu Tao, Nilesh Choudhury, Scott Martin, Mingmin Chen, Jia Shi, Alexander Tsukerman, Kothanda Umamageswaran
-
Publication number: 20150356158Abstract: A storage system communicatively coupled to a DBMS performs storage-side scanning of data sources that are not stored in the native database storage format of the DBMS. Data sources for external tables are accessible in a storage system referred to herein as a distributed data access system, e.g. a Hadoop Distributed File System. To execute a query that references an external table, a DBMS first generates an execution plan. The distributed data access system supplies the DBMS with information that specifies each portion of the data source, and specifies which data node to use to access the portion. The DBMS sends a request for each portion to the respective data node, the request requesting that the data node generate rows from data in the portion. The request may specify scanning criteria, specifying one or more columns to project and/or filter on. The request may also specify code modules for the data node to execute to generate rows or records and columns.Type: ApplicationFiled: June 8, 2015Publication date: December 10, 2015Inventors: Dmitry Mikhailovich Potapov, Krishnan Meiyyappan, Alexander Tsukerman, Kothanda Umamageswaran, Semen Ustimenko, Wei Zhang, Adrian Tsz Him Ng, Daniel McClary, Allen Brumm, James Stenoish, Robert K. Abbott
-
Publication number: 20150089140Abstract: In a write by-peer-reference, a storage device client writes a data block to a target storage device in the storage system by sending a write request to the target storage device, the write request specifying information used to obtain the data block from a source storage device in the storage system. The target storage device sends a read request to the source storage device for the data block. The source storage device sends the data block to the target storage device, which then writes the data block to the target storage device. The data block is thus written to the target storage device without the storage device client transmitting the data block itself to the target storage device.Type: ApplicationFiled: September 18, 2014Publication date: March 26, 2015Inventors: Vijay Sridharan, Alexander Tsukerman, Jia Shi, Kothanda Umamageswaran
-
Publication number: 20150089008Abstract: A method and apparatus for intelligent network resource manager for distributed computing systems is provided. A first priority is assigned to a first virtual channel set that includes at least two virtual channels of a plurality of virtual channels associated with a physical communication channel. A second priority is assigned to a second virtual channel set that includes at least one virtual channel of the plurality of virtual channels. The first virtual channel set has more virtual channels than the second virtual channel set. Outbound messages of the first priority are directed to virtual channels of the first virtual channel set. Outbound messages of the second priority are directed to virtual channels of the second virtual channel set. The virtual channels are processed in a round-robin order, where processing includes sending the outbound messages over the physical communication channel.Type: ApplicationFiled: September 16, 2014Publication date: March 26, 2015Inventors: Vijay Sridharan, Richard Frank, Jia Shi, Kothanda Umamageswaran, Juan Loaiza, Alexander Tsukerman, Bang Nguyen, Sumanta Chatterjee
-
Patent number: 8935227Abstract: In a consumer-producer distributed model of computing, consumers request data from producers and perform computing work on the data received from the producers, thereby transforming the data. At least some of the computing work performed by a consumer on data provided by the producer is commutable between the consumer and producer, that is, either the producer as well as the consumer can perform the computing work on the data. A producer redistributes commutable based on the work load of the producer and consumer as well as other factors.Type: GrantFiled: April 17, 2012Date of Patent: January 13, 2015Assignee: Oracle International CorporationInventors: Johnny Quan Zhou, Nilesh Choudhury, Juan R. Loaiza, Dmitry Mikhailovich Potapov, Alexander Tsukerman, Kothanda Umamageswaran
-
Publication number: 20150006813Abstract: Techniques are provided for using an intermediate cache between the shared cache of an application and the non-volatile storage of a storage system. The application may be any type of application that uses a storage system to persistently store data. The intermediate cache may be local to the machine upon which the application is executing, or may be implemented within the storage system. In one embodiment where the application is a database server, the database system includes both a DB server-side intermediate cache, and a storage-side intermediate cache. The caching policies used to populate the intermediate cache are intelligent, taking into account factors that may include which object an item belongs to, the item type of the item, a characteristic of the item, or the type of operation in which the item is involved.Type: ApplicationFiled: September 16, 2014Publication date: January 1, 2015Inventors: Kiran Badrinarain Goyal, Neil J.S. Macnaughton, Eugene Ho, Adam Y. Lee, Vipin Gokhale, Wei-Ming Hu, Juan R. Loaiza, Kothanda Umamageswaran, Bharat C.V. Baddepudi, Boris Erlikhman, Alexander Tsukerman, Selcuk Aya, Roger Hansen, Adrian Ng