Method and mechanism for processing queries for XML documents using an index
    1.
    发明授权
    Method and mechanism for processing queries for XML documents using an index 有权
    使用索引处理XML文档查询的方法和机制

    公开(公告)号:US07181680B2

    公开(公告)日:2007-02-20

    申请号:US10427276

    申请日:2003-04-30

    IPC分类号: G06F17/24

    摘要: A method and apparatus for processing a query is provided. A query for a set of Matching XML documents is received. A client may transmit the query for a set of XML documents to the database server. The database server transmits a request for the set of XML documents to a persistent storage. The persistent storage uses an index, at least in part, to obtain the set of XML documents sought by the query. The index stores a first set of entries comprising information about the location of elements, a second set of entries comprising information about element attributes, and a third set of entries comprising information about element values. In responding to a particular query, additional XML documents that are not indexed by the index may also be checked to determine if they correspond to the set of search criteria.

    摘要翻译: 提供了一种用于处理查询的方法和装置。 接收到一组匹配XML文档的查询。 客户端可以将一组XML文档的查询传送到数据库服务器。 数据库服务器将一组XML文档的请求发送到持久存储。 永久存储器至少部分地使用索引来获取查询所寻求的一组XML文档。 索引存储包括关于元素的位置的信息的第一组条目,包括关于元素属性的信息的第二组条目以及包含关于元素值的信息的第三组条目。 在响应特定查询时,还可以检查未被索引索引的附加XML文档,以确定它们是否与搜索条件集合相对应。

    TEXT INDEXING FOR UPDATEABLE TOKENIZED TEXT

    公开(公告)号:US20120150864A1

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

    申请号:US12967419

    申请日:2010-12-14

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30613 G06F17/30017

    摘要: Systems, methods, and other embodiments associated with text indexing for updateable tokenized text are described. One example method includes receiving revised tokenized text intended to replace existing tokenized text in an indexed document. Token location information corresponding to the revised tokenized text is stored in an allocated free space portion of a text index posting.

    摘要翻译: 描述了与用于可更新标记化文本的文本索引相关联的系统,方法和其他实施例。 一个示例性方法包括接收旨在替换索引文档中的现有标记化文本的经修改的标记化文本。 对应于经修改的标记化文本的令牌位置信息被存储在文本索引发布的分配的可用空间部分中。

    Techniques for extending user-defined indexes with auxiliary properties
    3.
    发明授权
    Techniques for extending user-defined indexes with auxiliary properties 有权
    用辅助属性扩展用户定义的索引的技术

    公开(公告)号:US07996387B2

    公开(公告)日:2011-08-09

    申请号:US12027897

    申请日:2008-02-07

    IPC分类号: G06F17/30

    摘要: In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The one or more functions are operable to generate index entries of the user-defined index for the one or more auxiliary properties. The one or more auxiliary properties are different than, and in addition to, a primary property of the user-defined index that provides for evaluating a query operator. The database server receives a first statement that defines the user-defined index, where the first statement includes one or more parameters that define the one or more auxiliary properties. The database server invokes the one or more functions in response to the first statement, where the one or more functions when invoked generate and store the index entries of the user-defined index according to the one or more parameters that define the one or more auxiliary properties.

    摘要翻译: 在一个实施例中,数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 一个或多个功能可操作以生成用于一个或多个辅助属性的用户定义索引的索引条目。 一个或多个辅助属性不同于并且除了用于定义查询运算符的用户定义索引的主要属性之外。 数据库服务器接收定义用户定义的索引的第一个语句,其中第一个语句包含一个或多个定义一个或多个辅助属性的参数。 数据库服务器响应于第一语句来调用一个或多个函数,其中调用时一个或多个函数生成并根据定义一个或多个辅助的一个或多个参数来存储用户定义的索引的索引条目 属性。

    Bicycle with a pivotable support unit usable as a rear rack and a stand
    4.
    发明申请
    Bicycle with a pivotable support unit usable as a rear rack and a stand 审中-公开
    具有可枢转支撑单元的自行车,可用作后架和支架

    公开(公告)号:US20070235979A1

    公开(公告)日:2007-10-11

    申请号:US11400370

    申请日:2006-04-10

    申请人: Wesley Lin

    发明人: Wesley Lin

    IPC分类号: B62H7/00

    CPC分类号: B62H1/04 B62J7/04

    摘要: A bicycle includes a rear wheel rotatably mounted on a bicycle frame for rolling on a ground surface, a support unit pivotably mounted on the bicycle frame, and a locking unit disposed to releasably retain the support unit in a traveling position. The support unit includes a pivoted end, a shank member which extends from the pivoted end, and an elongated rail member connected to the shank member. The rail member has a supporting surface such that in a suspending position, the supporting surface is rested on the ground surface to suspend the rear wheel from the ground surface, and that when the support unit is turned to the traveling position, the rail member is turned to have the supporting surface face upwardly to serve as a rear rack of the bicycle.

    摘要翻译: 自行车包括可旋转地安装在自行车车架上用于在地面上滚动的后轮,可枢转地安装在自行车车架上的支撑单元和设置成将支撑单元可释放地保持在行驶位置的锁定单元。 支撑单元包括枢转端,从枢转端延伸的柄构件和连接到柄构件的细长轨道构件。 轨道构件具有支撑表面,使得在悬挂位置中,支撑表面搁置在地面上以使后轮从地面悬挂,并且当支撑单元转向行进位置时,轨道构件是 转动使支撑面朝上,作为自行车的后架。

    Heavy-pedaling bicycle
    5.
    发明申请
    Heavy-pedaling bicycle 审中-公开
    重踏踏车

    公开(公告)号:US20070235973A1

    公开(公告)日:2007-10-11

    申请号:US11400369

    申请日:2006-04-10

    申请人: Wesley Lin

    发明人: Wesley Lin

    IPC分类号: B62M1/10

    摘要: A heavy-pedaling bicycle includes a pedaling unit which is rotated to deliver a driving force to drive a rear wheel to roll on a ground surface, and a dragging mechanism which is disposed on at least one of stationary and rotary members to generate a dragging force which counteracts the driving force during the forward pedaling of the pedaling unit, and which is self-adjustably maintained to be smaller than the driving force so as to turn the forward pedaling movement into an evenly decelerated movement. The dragging mechanism may include one of a plurality of wind blades, magnetically attractive members, and spring-biased friction members to generate a respective one of a resisting force, a magnetically attractive force, and a frictional force to serve as the dragging force.

    摘要翻译: 重踏脚踏车包括蹬踏单元,其被旋转以传递驱动力以驱动后轮在地面上滚动;以及拖曳机构,其设置在静止和旋转构件中的至少一个上以产生拖曳力 其在踩踏单元的向前踏板期间抵消驱动力,并且其被自动调节地保持为小于驱动力,以将前踏板运动转换成均匀的减速运动。 牵引机构可以包括多个风叶片,磁性吸引构件中的一个以及弹簧偏置的摩擦构件,以产生用作拖拉力的抵抗力,磁力吸引力和摩擦力中的相应的一个。

    Indexing mechanism for efficient node-aware full-text search over XML
    7.
    发明授权
    Indexing mechanism for efficient node-aware full-text search over XML 有权
    基于XML的高效节点感知全文检索的索引机制

    公开(公告)号:US08219563B2

    公开(公告)日:2012-07-10

    申请号:US12346327

    申请日:2008-12-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30911

    摘要: Techniques are provided for searching within a collection of XML documents. A relational table in an XML index stores an entry for each node of a set of nodes in the collection. Each entry of the relational table stores an order key and a path identifier along with the atomized value of the node. An index on the atomized value provides a mechanism to perform a node-aware full-text search. Instead of storing the atomized value in the table, a virtual column may be created to represent, for each node, the atomized value of the node. Alternately, each entry of the relational table stores an order key and a path identifier along with, for simple nodes, the atomized value, and for complex nodes, a null value. For a complex node with a descendant text node, a separate entry is stored for the descendant text node in the relational table.

    摘要翻译: 提供了在XML文档集合内进行搜索的技术。 XML索引中的关系表存储集合中一组节点的每个节点的条目。 关系表的每个条目存储订单密钥和路径标识符以及节点的雾化值。 雾化值上的索引提供了执行节点感知全文搜索的机制。 不用在表中存储雾化值,而是可以创建一个虚拟列,以便为每个节点表示节点的雾化值。 或者,关系表的每个条目存储订单密钥和路径标识符,对于简单节点,存在雾化值,对于复杂节点存储空值。 对于具有后代文本节点的复杂节点,为关系表中的后代文本节点存储单独的条目。

    Techniques for Optimizing SQL Statements Using User-Defined Indexes with Auxiliary Properties
    8.
    发明申请
    Techniques for Optimizing SQL Statements Using User-Defined Indexes with Auxiliary Properties 有权
    使用具有辅助属性的用户定义索引优化SQL语句的技术

    公开(公告)号:US20090030874A1

    公开(公告)日:2009-01-29

    申请号:US12027918

    申请日:2008-02-07

    IPC分类号: G06F7/06

    摘要: In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The database server receives a query that specifies one or more parameters. A query optimizer generates a plurality of execution plans for evaluating the query. The query optimizer estimates a plurality of total costs respectively associated with the plurality of execution plans, where estimating a particular total cost associated with a particular execution plan comprises: invoking the one or more functions with one or more function arguments based on the one or more parameters; receiving one or more index costs that are associated with using the one or more auxiliary properties of the user-defined index to evaluate the query; and determining the particular total cost based on the one or more index costs. From the plurality of execution plans, the query optimizer selects an optimal execution plan that is associated with an optimal total cost of the plurality of total costs.

    摘要翻译: 在一个实施例中,数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 数据库服务器接收一个指定一个或多个参数的查询。 查询优化器生成用于评估查询的多个执行计划。 查询优化器估计与多个执行计划分别相关联的多个总成本,其中估计与特定执行计划相关联的特定总成本包括:基于一个或多个参数调用具有一个或多个函数参数的一个或多个函数 参数; 接收与使用所述用户定义的索引的所述一个或多个辅助属性相关联的一个或多个索引成本来评估所述查询; 以及基于所述一个或多个索引成本确定所述特定总成本。 从多个执行计划中,查询优化器选择与多个总成本的最佳总成本相关联的最优执行计划。