公开(公告)号：US09710515B2

公开(公告)日：2017-07-18

申请号：US14404525

申请日：2012-05-31

Applicant: Hideomi Idei ,  Norifumi Nishikawa ,  Nobuo Kawamura ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Masashi Toyoda ,  Kazuo Goda

Inventor： Hideomi Idei ,  Norifumi Nishikawa ,  Nobuo Kawamura ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Masashi Toyoda ,  Kazuo Goda

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30445 ,  G06F17/30557

Abstract: This analysis system analyzes the behavior of a DBMS in a computer system having a computer which executes tasks in parallel and reads data from a database (DB) when executing a query. This analysis system acquires the number of selected rows corresponding to a key value of an index key used in the query, and calculates a model-based predicted degree of processing parallelism of the processing corresponding to the query. The system acquires, from the storage device, event information on an input-output event with respect to the storage medium when the processing corresponding to the query is executed actually, calculates a measured degree of processing parallelism when the processing corresponding to the query is executed actually, based on the event information, and displays information based on the model-based predicted degree of processing parallelism and the measured degree of processing parallelism.

公开(公告)号：US20150169591A1

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

申请号：US14402878

申请日：2012-05-24

Applicant: Michiko Yoshida ,  Akira Shimizu ,  Seisuke Tokuda ,  Kazuhiko Mogi ,  Shinji Fujiwara ,  Nobuo Kawamura ,  Masaru Kitsuregawa ,  Kazuo Goda

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

IPC: G06F17/30

CPC classification number: G06F16/252 ,  G06F16/24532 ,  G06F16/2455 ,  G06F16/24569

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

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

公开(公告)号：US08423825B2

公开(公告)日：2013-04-16

申请号：US13115333

申请日：2011-05-25

Applicant: Yoshiaki Eguchi ,  Kazuhiko Mogi ,  Yasutomo Yamamoto ,  Takashi Oeda ,  Kouji Arai

Inventor： Yoshiaki Eguchi ,  Kazuhiko Mogi ,  Yasutomo Yamamoto ,  Takashi Oeda ,  Kouji Arai

IPC: G06F11/00

CPC classification number: G06F11/142 ,  G06F11/1469 ,  G06F11/1471 ,  Y10S707/99953

Abstract: The storage system is coupled to a computer and includes a plurality of physical storages being used to configure a first logical storage and a second logical storage, a control unit receiving a read request and a write request from the computer; and a cache memory storing data which is sent to the computer. The control unit determines whether a request from the computer is a write request or a read request. If it is a read request, the control unit reads data from the cache memory or at least one of the plurality of physical storages based on the read request. If it is a write request, the control unit determines whether destination of the write request is the first logical storage.

Abstract translation: 存储系统耦合到计算机并且包括用于配置第一逻辑存储器和第二逻辑存储器的多个物理存储器，从计算机接收读取请求和写入请求的控制单元; 以及存储发送到计算机的数据的高速缓冲存储器。 控制单元确定来自计算机的请求是写请求还是读请求。 如果是读取请求，则控制单元基于读取的请求从高速缓冲存储器或多个物理存储器中的至少一个读取数据。 如果是写请求，则控制单元确定写请求的目的地是否是第一逻辑存储。

公开(公告)号：US20110225455A1

公开(公告)日：2011-09-15

申请号：US13115333

申请日：2011-05-25

Applicant: Yoshiaki Eguchi ,  Kazuhiko Mogi ,  Yasutomo Yamamoto ,  Takashi Oeda ,  Kouji Arai

Inventor： Yoshiaki Eguchi ,  Kazuhiko Mogi ,  Yasutomo Yamamoto ,  Takashi Oeda ,  Kouji Arai

IPC: G06F11/00

CPC classification number: G06F11/142 ,  G06F11/1469 ,  G06F11/1471 ,  Y10S707/99953

Abstract: The storage system is coupled to a computer and includes a plurality of physical storages being used to configure a first logical storage and a second logical storage, a control unit receiving a read request and a write request from the computer; and a cache memory storing data which is sent to the computer. The control unit determines whether a request from the computer is a write request or a read request. If it is a read request, the control unit reads data from the cache memory or at least one of the plurality of physical storages based on the read request. If it is a write request, the control unit determines whether destination of the write request is the first logical storage.

Abstract translation: 存储系统耦合到计算机并且包括用于配置第一逻辑存储器和第二逻辑存储器的多个物理存储器，从计算机接收读取请求和写入请求的控制单元; 以及存储发送到计算机的数据的高速缓冲存储器。 控制单元确定来自计算机的请求是写请求还是读请求。 如果是读取请求，则控制单元基于读取的请求从高速缓冲存储器或多个物理存储器中的至少一个读取数据。 如果是写请求，则控制单元确定写请求的目的地是否是第一逻辑存储。

公开(公告)号：US07865772B2

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

申请号：US11968209

申请日：2008-01-02

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

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

IPC: G06F11/00

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

