公开(公告)号：US07865514B2

公开(公告)日：2011-01-04

申请号：US11968681

申请日：2008-01-03

Applicant: Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

Inventor： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

IPC: G06F17/30

CPC classification number: G06F17/3048 ,  G06F17/30492

Abstract: A pre-fetch server, which is connected to a DB server running a DBMS and to a storage apparatus storing DB data, stores information required for judging whether or not a pre-fetch is effective. Judgment on whether or not the pre-fetch will be effective is performed when a pre-fetch I/O is issued. If the pre-fetch server judges that the pre-fetch will be effective, it issues the pre-fetch I/O to the storage apparatus.

Abstract translation: 连接到运行DBMS的DB服务器和存储DB数据的存储装置的预取服务器存储用于判断预取是否有效所需的信息。 当发出预取I / O时，执行对提取是否有效的判断。 如果预取服务器判断预取将有效，则向存储设备发出预取I / O。

公开(公告)号：US07689573B2

公开(公告)日：2010-03-30

申请号：US11455047

申请日：2006-06-19

Applicant: Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Toyohiro Nomoto

Inventor： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Toyohiro Nomoto

IPC: G06F17/00 ,  G06F15/173

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处理信息，预测在不久的将来访问的数据和顺序 基于该信息进行这样的访问，指示基于该预测结果，在不久的将来读取存储装置要访问的数据的高速缓存，并将最近将要访问的数据读入管理服务器内的高速缓冲存储器 。

公开(公告)号：US20090125568A1

公开(公告)日：2009-05-14

申请号：US12329143

申请日：2008-12-05

Applicant: Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

Inventor： Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

IPC: G06F17/30 ,  G06F12/00 ,  G06F12/16

CPC classification number: G06F11/1471 ,  G06F2201/80 ,  G06F2201/84 ,  Y10S707/99945 ,  Y10S707/99953

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

公开(公告)号：US07475347B2

公开(公告)日：2009-01-06

申请号：US11482337

申请日：2006-07-07

Applicant: Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

Inventor： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

IPC: G06F15/00 ,  G06F13/00

CPC classification number: G06F3/0634 ,  G06F1/3203 ,  G06F1/3268 ,  G06F3/0625 ,  G06F3/0689 ,  G11B19/209 ,  Y02D10/154 ,  Y10S707/99932

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

公开(公告)号：US07441082B2

公开(公告)日：2008-10-21

申请号：US11028218

申请日：2005-01-04

Applicant: Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

Inventor： Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

IPC: G06F12/00 ,  G06F13/00 ,  G06F13/28

CPC classification number: H04L67/1097

Abstract: Data writing into a storage device. Data is written into a cache memory in order to implement speeding-up, and also the data is written into a physical disc asynchronously therewith. Since allocation of the cache memory is performed on each writing-request basis, a cut-out processing is required which is executed when none of available areas exists. This results in a problem of necessitating a writing processing time. A DBMS server in advance notifies the storage device that a writing will take place. A manager included in the storage device performs acquisition of the cache memory prior to the writing processing. This allows the data to be stored into the acquired cache memory at the time of the writing processing.

Abstract translation: 数据写入存储设备。 将数据写入高速缓冲存储器以实现加速，并且将数据与其异步地写入物理盘。 由于在每个写入请求的基础上执行高速缓冲存储器的分配，所以当没有可用区域存在时，需要执行切出处理。 这导致需要写入处理时间的问题。 DBMS服务器预先通知存储设备将进行写入。 包含在存储装置中的管理器在写入处理之前执行高速缓冲存储器的采集。 这允许在写入处理时将数据存储到获取的高速缓冲存储器中。

公开(公告)号：US20080184068A1

公开(公告)日：2008-07-31

申请号：US11968209

申请日：2008-01-02

Applicant: Kazuhiko Mogi ,  Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura

Inventor： Kazuhiko Mogi ,  Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura

IPC: G06F11/07

CPC classification number: G06F11/1469 ,  G06F11/1435 ,  G06F11/1464 ,  G06F11/1471 ,  G06F2201/80 ,  G06F2201/84

Abstract: A management device stores configuration history information indicating a history of system configuration changes, from this information, specifies a system configuration of a recovery time, which is a certain point in time in the past, specifies a system configuration of the current time, and compares the system configuration of the recovery time with the system configuration of the current time, and based on the results of this comparison, specifies whether or not there is a system configuration part in the system configuration of the current time for which, if data of the recovery time is recovered, a setting change is required in order to access this recovered data. When this system configuration part is specified, the management device constructs a system configuration for enabling a data utilization unit to access the recovered data by issuing an indication related to a required setting change to an element capable of carrying out the setting change for this system configuration part.

