公开(公告)号：US20150112965A1

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

申请号：US14397030

申请日：2012-04-27

申请人： Seisuke Tokuda ,  Akira Shimizu ,  Michiko Yoshida ,  Shinji Fujiwara ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Kazuo Goda

发明人： Seisuke Tokuda ,  Akira Shimizu ,  Michiko Yoshida ,  Shinji Fujiwara ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Kazuo Goda

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30483

摘要： A database management system (DBMS) generates a query execution plan including information representing one or more database (DB) operations necessary for executing a query, and executes the query in accordance with the query execution plan. In the execution of the query, the DBMS dynamically generates tasks for executing the DB operations and executes the dynamically generated tasks. The query execution plan includes a plurality of query blocks, which are sets of one or more DB operations. When newly generating a task, the DBMS executes determination processing of simultaneous-task-generation number. The determination processing of simultaneous-task-generation number is to calculate, targeting each of the query blocks, the number of simultaneous task generation, which is the number of tasks simultaneously generatable as tasks for executing the query block. The number of the dynamically generated tasks is equal to or smaller than the number of simultaneous task generation.

摘要翻译： 数据库管理系统（DBMS）生成查询执行计划，包括表示执行查询所需的一个或多个数据库（DB）操作的信息，并根据查询执行计划执行查询。 在执行查询时，DBMS动态生成用于执行DB操作的任务，并执行动态生成的任务。 查询执行计划包括多个查询块，其是一个或多个DB操作的集合。 当新生成任务时，DBMS执行同时任务生成号码的确定处理。 同时任务生成号码的确定处理是针对每个查询块来计算同时任务生成的次数，其是同时生成作为执行查询块的任务的任务数量。 动态生成的任务的数量等于或小于同时任务生成的次数。

公开(公告)号：US08036076B2

公开(公告)日：2011-10-11

申请号：US12007936

申请日：2008-01-17

申请人： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

发明人： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

IPC分类号： G11B17/00 ,  G06F7/00

CPC分类号： G11B19/02

摘要： 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.

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

公开(公告)号：US07552138B2

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

申请号：US11247210

申请日：2005-10-12

申请人： Naokazu Nemoto ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Nobuo Kawamura

发明人： Naokazu Nemoto ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Nobuo Kawamura

IPC分类号： G06F17/00

CPC分类号： G06F11/0775 ,  G06F3/0617 ,  G06F3/0635 ,  G06F3/067 ,  G06F11/0709 ,  G06F11/0727 ,  G06F11/0748 ,  G06F11/2294 ,  H04L67/1097 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.

公开(公告)号：US07512680B2

公开(公告)日：2009-03-31

申请号：US10871814

申请日：2004-06-21

申请人： Norifumi Nishikawa ,  Kazuhiko Mogi

发明人： Norifumi Nishikawa ,  Kazuhiko Mogi

IPC分类号： G06F15/16

CPC分类号： G06F11/3495 ,  G06F11/3409 ,  G06F11/3433 ,  G06F2201/80 ,  G06F2201/87 ,  G06F2201/885

摘要： A second computer for monitoring a database management system and a storage subsystem introduced into a first computer, is provided with a step of acquiring profile information of an application, a step of determining a tuning item in accordance with the acquired profile information, and a step of transferring the determined tuning item to the first computer and the storage subsystem.

摘要翻译： 用于监视引入到第一计算机中的数据库管理系统和存储子系统的第二计算机被提供有获取应用的简档信息的步骤，根据获取的简档信息确定调整项目的步骤，以及步骤 将确定的调谐项目传送到第一计算机和存储子系统。

公开(公告)号：US07509331B2

公开(公告)日：2009-03-24

申请号：US11247160

申请日：2005-10-12

申请人： Naokazu Nemoto ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Nobuo Kawamura

发明人： Naokazu Nemoto ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Nobuo Kawamura

IPC分类号： G06F17/00

CPC分类号： G06F11/0775 ,  G06F3/0617 ,  G06F3/0635 ,  G06F3/067 ,  G06F11/0709 ,  G06F11/0727 ,  G06F11/0748 ,  G06F11/2294 ,  H04L67/1097 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.

