公开(公告)号：US20050267878A1

公开(公告)日：2005-12-01

申请号：US11182281

申请日：2005-07-14

申请人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

发明人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

IPC分类号： G06F12/08 ,  G06F12/00 ,  G06F17/30 ,  G06F7/00

CPC分类号： G06F17/3048 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A storage system for providing a preferable data access performance by performing controls considering database management system (DBMS) execution information or database process priorities, by acquiring static configurational information of a DBMS by means of a DBMS information acquisition and communication program, a DBMS information communication section, and a host information setting program; acquiring DBMS execution information by means of a query plan acquisition program, the DBMS information communication section, and a process performance management program; acquiring information on priorities of database processes given by the process performance management program; and storing them in disk I/O management information with process priorities, DBMS execution information, and DBMS data information, in which cache control section in a storage system control program controls a data cache by referring to the above information.

公开(公告)号：US07734616B2

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

申请号：US11182281

申请日：2005-07-14

申请人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

发明人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/3048 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A storage system for providing a preferable data access performance by performing controls considering database management system (DBMS) execution information or database process priorities, by acquiring static configurational information of a DBMS by means of a DBMS information acquisition and communication program, a DBMS information communication section, and a host information setting program; acquiring DBMS execution information by means of a query plan acquisition program, the DBMS information communication section, and a process performance management program; acquiring information on priorities of database processes given by the process performance management program; and storing them in disk I/O management information with process priorities, DBMS execution information, and DBMS data information, in which cache control section in a storage system control program controls a data cache by referring to the above information.

摘要翻译： 一种存储系统，其通过采用DBMS信息获取和通信程序获取DBMS的静态配置信息，通过DBMS信息获取和通信程序获取DBMS的静态配置信息，通过执行考虑到数据库管理系统（DBMS）执行信息或数据库处理优先级的控制来提供优选的数据访问性能 部分和主机信息设置程序; 通过查询计划获取程序，DBMS信息通信部分和过程执行管理程序获取DBMS执行信息; 获取过程绩效管理计划给出的数据库流程优先级信息; 并将它们存储在具有进程优先级的数据I / O管理信息，DBMS执行信息和DBMS数据信息中，其中存储系统控制程序中的高速缓存控制部分通过参考上述信息来控制数据高速缓存。

公开(公告)号：US06928451B2

公开(公告)日：2005-08-09

申请号：US10093682

申请日：2002-03-07

申请人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

发明人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

IPC分类号： G06F12/08 ,  G06F12/00 ,  G06F17/30

CPC分类号： G06F17/3048 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A storage system for providing a preferable data access performance by performing controls considering database management system (DBMS) execution information or database process priorities, by acquiring static configurational information of a DBMS by means of a DBMS information acquisition and communication program, a DBMS information communication section, and a host information setting program; acquiring DBMS execution information by means of a query plan acquisition program, the DBMS information communication section, and a process performance management program; acquiring information on priorities of database processes given by the process performance management program; and storing them in disk I/O management information with process priorities, DBMS execution information, and DBMS data information, in which cache control section in a storage system control program controls a data cache by referring to the above information.

摘要翻译： 一种存储系统，其通过采用DBMS信息获取和通信程序获取DBMS的静态配置信息，通过DBMS信息获取和通信程序获取DBMS的静态配置信息，通过执行考虑到数据库管理系统（DBMS）执行信息或数据库处理优先级的控制来提供优选的数据访问性能 部分和主机信息设置程序; 通过查询计划获取程序，DBMS信息通信部分和过程执行管理程序获取DBMS执行信息; 获取过程绩效管理计划给出的数据库流程优先级信息; 并将它们存储在具有进程优先级的数据I / O管理信息，DBMS执行信息和DBMS数据信息中，其中存储系统控制程序中的高速缓存控制部分通过参考上述信息来控制数据高速缓存。

公开(公告)号：US07054893B2

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

申请号：US10084540

申请日：2002-02-28

申请人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

发明人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

IPC分类号： G06F17/00

CPC分类号： G06F17/30312 ,  Y10S707/99953 ,  Y10S707/99956

