公开(公告)号：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.

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

公开(公告)号：US07089347B2

公开(公告)日：2006-08-08

申请号：US10633637

申请日：2003-08-05

申请人： Kazuhiko Mogi ,  Norifumi Nishikawa ,  Hideomi Idei

发明人： Kazuhiko Mogi ,  Norifumi Nishikawa ,  Hideomi Idei

IPC分类号： G06F12/00

CPC分类号： G06F17/30315 ,  G06F9/5083 ,  G06F11/3409 ,  G06F11/3419 ,  G06F11/3433 ,  G06F11/3485 ,  G06F2201/81 ,  G06F2201/815 ,  G06F2201/88 ,  G06F2201/885 ,  G06F2209/508

摘要： In a computer system with a DBMS running thereon, management of the performance of a storage apparatus is executed by using a performance indicator provided by a user job so as to simplify the management of the performance. For this reason, a management server employed in the computer system monitors an operating state of each system element, a response time onto a job and other information. A method for estimating a processing time is given to the management server, which issues a setting modification command based on an estimated processing time.

摘要翻译： 在其上运行DBMS的计算机系统中，通过使用由用户作业提供的性能指标来执行存储装置的性能的管理，以简化性能的管理。 为此，在计算机系统中使用的管理服务器监视每个系统元件的操作状态，作业上的响应时间和其他信息。 管理服务器给出了一种用于估计处理时间的方法，该管理服务器基于估计的处理时间发布设置修改命令。

公开(公告)号：US20050223174A1

公开(公告)日：2005-10-06

申请号：US10871838

申请日：2004-06-17

申请人： Kazuhiko Mogi ,  Norifumi Nishikawa

发明人： Kazuhiko Mogi ,  Norifumi Nishikawa

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

CPC分类号： G06F17/30339 ,  G06F12/0811 ,  G06F12/0866 ,  G06F12/0871 ,  G06F12/0873 ,  G06F12/0897 ,  G06F17/3048 ,  G06F2212/465 ,  Y10S707/99931

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

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

公开(公告)号：US20050203863A1

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

申请号：US10849184

申请日：2004-05-20

申请人： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

发明人： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

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

CPC分类号： G06F17/30442 ,  G06F12/0862 ,  G06F2212/465 ,  Y10S707/99945 ,  Y10S707/99952

摘要： A database (DB) server in which a database management system (DBMS) operates and a prefetch server connected to a storage device storing DB data are provided with an acquiring unit for acquiring information on a storage location on the storage device of a DB schema managed by the DBMS, information on DB processing executed by the DBMS, and information on an access to DB data made when the DBMS executes the DB processing, from the DB server, a predictor for predicting data to be read out on the basis of the acquired information, and a prefetch instructing unit for providing the storage device with an instruction to prefetch the corresponding data. Having received the prefetch instruction, the storage device reads out specified data onto a cache memory.

摘要翻译： 数据库管理系统（DBMS）操作的数据库（DB）服务器和连接到存储DB数据的存储设备的预取服务器被提供有获取单元，用于获取关于DB模式管理的存储设备上的存储位置的信息 由DBMS执行DBMS执行的DB处理的信息，以及关于当DBMS执行DB处理时对DB数据进行访问的信息，DB数据库服务器，用于基于获取的预测数据预测要读出的数据的预测器 信息和预取指示单元，用于向存储装置提供预取相应数据的指令。 在接收到预取指令之后，存储设备将指定的数据读出到高速缓冲存储器。

公开(公告)号：US20050193248A1

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

申请号：US10820858

申请日：2004-04-09

申请人： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

发明人： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

IPC分类号： G06F3/06 ,  G06F11/14 ,  G06F11/20 ,  G06F12/00 ,  G06F11/00

CPC分类号： G06F11/2074 ,  G06F11/2076

摘要： In the present invention, there is provided means which sets priorities of DB data for each management unit, means which copies data from a primary site to a secondary site in an order of the data priorities, and means which, when a disaster has occurred in the primary site and recovery of a DB is performed in the secondary site, performs recovery of data in the order of the data priorities to sequentially bring the data to a usable state.

摘要翻译： 在本发明中，提供了为每个管理单元设置DB数据的优先级的装置，以数据优先级的顺序将数据从主站点复制到次要站点的装置，以及在发生灾难时 在辅助站点中执行DB的主站点和恢复，按照数据优先级的顺序执行数据恢复，以顺序地将数据带入可用状态。

公开(公告)号：US5303400A

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

申请号：US680865

申请日：1991-04-05