公开(公告)号：US07693879B2

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

申请号：US11706245

申请日：2007-02-15

Applicant: Norifumi Nishikawa ,  Kazuhiko Mogi ,  Hideomi Idei ,  Yoshiaki Eguchi

Inventor： Norifumi Nishikawa ,  Kazuhiko Mogi ,  Hideomi Idei ,  Yoshiaki Eguchi

IPC: G06F17/30

CPC classification number: G06F11/2069 ,  G06F11/2058 ,  G06F11/2082 ,  G06F17/30578 ,  Y10S707/99953

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

公开(公告)号：US20090089614A1

公开(公告)日：2009-04-02

申请号：US12258498

申请日：2008-10-27

Applicant: Yoshiaki Eguchi ,  Kazuhiko Mogi ,  Yasutomo Yamamoto ,  Takashi Oeda ,  Kouji Arai

Inventor： Yoshiaki Eguchi ,  Kazuhiko Mogi ,  Yasutomo Yamamoto ,  Takashi Oeda ,  Kouji Arai

IPC: G06F11/00 ,  G06F12/00

CPC classification number: G06F11/142 ,  G06F11/1469 ,  G06F11/1471 ,  Y10S707/99953

Abstract: A host and a storage system each keep a shared identifier indicating a state of a system. The storage system acquires, at update of data, a data pair including data for a change through processing of the host and data before the update. The storage system relates the data pair to a shared identifier. When the host indicates an identifier, the storage system restores data using the data pair.

Abstract translation: 主机和存储系统各自保持指示系统状态的共享标识符。 存储系统在更新数据时，通过处理主机和更新之前的数据来获取包括用于改变的数据的数据对。 存储系统将数据对与共享标识相关联。 当主机指示标识符时，存储系统使用数据对恢复数据。

公开(公告)号：US07506012B2

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

申请号：US11153439

申请日：2005-06-16

Applicant: Norifumi Nishikawa ,  Kazuhiko Mogi ,  Nobuo Kawamura

Inventor： Norifumi Nishikawa ,  Kazuhiko Mogi ,  Nobuo Kawamura

IPC: G06F12/00

CPC classification number: G06F3/0665 ,  G06F3/0605 ,  G06F3/064 ,  G06F3/0653 ,  G06F3/067 ,  Y10S707/99956

Abstract: A computer is used in a computer system including multiple physical storage areas for storing database data. The database includes component information having a reference item having plural value ranges. The database data is dividable according to value ranges of the reference item. The computer comprises an access frequency obtaining module and a data allocation module. The access frequency obtaining module obtains, for each value range of the reference item in the component information, an estimated access frequency for data of the component information. The data allocation module allocates, based on the obtained estimated access frequency, data of the component information divided according to the value ranges of the reference item to the physical storage areas to be stored.

Abstract translation: 在计算机系统中使用计算机，包括用于存储数据库数据的多个物理存储区域。 数据库包括具有多个值范围的参考项的组件信息。 数据库数据可以根据参考项的值范围进行分割。 计算机包括访问频率获取模块和数据分配模块。 访问频率获取模块针对分量信息中的参考项目的每个值范围获得用于分量信息的数据的估计访问频率。 数据分配模块基于获得的估计访问频率，将根据参考项目的值范围划分的分量信息的数据分配给要存储的物理存储区域。

公开(公告)号：US20070266216A1

公开(公告)日：2007-11-15

申请号：US11879548

申请日：2007-07-17

Applicant: Hiroshi Arakawa ,  Kazuhiko Mogi ,  Yoshiaki Eguchi ,  Kouji Arai

Inventor： Hiroshi Arakawa ,  Kazuhiko Mogi ,  Yoshiaki Eguchi ,  Kouji Arai

IPC: G06F12/02

CPC classification number: G06F3/0613 ,  G06F3/0605 ,  G06F3/0608 ,  G06F3/0631 ,  G06F3/0635 ,  G06F3/0647 ,  G06F3/0659 ,  G06F3/067 ,  G06F11/1096 ,  G06F11/2087 ,  G06F12/0866 ,  H04L29/12179 ,  H04L61/1582 ,  Y10S707/99953 ,  Y10S707/99955

Abstract: The present invention provides techniques, including a method and system, for relocating data between storage systems. In one embodiment of the present invention a host collects usage information from a plurality of storage systems, and determines the relocation destination LU for data stored in the LU to be relocated. The host alters an LU logical position name table that determines matching between the logical position names of data and LUs. It also carries out data relocation between storage subsystems by shifting data stored in an origin LU to be relocated to a destination LU. In another embodiment relocation of files is provided.

公开(公告)号：US07237066B2

公开(公告)日：2007-06-26

申请号：US11443719

申请日：2006-05-30

Applicant: Kazuhiko Mogi ,  Norifumi Nishikawa

Inventor： Kazuhiko Mogi ,  Norifumi Nishikawa

IPC: G06F12/00 ,  G06F13/00

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.

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