Abstract translation: 管理装置存储表示系统配置变更的历史的配置历史信息，从该信息指定恢复时间的系统配置，该恢复时间是过去的某个时间点，指定当前时间的系统配置，并比较 系统配置恢复时间与系统配置当前时间，并根据此比较的结果，指定系统配置中是否存在系统配置当前时间，如果数据为 恢复时间恢复，需要进行设置更改才能访问此恢复的数据。 当指定了该系统配置部分时，管理设备构造一个系统配置，使得数据利用单元通过向能够执行该系统配置的设置改变的元件发出与所需的设置改变相关的指示来访问恢复的数据 部分。

公开(公告)号：US07395371B2

公开(公告)日：2008-07-01

申请号：US11259894

申请日：2005-10-26

Applicant: Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

Inventor： Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

IPC: G06F12/00

CPC classification number: G06F12/0871 ,  G06F17/30289 ,  G06F17/30557 ,  G06F2212/465 ,  G06F2212/601 ,  Y10S707/99932 ,  Y10S707/99943

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

公开(公告)号：US20070245088A1

公开(公告)日：2007-10-18

申请号：US11810462

申请日：2007-06-05

Applicant: Kazuhiko Mogi ,  Norifumi Nishikawa

Inventor： Kazuhiko Mogi ,  Norifumi Nishikawa

IPC: G06F12/08

CPC classification number: G06F17/30339 ,  G06F12/0811 ,  G06F12/0866 ,  G06F12/0871 ,  G06F12/0873 ,  G06F12/0897 ,  G06F17/3048 ,  G06F2212/465 ,  Y10S707/99931

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.

公开(公告)号：US07284014B2

公开(公告)日：2007-10-16

申请号：US10849184

申请日：2004-05-20

Applicant: Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

Inventor： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

IPC: G06F7/00 ,  G06F12/00 ,  G06F17/30

CPC classification number: G06F17/30442 ,  G06F12/0862 ,  G06F2212/465 ,  Y10S707/99945 ,  Y10S707/99952

Abstract: A database (DB) server in which a database management system (DBMS) operates and a prefetch server connected to a storage device storing DB data are provided with an acquiring unit for acquiring information on a storage location on the storage device of a DB schema managed by the DBMS, information on DB processing executed by the DBMS, and information on an access to DB data made when the DBMS executes the DB processing, from the DB server, a predictor for predicting data to be read out on the basis of the acquired information, and a prefetch instructing unit for providing the storage device with an instruction to prefetch the corresponding data. Having received the prefetch instruction, the storage device reads out specified data onto a cache memory.

Abstract translation: 数据库管理系统（DBMS）操作的数据库（DB）服务器和连接到存储DB数据的存储设备的预取服务器被提供有获取单元，用于获取关于DB模式管理的存储设备上的存储位置的信息 由DBMS执行DBMS执行的DB处理的信息，以及关于当DBMS执行DB处理时对DB数据进行访问的信息，DB数据库服务器，用于基于获取的预测数据预测要读出的数据的预测器 信息和预取指示单元，用于向存储装置提供预取相应数据的指令。 在接收到预取指令之后，存储设备将指定的数据读出到高速缓冲存储器。

公开(公告)号：US07225196B2

公开(公告)日：2007-05-29

申请号：US10729536

申请日：2003-12-05

Applicant: Toyohiro Nomoto ,  Norifumi Nishikawa ,  Hideomi Idei ,  Kazuhiko Mogi

Inventor： Toyohiro Nomoto ,  Norifumi Nishikawa ,  Hideomi Idei ,  Kazuhiko Mogi

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30569 ,  Y10S707/99942 ,  Y10S707/99945

Abstract: A data conversion job used for data conversion is separated into a data conversion server job for executing conversion processing on a data conversion server and a storage job for instructing a copy of a table on a storage device. Then, the storage job is executed to instruct the storage device to copy the table. The data conversion server job is executed only for fields that need to be converted, and thereby data conversion is performed for the copied table.This makes it possible to reduce a load of the data conversion server when converting data of a database, and also to enable a designer of a data conversion job to easily design the data conversion job.

Abstract translation: 用于数据转换的数据转换作业被分成数据转换服务器作业，用于执行数据转换服务器上的转换处理和用于指示存储装置上的表的副本的存储作业。 然后，执行存储作业以指示存储装置复制该表。 仅对需要转换的字段执行数据转换服务器作业，从而对复制的表执行数据转换。 这使得可以在转换数据库的数据时减少数据转换服务器的负载，并且使数据转换作业的设计者能够容易地设计数据转换作业。