SYSTEM AND METHOD FOR OPTIMIZING LARGE DATABASE MANAGEMENT SYSTEMS WITH MULTIPLE OPTIMIZERS

    公开(公告)号:US20190034485A1

    公开(公告)日:2019-01-31

    申请号: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 OPTIMIZING LARGE DATABASE MANAGEMENT SYSTEMS USING BLOOM FILTER

    公开(公告)号:US20180349364A1

    公开(公告)日:2018-12-06

    申请号:US15991082

    申请日: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 a query optimizer for optimizing data queries. The optimizer estimates the column cardinality of a set of rows based on estimated column cardinalities of disjoint subsets of the set of rows. For a particular column, the actual column cardinality of the set of rows is the sum of the actual column cardinalities of the two subsets of rows. The optimizer creates two respective Bloom filters from the two subsets, and then combines them to create a combined Bloom filter using logical OR operations. The actual column cardinality of the set of rows is estimated using a computation from the combined Bloom filter.

    DATABASE MANAGEMENT SYSTEM PROVIDING LOCAL BALANCING WITHIN INDIVIDUAL CLUSTER NODE

    公开(公告)号:US20180285167A1

    公开(公告)日:2018-10-04

    申请号:US15943447

    申请日:2018-04-02

    Applicant: OCIENT, INC

    Abstract: A highly parallel database system includes multiple clusters of nodes. Each cluster includes multiple nodes. Each node includes a set of first tier threads and a set of second tier threads. Each second tier thread determines its own current load, and communicates the load status to a corresponding first tier thread. Each first tier thread checks the load status of each corresponding second tier thread when it allocates tasks between a number of corresponding second tier threads to achieve load balance between the second tier threads.

    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.

    System and method for improving load balancing in large database management system

    公开(公告)号:US12182531B2

    公开(公告)日:2024-12-31

    申请号:US17514636

    申请日:2021-10-29

    Applicant: Ocient Inc.

    Abstract: A method for execution, by a first intermediate node of a plurality of nodes in a database management system, includes receiving a message, where the first intermediate node is limited to communication with a subset of nodes of the plurality of nodes, where the message: includes data that is being sent in accordance with a routing path, is a first size, and indicates a next node of the routing path, and where the subset of nodes includes the next node. The method continues by generating a revised message, wherein the revised message includes the data and has a second size. The method continues by determining whether there is at least one additional intermediate node after the next node in the routing path. When yes, determining an optimal route for forwarding the revised message via a node of the subset of nodes, and sending the revised message to the node.

    LOGICAL PARTITIONING OF MEMORY WITHIN A COMPUTING DEVICE

    公开(公告)号:US20240330265A1

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

    申请号:US18741519

    申请日:2024-06-12

    Applicant: Ocient Inc.

    CPC classification number: G06F16/2282 G06F9/4881 G06F16/24532 G06F16/285

    Abstract: A method includes a host computing device receiving a segment group of data. The method further includes the host computing device evaluating availability status of other computing devices in the storage cluster of computing devices. When one of the other computing devices is unavailable, the method further includes the host computing device dividing the segment group of data into a plurality of lines of data blocks. For a line of the data blocks, the method further includes the host computing device generating at least one parity block. The method further includes the host computing device sending a first data segment that includes first positioned data blocks to a first available computing device. The method further includes the host computing device sending a second data segment that includes second positioned data blocks to a second available computing device. The method further includes the host computing device storing a parity segment.

Patent Agency Ranking