Systematic verification of database metadata upgrade
    1.
    发明授权
    Systematic verification of database metadata upgrade 有权
    数据库元数据升级的系统验证

    公开(公告)号:US08738569B1

    公开(公告)日:2014-05-27

    申请号:US13371337

    申请日:2012-02-10

    IPC分类号: G06F17/00

    CPC分类号: G06F17/303

    摘要: A script is run on a database to transform the metadata and produce an upgraded database. A new database corresponding to the upgraded database is initialized, and the metadata in the new database catalog is verified by comparing it to the upgraded database metadata. A fast verification is performed on a partial upgrade by dumping the catalogs of master nodes and comparing the results, and a thorough verification is performed on a full upgrade by querying and comparing both master node catalogs and segment node catalogs.

    摘要翻译: 在数据库上运行脚本来转换元数据并生成升级的数据库。 初始化与升级的数据库对应的新数据库,并通过将其与升级的数据库元数据进行比较来验证新数据库目录中的元数据。 通过转储主节点的目录并比较结果,对部分升级进行快速验证,并通过查询和比较主节点目录和分段节点目录,对完全升级执行彻底的验证。

    Mirrored database upgrade using state machine
    2.
    发明授权
    Mirrored database upgrade using state machine 有权
    使用状态机镜像数据库升级

    公开(公告)号:US08745445B1

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

    申请号:US13371342

    申请日:2012-02-10

    IPC分类号: G06F11/00

    摘要: A process for upgrading a mirrored shared-nothing database system comprises a sequence of short well-defined idempotent steps, and at least one non-idempotent step involving transforming a master catalog. The upgrade process is managed and controlled by a state machine that has a persistent memory running on the master node. In the event of a failure or crash during an idempotent step, the process stops the database in the current state and repeats the step. If a failure or crash occurs during a non-idempotent step, the upgrade process is rolled back to the beginning and repeated.

    摘要翻译: 用于升级镜像的无共享数据库系统的过程包括简短明确的幂等级步骤的序列,以及涉及变换主目录的至少一个非幂等级步骤。 升级过程由在主节点上运行持久内存的状态机进行管理和控制。 在幂等级步骤中出现故障或崩溃的情况下,该进程将在当前状态下停止数据库并重复该步骤。 如果在非幂等级步骤中发生故障或崩溃,则升级过程将回滚到最初并重复。

    Method of transforming database system privileges to object privileges
    4.
    发明授权
    Method of transforming database system privileges to object privileges 有权
    将数据库系统特权转换为对象权限的方法

    公开(公告)号:US09111114B1

    公开(公告)日:2015-08-18

    申请号:US13371333

    申请日:2012-02-10

    IPC分类号: G06F17/30 G06F21/62

    CPC分类号: G06F21/6227

    摘要: Coarse-grained system-wide database privileges are transformed into new finer-grained database object privileges that are user-centric and specific to particular objects by creating an object class defining certain generic operations on objects, and defining within the object class a new object that embodies permissible actions on a particular database object. The new object is stored in a catalog table that comprises an object privilege table and is associated in the object privilege table with a consolidated grouping of object privileges of users relative to the new object.

    摘要翻译: 粗粒度全系统的数据库权限通过创建一个定义对象的某些通用操作的对象类来转换为以用户为中心和特定于特定对象的新的更细粒度的数据库对象特权,并在对象类中定义一个新对象 体现了对特定数据库对象的允许操作。 新对象存储在包含对象特权表的目录表中,并且在对象特权表中与用户相对于新对象的对象特权的合并分组相关联。