System and Method for Performing an Administrative Task upon the Occurrence of a Triggering Event
    1.
    发明申请
    System and Method for Performing an Administrative Task upon the Occurrence of a Triggering Event 审中-公开
    发生触发事件时执行管理任务的系统和方法

    公开(公告)号:US20080016192A1

    公开(公告)日:2008-01-17

    申请号:US11457310

    申请日:2006-07-13

    IPC分类号: G06F15/173

    摘要: In response to a triggering event, a resilient administrative schedule system recognizes a need to perform an administrative task on one of a set of data servers. A user selects the administrative task. The system determines an operational status of the data server to determine a communication protocol for communicating with the data server, selects the communication protocol based on the operational status of the data server adding the selected administrative task to a task list, and automatically executes the selected administrative task at a predetermined execution time without intervention by a human administrator.

    摘要翻译: 响应于触发事件,弹性管理调度系统识别需要在一组数据服务器之一上执行管理任务。 用户选择管理任务。 系统确定数据服务器的操作状态以确定用于与数据服务器通信的通信协议,基于将所选择的管理任务添加到任务列表的数据服务器的操作状态选择通信协议,并且自动执行所选择的 管理任务在预定的执行时间,而不受人类管理员的干预。

    Bufferpool coherency for identifying and retrieving versions of workfile
