公开(公告)号：US07801860B2

公开(公告)日：2010-09-21

申请号：US10994457

申请日：2004-11-23

申请人： Masataka Kan ,  Norihiro Hara ,  Nobuo Kawamura

发明人： Masataka Kan ,  Norihiro Hara ,  Nobuo Kawamura

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F11/2028 ,  G06F11/1662 ,  G06F11/2038 ,  G06F2201/80

摘要： In a system that switches multiple database servers to separate computers, a switching order of the database servers is variably changed and set. In the system that allows an executive system computer and a standby system computer having the database servers to share a database respectively, the system is switched from the database server of the executive system computer to the database server of the standby system computer. Information (order information) that indicates an order in which the system of the executive system database server is switched is registered in a storage device. The order information is changed by detection of the occurrence of an event in the executive system computer. The system switching processing is performed from the executive system database server to the standby system database server in accordance with the changed order information.

摘要翻译： 在将多个数据库服务器切换到单独的计算机的系统中，数据库服务器的切换顺序是可变的和设置的。 在允许具有数据库服务器的执行系统计算机和备用系统计算机分别共享数据的系统中，系统从执行系统计算机的数据库服务器切换到备用系统计算机的数据库服务器。 指示切换执行系统数据库服务器的系统的顺序的信息（订单信息）被登记在存储装置中。 通过检测执行系统计算机中事件的发生来改变订单信息。 根据改变的订单信息，从执行系统数据库服务器到备用系统数据库服务器执行系统切换处理。

公开(公告)号：US07447711B2

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

申请号：US10769351

申请日：2004-01-30

申请人： Norihiro Hara ,  Mitsuo Miyazaki ,  Nobuo Kawamura ,  Katsushi Yako ,  Masataka Kan

发明人： Norihiro Hara ,  Mitsuo Miyazaki ,  Nobuo Kawamura ,  Katsushi Yako ,  Masataka Kan

IPC分类号： G06F17/30

CPC分类号： G06F11/2035 ,  G06F11/2025 ,  G06F11/2033 ,  Y10S707/99953

摘要： The present invention provides a system switching function for database management systems which requires no standby resources idling during normal operation. One aspect of the invention is directed to a method for processing databases in a system which includes a plurality of storage areas each storing a database and a plurality of computers each having a database management program running thereon which manages one of the plurality of storage areas. Each storage area is associated with only the computer managing the storage area. The method comprises, when a failure has occurred in one of the plurality of computers as a failed computer, obtaining preset substitution information indicating that the storage area managed by the database management program running on the failed computer is to be managed by the database management program running on another one of the plurality of computers as a substitute computer; and, based on the substitution information, changing association of the storage area with the failed computer to the substitute computer. The storage area is to be managed by the database management program running on the substitute computer.

摘要翻译： 本发明提供了一种用于数据库管理系统的系统切换功能，其在正常操作期间不需要备用资源空闲。 本发明的一个方面涉及一种用于处理系统中的数据库的方法，该方法包括多个存储数据库的存储区域和多个计算机，每个计算机具有在其上运行的数据库管理程序，其管理多个存储区域中的一个。 每个存储区域仅与管理存储区域的计算机相关联。 该方法包括：当作为故障计算机的多台计算机中的一台计算机发生故障时，获得表示由该故障计算机上运行的数据库管理程序管理的存储区域由数据库管理程序管理的预置替代信息 作为替代计算机运行在所述多个计算机中的另一个上; 并且基于替代信息，将存储区域与故障计算机的关联改变为替代计算机。 存储区域由在替代计算机上运行的数据库管理程序进行管理。

公开(公告)号：US20090055444A1

公开(公告)日：2009-02-26

申请号：US12255707

申请日：2008-10-22

申请人： Norihiro Hara ,  Mitsuo Miyazaki ,  Nobuo Kawamura ,  Katsushi Yako ,  Masataka Kan

发明人： Norihiro Hara ,  Mitsuo Miyazaki ,  Nobuo Kawamura ,  Katsushi Yako ,  Masataka Kan

IPC分类号： G06F17/30

CPC分类号： G06F11/2035 ,  G06F11/2025 ,  G06F11/2033 ,  Y10S707/99953

