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

公开(公告)号：US5806058A

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

申请号：US668684

申请日：1996-06-24

申请人： Yasuharu Mori ,  Nobuo Kawamura

发明人： Yasuharu Mori ,  Nobuo Kawamura

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

CPC分类号： G06F17/30336 ,  Y10S707/99932

摘要： A database managing system for effecting management in accessing data stored in a database via an index is so configured so as to prevent duplication of index key values and increase of index key values from degrading the access performance and lowering the storage efficiency of the index. Upon receiving, from an application program, a request to add a data record, a database manager adds this data record to a data portion and effects addition and update of an index record in an index portion. An index manager intervenes in this processing and excepts, from the index portion, an index record containing an index key value which has reached an upper limit value of the number of duplications preset in an exception key managing table. At the time of recreation of the index, the index manager refers to access time contained in index records and excepts index records which have not been accessed during an elapse of a fixed period of time.

摘要翻译： 通过索引对存储在数据库中的数据进行管理的数据库管理系统被配置为防止索引关键字的重复和索引关键字值的增加，从而降低访问性能并降低索引的存储效率。 在从应用程序接收到添加数据记录的请求时，数据库管理器将该数据记录添加到数据部分，并且对索引部分中的索引记录进行添加和更新。 索引管理器介入该处理，除了索引部分之外，还包括索引记录，该索引记录包含达到在异常密钥管理表中预设的重复次数的上限值的索引关键字值。 在索引重建时，索引管理器指的是索引记录中包含的访问时间，以及在固定时间段内没有被访问的索引记录。

公开(公告)号：US5778388A

公开(公告)日：1998-07-07

申请号：US529176

申请日：1995-09-15

申请人： Nobuo Kawamura ,  Kazuo Masai ,  Nobuyuki Yamashita ,  Hiroshi Nagai

发明人： Nobuo Kawamura ,  Kazuo Masai ,  Nobuyuki Yamashita ,  Hiroshi Nagai

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

CPC分类号： G06F11/1466 ,  G06F11/1474 ,  G06F2201/80 ,  Y10S707/99932 ,  Y10S707/99953 ,  Y10S707/99954

摘要： In a database management method and a database management system in which transactions need not be stopped at a synchronization point (syncpoint) acquired at a fixed interval of time, when a point to acquire a syncpoint is reached in a database control procedure, a syncpoint acquisition start log is output and then a syncpoint acquisition flag is set ON in a page control table of each updated page existing in a buffer pool. In the operation, a list of update page control tables is also created to write in the database the pages which are indicated in the list thus prepared. However, for a transaction accessing the pertinent updated page prior to the write operation thereof in the database, the data write operation is performed before the page is referenced, thereby enabling the access to be performed to the database without interrupting the transaction.

摘要翻译： 在数据库管理方法和数据库管理系统中，其中事务不需要在以固定时间间隔获取的同步点（syncpoint）停止，当在数据库控制过程中达到获取同步点的点时，同步点获取 输出开始日志，然后在存储在缓冲池中的每个更新页面的页面控制表中将同步点获取标志设置为ON。 在操作中，还创建了更新页面控制表的列表，以便在数据库中写入由此准备的列表中指示的页面。 然而，对于在其在数据库中的写入操作之前访问相关更新页面的事务，在引用页面之前执行数据写入操作，从而使得能够对数据库执行访问而不中断事务。

公开(公告)号：US07991749B2

公开(公告)日：2011-08-02

申请号：US12329143

申请日：2008-12-05

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

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

公开(公告)号：US20100121824A1

公开(公告)日：2010-05-13

申请号：US12651752

申请日：2010-01-04

申请人： Nobuo Kawamura ,  Kota Yamaguchi ,  Takashi Oeda

发明人： Nobuo Kawamura ,  Kota Yamaguchi ,  Takashi Oeda

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

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

摘要： A technique capable of constructing a disaster recovery system reduced in performance degradation of a primary system is provided. The technique includes a step of conducting synchronous writing of log information into a secondary storage subsystem in a secondary system when a write request received from a host computer is a write request of log information, a step of temporarily storing a write request and conducting asynchronous writing into the secondary storage subsystem when the received write request is a write request of database data or status information, a step of modifying log information, data in a database area, and status information in the secondary storage subsystem according to contents of a write request received from a primary storage subsystem, and a step of recovering the database area according to contents of log information in a location indicated by the status information.

摘要翻译： 提供了一种能够构建灾难恢复系统的技术，降低了主系统的性能下降。 该技术包括当从主计算机接收的写请求是日志信息的写请求时，将日志信息同步写入次系统中的次存储子系统的步骤，临时存储写请求并进行异步写入的步骤 当所接收到的写入请求是数据库数据或状态信息的写入请求时，进入辅助存储子系统，根据所接收到的写入请求的内容，修改日志信息，数据库区域中的数据和辅助存储子系统中的状态信息 以及根据状态信息指示的位置中的日志信息的内容来恢复数据库区域的步骤。

