Implementation of backward compatible XML schema evolution
    122.
    发明申请
    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文档是否仍然与新模式兼容。 如果它们是,则可以进行就地模式演进操作。 就地模式操作基本上包括将更新的对象信息附加到底层对象类型,并通过在盘上存储元素映射信息来保留文档中元素的顺序。

    Efficient support for workspace-local queries in a repository that supports file versioning
    123.
    发明申请
    Efficient support for workspace-local queries in a repository that supports file versioning 有权
    在支持文件版本控制的存储库中高效支持工作区本地查询

    公开(公告)号:US20070150525A1

    公开(公告)日:2007-06-28

    申请号:US11316803

    申请日:2005-12-22

    IPC分类号: G06F17/30

    CPC分类号: G06F17/3023 Y10S707/99954

    摘要: Evaluation of workspace-local queries on a repository that supports versioning is enabled by tracking which versions of resources that are stored in the repository are associated with particular workspaces. A mapping is created and maintained for each workspace and each workspace-enabled table, i.e., a repository table that supports multiple versions of resources in the table. The mapping, such as a bit vector, is indexed by resource identifier. A set bit indicates that a particular resource version that corresponds to the bit is associated with the particular workspace. Therefore, the mapping indicates which rows in the workspace-enabled table are in the particular workspace. Index-based and functional evaluation schemes may utilize the per workspace, per table mapping to evaluate queries on the versioned repository. A new operator (IN_WORKSPACE) is introduced, through which an evaluation routine is invoked to determine whether or not a particular row maps to a particular workspace.

    摘要翻译: 通过跟踪存储在存储库中的哪些版本的资源与特定工作空间相关联,可以对支持版本控制的存储库上的工作区本地查询进行评估。 为每个工作空间和每个启用工作区的表创建和维护映射,即支持表中多个版本资源的存储库表。 诸如位向量的映射由资源标识符索引。 一组位表示与该位相对应的特定资源版本与特定工作空间相关联。 因此,映射指示工作区启用的表中哪些行在特定工作空间中。 基于索引和功能评估方案可以利用每个工作空间,每个表映射来评估版本化存储库中的查询。 引入了一个新的运算符(IN_WORKSPACE),通过该运算符调用一个评估程序来确定特定行是否映射到特定的工作区。

    Management of complex XML schemas in a database system
    124.
    发明授权
    Management of complex XML schemas in a database system 有权
    在数据库系统中管理复杂的XML模式

    公开(公告)号:US07761479B2

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

    申请号:US11519720

    申请日:2006-09-11

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/30917 Y10S707/954

    摘要: Techniques manage the presence of repeated constructs within a complex type at the time of schema registration. At registration, techniques detect repeated elements in the XML schema and analyze whether the repeated elements are from the same complex type. If so, techniques perform additional analysis to determine a minimal common ancestor. Within the context of a minimal common ancestor, techniques determine the maximum number of times an element may occur in the schema. In a choice content model, the largest maximum occurrence value is selected. In other content models, the maximum occurrence value is determined by adding together the occurrence values for the repeated elements. Then, when an object relational table is generated for the XML schema, the maximum number of times that an element appears in the schema is this value. Techniques retain the advantages of object relational storage, even after a schema evolution.

    摘要翻译: 技术在模式注册时管理复杂类型中重复构造的存在。 在注册时,技术会检测XML模式中的重复元素,并分析重复的元素是否来自相同的复杂类型。 如果是这样,技术将进行额外的分析,以确定一个最小的共同祖先。 在最小共同祖先的上下文中,技术确定元素在模式中可能发生的最大次数。 在选择内容模型中,选择最大的最大出现值。 在其他内容模型中,通过将重复元素的出现值相加来确定最大出现值。 然后,当为XML模式生成对象关系表时,元素在模式中出现的最大次数是此值。 技术保留对象关系存储的优点,即使在模式演进之后。

    METHOD AND SYSTEM FOR OPTIMIZING ROW LEVEL SECURITY IN DATABASE SYSTEMS
    125.
    发明申请
    METHOD AND SYSTEM FOR OPTIMIZING ROW LEVEL SECURITY IN DATABASE SYSTEMS 有权
    用于优化数据库系统中的级别安全的方法和系统

    公开(公告)号:US20100036846A1

    公开(公告)日:2010-02-11

    申请号:US12188675

    申请日:2008-08-08

    IPC分类号: G06F17/30

    摘要: One embodiment of the present invention provides a system that implements a security policy in a database. During operation, the system receives a request associated with a set of objects in the database. Next, the system obtains a set of access control lists (ACLs) associated with the database, wherein a respective ACL specifies one or more access privileges associated with a user or user group, and wherein a respective ACLs is not specific to a particular object in the database. The system then evaluates the ACLs to obtain a set of ACL results associated with the request and processes the request by applying the set of ACL results to the objects without evaluating the ACLs repeatedly for each of the objects.

    摘要翻译: 本发明的一个实施例提供一种在数据库中实现安全策略的系统。 在操作期间,系统接收与数据库中的一组对象相关联的请求。 接下来,系统获得与数据库相关联的一组访问控制列表(ACL),其中相应的ACL指定与用户或用户组相关联的一个或多个访问权限,并且其中相应的ACL不是特定于特定对象的特定对象 数据库。 然后,系统评估ACL以获得与请求相关联的一组ACL结果,并通过将ACL集合应用于对象来处理请求,而不对每个对象重复地评估ACL。

    Efficient queriability of version histories in a repository
    126.
    发明申请
    Efficient queriability of version histories in a repository 有权
    存储库中版本历史的高效可排序性

    公开(公告)号:US20070162441A1

    公开(公告)日:2007-07-12

    申请号:US11332117

    申请日:2006-01-12

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/2288 G06F17/3023

    摘要: Efficient evaluation of resource version history queries is enabled by using a data container storing records corresponding to links between successive versions of a resource. The records include: (a) a record identifier, (b) a predecessor identifier, (c) a successor identifier, (d) a predecessor rowset, which comprises the record identifier of each record in which the predecessor identifier in this record is the successor identifier, and (e) a successor rowset, which comprises the record identifier of each record in which the successor identifier in this record is the predecessor identifier. Depending on the nature of a request, a record is identified in which a particular version is identified by either the predecessor identifier or the successor identifier. Either the predecessor or successor rowsets are recursively read, while the predecessor or successor identifiers corresponding to each record read are added to a result set, thereby forming the ancestor or descendant version history.

    摘要翻译: 通过使用存储与资源的连续版本之间的链接相对应的记录的数据容器来启用资源版本历史查询的有效评估。 记录包括:(a)记录标识符,(b)前导标识符,(c)后继标识符,(d)前置行集合,其包括每个记录的记录标识符,其中该记录中的前身标识符是 后续标识符,以及(e)后继行集,其包括其中该记录中的后继标识符是前导标识符的每个记录的记录标识符。 根据请求的性质,识别一个记录,其中特定版本由前导标识符或后续标识符标识。 前导或后继行集是递归读取的,而与读取的每个记录相对应的前导或后继标识符被添加到结果集中,从而形成祖先或后代版本历史。

    Method and system for optimizing row level security in database systems
    127.
    发明授权
    Method and system for optimizing row level security in database systems 有权
    优化数据库系统中行级安全性的方法和系统

    公开(公告)号:US08667018B2

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

    申请号:US12188675

    申请日:2008-08-08

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    摘要: One embodiment of the present invention provides a system that implements a security policy in a database. During operation, the system receives a request associated with a set of objects in the database. Next, the system obtains a set of access control lists (ACLs) associated with the database, wherein a respective ACL specifies one or more access privileges associated with a user or user group, and wherein a respective ACLs is not specific to a particular object in the database. The system then evaluates the ACLs to obtain a set of ACL results associated with the request and processes the request by applying the set of ACL results to the objects without evaluating the ACLs repeatedly for each of the objects.

    摘要翻译: 本发明的一个实施例提供一种在数据库中实现安全策略的系统。 在操作期间,系统接收与数据库中的一组对象相关联的请求。 接下来,系统获得与数据库相关联的一组访问控制列表(ACL),其中相应的ACL指定与用户或用户组相关联的一个或多个访问权限,并且其中相应的ACL不是特定于特定对象的特定对象 数据库。 然后,系统评估ACL以获得与请求相关联的一组ACL结果,并通过将ACL集合应用于对象来处理请求,而不对每个对象重复地评估ACL。

    Evolution of XML schemas involving partial data copy
    128.
    发明授权
    Evolution of XML schemas involving partial data copy 有权
    涉及部分数据复制的XML模式的演进

    公开(公告)号:US08346725B2

    公开(公告)日:2013-01-01

    申请号:US11521907

    申请日:2006-09-15

    IPC分类号: G06F7/00

    摘要: XML schema evolutions can be performed on an XML-type database using partial data copy techniques. The partial data copy techniques provide mechanisms to identify a minimal set of data in the database that needs be copied out in order for schema evolution operations to occur. Identifying the minimal set of data involves comparing an existing XML schema to a new XML schema and determining the differences between the two schemas. Based on those differences, a minimal set of data can be determined. That data can then be copied to a temporary storage location, while the XML schema and its associated database structure are updated to conform to the new XML schema. Then, the minimal set of data is copied back into the modified database structure.

    摘要翻译: 可以使用部分数据复制技术在XML类型数据库上执行XML模式演进。 部分数据复制技术提供了识别数据库中需要复制出来以便模式演进操作发生的最小数据集的机制。 识别最小数据集涉及将现有XML模式与新的XML模式进行比较,并确定两种架构之间的差异。 基于这些差异,可以确定最小的数据集。 然后可以将该数据复制到临时存储位置,同时更新XML模式及其关联的数据库结构以符合新的XML模式。 然后,将最小数据集复制回修改后的数据库结构。

    Efficient queriability of version histories in a repository
    129.
    发明授权
    Efficient queriability of version histories in a repository 有权
    存储库中版本历史的高效可排序性

    公开(公告)号:US07730032B2

    公开(公告)日:2010-06-01

    申请号:US11332117

    申请日:2006-01-12

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/2288 G06F17/3023

    摘要: Efficient evaluation of resource version history queries is enabled by using a data container storing records corresponding to links between successive versions of a resource. The records include: (a) a record identifier, (b) a predecessor identifier, (c) a successor identifier, (d) a predecessor rowset, which comprises the record identifier of each record in which the predecessor identifier in this record is the successor identifier, and (e) a successor rowset, which comprises the record identifier of each record in which the successor identifier in this record is the predecessor identifier. Depending on the nature of a request, a record is identified in which a particular version is identified by either the predecessor identifier or the successor identifier. Either the predecessor or successor rowsets are recursively read, while the predecessor or successor identifiers corresponding to each record read are added to a result set, thereby forming the ancestor or descendant version history.

    摘要翻译: 通过使用存储与资源的连续版本之间的链接相对应的记录的数据容器来启用资源版本历史查询的有效评估。 记录包括:(a)记录标识符,(b)前身标识符,(c)后继标识符,(d)前置行集,其包括每个记录的记录标识符,其中该记录中的前身标识符是 后续标识符,以及(e)后继行集,其包括其中该记录中的后继标识符是前导标识符的每个记录的记录标识符。 根据请求的性质,识别一个记录,其中特定版本由前导标识符或后续标识符标识。 前导或后继行集是递归读取的,而与读取的每个记录相对应的前导或后继标识符被添加到结果集中,从而形成祖先或后代版本历史。

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

    公开(公告)号:US07424495B2

    公开(公告)日:2008-09-09

    申请号: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.

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