摘要： The present invention provides a system switching function for database management systems which requires no standby resources idling during normal operation. One aspect of the invention is directed to a method for processing databases in a system which includes a plurality of storage areas each storing a database and a plurality of computers each having a database management program running thereon which manages one of the plurality of storage areas. Each storage area is associated with only the computer managing the storage area. The method comprises, when a failure has occurred in one of the plurality of computers as a failed computer, obtaining preset substitution information indicating that the storage area managed by the database management program running on the failed computer is to be managed by the database management program running on another one of the plurality of computers as a substitute computer; and, based on the substitution information, changing association of the storage area with the failed computer to the substitute computer. The storage area is to be managed by the database management program running on the substitute computer.

摘要翻译： 本发明提供了一种用于数据库管理系统的系统切换功能，其在正常操作期间不需要备用资源空闲。 本发明的一个方面涉及一种用于处理系统中的数据库的方法，该方法包括多个存储数据库的存储区域和多个计算机，每个计算机具有在其上运行的数据库管理程序，其管理多个存储区域中的一个。 每个存储区域仅与管理存储区域的计算机相关联。 该方法包括：当作为故障计算机的多台计算机之一发生故障时，获得指示由在该故障计算机上运行的数据库管理程序管理的存储区域由数据库管理程序管理的预置替代信息 作为替代计算机运行在所述多个计算机中的另一个上; 并且基于替代信息，将存储区域与故障计算机的关联改变为替代计算机。 存储区域由在替代计算机上运行的数据库管理程序进行管理。

公开(公告)号：US20050144197A1

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

申请号：US10994457

申请日：2004-11-23

申请人： Masataka Kan ,  Norihiro Hara ,  Nobuo Kawamura

发明人： Masataka Kan ,  Norihiro Hara ,  Nobuo Kawamura

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

CPC分类号： G06F11/2028 ,  G06F11/1662 ,  G06F11/2038 ,  G06F2201/80

摘要： In a system that switches multiple database servers to separate computers, a switching order of the database servers is variably changed and set. In the system that allows an executive system computer and a standby system computer having the database servers to share a database respectively, the system is switched from the database server of the executive system computer to the database server of the standby system computer. Information (order information) that indicates an order in which the system of the executive system database server is switched is registered in a storage device. The order information is changed by detection of the occurrence of an event in the executive system computer. The system switching processing is performed from the executive system database server to the standby system database server in accordance with the changed order information.

摘要翻译： 在将多个数据库服务器切换到单独的计算机的系统中，数据库服务器的切换顺序是可变的和设置的。 在允许具有数据库服务器的执行系统计算机和备用系统计算机分别共享数据的系统中，系统从执行系统计算机的数据库服务器切换到备用系统计算机的数据库服务器。 指示切换执行系统数据库服务器的系统的顺序的信息（订单信息）被登记在存储装置中。 通过检测执行系统计算机中事件的发生来改变订单信息。 根据改变的订单信息，从执行系统数据库服务器到备用系统数据库服务器执行系统切换处理。

公开(公告)号：US09384219B2

公开(公告)日：2016-07-05

申请号：US13814989

申请日：2011-02-24

申请人： Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Michiko Tanaka ,  Nobuo Kawamura ,  Norihiro Hara

发明人： Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Michiko Tanaka ,  Nobuo Kawamura ,  Norihiro Hara

IPC分类号： G06F17/30

CPC分类号： G06F17/30283 ,  G06F17/30339

摘要： A computer system, comprising: a computer for outputting a result in response to a request; and a storage system for storing data output based on the request, the computer including: a request reception module for receiving the request; a processing procedure generation module for generating a plurality of processing procedures including an order of access to the data stored in the plurality of storage devices; a data division module for dividing the data; an information obtaining module for obtaining load information indicating a load condition of the storage system; an allotment determination module for determining, based on the obtained load information, allotments for allocating the divided data to be processed by the generated plurality of processing procedures; and a processing execution module for executing, based on the determined allotments, the generated plurality of processing procedures in parallel.

