公开(公告)号：US20070016716A1

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

申请号：US11259894

申请日：2005-10-26

申请人： Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

发明人： Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

IPC分类号： G06F12/06

CPC分类号： G06F12/0871 ,  G06F17/30289 ,  G06F17/30557 ,  G06F2212/465 ,  G06F2212/601 ,  Y10S707/99932 ,  Y10S707/99943

摘要： Provided is a computer system, including: at least one of database computers, in which a database management system operates; a storage system for storing a database operated by the database management system; and a management computer for managing the database computer and the storage system, the storage system having a cache memory for storing data temporarily and a physical disk drive for storing the database, in which the management computer changes capacity of the cache memory which is allocated to the database computer where the database management system operates, and instructs the database management system to change an access plan according to the change in capacity of the cache memory allocated to the database computer.

摘要翻译： 提供一种计算机系统，包括：数据库计算机中的至少一个，其中数据库管理系统操作; 用于存储由数据库管理系统操作的数据库的存储系统; 以及用于管理数据库计算机和存储系统的管理计算机，所述存储系统具有临时存储数据的高速缓存存储器和用于存储数据库的物理磁盘驱动器，其中管理计算机改变被分配给 数据库管理系统操作的数据库计算机，并且指示数据库管理系统根据分配给数据库计算机的高速缓冲存储器容量的变化来改变访问计划。

公开(公告)号：US5237683A

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

申请号：US591700

申请日：1990-10-02

申请人： Masaru Kitsuregawa ,  Shinya Fushimi

发明人： Masaru Kitsuregawa ,  Shinya Fushimi

IPC分类号： G06F7/00 ,  G06F7/24 ,  G06F9/50 ,  G06F15/173

CPC分类号： G06F9/505 ,  G06F15/17393 ,  G06F7/00 ,  G06F7/24

摘要： A data distributing method and an apparatus employing such method are disclosed, wherein a counter group counts and stores a cumulative number of data or work units outputted from a coupling unit for each kind of data. A control circuit recognizes the kind of data that is inputted to each of two input lines of the coupling unit, judges whether or not there is a deviation of distribution of data or work units which are transferred from a first group of devices to a second group of devices on the basis of the counts of the counters that correspond to the kinds of data recognized, and changes over connection patterns of switch in the coupling unit so that any deviation is corrected thereby equally distributing data or work units to the second group of devices.

公开(公告)号：US09842136B2

公开(公告)日：2017-12-12

申请号：US14397051

申请日：2012-04-27

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

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

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

CPC分类号： G06F17/30463 ,  G06F9/4843 ,  G06F17/30477 ,  G06F2209/485

摘要： A database management system (DBMS) generates a query execution plan including information indicating one or more database (DB) operations necessary to execute the query. The DBMS dynamically generates a task for executing the DB operation in execution of the query. The DBMS performs a determination processing of simultaneous-task-generation number when newly creating a task. The determination processing of simultaneous-task-generation number is to calculate the number of simultaneous task generation, which is the number of tasks that can be generated simultaneously, based on the number of tasks which can be newly generated, a first memory resource amount which is the amount of memory resources necessary to be allocated per task newly generated, and a second memory resource amount which is the number of memory resources that can be newly allocated. The number of tasks generated dynamically and simultaneously is equal to or smaller than the calculated number of simultaneously generatable tasks.

公开(公告)号：US20150112966A1

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

申请号：US14397051

申请日：2012-04-27

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F9/4843 ,  G06F17/30477 ,  G06F2209/485

摘要： A database management system (DBMS) generates a query execution plan including information indicating one or more database (DB) operations necessary to execute the query. The DBMS dynamically generates a task for executing the DB operation in execution of the query. The DBMS performs a determination processing of simultaneous-task-generation number when newly creating a task. The determination processing of simultaneous-task-generation number is to calculate the number of simultaneous task generation, which is the number of tasks that can be generated simultaneously, based on the number of tasks which can be newly generated, a first memory resource amount which is the amount of memory resources necessary to be allocated per task newly generated, and a second memory resource amount which is the number of memory resources that can be newly allocated. The number of tasks generated dynamically and simultaneously is equal to or smaller than the calculated number of simultaneously generatable tasks.

