Zero downtime maintenance for applications and databases

    公开(公告)号:US10303665B2

    公开(公告)日:2019-05-28

    申请号:US14495056

    申请日:2014-09-24

    IPC分类号: G06F16/21

    摘要: Methods, systems, and computer-readable storage media for minimizing downtime during maintenance procedures to an application. In some implementations, actions include executing a first application, executing a second application, and providing an access schema layer that facilitates communication between applications and a data schema layer, the data schema layer including one or more tables of a database, wherein, during a maintenance procedure, the access schema layer includes: a first access schema, the first access schema facilitating exclusive communication between the first application and at least one table of the data schema layer, and a second access schema, the second access schema facilitating exclusive communication between the second application and one or more tables of the data schema layer.

    Migrating data in tables in a database
    4.
    发明授权
    Migrating data in tables in a database 有权
    在数据库中的表中迁移数据

    公开(公告)号:US09436724B2

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

    申请号:US14059380

    申请日:2013-10-21

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30377

    摘要: Techniques for migrating data in a database include identifying an update to one or more data entries of a source table; determining that a status of a trigger associated with the source table indicates to update a logging table, and in response: updating, in a first transaction, (i) the one or more data entries of the source table, and (ii) one or more data entries of the logging table based on the user input, and copying content of the source table to a target table; and determining that the status indicates to update the target table, and in response: updating, in a second transaction, (i) the one or more data entries of the source table and (ii) one or more data entries of the target table based on the user input, and updating the content of the target table based on the one or more data entries of the logging table.

    摘要翻译: 用于在数据库中迁移数据的技术包括标识对源表的一个或多个数据条目的更新; 确定与源表相关联的触发器的状态指示更新记录表,并且作为响应:在第一事务中更新(i)源表的一个或多个数据条目,以及(ii)源表中的一个或多个 基于用户输入的记录表的更多数据条目,以及将源表的内容复制到目标表; 并且确定所述状态指示更新所述目标表,并且作为响应:在第二事务中更新所述源表的所述一个或多个数据条目,以及(ii)所述目标表的一个或多个数据条目 在用户输入上,并且基于记录表的一个或多个数据条目来更新目标表的内容。

    OPTIMIZING SOFTWARE CHANGE PROCESSES USING REAL-TIME ANALYSIS AND RULE-BASED HINTING

    公开(公告)号:US20160019042A1

    公开(公告)日:2016-01-21

    申请号:US14331794

    申请日:2014-07-15

    IPC分类号: G06F9/445 G06F9/44 G06N5/04

    摘要: In one aspect, the present disclosure relates to a method which comprises obtaining a set of software change process parameters characterizing the particular process, based on the obtained set of software change process parameters, selecting hot spot information corresponding to the obtained set of software change process parameters, the hot spot information being based on a statistical analysis of previous software change processes and wherein the hot spot information identifies one or more steps of the multiple steps of the process during which problems have occurred in the previous processes, providing the hot spot information to the host computer system for use in the software change process and obtaining status information relating to the software change process at multiple times during the execution of the software change process, a level of detail of the status information being increased for steps of the process identified in the hot spot information.

    Distributed database system utilizing an extended two-phase-commit process
    7.
    发明授权
    Distributed database system utilizing an extended two-phase-commit process 有权
    使用扩展两阶段提交过程的分布式数据库系统

    公开(公告)号:US08880486B2

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

    申请号:US12844662

    申请日:2010-07-27

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30377 G06F17/30557

    摘要: A distributed database system is provided in which a commit coordinator ensures that transactions spanning multiple database instances are committed or rolled back consistently. The commit coordinator utilizes an extended two-phase-commit process. The extension of the two-phase-commit process enables, that if within the distributed database cohorts store redundant data for a productive operation, only one of the cohorts out of a redundancy group are required. By this, the distributed database is prepared to continue operation even during shutdown or failure of single cohorts. Related apparatus, systems, techniques and articles are also described.

    摘要翻译: 提供了一种分布式数据库系统,其中提交协调器确保跨多个数据库实例的事务一致地提交或回滚。 提交协调器利用扩展的两阶段提交过程。 两阶段提交过程的扩展使得如果在分布式数据库队列中存储用于生产操作的冗余数据,则仅需要冗余组中的一个队列。 由此,即使在单个队列的关闭或故障期间,分布式数据库也准备继续运行。 还描述了相关设备,系统,技术和物品。

    Single-Database Multiple-Tenant Software System Upgrade
    8.
    发明申请
    Single-Database Multiple-Tenant Software System Upgrade 有权
    单数据库多租户软件系统升级

    公开(公告)号:US20140114913A1

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

    申请号:US13658644

    申请日:2012-10-23

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30079

    摘要: Example systems and methods of upgrading a single-database, multiple-tenant software system are presented. In one example, a target database schema for a target version of the software system is created. For each tenant of a current database schema for a current version of the software system, a current state of the data corresponding to the tenant in the current database schema is captured. The data corresponding to the tenant is transitioned from the current database schema to the target database schema. The tenant in the target database schema is tested to verify the tenant. If the tenant in the target database schema is verified, the tenant in the target database schema is opened for users. If not verified, the tenant in the current database schema is restored using the captured state.

    摘要翻译: 介绍了升级单数据库,多租户软件系统的示例系统和方法。 在一个示例中,创建用于软件系统的目标版本的目标数据库模式。 对于软件系统的当前版本的当前数据库模式的每个租户,捕获与当前数据库模式中的租户对应的数据的当前状态。 对应于租户的数据从当前数据库模式转换到目标数据库模式。 测试目标数据库模式中的租户以验证租户。 如果目标数据库架构中的租户被验证,目标数据库架构中的租户将为用户打开。 如果未验证,则使用捕获状态恢复当前数据库模式中的租户。

    USING TEMPORARY SYSTEM TO PROVIDE CONTINUOUS ACCESS DURING APPLICATION UPGRADE
    9.
    发明申请
    USING TEMPORARY SYSTEM TO PROVIDE CONTINUOUS ACCESS DURING APPLICATION UPGRADE 有权
    使用临时系统在应用程序升级期间提供连续访问

    公开(公告)号:US20130238868A1

    公开(公告)日:2013-09-12

    申请号:US13730746

    申请日:2012-12-28

    IPC分类号: G06F12/16

    摘要: A temporary system is described to provide, during an upgrade of an application implemented using an original system, a continuous access to the application. A copy of a first data-set characterizing a first version of the application is generated on the temporary system when the upgrade becomes available. A selective access to the copy on the temporary system is enabled while preventing access to the first data-set on an original system. The first data-set on the original system is upgraded to form a second data-set characterizing a second version of the application, and a testing of the second data-set is performed. When a result of the testing indicates that the second data-set should be implemented, an access to the second data-set on the original system is enabled while preventing access to the copy on the temporary system. Related methods, apparatus, systems, techniques and articles are also described.

    摘要翻译: 描述了临时系统,以在使用原始系统实现的应用的升级期间提供对应用的连续访问。 当升级变得可用时,在临时系统上生成表征应用程序的第一版本的第一数据集的副本。 启用对临时系统上的副本的选择性访问,同时防止访问原始系统上的第一个数据集。 原始系统上的第一数据集被升级以形成表征应用的第二版本的第二数据集,并且执行第二数据集的测试。 当测试结果指示应该实现第二数据集时,启用对原始系统上的第二数据集的访问,同时防止对临时系统上的副本的访问。 还描述了相关方法,装置,系统,技术和制品。