摘要翻译： 一种计算机系统，包括：用于响应于请求输出结果的计算机; 以及存储系统，用于存储基于所述请求输出的数据，所述计算机包括：用于接收所述请求的请求接收模块; 处理过程生成模块，用于生成包括访问存储在所述多个存储装置中的数据的顺序的多个处理过程; 数据分割模块，用于分割数据; 信息获取模块，用于获取指示所述存储系统的负载状况的负载信息; 分配确定模块，用于基于所获得的负载信息，确定用于分配由所生成的多个处理过程来处理的划分数据的分配; 以及处理执行模块，用于基于所确定的分配，并行地执行生成的多个处理过程。

公开(公告)号：US20130159303A1

公开(公告)日：2013-06-20

申请号：US13814989

申请日：2011-02-24

申请人： Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Michiko Tanaka ,  Nobuo Kawamura ,  Norihiro Hara

发明人： Kazutomo Ushijima ,  Akira Shimizu ,  Seisuke Tokuda ,  Michiko Tanaka ,  Nobuo Kawamura ,  Norihiro Hara

IPC分类号： G06F17/30

CPC分类号： G06F17/30283 ,  G06F17/30339

摘要： A computer system, comprising: a computer for outputting a result in response to a request; and a storage system for storing data output based on the request, the computer including: a request reception module for receiving the request; a processing procedure generation module for generating a plurality of processing procedures including an order of access to the data stored in the plurality of storage devices; a data division module for dividing the data; an information obtaining module for obtaining load information indicating a load condition of the storage system; an allotment determination module for determining, based on the obtained load information, allotments for allocating the divided data to be processed by the generated plurality of processing procedures; and a processing execution module for executing, based on the determined allotments, the generated plurality of processing procedures in parallel.

摘要翻译： 一种计算机系统，包括：用于响应于请求输出结果的计算机; 以及存储系统，用于存储基于所述请求输出的数据，所述计算机包括：用于接收所述请求的请求接收模块; 处理过程生成模块，用于生成包括访问存储在所述多个存储装置中的数据的顺序的多个处理过程; 数据分割模块，用于分割数据; 信息获取模块，用于获取指示所述存储系统的负载状况的负载信息; 分配确定模块，用于基于所获得的负载信息，确定用于分配由所生成的多个处理过程来处理的划分数据的分配; 以及处理执行模块，用于基于所确定的分配，并行地执行生成的多个处理过程。

公开(公告)号：US07797572B2

公开(公告)日：2010-09-14

申请号：US11620179

申请日：2007-01-05

申请人： Toru Kawashima ,  Nobuo Kawamura ,  Norihiro Hara

发明人： Toru Kawashima ,  Nobuo Kawamura ,  Norihiro Hara

IPC分类号： G06F11/00

CPC分类号： G06F11/2046 ,  G06F11/2023 ,  G06F11/2041 ,  G06F11/3433 ,  G06F11/3476 ,  G06F2201/81 ,  G06F2201/815 ,  G06F2201/88 ,  G06F2201/885

摘要： This invention provides a method of controlling switching of computers according to a cause of failure without preparing one standby node for each active node. For n active nodes (200), m standby nodes (300) of different characteristics (in terms of CPU performance, I/O performance, communication performance, and the like) are prepared. The m standby nodes (300) are assigned in advance with priority levels to be failover targets for each cause of failure. When a failure occurs in one active node (200), a standby node that can remove the cause of the failure is chosen out of the m standby nodes (300) to take over data processing.

摘要翻译： 本发明提供了一种根据故障原因控制计算机的切换的方法，而不为每个主动节点准备一个备用节点。 对于n个主动节点（200），准备不同特性的m个待机节点（在CPU性能，I / O性能，通信性能等方面）。 m个备用节点（300）被预先分配为优先级，以作为每个故障原因的故障切换目标。 当在一个活动节点（200）中发生故障时，从m个备用节点（300）中选出可以消除故障原因的备用节点以接管数据处理。

公开(公告)号：US06675160B2

公开(公告)日：2004-01-06

申请号：US10167435

申请日：2002-06-13

申请人： Norihiro Hara ,  Nobuo Kawamura ,  Tomohiro Nakayama ,  Kiyomi Hirohata

发明人： Norihiro Hara ,  Nobuo Kawamura ,  Tomohiro Nakayama ,  Kiyomi Hirohata

IPC分类号： G06F1730

CPC分类号： G06F17/30463 ,  G06F17/30312 ,  G06F17/30483 ,  G06F17/30492 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99937