摘要翻译： 计算机系统识别受存储系统中的任何设备或机制中发生的故障影响的作业，以控制这些作业的执行。 计算机系统包括DBMS服务器设备，虚拟交换设备和存储设备。 这些设备中的每一个将数据映射路径上的数据映射信息的一部分保存在通过用于存储表的逻辑卷的作业所访问的特定DB表的数据映射路径到用于在卷上分布式地存储数据的物理磁盘单元。 管理服务器设备从每个设备获取部分数据映射信息，并且逐个工作地整合数据映射信息。 当任何设备或机制在数据映射路径上发生故障时，管理服务器设备将参考数据映射信息来识别受故障影响的作业。 管理服务器设备还控制这些作业的执行。

公开(公告)号：US20080301151A1

公开(公告)日：2008-12-04

申请号：US11968681

申请日：2008-01-03

申请人： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

发明人： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

IPC分类号： G06F17/30

CPC分类号： G06F17/3048 ,  G06F17/30492

摘要： 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.

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

公开(公告)号：US07266718B2

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

申请号：US10820858

申请日：2004-04-09

申请人： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

发明人： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

IPC分类号： G06F11/00

CPC分类号： G06F11/2074 ,  G06F11/2076

摘要： In the present invention, there is provided means which sets priorities of DB data for each management unit, means which copies data from a primary site to a secondary site in an order of the data priorities, and means which, when a disaster has occurred in the primary site and recovery of a DB is performed in the secondary site, performs recovery of data in the order of the data priorities to sequentially bring the data to a usable state.

摘要翻译： 在本发明中，提供了为每个管理单元设置DB数据的优先级的装置，以数据优先级的顺序将数据从主站点复制到次要站点的装置，以及在发生灾难时 在辅助站点中执行DB的主站点和恢复，按照数据优先级的顺序执行数据恢复，以顺序地将数据带入可用状态。

公开(公告)号：US20060224825A1

公开(公告)日：2006-10-05

申请号：US11182867

申请日：2005-07-18

申请人： Kazuhiko Mogi ,  Norifumi Nishikawa

发明人： Kazuhiko Mogi ,  Norifumi Nishikawa

IPC分类号： G06F13/00

CPC分类号： G06F12/0804 ,  G06F11/3433 ,  G06F11/3466 ,  G06F11/3485 ,  G06F12/0866 ,  H04L67/1097

摘要： 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.

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

公开(公告)号：US20060184502A1

公开(公告)日：2006-08-17

申请号：US11378764

申请日：2006-03-17

申请人： Kyosuke Achiwa ,  Kazuhiko Mogi ,  Manabu Kitamura ,  Yoshiki Kano ,  Katsunori Nakamura

发明人： Kyosuke Achiwa ,  Kazuhiko Mogi ,  Manabu Kitamura ,  Yoshiki Kano ,  Katsunori Nakamura

IPC分类号： G06F17/30

CPC分类号： G06F11/2071 ,  G06F11/2069 ,  Y10S707/99955

摘要： An object of remote copy can be specified in units of a file or a directory more detailed than in units of a volume. If a host computer issues a write request of a file to NASa, NASa references a source NAS of remote copy and a source directory of remote copy at each entry on a copy file table and determines whether the file to be written is an object of remote copy; if it is determined to be an object of remote copy, the file to be written is remotely copied to a target directory of remote copy of a target NAS thereof.

公开(公告)号：US10747773B2

公开(公告)日：2020-08-18

申请号：US14402878

申请日：2012-05-24

申请人： Michiko Yoshida ,  Akira Shimizu ,  Seisuke Tokuda ,  Kazuhiko Mogi ,  Shinji Fujiwara ,  Nobuo Kawamura ,  Masaru Kitsuregawa ,  Kazuo Goda

发明人： Michiko Yoshida ,  Akira Shimizu ,  Seisuke Tokuda ,  Kazuhiko Mogi ,  Shinji Fujiwara ,  Nobuo Kawamura ,  Masaru Kitsuregawa ,  Kazuo Goda

IPC分类号： G06F16/25 ,  G06F16/2455 ,  G06F16/2453 ,  G06F16/245

摘要： 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.