Handling uniqueness constraints in a database system with versioned data
    2.
    发明申请
    Handling uniqueness constraints in a database system with versioned data 有权
    在具有版本化数据的数据库系统中处理唯一性约束

    公开(公告)号:US20070043783A1

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

    申请号:US11295310

    申请日:2005-12-05

    IPC分类号: G06F17/30

    摘要: A version history of each of a plurality of resources is stored in a table. The version history for each resource comprises a set of one or more values for the resource, wherein each value in the version history of a resource indicates the value that the resource had in a particular version of the resource. In response to a request to perform an operation that causes a given resource that is subject to a uniqueness constraint to have a particular value, it is determined whether the uniqueness constraint is violated based on whether any version of any resource other than the given resource has the particular value. The uniqueness constraint is determined to be violated if any version of any resource other than the given resource has the particular value. The uniqueness constraint is not violated by existence of a version of the given resource that has the particular value.

    摘要翻译: 多个资源中的每一个的版本历史被存储在表中。 每个资源的版本历史包括用于资源的一个或多个值的集合,其中资源的版本历史中的每个值指示资源在资源的特定版本中具有的值。 响应于执行导致受到唯一性约束的给定资源具有特定值的操作的请求,基于是否具有给定资源的任何资源的任何版本的任何版本是否被确定是否违反唯一性约束 具体的价值。 如果给定资源以外的任何资源的任何版本具有特定值,则唯一性约束被确定为违反。 唯一性约束不被存在具有特定值的给定资源的版本所抵触。

    Mechanism for uniform access control in a database system
    3.
    发明授权
    Mechanism for uniform access control in a database system 有权
    数据库系统中统一访问控制的机制

    公开(公告)号:US07051039B1

    公开(公告)日:2006-05-23

    申请号:US10259176

    申请日:2002-09-27

    IPC分类号: G06F7/00 G06F17/00

    摘要: Techniques are provided for facilitating uniform access control to data managed by a database server that can emulate hierarchically organized systems, whether the data is accessed through hierarchical or relational access mechanisms. A database server that can emulate hierarchically organized systems uses separate relational or object-relational database tables to store the content of the resources that belong to a hierarchy (the “content structures”) and information that captures the hierarchy (the “hierarchy structures”). Both types of structures contain access control data that define consistent user access privileges. To determine access privileges for a user requesting access to data in the database, access control information is accessed in the hierarchy structures when the request is made through the hierarchical access mechanism, or accessed in the content structures when the request is made through a relational access mechanism. Access control is consistent between the hierarchical or relational access mechanisms because access through either is governed by user access data that reflects the same privileges.

    摘要翻译: 提供了技术,用于促进对数据库服务器管理的数据的统一访问控制,数据库服务器可以模拟分层组织的系统,无论数据是通过分级或关系访问机制访问的。 可以模拟分级组织的系统的数据库服务器使用单独的关系或对象关系数据库表来存储属于层次结构的资源的内容(“内容结构”)和捕获层次结构的信息(“层次结构”) 。 这两种类型的结构都包含定义一致的用户访问权限的访问控制数据。 为了确定请求访问数据库中的数据的用户的访问权限,当通过分层访问机制进行请求时,在层次结构中访问访问控制信息,或者当通过关系访问进行请求时在内容结构中访问访问控制信息 机制。 访问控制在分级或关系访问机制之间是一致的,因为通过任何一个访问控制的用户访问数据反映相同的权限。

    In-place evolution of XML schemas
    4.
    发明申请
    In-place evolution of XML schemas 有权
    XML模式的就地演进

    公开(公告)号:US20050050105A1

    公开(公告)日:2005-03-03

    申请号:US10648749

    申请日:2003-08-25

    IPC分类号: G06F12/00 G06F17/30

    CPC分类号: G06F17/30297 G06F17/30908

    摘要: A method and system for the in-place evolution of XML schemas is disclosed. To automatically evolve an existing XML schema, a schema evolver receives both an existing XML schema and an XML document as input. The XML document indicates changes to be made to the existing XML schema. Based on the existing XML schema and the XML document, the schema evolver evolves the existing XML schema into a new XML schema that incorporates the changes indicated in the XML document. According to one aspect, the schema evolver generates one or more SQL statements based on the new XML schema. The SQL statements, when executed by a database server, cause the database server to evolve database structures that were based on the formerly existing XML schema so that the database structures conform to the new XML schema. This is accomplished “in place,” without copying the data in the database structures.

    摘要翻译: 公开了一种用于XML模式的就地演化的方法和系统。 为了自动演进现有的XML模式,模式演进器接收现有的XML模式和XML文档作为输入。 XML文档指示对现有XML模式进行的更改。 基于现有的XML架构和XML文档,架构演进者将现有的XML架构演变为新的XML架构,其中包含XML文档中指示的更改。 根据一个方面,模式演进者基于新的XML模式生成一个或多个SQL语句。 SQL语句在由数据库服务器执行时,会导致数据库服务器发展基于以前存在的XML模式的数据库结构,以便数据库结构符合新的XML模式。 这完成了“到位”,而不复制数据库结构中的数据。

    Performing an action in response to a file system event
    5.
    发明授权
    Performing an action in response to a file system event 有权
    执行响应文件系统事件的操作

    公开(公告)号:US08176007B2

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

    申请号:US13026131

    申请日:2011-02-11

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30067 G06F9/542

    摘要: A method and apparatus for performing an action in response to a file system event is provided. According to one aspect, sets of “event listeners” are associated with a file hierarchy and/or the nodes thereof. Each event listener contains a set of “event handlers.” Each event handler corresponds to a separate type of event that may occur relative to the file hierarchy's nodes. When an event is going to occur relative to the hierarchy or a node thereof, all event listeners that are associated with that hierarchy/node are inspected to determine whether those event listeners contain any event handlers that correspond to the event's type. Those event handlers that correspond to the event's type are placed in an ordered list of event handlers to be invoked. As the event handlers in the list are invoked, programmatic mechanisms that correspond to those event handlers are executed to perform customized user-specified actions.

    摘要翻译: 提供了一种用于响应于文件系统事件执行动作的方法和装置。 根据一个方面,“事件监听器”的集合与文件层级和/或其节点相关联。 每个事件监听器包含一组“事件处理程序”。每个事件处理程序对应于可能相对于文件层次结构节点发生的单独的事件类型。 当相对于层级或其节点将发生事件时,检查与该层级/节点相关联的所有事件监听器,以确定这些事件监听器是否包含与事件类型相对应的任何事件处理程序。 与事件类型相对应的事件处理程序被放置在要调用的事件处理程序的有序列表中。 在列表中的事件处理程序被调用时,执行与那些事件处理程序相对应的程序化机制来执行定制的用户指定的操作。

    Efficient path-based operations while searching across versions in a repository
    6.
    发明授权
    Efficient path-based operations while searching across versions in a repository 有权
    高效的基于路径的操作,同时在存储库中的版本中进行搜索

    公开(公告)号:US08015165B2

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

    申请号:US11304414

    申请日:2005-12-14

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30235 G06F17/30533

    摘要: A technique and mechanism for efficiently searching across multiple versions of a resource is provided. New operators are provided that take into account the versions of a particular resource. The query engine evaluates the new operators using either an index-based approach or a functional approach. Under an index-based implementation, a hierarchical index is traversed to find a particular resource (or resources) associated with a specified path and the version history identifier associated with the particular resource(s). A version history table containing references to all versions of the particular resource(s) are then obtained. Under the functional implementation, a link table, which contains all paths in a user's workspace, is examined to determine whether the version history identifier of a particular resource matches a version history identifier of a resource specified in the link table and whether the path to the resource in the link table is related to the path specified.

    摘要翻译: 提供了一种有效地搜索资源的多个版本的技术和机制。 提供了新的运算符,以考虑特定资源的版本。 查询引擎使用基于索引的方法或功能方法来评估新的运算符。 在基于索引的实现下,遍历分层索引以找到与指定路径相关联的特定资源(或资源)以及与特定资源相关联的版本历史标识符。 然后获得包含对特定资源的所有版本的引用的版本历史表。 在功能实现下,检查包含用户工作区中的所有路径的链接表,以确定特定资源的版本历史标识符是否与链接表中指定的资源的版本历史标识符是否匹配, 链接表中的资源与指定的路径相关。

    Performing an action in response to a file system event
    7.
    发明授权
    Performing an action in response to a file system event 有权
    执行响应文件系统事件的操作

    公开(公告)号:US07921076B2

    公开(公告)日:2011-04-05

    申请号:US11014502

    申请日:2004-12-15

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30067 G06F9/542

    摘要: A method and apparatus for performing an action in response to a file system event is provided. According to one aspect, sets of “event listeners” are associated with a file hierarchy and/or the nodes thereof. Each event listener contains a set of “event handlers.” Each event handler corresponds to a separate type of event that may occur relative to the file hierarchy's nodes. When an event is going to occur relative to the hierarchy or a node thereof, all event listeners that are associated with that hierarchy/node are inspected to determine whether those event listeners contain any event handlers that correspond to the event's type. Those event handlers that correspond to the event's type are placed in an ordered list of event handlers to be invoked. As the event handlers in the list are invoked, programmatic mechanisms that correspond to those event handlers are executed to perform customized user-specified actions.

    摘要翻译: 提供了一种用于响应于文件系统事件执行动作的方法和装置。 根据一个方面,“事件监听器”的集合与文件层级和/或其节点相关联。 每个事件监听器包含一组“事件处理程序”。每个事件处理程序对应于可能相对于文件层次结构节点发生的单独的事件类型。 当相对于层级或其节点将发生事件时,检查与该层级/节点相关联的所有事件监听器,以确定这些事件监听器是否包含与事件类型相对应的任何事件处理程序。 与事件类型相对应的事件处理程序被放置在要调用的事件处理程序的有序列表中。 在列表中的事件处理程序被调用时,执行与那些事件处理程序相对应的程序化机制来执行定制的用户指定的操作。

    Implementation of backward compatible XML schema evolution in a relational database system
    8.
    发明授权
    Implementation of backward compatible XML schema evolution in a relational database system 有权
    在关系数据库系统中实现向后兼容的XML模式演进

    公开(公告)号:US07870163B2

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

    申请号:US11540341

    申请日:2006-09-28

    IPC分类号: G06F17/30

    CPC分类号: G06F17/2247

    摘要: In-place XML schema evolution occurs by evaluating an existing XML schema in a database system to see if it is compatible with a new XML schema. To determine if the old schema is compatible with the new schema, a lock-step traversal is performed on the two schemas. Each instruction in the old schema is compared to instructions in the new schema. Detected differences between the two schemas are evaluated to determine if existing XML documents are still compatible with the new schema. If they are, then an in-place schema evolution operation can take place. The in-place schema operation basically, involves appending the updated object information to the underlying object type and preserving the order of elements in a document by storing element mapping information on disk.

    摘要翻译: 通过评估数据库系统中的现有XML模式来查看是否与新的XML模式兼容,就会发生就地XML模式演进。 为了确定旧模式是否与新模式兼容,在两个模式上执行锁步遍历。 将旧模式中的每个指令与新模式中的指令进行比较。 对两个模式之间的检测差异进行评估,以确定现有XML文档是否仍然与新模式兼容。 如果它们是,则可以进行就地模式演进操作。 就地模式操作基本上包括将更新的对象信息附加到底层对象类型,并通过在盘上存储元素映射信息来保留文档中元素的顺序。

    Implementation of backward compatible XML schema evolution
    10.
    发明申请
    Implementation of backward compatible XML schema evolution 有权
    实现向后兼容的XML模式演进

    公开(公告)号:US20080082560A1

    公开(公告)日:2008-04-03

    申请号:US11540341

    申请日:2006-09-28

    IPC分类号: G06F7/00

    CPC分类号: G06F17/2247

    摘要: In-place XML schema evolution occurs by evaluating an existing XML schema in a database system to see if it is compatible with a new XML schema. To determine if the old schema is compatible with the new schema, a lock-step traversal is performed on the two schemas. Each instruction in the old schema is compared to instructions in the new schema. Detected differences between the two schemas are evaluated to determine if existing XML documents are still compatible with the new schema. If they are, then an in-place schema evolution operation can take place. The in-place schema operation basically, involves appending the updated object information to the underlying object type and preserving the order of elements in a document by storing element mapping information on disk.

    摘要翻译: 通过评估数据库系统中的现有XML模式来查看是否与新的XML模式兼容,就会发生就地XML模式演进。 为了确定旧模式是否与新模式兼容,在两个模式上执行锁步遍历。 将旧模式中的每个指令与新模式中的指令进行比较。 对两个模式之间的检测差异进行评估,以确定现有XML文档是否仍然与新模式兼容。 如果它们是,则可以进行就地模式演进操作。 就地模式操作基本上包括将更新的对象信息附加到底层对象类型,并通过在盘上存储元素映射信息来保留文档中元素的顺序。