System, method, and data structure for automatically generating database queries which are data model independent and cardinality independent
    5.
    发明授权
    System, method, and data structure for automatically generating database queries which are data model independent and cardinality independent 有权
    用于自动生成数据模型独立和基数独立的数据库查询的系统,方法和数据结构

    公开(公告)号:US08825633B2

    公开(公告)日:2014-09-02

    申请号:US13471548

    申请日:2012-05-15

    IPC分类号: G06F7/00 G06F17/30

    摘要: Systems and methods are provided for performing a database query. After receiving an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, a query generation system creates and executes a database query that comprises one or more Uqueries, wherein each Uquery comprises a Mx segment subquery and a U0 segment subquery. The Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. The query generation system can generate a virtual results table by aggregating Uquery results from one Uquery with Uquery results from another Uquery.

    摘要翻译: 提供了系统和方法来执行数据库查询。 在接收到数据项组件的标识和数据项组件之间的关联之后,其中数据项组件包括度量和类别,查询生成系统创建并执行包括一个或多个Uqueries的数据库查询,其中每个Uquery包括 Mx段子查询和一个U0段子查询。 Mx段子查询与包含度量的表相关联,该表包含计算度量的列或相关表,U0段子查询与包含该类别的表相关联,该表包含 计算的类别,依赖度量表或从属过滤器表。 查询生成系统可以通过从一个Uquery的Uquery结果聚合来自另一个Uquery的Uquery结果来生成虚拟结果表。

    System, Method, and Data Structure for Automatically Generating Database Queries which are Data Model Independent and Cardinality Independent
    6.
    发明申请
    System, Method, and Data Structure for Automatically Generating Database Queries which are Data Model Independent and Cardinality Independent 有权
    自动生成数据查询的系统,方法和数据结构,这些数据查询是独立于数据模型和基数独立的

    公开(公告)号:US20130311442A1

    公开(公告)日:2013-11-21

    申请号:US13471548

    申请日:2012-05-15

    IPC分类号: G06F17/30

    摘要: Systems and methods are provided for performing a database query. After receiving an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, a query generation system creates and executes a database query that comprises one or more Uqueries, wherein each Uquery comprises a Mx segment subquery and a U0 segment subquery. The Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. The query generation system can generate a virtual results table by aggregating Uquery results from one Uquery with Uquery results from another Uquery.

    摘要翻译: 提供了系统和方法来执行数据库查询。 在接收到数据项组件的标识和数据项组件之间的关联之后,其中数据项组件包括度量和类别,查询生成系统创建并执行包括一个或多个Uqueries的数据库查询,其中每个Uquery包括 Mx段子查询和一个U0段子查询。 Mx段子查询与包含度量的表相关联,该表包含计算度量的列或相关表,U0段子查询与包含该类别的表相关联,该表包含列 计算的类别,依赖度量表或从属过滤器表。 查询生成系统可以通过从一个Uquery的Uquery结果聚合来自另一个Uquery的Uquery结果来生成虚拟结果表。

    Drive mechanism for crawler tracks
    7.
    发明授权
    Drive mechanism for crawler tracks 失效
    履带履带驱动机构

    公开(公告)号:US5456527A

    公开(公告)日:1995-10-10

    申请号:US168346

    申请日:1993-12-17

    IPC分类号: B62D55/12 B62D55/135

    CPC分类号: B62D55/135

    摘要: A tumbler drive mechanism having a rotatable tumbler body mounted on a shaft and a plurality of tumbler lugs removably mounted on the tumbler body. The shaft has a longitudinal axis about which it and the tumbler rotate. The tumbler body includes a center drum and a plurality of circumferentially spaced apart radially projecting drive flanges. Each one of the plurality of tumbler lugs is mounted between and in engagement with two adjacent ones of the plurality of drive flanges. Each of the tumbler lugs engages the shoe lugs of a crawler track as the tumbler body rotates to drive the crawler track. The tumbler lug is mounted on the tumbler body at a selectively variable radial distance from the axis of the tumbler body. The radial distance at which the tumbler lugs are mounted on the tumbler body is accomplished by providing one or more shims positioned between the lug and the tumbler body.

    摘要翻译: 一种滚筒驱动机构,其具有安装在轴上的可旋转转动体,以及多个可移除地安装在制动器主体上的制动栓凸耳。 轴具有纵向轴线,转轴和转鼓绕其旋转。 制动器主体包括中心鼓和多个周向间隔开的径向突出的驱动凸缘。 多个滚筒凸耳中的每一个安装在多个驱动凸缘中的两个相邻驱动凸缘之间并与其接合。 当制动器主体旋转以驱动履带时,每个制动栓凸耳与履带的鞋舌接合。 转鼓凸耳以与制动器主体的轴线有选择性地可变的径向距离安装在制动器本体上。 制动栓凸耳安装在制动栓体上的径向距离是通过提供一个或多个位于凸耳和制动栓体之间的垫片来实现的。

    Auxiliary assembly for reducing unwanted movement of a hoist rope
    10.
    发明授权
    Auxiliary assembly for reducing unwanted movement of a hoist rope 有权
    辅助组件,用于减少起重绳索的不必要的运动

    公开(公告)号:US07024806B2

    公开(公告)日:2006-04-11

    申请号:US10755808

    申请日:2004-01-12

    IPC分类号: E02F5/02 E02F9/14

    CPC分类号: B66C23/66 E02F3/304 E02F3/36

    摘要: An auxiliary hoist sheave assembly comprising a sheave support frame, a mechanism for mounting the sheave support frame to a boom, a lower sheave shaft mounted on the sheave support frame, and a grooved hoist sheave, rotatably supported by and slidable along the lower sheave shaft, the hoist sheave being in contact with a hoist rope, and the hoist sheave fleeting side to side along the lower sheave shaft as the hoist rope follows the hoist drum.

    摘要翻译: 一种辅助起重滑轮组件,包括滑轮支撑框架,用于将滑轮支撑框架安装到起重臂的机构,安装在滑轮支撑框架上的下滑轮轴和带槽的起重滑轮,其可旋转地支撑并沿着下滑轮轴可滑动 提升绳轮与起重绳索接触,并且当起重绳跟随提升滚筒时,起重滑轮沿着下滑轮轴线一侧向侧滑。