摘要翻译： 数据库管理系统（DBMS）生成查询执行计划，其包括指示执行查询所必需的一个或多个数据库（DB）操作的信息。 DBMS在执行查询时动态生成执行DB操作的任务。 当新创建任务时，DBMS执行同时任务生成次数的确定处理。 同时任务生成号的确定处理是基于可以新生成的任务的数量来计算同时任务生成的次数，即同时生成的任务的数量，第一存储器资源量 是每个新生成的任务需要分配的内存资源量，以及作为新分配的存储器资源的数量的第二存储器资源量。 动态和同时生成的任务数量等于或小于计算出的同时可生成任务的数量。

公开(公告)号：US20120005191A1

公开(公告)日：2012-01-05

申请号：US13233578

申请日：2011-09-15

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

公开(公告)号：US07039660B2

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

申请号：US10628516

申请日：2003-07-29

申请人： Masaru Kitsuregawa ,  Nobuo Kawamura ,  Kazuo Masai

发明人： Masaru Kitsuregawa ,  Nobuo Kawamura ,  Kazuo Masai

IPC分类号： G06F12/00

CPC分类号： G06F11/2092 ,  G06F11/1471 ,  G06F11/2048 ,  G06F11/2097 ,  Y10S707/99955

摘要： Judgement is made to determine whether or not an access request from a host computer is a write request and whether or not the contents of the write request are log information indicating contents of database processing executed in a buffer by the host computer. When the contents of the write request are the log information, position information indicated in the log information is converted into physical position information in a primary storage system using a conversion table indicating a correspondence between logical position information recognized by the host computer and physical position information in the primary storage system. According to the contents of the log information, data is updated in a database area of the primary storage system represented by the physical position information converted using the conversion table. The access request is sent to a secondary storage system.

摘要翻译： 进行判断以确定来自主计算机的访问请求是否为写入请求，以及写入请求的内容是否是指示由主计算机在缓冲器中执行的数据库处理的内容的日志信息。 当写请求的内容是日志信息时，在日志信息中指示的位置信息使用表示由主计算机识别的逻辑位置信息与物理位置信息之间的对应关系的转换表转换到主存储系统中的物理位置信息 在主存储系统中。 根据日志信息的内容，在由使用转换表转换的物理位置信息表示的主存储系统的数据库区域中更新数据。 访问请求被发送到辅助存储系统。

公开(公告)号：US20060085598A1

公开(公告)日：2006-04-20

申请号：US11028218

申请日：2005-01-04

申请人： Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

发明人： Naokazu Nemoto ,  Norifumi Nishikawa ,  Kazuhiko Mogi ,  Masaru Kitsuregawa

IPC分类号： G06F12/00

CPC分类号： H04L67/1097

摘要： Data writing into a storage device. Data is written into a cache memory in order to implement speeding-up, and also the data is written into a physical disc asynchronously therewith. Since allocation of the cache memory is performed on each writing-request basis, a cut-out processing is required which is executed when none of available areas exists. This results in a problem of necessitating a writing processing time. A DBMS server in advance notifies the storage device that a writing will take place. A manager included in the storage device performs acquisition of the cache memory prior to the writing processing. This allows the data to be stored into the acquired cache memory at the time of the writing processing.

摘要翻译： 数据写入存储设备。 将数据写入高速缓冲存储器以实现加速，并且将数据与其异步地写入物理盘。 由于在每个写入请求的基础上执行高速缓冲存储器的分配，所以当没有可用区域存在时，需要执行切出处理。 这导致需要写入处理时间的问题。 DBMS服务器预先通知存储设备将进行写入。 包含在存储装置中的管理器在写入处理之前执行高速缓冲存储器的采集。 这允许在写入处理时将数据存储到获取的高速缓冲存储器中。

公开(公告)号：US20060085488A1

公开(公告)日：2006-04-20

申请号：US11080648

申请日：2005-03-16

申请人： Masaru Kitsuregawa ,  Kazuo Goda ,  Nobuo Kawamura

发明人： Masaru Kitsuregawa ,  Kazuo Goda ,  Nobuo Kawamura

