System and method for optimizing large database management systems with multiple optimizers

    公开(公告)号:US11416486B2

    公开(公告)日:2022-08-16

    申请号:US16933174

    申请日:2020-07-20

    Applicant: Ocient Inc.

    Abstract: A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An execution plan generator component of the database management system generates an initial execution plan for the query. The initial execution plan is fed as input to more than one query optimizers. Each optimizer starts with the initial execution plan, generates alternative execution plans, and determines a satisfactory execution plan that incurs the lowest cost. The database management system compares the selected execution plans by the optimizers and selects one with the lowest cost. The multiple query optimizers run in parallel.

    SEGMENTING A PARTITION OF A DATA SET BASED ON A CODING SCHEME

    公开(公告)号:US20220075784A1

    公开(公告)日:2022-03-10

    申请号:US17527430

    申请日:2021-11-16

    Applicant: Ocient Inc.

    Abstract: A method includes receiving, by a first computing entity of a database system, a data set that is organized in rows and columns. The method further includes determining whether to partition the data set based on a parameter associated with the data set. When determining to partition the data set, the method includes determining partitioning parameters for the data set, and partitioning the data set into a plurality of data partitions in accordance with the partitioning parameters. The method further includes determining a first coding scheme for a first data partition and determining a first number of first raw data segments for a first segment group of the first partition based on the coding scheme. The method further includes dividing the first partition to produce the first number of first raw data segments for storage in the database system.

    System and Method for Optimizing Large Database Management Systems with Multiple Optimizers

    公开(公告)号:US20200349162A1

    公开(公告)日:2020-11-05

    申请号:US16933174

    申请日:2020-07-20

    Applicant: Ocient Inc.

    Abstract: A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An execution plan generator component of the database management system generates an initial execution plan for the query. The initial execution plan is fed as input to more than one query optimizers. Each optimizer starts with the initial execution plan, generates alternative execution plans, and determines a satisfactory execution plan that incurs the lowest cost. The database management system compares the selected execution plans by the optimizers and selects one with the lowest cost. The multiple query optimizers run in parallel.

    System and method for optimizing large database management systems with multiple optimizers

    公开(公告)号:US10747765B2

    公开(公告)日:2020-08-18

    申请号:US15991192

    申请日:2018-05-29

    Applicant: OCIENT INC.

    Abstract: A large highly parallel database management system includes thousands of nodes storing huge volume of data. The database management system includes multiple query optimizers for determining low cost execution plans for queries. The database management system is adapted to receive a data query. An execution plan generator component of the database management system generates an initial execution plan for the query. The initial execution plan is fed as input to more than one query optimizers. Each optimizer starts with the initial execution plan, generates alternative execution plans, and determines a satisfactory execution plan that incurs the lowest cost. The database management system compares the selected execution plans by the optimizers and selects one with the lowest cost. The multiple query optimizers run in parallel.

    System and method for optimal routing in a large database management system

    公开(公告)号:US12288040B2

    公开(公告)日:2025-04-29

    申请号:US18765755

    申请日:2024-07-08

    Applicant: Ocient Inc.

    Abstract: A method for execution, by a first intermediate node of a plurality of nodes in a database management system, includes processing a message that includes data that is being sent in accordance with a routing path from a source node to a destination node, is a first size, and indicates a next node of the routing path, wherein the first intermediate node is limited to communication with a subset of nodes of the plurality of nodes, and wherein the subset of nodes includes the next node. The method further includes maintaining a tracking table that indicates a total amount of data sent to each node of the subset of nodes during a first time period. The method further includes resetting the total amount of data sent to each of the subset of nodes to zero based one or more of a command and an initiation of a second time period.

Patent Agency Ranking