Systems and methods for reslicing data in a relational database
    1.
    发明授权
    Systems and methods for reslicing data in a relational database 有权
    在关系数据库中重新分组数据的系统和方法

    公开(公告)号:US08554726B2

    公开(公告)日:2013-10-08

    申请号:US13151203

    申请日:2011-06-01

    IPC分类号: G06F17/30

    摘要: Systems and methods for reslicing data in a representation of a relational database are disclosed. In one embodiment, the database includes a representation including a first slice. The database system creates a plurality of new slice and to create a plurality of write queues. The database system copies units of data in the first slice to the new slices according to a distribution function. The distribution function determines, for each unit of data in the first slice, one of the new slices into which to copy the unit of data. The database system asynchronously writes one or more actions of a set of one or more asynchronous database transactions to the first slice when copying the data in the first slice to the new slices. The database asynchronously enqueues the one or more actions of the set of asynchronous database transactions in the write queues according to the distribution function.

    摘要翻译: 公开了在关系数据库的表示中重新分组数据的系统和方法。 在一个实施例中,数据库包括包括第一切片的表示。 数据库系统创建多个新切片并创建多个写入队列。 数据库系统根据分布函数将第一片中的数据单元复制到新的片段。 分配函数为第一个片段中的每个单位的数据确定复制数据单位的新片段之一。 当将第一切片中的数据复制到新切片时,数据库系统异步地将一组或多个异步数据库事务的一个或多个动作写入第一切片。 数据库根据分布函数异步地排列写入队列中的一组异步数据库事务的一个或多个操作。

    SYSTEMS AND METHODS FOR RESLICING DATA IN A RELATIONAL DATABASE
    2.
    发明申请
    SYSTEMS AND METHODS FOR RESLICING DATA IN A RELATIONAL DATABASE 有权
    用于在关系数据库中回滚数据的系统和方法

    公开(公告)号:US20120310991A1

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

    申请号:US13151203

    申请日:2011-06-01

    IPC分类号: G06F17/30

    摘要: Systems and methods for reslicing data in a representation of a relational database are disclosed. In one embodiment, the database includes a representation including a first slice. The database system creates a plurality of new slice and to create a plurality of write queues. The database system copies units of data in the first slice to the new slices according to a distribution function. The distribution function determines, for each unit of data in the first slice, one of the new slices into which to copy the unit of data. The database system asynchronously writes one or more actions of a set of one or more asynchronous database transactions to the first slice when copying the data in the first slice to the new slices. The database asynchronously enqueues the one or more actions of the set of asynchronous database transactions in the write queues according to the distribution function.

    摘要翻译: 公开了在关系数据库的表示中重新分组数据的系统和方法。 在一个实施例中,数据库包括包括第一切片的表示。 数据库系统创建多个新切片并创建多个写入队列。 数据库系统根据分布函数将第一片中的数据单元复制到新的片段。 分配函数为第一个片段中的每个单位的数据确定复制数据单位的新片段之一。 当将第一切片中的数据复制到新切片时,数据库系统异步地将一组或多个异步数据库事务的一个或多个动作写入第一切片。 数据库根据分布函数异步地排列写入队列中的一组异步数据库事务的一个或多个操作。

    Systems and methods for redistributing data in a relational database
    3.
    发明授权
    Systems and methods for redistributing data in a relational database 有权
    在关系数据库中重新分发数据的系统和方法

    公开(公告)号:US08543538B2

    公开(公告)日:2013-09-24

    申请号:US13151189

    申请日:2011-06-01

    IPC分类号: G06F17/30

    摘要: Systems and methods for redistributing data in a relational database are disclosed. In one embodiment, the database includes a plurality of rows of data distributed across a plurality of slices of a table in the database. The database system is configured to distribute the rows of data across the slices according to a first function based on one or more columns of the database. The database system monitors at least one database statistic indicative of variation in a distribution of the rows of data across the slices and detects a redistribution condition based on the at least one monitored database statistic. The database system is further configured to respond to the detected redistribution condition by redistributing the rows of data across the slices according to a second function based on a different number of columns than the first function.

    摘要翻译: 公布了在关系数据库中重新分配数据的系统和方法。 在一个实施例中,数据库包括跨数据库中的表的多个片段分布的多个数据行。 数据库系统被配置为根据基于数据库的一个或多个列的第一函数在片之间分布数据行。 数据库系统监视指示横跨片段的数据行分布的变化的至少一个数据库统计量,并且基于至少一个监视的数据库统计信息来检测再分配条件。 数据库系统还被配置为通过基于与第一功能不同数量的列根据第二功能重新分布跨片段的数据行来响应检测到的再分配条件。

    SYSTEMS AND METHODS FOR REDISTRIBUTING DATA IN A RELATIONAL DATABASE
    4.
    发明申请
    SYSTEMS AND METHODS FOR REDISTRIBUTING DATA IN A RELATIONAL DATABASE 有权
    用于在关系数据库中重新分配数据的系统和方法

    公开(公告)号:US20120310986A1

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

    申请号:US13151189

    申请日:2011-06-01

    IPC分类号: G06F17/30

    摘要: Systems and methods for redistributing data in a relational database are disclosed. In one embodiment, the database includes a plurality of rows of data distributed across a plurality of slices of a table in the database. The database system is configured to distribute the rows of data across the slices according to a first function based on one or more columns of the database. The database system monitors at least one database statistic indicative of variation in a distribution of the rows of data across the slices and detects a redistribution condition based on the at least one monitored database statistic. The database system is further configured to respond to the detected redistribution condition by redistributing the rows of data across the slices according to a second function based on a different number of columns than the first function.

    摘要翻译: 公布了在关系数据库中重新分配数据的系统和方法。 在一个实施例中,数据库包括跨数据库中的表的多个片段分布的多个数据行。 数据库系统被配置为根据基于数据库的一个或多个列的第一函数在片之间分布数据行。 数据库系统监视指示横跨片段的数据行分布的变化的至少一个数据库统计量,并且基于至少一个监视的数据库统计信息来检测再分配条件。 数据库系统还被配置为通过基于与第一功能不同数量的列根据第二功能重新分布跨片段的数据行来响应检测到的再分配条件。

    Systems and methods for replication replay in a relational database
    5.
    发明授权
    Systems and methods for replication replay in a relational database 有权
    用于复制的系统和方法在关系数据库中重播

    公开(公告)号:US09348883B2

    公开(公告)日:2016-05-24

    申请号:US13151040

    申请日:2011-06-01

    申请人: Jim Gale Scott Smith

    发明人: Jim Gale Scott Smith

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30578 G06F17/30289

    摘要: Systems and methods for replication replay in a relational database are disclosed. In one embodiment, a relational database includes a master database and a slave database, and events performed on the master database are stored in a log. A portion of the log is provided to a slave replay system associated with the slave database, and the slave replay system identifies a first table row associated with a first event of the portion of the log and a second table row associated with a second event in the portion of the log. The slave replay system replays the first and second events on the slave database in parallel if the first and second rows are different rows with unique sets of values, and otherwise replays the first and second events serially.

    摘要翻译: 公开了在关系数据库中复制重放的系统和方法。 在一个实施例中,关系数据库包括主数据库和从属数据库,并且在主数据库上执行的事件存储在日志中。 日志的一部分被提供给与从属数据库相关联的从属重放系统,并且从属重放系统识别与日志的该部分的第一事件相关联的第一表行和与第二事件相关联的第二表行 日志的一部分。 如果第一行和第二行是具有唯一的值集合的不同行,则从属重播系统并行重放从属数据库上的第一和第二事件,否则连续重播第一和第二事件。

    SYSTEMS AND METHODS FOR REPLICATION REPLAY IN A RELATIONAL DATABASE
    6.
    发明申请
    SYSTEMS AND METHODS FOR REPLICATION REPLAY IN A RELATIONAL DATABASE 有权
    在关系数据库中复制的系统和方法

    公开(公告)号:US20120310985A1

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

    申请号:US13151040

    申请日:2011-06-01

    申请人: Jim Gale Scott Smith

    发明人: Jim Gale Scott Smith

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30578 G06F17/30289

    摘要: Systems and methods for replication replay in a relational database are disclosed. In one embodiment, a relational database includes a master database and a slave database, and events performed on the master database are stored in a log. A portion of the log is provided to a slave replay system associated with the slave database, and the slave replay system identifies a first table row associated with a first event of the portion of the log and a second table row associated with a second event in the portion of the log. The slave replay system replays the first and second events on the slave database in parallel if the first and second rows are different rows with unique sets of values, and otherwise replays the first and second events serially.

    摘要翻译: 公开了在关系数据库中复制重放的系统和方法。 在一个实施例中,关系数据库包括主数据库和从属数据库,并且在主数据库上执行的事件存储在日志中。 日志的一部分被提供给与从属数据库相关联的从属重放系统,并且从属重放系统识别与日志的该部分的第一事件相关联的第一表行和与第二事件相关联的第二表行 日志的一部分。 如果第一行和第二行是具有唯一的值集合的不同行,则从属重播系统并行重放从属数据库上的第一和第二事件,否则连续重播第一和第二事件。

    Bait lock socket
    7.
    发明授权

    公开(公告)号:US11793181B1

    公开(公告)日:2023-10-24

    申请号:US17209390

    申请日:2021-03-23

    IPC分类号: A01K85/18 A01K85/02

    CPC分类号: A01K85/18 A01K85/02

    摘要: The bait lock structure is a towed device. The bait lock socket is adapted for use with a bait fish. The bait lock socket is adapted for use with a game fish. The bait lock socket displays the bait fish in order to attract and capture the game fish. The bait lock socket incorporates a lure structure, a locking post, and a capture structure. The locking post secures the capture structure to the lure structure. The bait fish attaches to the lure structure. The capture structure captures the game fish.

    TOOL BOX SHIELD ASSEMBLY
    8.
    发明申请

    公开(公告)号:US20200246963A1

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

    申请号:US16267501

    申请日:2019-02-05

    申请人: Scott Smith

    发明人: Scott Smith

    IPC分类号: B25H3/02

    摘要: A tool box shield assembly for protecting contents of a tool box from debris and contaminants includes a tool box that has a front side, a top side and a bottom side, and the front side has a plurality of drawers therein. A shield unit is positioned on the tool box and the shield unit is urgeable into a deployed position has the shield unit covering the front side of the tool box. In this way the shield unit protects the drawers in the tool box from dirt and debris. The shield unit is biased into a stored position having the front side of the tool box being exposed.