公开(公告)号：US5101408A

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

申请号：US435026

申请日：1989-11-13

申请人： Masaru Kitsuregawa ,  Yasunori Kasahara

发明人： Masaru Kitsuregawa ,  Yasunori Kasahara

IPC分类号： G06F7/00 ,  G06F11/07 ,  G06F11/14

CPC分类号： G06F11/073 ,  G06F11/0793 ,  G06F11/1402 ,  G06F7/00

摘要： An error collection method for a sorter system having n pipelined sort elements Pi (i=1-n) of the same type and n local memories Mi (i=1-n) each connected to the corresponding sort element and having a memory capacity of at least 2.sup.i-1 record length, which includes the steps of sorting in said sort elements when one of the sort elements detects a fault; reporting contents of an error to the upper structure; analyzing the error; and restarting sorting.

摘要翻译： 一种具有相同类型的n个流水线分类元素Pi（i = 1-n）和n个本地存储器Mi（i = 1-n）的分类器系统的错误收集方法，每个连接到相应的分类元素并具有存储容量 至少2i-1记录长度，其包括当所述分类元素之一检测到故障时在所述分类元素中排序的步骤; 向上部结构报告错误内容; 分析错误; 并重新启动排序。

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