Patents by Inventor Leonid Novak

Leonid Novak 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: 11636075
    Abstract: In accordance with an embodiment, described herein are systems and methods for providing direct access to a sharded database. A shard director provides access by software client applications to database shards. A connection pool (e.g., a Universal Connection Pool, UCP) and database driver (e.g., a Java Database Connectivity, JDBC, component) can be configured to allow a client application to provide a shard key, either during connection checkout or at a later time; recognize shard keys specified by the client application; and enable connection by the client application to a particular shard or chunk. The approach enables efficient re-use of connection resources, and faster access to appropriate shards.
    Type: Grant
    Filed: April 20, 2016
    Date of Patent: April 25, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Vidya Hegde, Jean de Lavarene, Douglas Surber, Mark Dilman, Leonid Novak, Wei Ming Hu, Ashok Shivarudraiah, Tong Zhou, Ilya Taranov
  • Patent number: 11609901
    Abstract: Techniques are provided for processing a database command in a sharded database. The processing of the database command may include generating or otherwise accessing a shard key expression, and evaluating the shard key expression to identify one or more target shards that contain data used to execute the database command.
    Type: Grant
    Filed: September 13, 2021
    Date of Patent: March 21, 2023
    Assignee: Oracle International Corporation
    Inventors: Lik Wong, Leonid Novak, Douglas N. Surber, Ilesh Garish, Saurabh Verma, Wei Ming Hu, Mark Dilman, Jean de Lavarene
  • Patent number: 11409721
    Abstract: In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.
    Type: Grant
    Filed: December 23, 2019
    Date of Patent: August 9, 2022
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Vidya Hegde, Jean de Lavarene, Douglas Surber, Mark Dilman, Leonid Novak, Wei Ming Hu, Ashok Shivarudraiah, Tong Zhou, Ilya Taranov
  • Publication number: 20210406252
    Abstract: Techniques are provided for processing a database command in a sharded database. The processing of the database command may include generating or otherwise accessing a shard key expression, and evaluating the shard key expression to identify one or more target shards that contain data used to execute the database command.
    Type: Application
    Filed: September 13, 2021
    Publication date: December 30, 2021
    Inventors: Lik Wong, Leonid Novak, Douglas N. Surber, Ilesh Garish, Saurabh Verma, Wei Ming Hu, Mark Dilman, Jean de Lavarene
  • Patent number: 11204900
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used to route database requests and process queries in a sharded database.
    Type: Grant
    Filed: May 3, 2019
    Date of Patent: December 21, 2021
    Assignee: Oracle International Corporation
    Inventors: Wei-Ming Hu, Mark Dilman, Leonid Novak, Ilya Taranov, Zheng Zeng, Jean de Lavarene, Vidya Hegde
  • Patent number: 11151124
    Abstract: Techniques are provided for processing a database command in a sharded database. The processing of the database command may include generating or otherwise accessing a shard key expression, and evaluating the shard key expression to identify one or more target shards that contain data used to execute the database command.
    Type: Grant
    Filed: September 9, 2019
    Date of Patent: October 19, 2021
    Assignee: Oracle International Corporation
    Inventors: Lik Wong, Leonid Novak, Douglas N. Surber, Ilesh Garish, Saurabh Verma, Wei Ming Hu, Mark Dilman, Jean de Lavarene
  • Patent number: 10983970
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described provide improvements to load distribution, organization, query processing, and schema propagation in a sharded database.
    Type: Grant
    Filed: March 21, 2019
    Date of Patent: April 20, 2021
    Assignee: Oracle International Corporation
    Inventors: Wei-Ming Hu, Mark Dilman, Stephen Ball, Ghazi Nourdine Benadjaoud, Leonid Novak, Ilya Taranov, Zheng Zeng
  • Publication number: 20210073208
    Abstract: Techniques are provided for processing a database command in a sharded database. The processing of the database command may include generating or otherwise accessing a shard key expression, and evaluating the shard key expression to identify one or more target shards that contain data used to execute the database command.
    Type: Application
    Filed: September 9, 2019
    Publication date: March 11, 2021
    Inventors: Lik Wong, Leonid Novak, Douglas N. Surber, Ilesh Garish, Saurabh Verma, Wei Ming Hu, Mark Dilman, Jean de Lavarene
  • Publication number: 20200125546
    Abstract: In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.
    Type: Application
    Filed: December 23, 2019
    Publication date: April 23, 2020
    Inventors: Vidya Hegde, Jean de Lavarene, Douglas Surber, Mark Dilman, Leonid Novak, Wei Ming Hu, Ashok Shivarudraiah, Tong Zhou, Ilya Taranov
  • Patent number: 10545935
    Abstract: In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.
    Type: Grant
    Filed: April 20, 2016
    Date of Patent: January 28, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Vidya Hegde, Jean de Lavarene, Douglas Surber, Mark Dilman, Leonid Novak, Wei Ming Hu, Ashok Shivarudraiah, Tong Zhou, Ilya Taranov
  • Patent number: 10496614
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used for load distribution, organization, query processing, and schema propagation in a sharded database.
    Type: Grant
    Filed: September 16, 2016
    Date of Patent: December 3, 2019
    Assignee: Oracle International Corporation
    Inventors: Wei-Ming Hu, Mark Dilman, Leonid Novak, Stephen Ball, Ghazi Nourdine Benadjaoud
  • Publication number: 20190258613
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used to route database requests and process queries in a sharded database.
    Type: Application
    Filed: May 3, 2019
    Publication date: August 22, 2019
    Inventors: Wei-Ming Hu, Mark Dilman, Leonid Novak, Ilya Taranov, Zheng Zeng, Jean de Lavarene, Vidya Hegde
  • Publication number: 20190220450
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described provide improvements to load distribution, organization, query processing, and schema propagation in a sharded database.
    Type: Application
    Filed: March 21, 2019
    Publication date: July 18, 2019
    Inventors: Wei-Ming Hu, Mark Dilman, Stephen Ball, Ghazi Nourdine Benadjaoud, Leonid Novak, Ilya Taranov, Zheng Zeng
  • Patent number: 10331634
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used to route database requests and process queries in a sharded database.
    Type: Grant
    Filed: September 16, 2016
    Date of Patent: June 25, 2019
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Wei-Ming Hu, Mark Dilman, Leonid Novak, Ilya Taranov, Zheng Zeng, Jean de Lavarene, Vidya Hegde
  • Patent number: 10268710
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described provide improvements to load distribution, organization, query processing, and schema propagation in a sharded database.
    Type: Grant
    Filed: September 16, 2016
    Date of Patent: April 23, 2019
    Assignee: Oracle International Corporation
    Inventors: Wei-Ming Hu, Mark Dilman, Stephen Ball, Ghazi Nourdine Benadjaoud, Leonid Novak, Ilya Taranov, Zheng Zeng
  • Publication number: 20190102408
    Abstract: Techniques are described herein for routing queries to particular nodes of a multi-node database system based on the query. A database table is partitioned into a plurality of affinity groups. Each affinity group is assigned a particular node as the master node of the affinity group. A mapping is sent to a query router indicating the master node for each affinity group of the plurality of affinity groups. The query router determines, for a particular query, a target node to which to send the particular query based on the mapping and the particular query.
    Type: Application
    Filed: December 18, 2017
    Publication date: April 4, 2019
    Inventors: Juan R. Loaiza, Wei-Ming Hu, Mark Dilman, Leonid Novak
  • Publication number: 20170103094
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used to route database requests and process queries in a sharded database.
    Type: Application
    Filed: September 16, 2016
    Publication date: April 13, 2017
    Inventors: Wei-Ming Hu, Mark Dilman, Leonid Novak, Ilya Taranov, Zheng Zeng, Jean de Lavarene, Vidya Hegde
  • Publication number: 20170103116
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described provide improvements to load distribution, organization, query processing, and schema propagation in a sharded database.
    Type: Application
    Filed: September 16, 2016
    Publication date: April 13, 2017
    Inventors: Wei-Ming Hu, Mark Dilman, Stephen Ball, Ghazi Nourdine Benadjaoud, Leonid Novak, Ilya Taranov, Zheng Zeng
  • Publication number: 20170103092
    Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used for load distribution, organization, query processing, and schema propagation in a sharded database.
    Type: Application
    Filed: September 16, 2016
    Publication date: April 13, 2017
    Inventors: Wei-Ming Hu, Mark Dilman, Leonid Novak, Stephen Ball, Ghazi Nourdine Benadjaoud
  • Publication number: 20160306854
    Abstract: In accordance with an embodiment, described herein are systems and methods for providing direct access to a sharded database. A shard director provides access by software client applications to database shards. A connection pool (e.g., a Universal Connection Pool, UCP) and database driver (e.g., a Java Database Connectivity, JDBC, component) can be configured to allow a client application to provide a shard key, either during connection checkout or at a later time; recognize shard keys specified by the client application; and enable connection by the client application to a particular shard or chunk. The approach enables efficient re-use of connection resources, and faster access to appropriate shards.
    Type: Application
    Filed: April 20, 2016
    Publication date: October 20, 2016
    Inventors: Vidya Hegde, Jean de Lavarene, Douglas Surber, Mark Dilman, Leonid Novak, Wei Ming Hu, Ashok Shivarudraiah, Tong Zhou, Ilya Taranov