公开(公告)号：US07567989B2

公开(公告)日：2009-07-28

申请号：US11065361

申请日：2005-02-25

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

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

IPC分类号： G06F12/00 ,  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.

摘要翻译： 通过并行数据库管理系统中的事务来保证更新的内容。 数据库管理系统包括管理副本数据库的副本数据库管理单元，在每个数据库管理单元中生成的交易中的一个有效的定时记录同步信息，在每个数据库管理单元中记录其他事务无效的提取更新信息 以及用于从更新日志创建副本数据库的同步信息，并且使副本数据库管理单元在记录同步信息之前导入已变为有效的每个事务的更新信息。

公开(公告)号：US20090024384A1

公开(公告)日：2009-01-22

申请号：US12232336

申请日：2008-09-16

申请人： Susumu Kobayashi ,  Yukio Nakano ,  Nobuo Kawamura ,  Masashi Tsuchida ,  Shunichi Torii

发明人： Susumu Kobayashi ,  Yukio Nakano ,  Nobuo Kawamura ,  Masashi Tsuchida ,  Shunichi Torii

IPC分类号： G06F17/20

CPC分类号： G06F17/2863 ,  G06F17/275 ,  G06F17/289

摘要： A database access management unit manages accesses to databases managed by a plurality of data processing servers each provided for each data kind. A request analysis unit analyzes a request from an application containing a process request for each data kind. A process server selection unit selects the data processing server for executing a data process in accordance with the data kind. A data process request unit requests the data processing server to execute the data process. A process result edition unit edits the process result by the data processing server.

摘要翻译： 数据库访问管理单元管理对由每种数据类型提供的多个数据处理服务器管理的数据库的访问。 请求分析单元分析来自包含每个数据类型的处理请求的应用的请求。 处理服务器选择单元根据数据类型选择用于执行数据处理的数据处理服务器。 数据处理请求单元请求数据处理服务器执行数据处理。 处理结果编辑单元通过数据处理服务器编辑处理结果。

公开(公告)号：US07353335B2

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

申请号：US11396644

申请日：2006-04-04

申请人： Nobuo Kawamura

发明人： Nobuo Kawamura

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

CPC分类号： G06F11/2071 ,  G06F11/2074 ,  G06F11/2076 ,  G06F17/30312 ,  G06F17/30368 ,  Y10S707/99953

摘要： The present invention is constituted so as to enable the recovery of a database even when a log comprising a DB update history is not created. When executing a transaction in the logless mode, a logless-start log is created and written to a primary log VOL 55A at the start of this transaction, and this logless-start log is also written to a secondary log VOL 55B. Thereafter, batch processing is carried out for a DB of a primary DB VOL 51A, and while this transaction is being executed, the pair-split state of the DB VOL is cancelled either prior to the start or after the end of the batch processing, and if the difference between the DB VOLs is eliminated subsequent to the end of batch processing, a logless-end log is created and written to the primary log VOL 55A, and this log is also written to the secondary log VOL 55B.

摘要翻译： 本发明构成为即使在不创建包含DB更新历史的日志的情况下也能够恢复数据库。 在无日志模式下执行事务时，将在此事务开始时创建一个无日志启动日志并将其写入主日志VOL 55 A，并将此无启动日志写入辅助日志VOL 55 B.此后 对于主DB VOL 51A的DB执行批量处理，并且在执行该事务时，在批处理开始之前或之后取消DB VOL的成对拆分状态， 并且如果在批量处理结束之后消除DB VOL之间的差异，则创建无log-end日志并将其写入主日志VOL 55 A，并且该日志也被写入辅助日志VOL 55B。

公开(公告)号：US07321907B2

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

申请号：US10929699

申请日：2004-08-30

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

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

IPC分类号： G06F17/30

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.

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

公开(公告)号：US07263580B2

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

申请号：US10849022

申请日：2004-05-20

申请人： Hiroyasu Kiba ,  Nobuo Kawamura

发明人： Hiroyasu Kiba ,  Nobuo Kawamura

IPC分类号： G06F12/00

CPC分类号： G06F12/0804 ,  G06F12/0866

摘要： A data processing system is used which is provided with a computer for executing a program, and a storage unit having a cache memory for storing data transmitted as a result of execution of the program and a disk device for storing data stored in the cache memory. The storage unit responds to an input of a request for storing data transmitted from the program to store the transmitted data in the cache memory. Next, the storage unit responds to an input of a request for flashing transmitted from the program to store, in the disk device, the data stored in the cache memory.

摘要翻译： 使用具有用于执行程序的计算机的数据处理系统，以及具有用于存储作为执行程序的结果而发送的数据的高速缓冲存储器的存储单元和用于存储存储在高速缓冲存储器中的数据的盘装置。 存储单元响应于从程序发送的数据存储请求的输入，以将所发送的数据存储在高速缓冲存储器中。 接下来，存储单元响应于从程序发送的用于闪存的请求的输入，以在盘设备中存储存储在高速缓存存储器中的数据。