DATABASE MANAGEMENT SYSTEM, COMPUTER, AND DATABASE MANAGEMENT METHOD
    3.
    发明申请
    DATABASE MANAGEMENT SYSTEM, COMPUTER, AND DATABASE MANAGEMENT METHOD 审中-公开
    数据库管理系统,计算机和数据库管理方法

    公开(公告)号:US20150169591A1

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

    申请号:US14402878

    申请日:2012-05-24

    IPC分类号: G06F17/30

    摘要: A database management system (DBMS) manages a database existing in a second storage device with an access speed lower than that of a first storage device. In an execution of a query, the DBMS dynamically generates tasks two or more executable tasks in parallel. The DBMS generates task start information which is information representing a content of the execution of the task, manages the task start information, and executes a content represented by the task start information by the task. The task start information includes a data address set existing in the second storage device. The DBMS controls movement of the data address sets between the first storage device and the second storage device based on a management state of the task start information. In addition, the DBMS selects the task start information based on whether or not the data address set exists in the first storage device.

    摘要翻译: 数据库管理系统(DBMS)以比第一存储设备低的访问速度来管理第二存储设备中存在的数据库。 在执行查询时,DBMS并行动态生成任务两个或多个可执行任务。 DBMS生成作为任务执行内容的信息的任务开始信息,管理该任务开始信息,并执行任务开始信息所表示的内容。 任务开始信息包括存在于第二存储装置中的数据地址集。 DBMS基于任务开始信息的管理状态,控制第一存储装置与第二存储装置之间的数据地址集的移动。 另外,DBMS根据第一存储装置中是否存在数据地址组来选择任务开始信息。

    Reorganization method of database and a database reorganization system
    4.
    发明授权
    Reorganization method of database and a database reorganization system 有权
    数据库重组方法和数据库重组系统

    公开(公告)号:US07657584B2

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

    申请号:US11257328

    申请日:2005-10-25

    IPC分类号: G06F17/30 G06F17/00

    CPC分类号: G06F17/30312

    摘要: Provided is a storage system in which a transaction of a database is quiesced, a pair of a first volume and a second volume is split so as to make settings to allow an access to be made only to the database in the first volume, the transaction is then released from the quiescent state, a sparse space is specified in the database stored in the second volume, only the specified sparse space in the second volume is partially reorganized, and the contents of the partially reorganized second volume are copied to the first volume such that the first volume and the second volume are resynchronized with each other to form the pair again.

    摘要翻译: 提供了一种存储系统,其中数据库的事务被停顿,一对第一卷和第二卷被拆分,以便进行设置以允许仅对第一卷中的数据库进行访问,该事务 然后从静止状态释放,在第二个卷中存储的数据库中指定了一个稀疏空间,只有第二个卷中指定的稀疏空间被部分重新组织,部分重新组织的第二个卷的内容将被复制到第一个卷 使得第一卷和第二卷彼此重新同步以再次形成对。

    PARALLEL DATA PROCESSING SYSTEM, COMPUTER, AND PARALLEL DATA PROCESSING METHOD
    5.
    发明申请
    PARALLEL DATA PROCESSING SYSTEM, COMPUTER, AND PARALLEL DATA PROCESSING METHOD 有权
    并行数据处理系统,计算机和并行数据处理方法

    公开(公告)号:US20150113535A1

    公开(公告)日:2015-04-23

    申请号:US14404550

    申请日:2012-05-31

    IPC分类号: G06F9/46 G06F9/54

    摘要: A parallel data processing system includes a parallel data processing execution unit for reading a data from a data set including a first data set that includes a plurality of first data and a second data set that includes a plurality of second data and executing processing. The parallel data processing execution unit (A) reads the first data from the first data set, and acquires a first value from the first data based on first format information acquired from an application, (B) generates one or more threads for respectively reading one or more second data corresponding to the first value from the second data set based on first reference information acquired from the application, (C) executes (A) and (B) on one or more first data in the first data set, and (D) executes a plurality of the threads in parallel.

    摘要翻译: 并行数据处理系统包括并行数据处理执行单元,用于从包括多个第一数据的第一数据集和包括多个第二数据和执行处理的第二数据集的数据集读取数据。 并行数据处理执行单元(A)从第一数据集读取第一数据,并根据从应用获得的第一格式信息从第一数据获取第一值,(B)生成一个或多个线程,分别读取一个 (C)对第一数据集中的一个或多个第一数据执行(A)和(B),和(D)对应于来自第二数据集的第一值的第二数据; )并行地执行多个线程。

    DATABASE MANAGEMENT SYSTEM, COMPUTER, AND DATABASE MANAGEMENT METHOD
    7.
    发明申请
    DATABASE MANAGEMENT SYSTEM, COMPUTER, AND DATABASE MANAGEMENT METHOD 有权
    数据库管理系统,计算机和数据库管理方法

    公开(公告)号:US20150112966A1

    公开(公告)日:2015-04-23

    申请号:US14397051

    申请日:2012-04-27

    IPC分类号: G06F17/30

    摘要: A database management system (DBMS) generates a query execution plan including information indicating one or more database (DB) operations necessary to execute the query. The DBMS dynamically generates a task for executing the DB operation in execution of the query. The DBMS performs a determination processing of simultaneous-task-generation number when newly creating a task. The determination processing of simultaneous-task-generation number is to calculate the number of simultaneous task generation, which is the number of tasks that can be generated simultaneously, based on the number of tasks which can be newly generated, a first memory resource amount which is the amount of memory resources necessary to be allocated per task newly generated, and a second memory resource amount which is the number of memory resources that can be newly allocated. The number of tasks generated dynamically and simultaneously is equal to or smaller than the calculated number of simultaneously generatable tasks.

    摘要翻译: 数据库管理系统(DBMS)生成查询执行计划,其包括指示执行查询所必需的一个或多个数据库(DB)操作的信息。 DBMS在执行查询时动态生成执行DB操作的任务。 当新创建任务时,DBMS执行同时任务生成次数的确定处理。 同时任务生成号的确定处理是基于可以新生成的任务的数量来计算同时任务生成的次数,即同时生成的任务的数量,第一存储器资源量 是每个新生成的任务需要分配的内存资源量,以及作为新分配的存储器资源的数量的第二存储器资源量。 动态和同时生成的任务数量等于或小于计算出的同时可生成任务的数量。

    Method and system for data processing with database reorganization for the same
    8.
    发明申请
    Method and system for data processing with database reorganization for the same 有权
    用于数据重组的数据处理方法和系统相同

    公开(公告)号:US20060085488A1

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

    申请号:US11080648

    申请日:2005-03-16

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30339

    摘要: To provide a storage system that carries out database reorganization processing. Provided is a method of reorganizing, upon request from a host computer, a database which is stored in a disk drive of a storage device, the disk drive containing a first volume where the database is stored and a second volume paired with the first volume to store a copy of the database, and the reorganization method comprising the steps of: making a transaction of the host computer quiescent state; splitting the paired first volume and second volume to be accessed the only database in the first volume; releasing the quiescent state of the transaction; reorganizing the second volume; and copying data in the second volume to the first volume to resynchronize and pair the first volume and the second volume with each other.

    摘要翻译: 提供进行数据库重组处理的存储系统。 提供了一种根据主计算机请求重新组织存储在存储设备的磁盘驱动器中的数据库的方法,所述磁盘驱动器包含存储数据库的第一卷和与第一卷配对的第二卷 存储数据库的副本,并且重组方法包括以下步骤:进行主计算机静止状态的交易; 将配对的第一卷和第二卷拆分为第一卷中唯一的数据库; 释放交易的静止状态; 重组第二卷; 以及将所述第二卷中的数据复制到所述第一卷,以使所述第一卷和所述第二卷彼此重新同步并配对。