IPC分类号： G06F17/30

CPC分类号： G06F17/30339

摘要： To provide a storage system that carries out database reorganization processing. Provided is a method of reorganizing, upon request from a host computer, a database which is stored in a disk drive of a storage device, the disk drive containing a first volume where the database is stored and a second volume paired with the first volume to store a copy of the database, and the reorganization method comprising the steps of: making a transaction of the host computer quiescent state; splitting the paired first volume and second volume to be accessed the only database in the first volume; releasing the quiescent state of the transaction; reorganizing the second volume; and copying data in the second volume to the first volume to resynchronize and pair the first volume and the second volume with each other.

摘要翻译： 提供进行数据库重组处理的存储系统。 提供了一种根据主计算机请求重新组织存储在存储设备的磁盘驱动器中的数据库的方法，所述磁盘驱动器包含存储数据库的第一卷和与第一卷配对的第二卷 存储数据库的副本，并且重组方法包括以下步骤：进行主计算机静止状态的交易; 将配对的第一卷和第二卷拆分为第一卷中唯一的数据库; 释放交易的静止状态; 重组第二卷; 以及将所述第二卷中的数据复制到所述第一卷，以使所述第一卷和所述第二卷彼此重新同步并配对。

公开(公告)号：US20050193034A1

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

申请号：US10628516

申请日：2003-07-29

申请人： Masaru Kitsuregawa ,  Nobuo Kawamura ,  Kazuo Masai

发明人： Masaru Kitsuregawa ,  Nobuo Kawamura ,  Kazuo Masai

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

CPC分类号： G06F11/2092 ,  G06F11/1471 ,  G06F11/2048 ,  G06F11/2097 ,  Y10S707/99955

摘要： Judgement is made to determine whether or not an access request from a host computer is a write request and whether or not the contents of the write request are log information indicating contents of database processing executed in a buffer by the host computer. When the contents of the write request are the log information, position information indicated in the log information is converted into physical position information in a primary storage system using a conversion table indicating a correspondence between logical position information recognized by the host computer and physical position information in the primary storage system. According to the contents of the log information, data is updated in a database area of the primary storage system represented by the physical position information converted using the conversion table. The access request is sent to a secondary storage system.

摘要翻译： 进行判断以确定来自主计算机的访问请求是否为写入请求，以及写入请求的内容是否是指示由主计算机在缓冲器中执行的数据库处理的内容的日志信息。 当写请求的内容是日志信息时，在日志信息中指示的位置信息使用表示由主计算机识别的逻辑位置信息与物理位置信息之间的对应关系的转换表转换到主存储系统中的物理位置信息 在主存储系统中。 根据日志信息的内容，在由使用转换表转换的物理位置信息表示的主存储系统的数据库区域中更新数据。 访问请求被发送到辅助存储系统。

公开(公告)号：US5603028A

公开(公告)日：1997-02-11

申请号：US381524

申请日：1995-01-31

申请人： Masaru Kitsuregawa ,  Shinya Fushimi

发明人： Masaru Kitsuregawa ,  Shinya Fushimi

IPC分类号： G06F9/50 ,  G06F13/38

CPC分类号： G06F9/5083

摘要： A data distribution apparatus and method for distributing data from a first group of devices to a second group of devices through a series of controlled coupling units to evenly distribute processing load associated with the data among the second group of devices. The coupling units have memory for storing values relating to an accumulated processing load of data distributed through the coupling unit. The coupling units distribute data and/or descriptive indicators representing data based on kinds of data, such as job classes, and processing loads that are previously estimated. By distributing based on processing load, a plurality of processes can be performed nearly simultaneously without excess waiting.

摘要翻译： 一种用于通过一系列受控耦合单元将数据从第一组设备分发到第二组设备的数据分配设备和方法，以在第二组设备之间均匀地分配与数据相关联的处理负载。 耦合单元具有用于存储与通过耦合单元分布的数据的累积处理负载有关的值的存储器。 耦合单元基于诸如作业类别和先前估计的处理负载的数据种类来分布表示数据的数据和/或描述性指示符。 通过基于处理负载进行分配，可以几乎同时执行多个处理，而不会过多等待。