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

    公开(公告)号:US20150112966A1

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

    申请号:US14397051

    申请日:2012-04-27

    CPC classification number: G06F17/30463 G06F9/4843 G06F17/30477 G06F2209/485

    Abstract: 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.

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

    Computer system and method for reducing power consumption of storage system
    82.
    发明授权
    Computer system and method for reducing power consumption of storage system 有权
    用于降低存储系统功耗的计算机系统和方法

    公开(公告)号:US08196034B2

    公开(公告)日:2012-06-05

    申请号:US12327593

    申请日:2008-12-03

    Abstract: A disk rotation control part for controlling the rotations of a plurality of disk devices is provided. The configuration is such that a disk of a disk device for which an access will not be generated is rotated at a second rate of speed, which is faster than 0, and slower than a first rate of speed, which is the rotation speed at access time. DB management information comprises information denoting which DB schema inside a DB is stored in which location. The disk rotation control part, based on a query plan of a query received by the DBMS, and DB management information, specifies the storage location of a DB schema to be accessed when this query is processed, and rotates a disk of the disk device comprising the specified storage location at a first rate of speed.

    Abstract translation: 提供一种用于控制多个盘装置的旋转的盘旋转控制部。 该配置使得不会生成访问的盘装置的盘以比0快的第二速度旋转,并且比作为访问时的转速的第一速度速度慢 时间。 DB管理信息包括表示DB中哪个DB模式存储在哪个位置的信息。 基于由DBMS接收到的查询的查询计划和DB管理信息的盘旋转控制部分指定在处理该查询时要访问的DB模式的存储位置,并且旋转包括 指定的存储位置以第一速率。

    Database recovery method applying update journal and database log
    83.
    发明授权
    Database recovery method applying update journal and database log 有权
    应用更新日志和数据库日志的数据库恢复方法

    公开(公告)号:US07991749B2

    公开(公告)日:2011-08-02

    申请号:US12329143

    申请日:2008-12-05

    Abstract: A database recovery method including a computer and a storage system, in which: the storage system includes a disk drive for storing data; the disk drive includes a data volume, a snapshot volume, a database log for storing an update log, and an update journal for storing update information of the data volume; a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied is recorded to recover the data volume; and when the database is to be recovered, the update journal is applied to the snapshot volume up to the recovery point, the snapshot volume after the update is switched to the data volume, and the database log after the recovery point is applied to the data volume that is set by switching.

    Abstract translation: 一种包括计算机和存储系统的数据库恢复方法,其中:存储系统包括用于存储数据的磁盘驱动器; 磁盘驱动器包括数据卷,快照卷,用于存储更新日志的数据库日志和用于存储数据卷的更新信息的更新日志; 记录用于指示要应用更新日志的范围的终点的恢复点和要应用数据库日志的范围的起始点,以恢复数据量; 要恢复数据库时,将更新日志应用于直到恢复点的快照卷,将更新后的快照卷切换到数据卷,并将恢复点后的数据库日志应用于数据 通过切换设置的音量。

    Cache memory managing method for computer system
    85.
    发明授权
    Cache memory managing method for computer system 有权
    计算机系统缓存存储管理方法

    公开(公告)号:US07500058B2

    公开(公告)日:2009-03-03

    申请号:US11810462

    申请日:2007-06-05

    Abstract: A computer system acquires mapping information of data storage regions in respective layers from a layer of DBMSs to a layer of storage subsystems, grasps correspondence between DB data and storage positions of each storage subsystem on the basis of the mapping information, decides a cache partitioning in each storage subsystem on the basis of the correspondence and sets the cache partitioning for each storage subsystem. When cache allocation in the DBMS or the storage subsystem needs to be changed, information for estimating the cache effect due to the change in cache allocation acquired by the DBMS is used for estimating the cache effect in the storage subsystem.

    Abstract translation: 计算机系统从DBMS到一层存储子系统获取各层数据存储区域的映射信息,根据映射信息掌握DB数据和每个存储子系统的存储位置之间的对应关系,决定高速缓存分区 每个存储子系统基于对应关系,并设置每个存储子系统的高速缓存分区。 当DBMS或存储子系统中的缓存分配需要改变时,用于估计由DBMS获取的高速缓存分配变化引起的高速缓存效应的信息用于估计存储子系统中的高速缓存效应。

    Computer system, storage subsystem, and write processing control method
    86.
    发明授权
    Computer system, storage subsystem, and write processing control method 有权
    计算机系统,存储子系统和写入处理控制方法

    公开(公告)号:US07325096B2

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

    申请号:US11182867

    申请日:2005-07-18

    Abstract: A computer system is provided with a collection section for collecting load information related to an application server and a storage subsystem, a transmission section for predicting a write processing property based on the load information collected by the collection section and for transmitting the write processing property to the storage subsystem, and a write control section for controlling a write processing to a hard disk drive in the storage subsystem based on the write processing property transmitted by the transmission section. A target of the writable cache amount is set so that a write processing amount from a cache of the storage subsystem to the hard disk drive is averaged in terms of time, and the write processing to the hard disk drive is performed to satisfy the target of the writable cache amount.

    Abstract translation: 计算机系统具备收集部,用于收集与应用服务器和存储子系统相关的负载信息;发送部,其基于由所述收集部收集的负载信息来预测写入处理特性,并将所述写入处理属性发送到 存储子系统,以及写入控制部分,用于基于由传输部分发送的写入处理属性来控制对存储子系统中的硬盘驱动器的写入处理。 可写高速缓存量的目标被设置为使得从存储子系统的高速缓存到硬盘驱动器的写入处理量在时间上被平均,并且执行对硬盘驱动器的写入处理以满足目标 可写缓存量。

    Database system including center server and local servers
    87.
    发明申请
    Database system including center server and local servers 有权
    数据库系统包括中心服务器和本地服务器

    公开(公告)号:US20070143362A1

    公开(公告)日:2007-06-21

    申请号:US11706245

    申请日:2007-02-15

    Abstract: A database system includes a center server and local servers. The center server includes a replication requesting unit, a data consolidating unit including a center DB freeze requesting unit and a center DB freeze release requesting unit, a replication source managing table and a data consolidation completion notifying unit. Each of the local servers includes a local DB freeze requesting unit, a remote volume split requesting unit, a remote volume split completion notifying unit and a local DB freeze release requesting unit. The center server permits replications of local DB's in local storage subsystems to be created in the center storage subsystem and accesses shadow images of the replications to give a consolidated access to the plurality of local DB's.

    Abstract translation: 数据库系统包括中心服务器和本地服务器。 中央服务器包括复制请求单元,数据合并单元,包括中央DB冻结请求单元和中央DB冻结释放请求单元,复制源管理表和数据合并完成通知单元。 每个本地服务器包括本地数据库冻结请求单元,远程卷分离请求单元,远程卷拆分完成通知单元和本地数据库冻结释放请求单元。 中心服务器允许在中央存储子系统中创建本地存储子系统中的本地数据库的复制,并访问复制的阴影映像,以对多个本地数据库进行统一访问。

    Prefetch appliance server
    89.
    发明申请
    Prefetch appliance server 失效
    预取设备服务器

    公开(公告)号:US20070005660A1

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

    申请号:US11455047

    申请日:2006-06-19

    CPC classification number: G06F12/0862

    Abstract: In a system in which a DB is built in a virtualization environment, a management server obtains DB processing information such as a DB processing execution plan and a degree of processing priority from a DBMS, predicts data to be accessed in the near future and the order of such accesses based on the information, instructs to read into caches of storage devices data to be accessed in the near future based on the prediction results, and reads the data that will be accessed in the nearest future into a cache memory within the management server.

    Abstract translation: 在虚拟化环境中构建DB的系统中,管理服务器从DBMS中获取数据库处理执行计划和处理优先级的DB处理信息,预测在不久的将来访问的数据和顺序 基于该信息进行这样的访问,指示基于该预测结果,在不久的将来读取存储装置要访问的数据的高速缓存,并将最近将要访问的数据读入管理服务器内的高速缓冲存储器 。

Patent Agency Ranking