data using a producing DBMS and a consuming DBMS
    2.
    发明授权
    Bufferpool coherency for identifying and retrieving versions of workfile data using a producing DBMS and a consuming DBMS 失效
    缓冲池一致性,用于使用生成的DBMS和消耗的DBMS来识别和检索工作文件数据的版本

    公开(公告)号:US5692182A

    公开(公告)日:1997-11-25

    申请号:US539411

    申请日:1995-10-05

    IPC分类号: G06F17/30

    摘要: A system and method for a computer based system having one or more consuming DBMSs and one or more producing DBMSs such that the producing DBMSs produce workfiles for the consuming DBMSs. A producing DBMS uniquely identifies the bufferpool pages comprising a workfile, uniquely identifies the workfile, and flushes only the bufferpool pages corresponding to the workfile to a storage device. The producing DBMS further notifies the consuming DBMS that the workfile is available and receives a reply from the consuming DBMS indicating that the consuming device retrieved the data from the storage device. The consuming device receives notification from the producing DBMS, retrieves the workfile, and replies to the producing DBMS that it has retrieved the workfile.

    摘要翻译: 一种用于基于计算机的系统的系统和方法,其具有一个或多个消耗DBMS和一个或多个生成DBMS,使得生成DBMS产生用于消费DBMS的工作文件。 生产DBMS唯一地标识包括工作文件的缓冲池页面,唯一地标识工作文件,并且仅将与工作文件对应的缓冲池页面刷新到存储设备。 生产DBMS还通知消费DBMS工作文件可用并且从消费DBMS接收到指示消费设备从存储设备检索数据的应答。 消费设备从生产DBMS接收通知,检索工作文件,并回复生产DBMS已检索工作文件。

    Method and apparatus for recording and managing data object relationship data

    公开(公告)号:US10783122B2

    公开(公告)日:2020-09-22

    申请号:US11777254

    申请日:2007-07-12

    摘要: The invention relates to a method and apparatus for recording and maintaining stored information system object relationship information. Information contained within a stored information system (including system catalogs, referential constraints, triggers, table hierarchies, column references, indexes, stored program packages, system catalogs, stored procedures, stored queries, log/trace files of dynamically executed code, etc.) are searched to identify dependency relationships between objects. This object relationship information is stored and maintained in an information base. Information within the information based may be organized based upon subsets of objects that support a common application, service, or capability. Object relationship data is used to facilitate stored information system administration activities such as generating/restoring from archives, physically/logically segmenting data objects, replicating data objects; optimizing the distribution of data in distributed data system; and estimating operational capacity.

    Automatic query execution plan management and performance stabilization for workloads
    6.
    发明授权
    Automatic query execution plan management and performance stabilization for workloads 有权
    自动查询执行计划管理和工作负载性能稳定

    公开(公告)号:US08805852B2

    公开(公告)日:2014-08-12

    申请号:US12395836

    申请日:2009-03-02

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30306

    摘要: A method, apparatus, and computer program product are disclosed for managing query execution plans for a workload. In one embodiment, the method includes gathering an initial set of performance characteristics generated from a database management system (DBMS) executing a database workload according to one or more query execution plans (QEPs). The database workload includes one or more database statements. The method determines a QEP change for one or more QEPs of the database workload. In addition, the method gathers a subsequent set of performance characteristics generated from the DBMS executing the one or more QEPs of the database workload influenced by the QEP change. Furthermore, the method determines a performance difference created by the QEP change based on the initial set of performance characteristics and the subsequent set of performance characteristics and responds to the performance difference in accordance with a monitoring policy.

    摘要翻译: 公开了用于管理工作负载的查询执行计划的方法,装置和计算机程序产品。 在一个实施例中,该方法包括收集根据一个或多个查询执行计划(QEP)从执行数据库工作负荷的数据库管理系统(DBMS)生成的一组初始性能特征。 数据库工作负载包括一个或多个数据库语句。 该方法确定数据库工作负载的一个或多个QEP的QEP更改。 此外,该方法收集从DBMS生成的后续一组性能特征,这些特性执行受QEP更改影响的数据库工作负载的一个或多个QEP。 此外,该方法基于初始的性能特征集合和后续的一组性能特性来确定由QEP改变产生的性能差异,并且根据监视策略来响应性能差异。

    Method and apparatus for recording and managing data object relationship data
    8.
    发明授权
    Method and apparatus for recording and managing data object relationship data 有权
    用于记录和管理数据对象关系数据的方法和装置

    公开(公告)号:US07290007B2

    公开(公告)日:2007-10-30

    申请号:US10141776

    申请日:2002-05-10

    IPC分类号: G06F17/00 G06F7/00

    摘要: The invention relates to a method and apparatus for recording and maintaining stored information system object relationship information. Information contained within a stored information system (including system catalogs, referential constraints, triggers, table hierarchies, column references, indexes, stored program packages, system catalogs, stored procedures, stored queries, log/trace files of dynamically executed code, etc.) are searched to identify dependency relationships between objects. This object relationship information is stored and maintained in an information base. Information within the information based may be organized based upon subsets of objects that support a common application, service, or capability. Object relationship data is used to facilitate stored information system administration activities such as generating/restoring from archives, physically/logically segmenting data objects, replicating data objects; optimizing the distribution of data in distributed data system; and estimating operational capacity.

    摘要翻译: 本发明涉及用于记录和维护存储的信息系统对象关系信息的方法和装置。 包含在存储的信息系统(包括系统目录,参照约束,触发器,表层次结构,列引用,索引,存储的程序包,系统目录,存储过程,存储的查询,动态执行代码的日志/跟踪文件等)中的信息) 被搜索以识别对象之间的依赖关系。 该对象关系信息被存储和维护在信息库中。 基于信息的信息可以基于支持公共应用,服务或能力的对象的子集来组织。 对象关系数据用于促进存储的信息系统管理活动,例如从归档生成/恢复,物理/逻辑地分割数据对象,复制数据对象; 优化分布式数据系统中数据的分布; 并估算运营能力。

    Accessing a dataset using an unsupported access method
    9.
    发明授权
    Accessing a dataset using an unsupported access method 有权
    使用不受支持的访问方法访问数据集

    公开(公告)号:US07266552B2

    公开(公告)日:2007-09-04

    申请号:US10821717

    申请日:2004-04-09

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

    摘要: A method, apparatus, and article of manufacture accesses a dataset using an unsupported access method. A first request to access a dataset is intercepted. The first request is associated with a first data structure that specifies a first access method. The first data structure is replaced with a second data structure that specifies a second access method which is different from the first access method. The dataset is accessed in accordance with the second access method of the second data structure.In another particular embodiment, the first access method is the basic direct access method, and the second access method is any of the basic sequential access method and the queued sequential access method. In yet another embodiment, the dataset is an extended format physical sequential dataset.

    摘要翻译: 方法,装置和制品使用不受支持的访问方法访问数据集。 第一个访问数据集的请求被截获。 第一请求与指定第一访问方法的第一数据结构相关联。 第一数据结构被替换为指定与第一访问方法不同的第二访问方法的第二数据结构。 根据第二数据结构的第二访问方法访问数据集。 在另一特定实施例中,第一访问方法是基本直接访问方法,第二访问方法是基本顺序访问方法和排队顺序访问方法中的任何一种。 在另一个实施例中,数据集是扩展格式物理顺序数据集。