公开(公告)号：US20070185923A1

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

申请号：US11386982

申请日：2006-03-23

申请人： Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

发明人： Norifumi Nishikawa ,  Takashi Oeda ,  Nobuo Kawamura ,  Kazuhiko Mogi

IPC分类号： G06F17/30

CPC分类号： G06F11/1471 ,  G06F2201/80 ,  G06F2201/84 ,  Y10S707/99945 ,  Y10S707/99953

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

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

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

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

公开(公告)号：US20070022265A1

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

申请号：US11526047

申请日：2006-09-25

申请人： Norifumi Nishikawa ,  Kazuhiko Mogi ,  Nobuo Kawamura ,  Takashi Oeda

发明人： Norifumi Nishikawa ,  Kazuhiko Mogi ,  Nobuo Kawamura ,  Takashi Oeda

IPC分类号： G06F12/16

CPC分类号： G06F11/2087 ,  G06F11/2033 ,  G06F11/2038 ,  G06F11/2069 ,  G06F11/2074 ,  G06F11/2097

摘要： A method include a configuration definition creation step of writing configuration information on a primary site into a storage subsystem; a data transfer step of copying the configuration information, which is written into a storage device, to a storage subsystem in a secondary site over a network; a data reception step of receiving the transferred configuration information and storing it in the storage subsystem in the secondary site; and a configuration definition step of reading the stored configuration information and settings up a server in the secondary site.

公开(公告)号：US20060074847A1

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

申请号：US11065361

申请日：2005-02-25

申请人： Eiji Yatabe ,  Nobuo Kawamura ,  Yasuhiro Takahashi ,  Hideaki Sunami

发明人： Eiji Yatabe ,  Nobuo Kawamura ,  Yasuhiro Takahashi ,  Hideaki Sunami

IPC分类号： G06F17/30

CPC分类号： G06F17/30581 ,  Y10S707/99953

摘要： To guarantee that contents of an update by a transaction in a parallel database management system. A database management system includes a replica database management unit that manages the replica database, records synchronous information at a timing at which one of the transaction generated is valid in every database management unit and other transactions are invalid in every database management unit, extracts update information and the synchronous information for creating the replica database from the update logs, and causes the replica database management unit to import the update information of each transaction that has become valid before the synchronous information was recorded.

公开(公告)号：US20060004877A1

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

申请号：US10932100

申请日：2004-09-02

申请人： Taichi Ishikawa ,  Nobuo Kawamura

发明人： Taichi Ishikawa ,  Nobuo Kawamura

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： A data processing apparatus includes a storage device having a replication generation function for replicating a data base to create a replication data base, and stores data and a plurality of log information in transaction processing that uses the data in the storage device, selects a transaction that is performing a data operation without meeting a predetermined condition after synchronization between the data base and the replication data base is released, and performs the data operation cancellation processing to the replication data base by the selected transaction. It also selects a transaction, which meets the predetermined condition and is not performing a data operation to the replication data base, to perform a data operation to the replication data base with the selected transaction. It then becomes possible to reduce the burden for the data processing apparatus during using the replication data base.

摘要翻译： 数据处理装置包括具有用于复制数据库以创建复制数据库的复制生成功能的存储装置，并且将数据和多个日志信息存储在使用存储装置中的数据的事务处理中， 在数据库和复制数据库之间的同步之后不执行预定条件执行数据操作，并且通过所选择的事务对复制数据库执行数据操作取消处理。 它还选择满足预定条件并且不对复制数据库执行数据操作的事务，以便利用所选择的事务对复制数据库执行数据操作。 因此，可以减少使用复制数据库期间的数据处理装置的负担。

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

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

公开(公告)号：US06829623B2

公开(公告)日：2004-12-07

申请号：US09944262

申请日：2001-08-31

申请人： Masashi Tsuchida ,  Nobuo Kawamura ,  Nobuyuki Yamashita

发明人： Masashi Tsuchida ,  Nobuo Kawamura ,  Nobuyuki Yamashita

IPC分类号： G06F1730

CPC分类号： G06F11/2094 ,  G06F11/2097 ,  G06F17/30575 ,  G06F2201/80 ,  Y10S707/954 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99945 ,  Y10S707/99953 ,  Y10S707/99955

摘要： The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database. When the above duplication or incorporation is completed, the intermediate storage unit is updated for the transactions that have taken place during the above operations to be synchronized with the main storage unit.

摘要翻译： 该系统至少管理多个数据库存储单元中的数据库，并且重复数据库以进行冗余。 系统维护数据库冗余以实现安全。 该系统能够维护和重组数据库存储单元，而不会中断正在进行的涉及对数据库存储单元的访问的操作。 可以通过分配一对主存储单元和维持基本上相同的数据的中间存储单元来获得不间断的数据库访问。 在某些预定操作期间，主存储单元被专用于正在进行的事务，而中间数据库存储单元被操纵以包含对应于指定时间的数据。 例如，中间存储器的内容随后被复制或用于更新另一个数据库。 当上述复制或并入完成时，中间存储单元被更新为在上述操作期间发生的与主存储单元同步的事务。

公开(公告)号：US06567806B1

公开(公告)日：2003-05-20

申请号：US09666884

申请日：2000-09-20

申请人： Masashi Tsuchida ,  Yukio Nakano ,  Nobuo Kawamura ,  Kazuyoshi Negishi ,  Shunichi Torii

发明人： Masashi Tsuchida ,  Yukio Nakano ,  Nobuo Kawamura ,  Kazuyoshi Negishi ,  Shunichi Torii

IPC分类号： G06F1730

CPC分类号： G06F17/3056 ,  G06F17/30445 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99937

摘要： A database management system for executing database operations in parallel by a plurality of nodes and a query processing method are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

摘要翻译： 描述用于由多个节点并行执行数据库操作的数据库管理系统和查询处理方法。 数据库管理系统包含用于确定分发节点以检索信息的决策管理节点，以便分析从应用程序接收到的查询，生成用于处理查询的处理过程，并执行该处理和连接节点进行排序，合并 并且加入由分发节点检索的信息。 当执行查询处理时，由决策管理节点决定的分发节点检索要处理的信息，由决策管理节点决定的连接节点也从检索到的信息中获取查询结果。 查询结果从输出节点输出并传送到应用程序。

公开(公告)号：US06556986B2

公开(公告)日：2003-04-29

申请号：US10029239

申请日：2001-12-28

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

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

IPC分类号： G06F1730

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

摘要： A method and a system for executing a general database processing independent of a specific user-defined function are provided. In an implementation method, 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 in response to a processing request for the database issued from an end user, that the user-defined function contained therein 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 from the module definition information, and a database processing is performed using the implementation module thus selected.

摘要翻译： 提供了用于执行独立于特定用户定义功能的一般数据库处理的方法和系统。 在实现方法中，创建用于根据用于对数据库区域中的数据进行索引访问的特定索引来设置特定用户定义函数的索引定义信息，以及用于设置特定索引的模块定义信息 用于对与数据库区域中的数据进行特定处理的实现模块相对应地执行对数据库区域中的数据的索引访问。 当响应于从最终用户发出的对数据库的处理请求而确定，根据索引定义信息将其中包含的用户定义功能与特定索引相对应地设置时，用于承载的特定实现模块 从模块定义信息中选择使用特定索引的访问，并且使用由此选择的实现模块执行数据库处理。

公开(公告)号：US06427145B1

公开(公告)日：2002-07-30

申请号：US09516778

申请日：2000-03-01

申请人： 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”的表数据的标识符。 除非生成索引，否则决定是否通过访问数据库获取的列数据满足查询中包含的谓词中指定的条件。