申请人： Kazuhiko Mogi

发明人： Kazuhiko Mogi

IPC分类号： H04B1/06 ,  H03J1/00 ,  H03J7/18 ,  H04B1/16

CPC分类号： H04B1/1646 ,  H03J7/186 ,  H04H20/26 ,  H04H40/18 ,  H03J1/0008 ,  H04H2201/60

摘要： A radio receiver including a first receiver and a second receiver means which sweep frequencies of the divided regions of one reception band respectively or from lower end to upper end of one reception band. A control circuit stores received broadcasting stations having the reception quality level higher than the levels specified by sweeping the first receivers and the second receiver respectively.

摘要翻译： 一种无线电接收机，包括第一接收机和第二接收机装置，其分别扫描一个接收频带的分割区域的频率或从一个接收频带的下限到上端。 控制电路存储接收质量水平高于通过扫描第一接收机和第二接收机指定的电平的接收广播电台。

公开(公告)号：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.

公开(公告)号：US20150177984A1

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

申请号：US14404963

申请日：2012-06-07

申请人： Hideomi Idei ,  Norifumi Nishikawa ,  Shinji Fujiwara ,  Kazuhiko Mogi

发明人： Hideomi Idei ,  Norifumi Nishikawa ,  Shinji Fujiwara ,  Kazuhiko Mogi

IPC分类号： G06F3/06

CPC分类号： G06F3/061 ,  G06F3/0647 ,  G06F3/0665 ,  G06F3/067 ,  G06F3/0689

摘要： A management system manages a plurality of data units constituting schemas of a database in a storage device, which includes a plurality of first storage device sets having a plurality of storage areas. An ordered schema constituted of the plurality of data units having order properties defining respective orders is included in the schemas. When a second storage device set, which is a set of one or more second storage devices and in which each of the storage areas is a free storage area, is added to the first storage device set, the management system migrates two or more data units not consecutive in the order among a plurality of data units stored in the plurality of storage areas in the first storage device set respectively from at least the one first storage device set to the free storage areas of the second storage device set.

摘要翻译： 管理系统管理构成存储装置中的数据库的模式的多个数据单元，其包括具有多个存储区域的多个第一存储装置组。 由具有定义各个顺序的顺序属性的多个数据单元构成的有序模式包括在模式中。 当作为一个或多个第二存储装置的集合的第二存储装置集合并且其中每个存储区域是空闲存储区域被添加到第一存储装置集合时，管理系统迁移两个或更多个数据单元 在从至少一个第一存储装置设置到第二存储装置组的空闲存储区域的第一存储装置中存储的多个存储区域中存储的多个数据单元中的顺序不是连续的。

公开(公告)号：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执行同时任务生成次数的确定处理。 同时任务生成号的确定处理是基于可以新生成的任务的数量来计算同时任务生成的次数，即同时生成的任务的数量，第一存储器资源量 是每个新生成的任务需要分配的内存资源量，以及作为新分配的存储器资源的数量的第二存储器资源量。 动态和同时生成的任务数量等于或小于计算出的同时可生成任务的数量。

公开(公告)号：US08196034B2

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

申请号：US12327593

申请日：2008-12-03

申请人： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

发明人： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

IPC分类号： G06F13/00 ,  G06F15/00

CPC分类号： G06F3/0634 ,  G06F1/3203 ,  G06F1/3268 ,  G06F3/0625 ,  G06F3/0689 ,  G11B19/209 ,  Y02D10/154 ,  Y10S707/99932

摘要： A disk rotation control part for controlling the rotations of a plurality of disk devices is provided. The configuration is such that a disk of a disk device for which an access will not be generated is rotated at a second rate of speed, which is faster than 0, and slower than a first rate of speed, which is the rotation speed at access time. DB management information comprises information denoting which DB schema inside a DB is stored in which location. The disk rotation control part, based on a query plan of a query received by the DBMS, and DB management information, specifies the storage location of a DB schema to be accessed when this query is processed, and rotates a disk of the disk device comprising the specified storage location at a first rate of speed.

摘要翻译： 提供一种用于控制多个盘装置的旋转的盘旋转控制部。 该配置使得不会生成访问的盘装置的盘以比0快的第二速度旋转，并且比作为访问时的转速的第一速度速度慢 时间。 DB管理信息包括表示DB中哪个DB模式存储在哪个位置的信息。 基于由DBMS接收到的查询的查询计划和DB管理信息的盘旋转控制部分指定在处理该查询时要访问的DB模式的存储位置，并且旋转包括 指定的存储位置以第一速率。