Computer system, computer, data access method and database system
    62.
    发明授权
    Computer system, computer, data access method and database system 有权
    计算机系统,计算机,数据访问方法和数据库系统

    公开(公告)号:US07693816B2

    公开(公告)日:2010-04-06

    申请号:US11048290

    申请日:2005-01-31

    CPC classification number: G06F17/30595 G06F17/30457 G06F17/3048

    Abstract: There is a program for transmitting a prefetch command to a database management system (DBMS) so that access data of the DBMS can be prefetched to a storage. The DBMS is able to generate an access plan conscious of prefetch and to access database (DB). The DBMS is, however, unable to recognize that a prefetch command program is halted and it cannot generate an access plan at a proper I/O cost. Database management system servers 1, 2, . . . monitor a prefetch program of a management server 5, understands that the prefetch program is halted and it can optimize an execution plan to access storage apparatus 3, 4, . . . by using an I/O cost changed when the prefetch program is halted.

    Abstract translation: 存在用于将预取命令发送到数据库管理系统(DBMS)的程序,使得DBMS的访问数据可以被预取到存储器。 DBMS能够生成访问计划,意识到预取和访问数据库(DB)。 然而,DBMS无法识别预取命令程序被停止,并且不能以正确的I / O代价生成访问计划。 数据库管理系统服务器1,2,。 。 。 监视管理服务器5的预取程序,理解预取程序被停止,并且可以优化执行计划以访问存储设备3,4。 。 。 通过使用在预取程序停止时改变的I / O成本。

    Method of reducing storage power consumption by use of prefetch and computer system using the same
    63.
    发明申请
    Method of reducing storage power consumption by use of prefetch and computer system using the same 有权
    使用预取功能降低存储功耗的方法及使用其的计算机系统

    公开(公告)号:US20090112894A1

    公开(公告)日:2009-04-30

    申请号:US12007936

    申请日:2008-01-17

    CPC classification number: G11B19/02

    Abstract: Provided is a computer system including: a computer running as a DB server; a storage system including a plurality of disk drives for storing data; and a management module, in which: at least one of the plurality of disk drives stores data of a DB schema written by the computer; the management module specifies the DB schema to be accessed based on a received query, transmits, to the storage system, an instruction to copy at least a portion of the data of the specified DB schema from the disk drive to a memory, and transmits, to the storage system, an instruction to control an rpm of the disk drive that stores the data of the specified DB schema; and the storage system controls the rpm of the disk drive based on the instruction. Accordingly, power consumption of the storage system can be reduced even if installed disks increase in number.

    Abstract translation: 提供了一种计算机系统,包括:作为DB服务器运行的计算机; 包括用于存储数据的多个盘驱动器的存储系统; 以及管理模块,其中:所述多个磁盘驱动器中的至少一个磁盘驱动器存储由所述计算机写入的DB模式的数据; 管理模块基于接收到的查询指定要访问的DB模式,向存储系统发送将指定的DB模式的数据的至少一部分的副本从盘驱动器复制到存储器的指令, 向存储系统提供控制存储指定DB模式的数据的磁盘驱动器的rpm的指令; 并且存储系统基于指令控制磁盘驱动器的rpm。 因此,即使安装的盘数量增加,也可以减少存储系统的功耗。

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

    公开(公告)号:US07472139B2

    公开(公告)日:2008-12-30

    申请号:US11386982

    申请日:2006-03-23

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

    Computer system
    65.
    发明授权
    Computer system 失效
    电脑系统

    公开(公告)号:US07313662B2

    公开(公告)日:2007-12-25

    申请号:US11526047

    申请日:2006-09-25

    Abstract: A method include a configuration definition creation step of writing configuration information on a primary site into a storage subsystem; a data transfer step of copying the configuration information, which is written into a storage device, to a storage subsystem in a secondary site over a network; a data reception step of receiving the transferred configuration information and storing it in the storage subsystem in the secondary site; and a configuration definition step of reading the stored configuration information and settings up a server in the secondary site.

    Abstract translation: 一种方法包括:将主站点上的配置信息写入到存储子系统中的配置定义创建步骤; 数据传送步骤,将写入存储装置的配置信息复制到通过网络的辅助站点中的存储子系统; 数据接收步骤,接收所传送的配置信息并将其存储在辅助站点中的存储子系统中; 以及配置定义步骤,用于读取存储的配置信息并设置辅助站点中的服务器。

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

    公开(公告)号:US20070250475A1

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

    申请号:US11482337

    申请日:2006-07-07

    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模式的存储位置,并且旋转包括 指定的存储位置以第一速率。

    Information processing system and system setting method
    69.
    发明授权
    Information processing system and system setting method 有权
    信息处理系统和系统设置方法

    公开(公告)号:US07171423B2

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

    申请号:US10650773

    申请日:2003-08-29

    Abstract: An objective of the present invention is to carry out setting efficiently both a database management system and a storage subsystem. In an information processing system having computers 1, 2 and the storage subsystem 3, the following processes are executed. A system definition program 5 in the computer 1 generates based on the database design information, database definition information defining a structure of plural tables constituting the database and storage location volume of data of the plural tables, and volume definition information defining a condition for determining a volume configuration. A volume definition program 6 in the storage subsystem 3 determines based on the volume definition information from the management server 1, a storage device configuring the volume out of plural storage devices 36a . . . 36p. A database management system program 9 in the computer 2 stores the data of each table in the volume of the storage subsystem 3, based on the definition information from the management server 1, and accesses the volume in response to a request from outside.

    Abstract translation: 本发明的目的是有效地实现数据库管理系统和存储子系统的设置。 在具有计算机1,2和存储子系统3的信息处理系统中,执行以下处理。 计算机1中的系统定义程序5基于数据库设计信息生成数据库定义信息,定义构成数据库的多个表的结构的数据库定义信息和多个表的数据的存储位置量,以及定义用于确定 音量配置。 存储子系统3中的卷定义程序6基于来自管理服务器1的卷定义信息来确定构成多个存储装置36a中的卷的存储装置。 。 。 36 p。 计算机2中的数据库管理系统程序9基于来自管理服务器1的定义信息,将每个表的数据存储在存储子系统3的卷中,并响应于来自外部的请求而访问该卷。

    Method of controlling a database management system by changing allocation of cache memory
    70.
    发明申请
    Method of controlling a database management system by changing allocation of cache memory 有权
    通过改变高速缓冲存储器的分配来控制数据库管理系统的方法

    公开(公告)号:US20070016716A1

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

    申请号:US11259894

    申请日:2005-10-26

    Abstract: Provided is a computer system, including: at least one of database computers, in which a database management system operates; a storage system for storing a database operated by the database management system; and a management computer for managing the database computer and the storage system, the storage system having a cache memory for storing data temporarily and a physical disk drive for storing the database, in which the management computer changes capacity of the cache memory which is allocated to the database computer where the database management system operates, and instructs the database management system to change an access plan according to the change in capacity of the cache memory allocated to the database computer.

    Abstract translation: 提供一种计算机系统,包括:数据库计算机中的至少一个,其中数据库管理系统操作; 用于存储由数据库管理系统操作的数据库的存储系统; 以及用于管理数据库计算机和存储系统的管理计算机,所述存储系统具有临时存储数据的高速缓存存储器和用于存储数据库的物理磁盘驱动器,其中管理计算机改变被分配给 数据库管理系统操作的数据库计算机,并且指示数据库管理系统根据分配给数据库计算机的高速缓冲存储器容量的变化来改变访问计划。

Patent Agency Ranking