公开(公告)号：US20070016582A1

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

申请号：US11257328

申请日：2005-10-25

申请人： Nobuo Kawamura ,  Masaru Kitsuregawa ,  Kazuo Goda

发明人： Nobuo Kawamura ,  Masaru Kitsuregawa ,  Kazuo Goda

IPC分类号： G06F7/00

CPC分类号： G06F17/30312

摘要： Provided is a storage system in which a transaction of a database is quiesced, a pair of a first volume and a second volume is split so as to make settings to allow an access to be made only to the database in the first volume, the transaction is then released from the quiescent state, a sparse space is specified in the database stored in the second volume, only the specified sparse space in the second volume is partially reorganized, and the contents of the partially reorganized second volume are copied to the first volume such that the first volume and the second volume are resynchronized with each other to form the pair again.

摘要翻译： 提供了一种存储系统，其中数据库的事务被停顿，一对第一卷和第二卷被拆分，以便进行设置以允许仅对第一卷中的数据库进行访问，该事务 然后从静止状态释放，在第二个卷中存储的数据库中指定了一个稀疏空间，只有第二个卷中指定的稀疏空间被部分重新组织，部分重新组织的第二个卷的内容将被复制到第一个卷 使得第一卷和第二卷彼此重新同步以再次形成对。

公开(公告)号：US07054893B2

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

申请号：US10084540

申请日：2002-02-28

申请人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

发明人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

IPC分类号： G06F17/00

CPC分类号： G06F17/30312 ,  Y10S707/99953 ,  Y10S707/99956

摘要： A data storage position management main program collects volume physical storage position management information and physical storage apparatus operation information from a storage apparatus, and stores them as storage apparatus arrangement information and storage apparatus operation information. The program also collects necessary information from schema information in a DBMS, stores it as DBMS schema information, collects mapping information in a host and virtual volume information in a virtual volume switch, stores them as data storage position management information, acquires execution history information from the host, and stores it as a DBMS execution history information. The program determines a data relocation plan having a better performance characteristic on the basis of the above information.

公开(公告)号：US20050283504A1

公开(公告)日：2005-12-22

申请号：US10989398

申请日：2004-11-17

申请人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

发明人： Yoshio Suzuki ,  Nobuo Kawamura ,  Kota Yamaguchi ,  Shinji Fujiwara ,  Satoru Watanabe ,  Masaru Kitsuregawa

IPC分类号： G06F12/00

CPC分类号： G06F11/2028 ,  G06F11/2025 ,  G06F11/2097

摘要： To reduce operational and management costs during normal operations while recovering a database without loss and maintaining on-line performance on a site. A first system includes a primary storage system (103) that stores a DB (107) and a main computer (100) that executes a primary DBMS (101), which provides a DB. A second system includes a secondary (113) that receives from the primary storage system (103) a copy of a log, which shows update differences of the DB (107), and stores a secondary DBMS (117), and a subset (500) that recovers the secondary DB (117) according to the log that is copied from the primary storage system (103). When a failure occurs in the first system, the first system is switched to the second system. A second computer (110) that executes a second DBMS (111) is added to the second system, and the secondary DB (117) that is recovered or is being recovered in the subset (500) is taken over to the second computer (110).

摘要翻译： 在正常运行期间降低运营和管理成本，同时在不丢失数据库的情况下恢复数据库并维护站点上的在线性能。 第一系统包括存储DB（107）的主存储系统（103）和执行提供DB的主DBMS（101）的主计算机（100）。 第二系统包括次级（113），其从主存储系统（103）接收日志的副本，其显示DB（107）的更新差异，并存储辅助DBMS（117）和子集（500） ），其根据从主存储系统（103）复制的日志恢复辅助DB（117）。 当第一系统发生故障时，第一个系统切换到第二个系统。 执行第二DBMS（111）的第二计算机（110）被添加到第二系统，并且在子集（500）中恢复或正在恢复的辅助DB（117）被接管到第二计算机（110） ）。

公开(公告)号：US06928450B2

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

申请号：US10083354

申请日：2002-02-27

申请人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

发明人： Kazuhiko Mogi ,  Takashi Oeda ,  Masaru Kitsuregawa

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

CPC分类号： G06F17/30315 ,  Y10S707/99943

摘要： A storage apparatus acquires static constituent information of a database management system (DBMS) through a network by using a DBMS information acquisition/communication program, DBMS information communication portion, and host information setting program, and stores them as DBMS data information in its memory. The physical storage position managing/optimizing execution portion within a control program of the storage apparatus makes data allocation and cache control that consider the characteristics of the data base management system by using DBMS data information, thereby improving the data access performance of the storage apparatus.

摘要翻译： 存储装置通过使用DBMS信息获取/通信程序，DBMS信息通信部分和主机信息设定程序，通过网络获取数据库管理系统（DBMS）的静态构成信息，并将其作为DBMS数据信息存储在其存储器中。 存储装置的控制程序内的物理存储位置管理/优化执行部分通过使用DBMS数据信息来进行考虑数据库管理系统的特性的数据分配和高速缓存控制，从而提高存储装置的数据访问性能。

公开(公告)号：US5079736A

公开(公告)日：1992-01-07

申请号：US357128

申请日：1989-05-26

申请人： Masaru Kitsuregawa ,  Shinya Fushimi

发明人： Masaru Kitsuregawa ,  Shinya Fushimi

IPC分类号： G06F7/24

CPC分类号： G06F7/24 ,  G06F2207/222 ,  Y10S707/99937

摘要： A control data generator for a sort processor includes a control data output unit which consists of a storage unit for storing information about the length of input data and a control data generation unit responsive to the stored information to generate control data for switching each sort processor between the first function and the second function, whereby control data is generated without using any programs.