摘要： A data storage position management main program collects volume physical storage position management information and physical storage apparatus operation information from a storage apparatus, and stores them as storage apparatus arrangement information and storage apparatus operation information. The program also collects necessary information from schema information in a DBMS, stores it as DBMS schema information, collects mapping information in a host and virtual volume information in a virtual volume switch, stores them as data storage position management information, acquires execution history information from the host, and stores it as a DBMS execution history information. The program determines a data relocation plan having a better performance characteristic on the basis of the above information.

公开(公告)号：US06928450B2

公开(公告)日：2005-08-09

申请号：US10083354

申请日：2002-02-27

申请人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

发明人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

IPC分类号： G06F12/08 ,  G06F3/06 ,  G06F12/00 ,  G06F17/30 ,  G07F17/30

CPC分类号： G06F17/30315 ,  Y10S707/99943

摘要： A storage apparatus acquires static constituent information of a database management system (DBMS) through a network by using a DBMS information acquisition/communication program, DBMS information communication portion, and host information setting program, and stores them as DBMS data information in its memory. The physical storage position managing/optimizing execution portion within a control program of the storage apparatus makes data allocation and cache control that consider the characteristics of the data base management system by using DBMS data information, thereby improving the data access performance of the storage apparatus.

摘要翻译： 存储装置通过使用DBMS信息获取/通信程序，DBMS信息通信部分和主机信息设定程序，通过网络获取数据库管理系统（DBMS）的静态构成信息，并将其作为DBMS数据信息存储在其存储器中。 存储装置的控制程序内的物理存储位置管理/优化执行部分通过使用DBMS数据信息来进行考虑数据库管理系统的特性的数据分配和高速缓存控制，从而提高存储装置的数据访问性能。

公开(公告)号：US09710515B2

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

申请号：US14404525

申请日：2012-05-31

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

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

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30445 ,  G06F17/30557

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

申请人： 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分类号： G06F17/30

CPC分类号： G06F16/252 ,  G06F16/24532 ,  G06F16/2455 ,  G06F16/24569

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

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

公开(公告)号：US09639576B2

公开(公告)日：2017-05-02

申请号：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.

公开(公告)号：US20150113535A1

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

申请号：US14404550

申请日：2012-05-31

申请人： Kazuo Goda ,  Hiroyuki Yamada ,  Masaru Kitsuregawa ,  Nobuo Kawamura ,  Shinji Fujiwara ,  Kazuhiko Mogi

发明人： Kazuo Goda ,  Hiroyuki Yamada ,  Masaru Kitsuregawa ,  Nobuo Kawamura ,  Shinji Fujiwara ,  Kazuhiko Mogi

IPC分类号： G06F9/46 ,  G06F9/54

CPC分类号： G06F9/466 ,  G06F9/4843 ,  G06F9/54 ,  G06F17/30445 ,  G06F17/30477

摘要： A parallel data processing system includes a parallel data processing execution unit for reading a data from a data set including a first data set that includes a plurality of first data and a second data set that includes a plurality of second data and executing processing. The parallel data processing execution unit (A) reads the first data from the first data set, and acquires a first value from the first data based on first format information acquired from an application, (B) generates one or more threads for respectively reading one or more second data corresponding to the first value from the second data set based on first reference information acquired from the application, (C) executes (A) and (B) on one or more first data in the first data set, and (D) executes a plurality of the threads in parallel.

摘要翻译： 并行数据处理系统包括并行数据处理执行单元，用于从包括多个第一数据的第一数据集和包括多个第二数据和执行处理的第二数据集的数据集读取数据。 并行数据处理执行单元（A）从第一数据集读取第一数据，并根据从应用获得的第一格式信息从第一数据获取第一值，（B）生成一个或多个线程，分别读取一个 （C）对第一数据集中的一个或多个第一数据执行（A）和（B），和（D）对应于来自第二数据集的第一值的第二数据; ）并行地执行多个线程。

公开(公告)号：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执行同时任务生成号码的确定处理。 同时任务生成号码的确定处理是针对每个查询块来计算同时任务生成的次数，其是同时生成作为执行查询块的任务的任务数量。 动态生成的任务的数量等于或小于同时任务生成的次数。