System and method for providing system objects to a database
    1.
    发明申请
    System and method for providing system objects to a database 审中-公开
    将系统对象提供给数据库的系统和方法

    公开(公告)号:US20060167925A1

    公开(公告)日:2006-07-27

    申请号:US11042451

    申请日:2005-01-24

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24535

    摘要: A system and method are presented for providing system code to a variety of databases by using a resource database. The resource database contains pre-created system objects, which have been parsed and organized into a format suitable for execution. These pre-created system objects are capable of logically appearing in the variety of databases, while physically persisting in the resource database. Employing the resource database allows for quick upgrades and rollbacks since the pre-created system objects can be copied and installed on computer systems in a single file-copy operation. Additionally, the resource database limits accessibility to its pre-created system objects, thereby ensuring the integrity of the resource database. Lastly, the resource database contains its own metadata that is distinct from the metadata of the variety of databases.

    摘要翻译: 提出了一种通过使用资源数据库向各种数据库提供系统代码的系统和方法。 资源数据库包含预先创建的系统对象,这些对象已被解析并组织成适合执行的格式。 这些预先创建的系统对象能够逻辑上出现在各种数据库中,同时在资源数据库中持续存在。 使用资源数据库可以快速升级和回滚,因为可以在单个文件复制操作中将预先创建的系统对象复制并安装在计算机系统上。 此外,资源数据库限制了对其预先创建的系统对象的可访问性,从而确保资源数据库的完整性。 最后,资源数据库包含与各种数据库的元数据不同的自己的元数据。

    Mapping of schema data into data structures
    2.
    发明申请
    Mapping of schema data into data structures 审中-公开
    将模式数据映射到数据结构中

    公开(公告)号:US20060085451A1

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

    申请号:US11179918

    申请日:2005-07-12

    IPC分类号: G06F7/00

    CPC分类号: G06F16/86

    摘要: Translation architecture that facilitates translation between schema data and relational structures. The architecture includes a translation component that consumes schema data (e.g., an XML schema) that includes a schema structure, validates the schema structure, and persists in memory a representation of the schema as a relational format. Since schemas are shredded into tables, instance validation loads only the necessary components to perform validation. During validation, only parts of the schema that are used are loaded and cached. A schema cache stores the in-memory representation of schema optimized for instance validation. Schema components are loaded from metadata into main memory as read-only objects such that multiple users can use the in-memory objects for validation, query processing, query optimization and storage optimization of XML instance data

    摘要翻译: 有助于模式数据和关系结构之间的转换的翻译架构。 该架构包括消耗包括模式结构的模式数据(例如,XML模式)的翻译组件,验证模式结构,并将存储器中的模式的表示作为关系格式持续存储。 由于模式被分解成表,实例验证只加载必要的组件来执行验证。 在验证期间,只有部分使用的模式被加载和缓存。 模式缓存存储针对实例验证优化的模式的内存中表示。 模式组件从元数据加载到主内存中作为只读对象,以便多个用户可以使用内存中的对象来进行XML实例数据的验证,查询处理,查询优化和存储优化

    Specification of a hierarchical authorization model for a DBMS - SQL language extensions
    3.
    发明申请
    Specification of a hierarchical authorization model for a DBMS - SQL language extensions 有权
    规范DBMS - SQL语言扩展的分层授权模型

    公开(公告)号:US20060282433A1

    公开(公告)日:2006-12-14

    申请号:US11151998

    申请日:2005-06-14

    IPC分类号: G06F17/30

    摘要: Provided are systems and methods that facilitate providing permission to entities of a database. A system includes a component that authorizes a principal of a containing entity to grant a permission to that entity, and a component that grants the permission to the containing entity, the grantee of the permission inherits a set of permissions to one or more entities contained by the containing entity. When a permission is granted to a parent in a hierarchy of a relational database, the permission is inherited by the child nodes. Also provided is a method for transferring ownership of entities in a relational database. The method includes a two-part handshake that can be audited to avoid repudiation issues.

    摘要翻译: 提供了有助于向数据库的实体提供许可的系统和方法。 系统包括授权包含实体的委托人向该实体授予许可的组件,以及向该包含实体授予许可的组件,该许可的授予者将继承一组或多个由 包含实体。 当向关系数据库的层次结构中的父级授予权限时,权限将由子节点继承。 还提供了一种用于转移关系数据库中的实体的所有权的方法。 该方法包括两部分握手,可以进行审核,以避免否认问题。