摘要： A database processing system for analyzing a query issued to a database to generate a corresponding execution procedure for performing database processing in accordance therewith. A plurality of columns for storing data each constituted by a set of instances and conditions concerning the instances constituting the plurality of columns are entered. A query is inputted which contains a predicate for evaluating whether a set of instances which meet the designated conditions and which can be identified with the same subscript exists among the sets of instances stored in the plurality of columns. In response to the query, a decision is made as to whether or not an index has been generated for one or plural columns specified in the query predicate. When the index is generated, the index is accessed to acquire an identifier of table data which is “true” for a predicate. Unless the index is generated, a decision is then made as to whether or not column data acquired by accessing the database meet the conditions specified in the predicate contained in the query.

摘要翻译： 一种数据库处理系统，用于分析发给数据库的查询，以生成相应的执行过程，用于执行数据库处理。 输入用于存储数据的多个列，每个列由关于构成多个列的实例的一组实例和条件构成。 输入查询，该查询包含用于评估在多个列中存储的实例组中是否存在满足指定条件并且可以被标识具有相同下标的一组实例的谓词。 响应于该查询，作出关于是否已经在查询谓词中指定的一个或多个列生成了索引的决定。 当生成索引时，访问索引以获取对于谓词为“true”的表数据的标识符。 除非生成索引，否则就决定通过访问数据库获取的列数据是否满足查询中包含的谓词中指定的条件。

公开(公告)号：US07324992B2

公开(公告)日：2008-01-29

申请号：US10788276

申请日：2004-03-01

申请人： Norihiro Hara ,  Nobuo Kawamura ,  Shunichi Torii ,  Yoshito Kamegi

发明人： Norihiro Hara ,  Nobuo Kawamura ,  Shunichi Torii ,  Yoshito Kamegi

IPC分类号： G06F17/30 ,  G06F15/00

CPC分类号： G06F17/30342 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99936 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944

摘要： In an implementation method for executing a general database processing, index definition information for setting a specific user-defined function in correspondence to a specific index which is used to carry out an index access to data in a database region is created, and module definition information for setting the specific index which is used to carry out the index access to the data in the database region in correspondence to an implementation module for subjecting the data in the database region to a specific processing is created. When it is determined that the user-defined function contained in a processing request is set in correspondence to the specific index on the basis of the index definition information, a specific implementation module for carrying out an access using the specific index is selected, and a database processing is performed using the implementation module.

摘要翻译： 在用于执行通用数据库处理的实现方法中，创建用于根据用于对数据库区域中的数据进行索引访问的特定索引来设置特定用户定义函数的索引定义信息，以及模块定义信息 用于将用于对与数据库区域中的数据进行特定处理的实现模块相对应的用于对数据库区域中的数据进行索引访问的特定索引进行设置。 当确定处理请求中包含的用户定义功能是根据索引定义信息被设置为与特定索引相对应时，选择用于使用特定索引执行访问的特定实现模块，并且 使用实现模块执行数据库处理。

公开(公告)号：US20070174248A1

公开(公告)日：2007-07-26

申请号：US11365496

申请日：2006-03-02

申请人： Shota Kumugai ,  Nobuo Kawamura ,  Norihiro Hara

发明人： Shota Kumugai ,  Nobuo Kawamura ,  Norihiro Hara

IPC分类号： G06F17/30

CPC分类号： G06F16/24532

摘要： In a database management method, a plurality of nodes are instructed to execute queries to the data base stored in a storage. A computer receives the input of the queries, and divides each input query into a plurality of processing phases constituting units capable of being executed in parallel. Based on the feature of the processing phases and the operating condition of each node at the time of execution of the processing phases of each query, the processing phases of the query are distributed among the nodes. The predetermined intended application of each node and the application of each query specified by the type of the query are compared with each other thereby to specify the nodes to which the processing phases are distributed.

摘要翻译： 在数据库管理方法中，指示多个节点对存储在存储器中的数据库执行查询。 计算机接收查询的输入，并且将每个输入查询划分成能够并行执行的构成单元的多个处理阶段。 基于处理阶段的特征和执行每个查询的处理阶段时每个节点的操作条件，查询的处理阶段分布在节点之间。 将每个节点的预定预期应用和由查询的类型指定的每个查询的应用彼此进行比较，从而指定分发处理阶段的节点。