中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

101 records (took 0.03 seconds)

    DATABASE MANAGEMENT SYSTEM, COMPUTER, AND DATABASE MANAGEMENT METHOD
    21.
    发明申请
    DATABASE MANAGEMENT SYSTEM, COMPUTER, AND DATABASE MANAGEMENT METHOD 有权
    数据库管理系统，计算机和数据库管理方法

    公开(公告)号：US20150112965A1

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

    申请号：US14397030

    申请日：2012-04-27

    Applicant: Seisuke Tokuda ,  Akira Shimizu ,  Michiko Yoshida ,  Shinji Fujiwara ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Kazuo Goda

    Inventor： Seisuke Tokuda ,  Akira Shimizu ,  Michiko Yoshida ,  Shinji Fujiwara ,  Kazuhiko Mogi ,  Masaru Kitsuregawa ,  Kazuo Goda

    IPC: G06F17/30

    CPC classification number: G06F17/30463 ,  G06F17/30483

    Abstract: 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.

    Abstract translation: 数据库管理系统（DBMS）生成查询执行计划，包括表示执行查询所需的一个或多个数据库（DB）操作的信息，并根据查询执行计划执行查询。 在执行查询时，DBMS动态生成用于执行DB操作的任务，并执行动态生成的任务。 查询执行计划包括多个查询块，其是一个或多个DB操作的集合。 当新生成任务时，DBMS执行同时任务生成号码的确定处理。 同时任务生成号码的确定处理是针对每个查询块来计算同时任务生成的次数，其是同时生成作为执行查询块的任务的任务数量。 动态生成的任务的数量等于或小于同时任务生成的次数。

    Method of reducing storage power consumption by use of prefetch and computer system using the same
    22.
    发明授权
    Method of reducing storage power consumption by use of prefetch and computer system using the same 有权
    使用预取功能降低存储功耗的方法及使用其的计算机系统

    公开(公告)号：US08036076B2

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

    申请号：US12007936

    申请日：2008-01-17

    Applicant: Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

    Inventor： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

    IPC: G11B17/00 ,  G06F7/00

    CPC classification number: G11B19/02

    Abstract: Provided is a computer system including: a computer running as a DB server; a storage system including a plurality of disk drives for storing data; and a management module, in which: at least one of the plurality of disk drives stores data of a DB schema written by the computer; the management module specifies the DB schema to be accessed based on a received query, transmits, to the storage system, an instruction to copy at least a portion of the data of the specified DB schema from the disk drive to a memory, and transmits, to the storage system, an instruction to control an rpm of the disk drive that stores the data of the specified DB schema; and the storage system controls the rpm of the disk drive based on the instruction. Accordingly, power consumption of the storage system can be reduced even if installed disks increase in number.

    Abstract translation: 提供了一种计算机系统，包括：作为DB服务器运行的计算机; 包括用于存储数据的多个盘驱动器的存储系统; 以及管理模块，其中：所述多个磁盘驱动器中的至少一个磁盘驱动器存储由所述计算机写入的DB模式的数据; 管理模块基于接收到的查询指定要访问的DB模式，向存储系统发送将指定的DB模式的数据的至少一部分的副本从盘驱动器复制到存储器的指令， 向存储系统提供控制存储指定DB模式的数据的磁盘驱动器的rpm的指令; 并且存储系统基于指令控制磁盘驱动器的rpm。 因此，即使安装的盘数量增加，也可以减少存储系统的功耗。

    Storage system having means for acquiring execution information of database management system
    23.
    发明授权
    Storage system having means for acquiring execution information of database management system 失效
    具有用于获取数据库管理系统的执行信息的装置的存储系统

    公开(公告)号：US07734616B2

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

    申请号：US11182281

    申请日：2005-07-14

    Applicant: Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

    Inventor： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

    IPC: G06F7/00 ,  G06F17/30

    CPC classification number: G06F17/3048 ,  Y10S707/99933 ,  Y10S707/99943

    Abstract: 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.

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

    System monitoring method
    25.
    发明授权
    System monitoring method 失效
    系统监控方法

    公开(公告)号：US07512680B2

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

    申请号：US10871814

    申请日：2004-06-21

    Applicant: Norifumi Nishikawa ,  Kazuhiko Mogi

    Inventor： Norifumi Nishikawa ,  Kazuhiko Mogi

    IPC: G06F15/16

    CPC classification number: G06F11/3495 ,  G06F11/3409 ,  G06F11/3433 ,  G06F2201/80 ,  G06F2201/87 ,  G06F2201/885

    Abstract: A second computer for monitoring a database management system and a storage subsystem introduced into a first computer, is provided with a step of acquiring profile information of an application, a step of determining a tuning item in accordance with the acquired profile information, and a step of transferring the determined tuning item to the first computer and the storage subsystem.

    Abstract translation: 用于监视引入到第一计算机中的数据库管理系统和存储子系统的第二计算机被提供有获取应用的简档信息的步骤，根据获取的简档信息确定调整项目的步骤，以及步骤 将确定的调谐项目传送到第一计算机和存储子系统。

    Method and apparatus for managing faults in storage system having job management function
    26.
    发明授权
    Method and apparatus for managing faults in storage system having job management function 失效
    用于管理具有作业管理功能的存储系统中的故障的方法和装置

    公开(公告)号：US07509331B2

    公开(公告)日：2009-03-24

    申请号：US11247160

    申请日：2005-10-12

    Applicant: Naokazu Nemoto ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Nobuo Kawamura

    Inventor： Naokazu Nemoto ,  Kazuhiko Mogi ,  Norifumi Nishikawa ,  Nobuo Kawamura

    IPC: G06F17/00

    CPC classification number: G06F11/0775 ,  G06F3/0617 ,  G06F3/0635 ,  G06F3/067 ,  G06F11/0709 ,  G06F11/0727 ,  G06F11/0748 ,  G06F11/2294 ,  H04L67/1097 ,  Y10S707/99942 ,  Y10S707/99943

    Abstract: A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.

    Abstract translation: 计算机系统识别受存储系统中的任何设备或机制中发生的故障影响的作业，以控制这些作业的执行。 计算机系统包括DBMS服务器设备，虚拟交换设备和存储设备。 这些设备中的每一个将数据映射路径上的数据映射信息的一部分保存在通过用于存储表的逻辑卷的作业所访问的特定DB表的数据映射路径到用于在卷上分布式地存储数据的物理磁盘单元。 管理服务器设备从每个设备获取部分数据映射信息，并且逐个工作地整合数据映射信息。 当任何设备或机制在数据映射路径上发生故障时，管理服务器设备将参考数据映射信息来识别受故障影响的作业。 管理服务器设备还控制这些作业的执行。

    COMPUTER SYSTEM AND DATABASE MANAGEMENT METHOD USING THE SAME
    27.
    发明申请
    COMPUTER SYSTEM AND DATABASE MANAGEMENT METHOD USING THE SAME 有权
    使用它的计算机系统和数据库管理方法

    公开(公告)号：US20080301151A1

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

    申请号：US11968681

    申请日：2008-01-03

    Applicant: Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

    Inventor： Hideomi Idei ,  Kazuhiko Mogi ,  Norifumi Nishikawa

    IPC: G06F17/30

    CPC classification number: G06F17/3048 ,  G06F17/30492

    Abstract: A pre-fetch server, which is connected to a DB server running a DBMS and to a storage apparatus storing DB data, stores information required for judging whether or not a pre-fetch is effective. Judgment on whether or not the pre-fetch will be effective is performed when a pre-fetch I/O is issued. If the pre-fetch server judges that the pre-fetch will be effective, it issues the pre-fetch I/O to the storage apparatus.

    Abstract translation: 连接到运行DBMS的DB服务器和存储DB数据的存储装置的预取服务器存储用于判断预取是否有效所需的信息。 当发出预取I / O时，执行对提取是否有效的判断。 如果预取服务器判断预取将有效，则向存储设备发出预取I / O。

    Computer system for recovering data based on priority of the data
    28.
    发明授权
    Computer system for recovering data based on priority of the data 有权
    基于数据优先级恢复数据的计算机系统

    公开(公告)号：US07266718B2

    公开(公告)日：2007-09-04

    申请号：US10820858

    申请日：2004-04-09

    Applicant: Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

    Inventor： Hideomi Idei ,  Norifumi Nishikawa ,  Kazuhiko Mogi

    IPC: G06F11/00

    CPC classification number: G06F11/2074 ,  G06F11/2076

    Abstract: 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.

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

    Database recovery method applying update journal and database log
    30.
    发明申请
    Database recovery method applying update journal and database log 有权
    应用更新日志和数据库日志的数据库恢复方法

    公开(公告)号：US20070185923A1

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

    申请号：US11386982

    申请日：2006-03-23

    Applicant: Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

    Inventor： Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

    IPC: G06F17/30

    CPC classification number: G06F11/1471 ,  G06F2201/80 ,  G06F2201/84 ,  Y10S707/99945 ,  Y10S707/99953

    Abstract: A database recovery method including a computer and a storage system, in which: the storage system includes a disk drive for storing data; the disk drive includes a data volume, a snapshot volume, a database log for storing an update log, and an update journal for storing update information of the data volume; a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied is recorded to recover the data volume; and when the database is to be recovered, the update journal is applied to the snapshot volume up to the recovery point, the snapshot volume after the update is switched to the data volume, and the database log after the recovery point is applied to the data volume that is set by switching.

    Abstract translation: 一种包括计算机和存储系统的数据库恢复方法，其中：存储系统包括用于存储数据的磁盘驱动器; 磁盘驱动器包括数据卷，快照卷，用于存储更新日志的数据库日志和用于存储数据卷的更新信息的更新日志; 记录用于指示要应用更新日志的范围的终点的恢复点和要应用数据库日志的范围的起始点，以恢复数据量; 要恢复数据库时，将更新日志应用于直到恢复点的快照卷，将更新后的快照卷切换到数据卷，并将恢复点后的数据库日志应用于数据 通过切换设置的音量。

Patent Agency Ranking