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

公开(公告)号：US08041707B2

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

申请号：US12897243

申请日：2010-10-04

申请人： Masaru Kitsuregawa ,  Kazuo Goda

发明人： Masaru Kitsuregawa ,  Kazuo Goda

IPC分类号： G06F7/00

CPC分类号： G06F17/30474 ,  G06F17/30433 ,  G06F17/30463 ,  G06F17/30513

摘要： A database management system has a query interface for receiving a query and a query executor for executing the received query. The query executor dynamically generates a task, and executes a plurality of tasks in parallel. In execution of each task, each time data is required to be read from a database, the query executor generates a task for acquiring the data, and in execution of the generated task, issues a data read request for reading the data from the database, to thereby shorten a time taken to execute each task.

摘要翻译： 数据库管理系统具有用于接收查询的查询接口和用于执行接收到的查询的查询执行器。 查询执行器动态生成任务，并行执行多个任务。 在每个任务的执行中，每当需要从数据库读取数据时，查询执行器生成用于获取数据的任务，并且在执行生成的任务时，发出用于从数据库读取数据的数据读取请求， 从而缩短执行每个任务所需的时间。

公开(公告)号：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数据信息中，其中存储系统控制程序中的高速缓存控制部分通过参考上述信息来控制数据高速缓存。

公开(公告)号：US20070022100A1

公开(公告)日：2007-01-25

申请号：US11490172

申请日：2006-07-21

申请人： Masaru Kitsuregawa ,  Kazuo Goda

发明人： Masaru Kitsuregawa ,  Kazuo Goda

IPC分类号： G06F17/30

CPC分类号： G06F17/30474 ,  G06F17/30433 ,  G06F17/30463 ,  G06F17/30513

摘要： A database management system has a query interface for receiving a query and a query executor for executing the received query. The query executor dynamically generates a task, and executes a plurality of tasks in parallel. In execution of each task, each time data is required to be read from a database, the query executor generates a task for acquiring the data, and in execution of the generated task, issues a data read request for reading the data from the database, to thereby shorten a time taken to execute each task.

摘要翻译： 数据库管理系统具有用于接收查询的查询接口和用于执行接收到的查询的查询执行器。 查询执行器动态生成任务，并行执行多个任务。 在每个任务的执行中，每当需要从数据库读取数据时，查询执行器生成用于获取数据的任务，并且在执行生成的任务时，发出用于从数据库读取数据的数据读取请求， 从而缩短执行每个任务所需的时间。

公开(公告)号：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数据信息中，其中存储系统控制程序中的高速缓存控制部分通过参考上述信息来控制数据高速缓存。

公开(公告)号：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根据第一存储装置中是否存在数据地址组来选择任务开始信息。

公开(公告)号：US07925633B2

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

申请号：US10989398

申请日：2004-11-17

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

IPC分类号： G06F7/00

CPC分类号： G06F11/2028 ,  G06F11/2025 ,  G06F11/2097

摘要： To reduce operational and management costs during normal operations while recovering a database without loss and maintaining on-line performance on a site. A first system includes a primary storage system (103) that stores a DB (107) and a main computer (100) that executes a primary DBMS (101), which provides a DB. A second system includes a secondary (113) that receives from the primary storage system (103) a copy of a log, which shows update differences of the DB (107), and stores a secondary DBMS (117), and a subset (500) that recovers the secondary DB (117) according to the log that is copied from the primary storage system (103). When a failure occurs in the first system, the first system is switched to the second system. A second computer (110) that executes a second DBMS (111) is added to the second system, and the secondary DB (117) that is recovered or is being recovered in the subset (500) is taken over to the second computer (110).

摘要翻译： 在正常运行期间降低运营和管理成本，同时在不丢失数据库的情况下恢复数据库并维护站点上的在线性能。 第一系统包括存储DB（107）的主存储系统（103）和执行提供DB的主DBMS（101）的主计算机（100）。 第二系统包括从主存储系统（103）接收日志的副本的次要（113），其显示DB（107）的更新差异，并存储辅助DBMS（117）和子集（500） ），其根据从主存储系统（103）复制的日志恢复辅助DB（117）。 当在第一系统中发生故障时，第一系统被切换到第二系统。 执行第二DBMS（111）的第二计算机（110）被添加到第二系统，并且在子集（500）中恢复或正在恢复的辅助DB（117）被接管到第二计算机（110） ）。