Method and system for processing structured documents in a native database
    1.
    发明授权
    Method and system for processing structured documents in a native database 失效
    在本地数据库中处理结构化文档的方法和系统

    公开(公告)号:US07171430B2

    公开(公告)日:2007-01-30

    申请号:US10652662

    申请日:2003-08-28

    IPC分类号: G06F17/30

    摘要: An improved method and system for processing a structured document stored in a database is disclosed. The method includes identifying strings that are processed by the database, assigning an identifier to each of the strings, storing each of the strings and the assigned identifier in a table in the database, where the table is a global database table, and utilizing the table to replace the strings with their assigned identifiers throughout the database, where the identifiers are used during document processing.

    摘要翻译: 公开了一种用于处理存储在数据库中的结构化文档的改进方法和系统。 该方法包括识别由数据库处理的字符串,向每个字符串分配标识符,将每个字符串和分配的标识符存储在数据库中的表中,其中该表是全局数据库表,并且使用该表 在整个数据库中替换其分配的标识符的字符串,其中在文档处理期间使用标识符。

    Method and system for utilizing a cache for path-level access control to structured documents stored in a database
    2.
    发明授权
    Method and system for utilizing a cache for path-level access control to structured documents stored in a database 失效
    用于利用缓存进行数据库中存储的结构化文档的路径级访问控制的方法和系统

    公开(公告)号:US08250093B2

    公开(公告)日:2012-08-21

    申请号:US10648499

    申请日:2003-08-25

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30595

    摘要: An improved method and system for performing path-level access control evaluation for a structured document in a collection, where the structured document includes a plurality of nodes and each of the nodes is described by a path, is disclosed. The method comprises providing a cache for temporarily storing a cache entry for a path associated with a node of the plurality of nodes, receiving a query that includes a request to access the node, checking the cache entry for the path associated with the node, and determining whether to grant access to the node based on the cache entry.

    摘要翻译: 公开了一种用于对集合中的结构化文档执行路径级访问控制评估的改进的方法和系统,其中结构化文档包括多个节点,并且每个节点由路径描述。 该方法包括:提供用于临时存储与多个节点的节点相关联的路径的高速缓存条目的高速缓存,接收包括访问该节点的请求的查询,检查与节点相关联的路径的高速缓存条目,以及 确定是否基于所述高速缓存条目授予对所述节点的访问。

    Processing structured documents stored in a database
    3.
    发明授权
    Processing structured documents stored in a database 失效
    处理存储在数据库中的结构化文档

    公开(公告)号:US08037090B2

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

    申请号:US12398716

    申请日:2009-03-05

    IPC分类号: G06F17/30

    摘要: A method, computer readable medium, and system for processing a structured document are disclosed. The method, computer readable medium, and system include identifying a plurality of strings processed by a database, assigning an identifier to each of the plurality of strings, storing each of the plurality of strings and its assigned identifier in a table in the database, and utilizing the table during document processing.

    摘要翻译: 公开了一种用于处理结构化文档的方法,计算机可读介质和系统。 所述方法,计算机可读介质和系统包括识别由数据库处理的多个字符串,将标识符分配给多个字符串中的每一个,将多个字符串中的每个字符串及其分配的标识符存储在数据库中的表中,以及 在文件处理期间利用表格。

    System and method for performing database operations on a continuous stream of tuples

    公开(公告)号:US06604102B2

    公开(公告)日:2003-08-05

    申请号:US09997823

    申请日:2001-11-29

    IPC分类号: G06F1730

    摘要: The SQL compiler and SQL executor in a database management system are extended to process queries requiring streaming mode processing of data stored in a table. A scan operator performs table access functions during execution of the streaming mode query. The scan operator first performs an initial scan to access rows in a specified database table, and then performs a delta scan to access new rows added to the table, as well as rows modified by other queries. The scan operator continues to process new data added to the table until the initiating user or application closes the associated cursor. A set of data structures are provided to keep track of active scan operators, including a session control block that includes fields for keeping track of whether the scan operator is performing an initial scan or a delta scan. The session control block also includes, for streaming mode scan operators, a delta scan list of new and modified rows to be processed in the delta scan. When a transaction terminates, any streaming mode scan operators whose operation was suspended because of rows locked by the transaction are automatically rescheduled for execution.

    System and method for performing database operations on a continuous stream of tuples
    7.
    发明授权
    System and method for performing database operations on a continuous stream of tuples 有权
    在连续的元组流中执行数据库操作的系统和方法

    公开(公告)号:US06339772B1

    公开(公告)日:2002-01-15

    申请号:US09347997

    申请日:1999-07-06

    IPC分类号: G06F1730

    摘要: The SQL compiler and SQL executor in a database management system are extended to process queries requiring streaming mode processing of data stored in a table. A scan operator performs table access functions during execution of the streaming mode query. The scan operator first performs an initial scan to access rows in a specified database table, and then performs a delta scan to access new rows added to the table, as well as rows modified by other queries. The scan operator continues to process new data added to the table until the initiating user or application closes the associated cursor. A set of data structures are provided to keep track of active scan operators, including a session control block that includes fields for keeping track of whether the scan operator is performing an initial scan or a delta scan. The session control block also includes, for streaming mode scan operators, a delta scan list of new and modified rows to be processed in the delta scan. When a transaction terminates, any streaming mode scan operators whose operation was suspended because of rows locked by the transaction are automatically rescheduled for execution.

    摘要翻译: 数据库管理系统中的SQL编译器和SQL执行器被扩展到处理需要对存储在表中的数据进行流模式处理的查询。 扫描运算符在执行流模式查询期间执行表访问功能。 扫描操作员首先执行初始扫描以访问指定数据库表中的行,然后执行增量扫描以访问添加到表中的新行以及其他查询修改的行。 扫描运算符继续处理添加到表中的新数据,直到启动用户或应用程序关闭相关联的光标。 提供了一组数据结构来跟踪主动扫描运算符,包括会话控制块,其包括用于跟踪扫描运算符是执行初始扫描还是增量扫描的字段。 对于流模式扫描运算符,会话控制块还包括在delta扫描中要处理的新行和修改行的增量扫描列表。 当事务终止时,由于事务锁定行被暂停运行的任何流模式扫描运算符都将自动重新计划执行。

    Method and system for querying structured documents stored in their native format in a database
    9.
    发明授权
    Method and system for querying structured documents stored in their native format in a database 有权
    用于在数据库中查询以其本机格式存储的结构化文档的方法和系统

    公开(公告)号:US07792866B2

    公开(公告)日:2010-09-07

    申请号:US10648752

    申请日:2003-08-25

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30595

    摘要: A method and system for querying a structured document stored in its native format in a database, where the structured document includes a plurality of nodes that form a hierarchical node tree, is disclosed. The method includes providing at least one child pointer in each of the plurality of nodes, where the at least one child pointer points to a corresponding child node of the plurality of nodes, and storing a hint in each of the at least one child pointers. The hint is then utilized to navigate the hierarchical node tree during query evaluation.

    摘要翻译: 公开了一种在数据库中查询以其本机格式存储的结构化文档的方法和系统,其中结构化文档包括形成分层结构树的多个节点。 所述方法包括在所述多个节点中的每一个中提供至少一个子指针,其中所述至少一个子指针指向所述多个节点中的相应子节点,并且在所述至少一个子指针的每一个中存储提示。 然后在查询评估期间利用提示来导航分层节点树。

    Database management system and method for dequeuing rows published to a database table
    10.
    发明授权
    Database management system and method for dequeuing rows published to a database table 失效
    数据库管理系统和方法,用于将列发布到数据库表的行

    公开(公告)号:US06453313B1

    公开(公告)日:2002-09-17

    申请号:US09347996

    申请日:1999-07-06

    IPC分类号: G06F1730

    摘要: The SQL compiler and SQL executor in a database management system are extended to execute statements for dequeuing rows from a database table and statements that both updating tuples and return those tuples to a calling application. During execution of a select statement that includes an embedded update or delete operation, a table access operator accesses a defined range of rows in a database table. The table access operator receives from a calling application a request for rows dequeued from the database table. The table access operator responds to the requests for rows by returning to the calling application qualifying rows, if any, from the database table and also by performing the embedded delete or update operation. The SQL executor returns control to the calling application only after all rows deleted or updated by the table access operator have been sent to the calling application.

    摘要翻译: 数据库管理系统中的SQL编译器和SQL执行程序被扩展为执行语句,用于从数据库表中将行排队,并且更新元组并将这些元组返回给调用应用程序的语句。 在执行包含嵌入式更新或删除操作的select语句期间,表访问运算符访问数据库表中定义的行范围。 表访问运算符从调用应用程序接收对从数据库表排队的行的请求。 表访问操作符通过返回到调用应用程序来响应行的请求,从数据库表中限定行(如果有的话),还通过执行嵌入式删除或更新操作。 只有在由表访问运算符删除或更新的所有行已发送到调用应用程序之后,SQL执行程序将控制权返回给调用应用程序。