公开(公告)号：US09864777B2

公开(公告)日：2018-01-09

申请号：US12473322

申请日：2009-05-28

申请人： Soh Kaijima ,  Masahiro Okawa ,  Akira Sakaguchi ,  Masakazu Sano

发明人： Soh Kaijima ,  Masahiro Okawa ,  Akira Sakaguchi ,  Masakazu Sano

IPC分类号： G06F17/30

CPC分类号： G06F17/30492 ,  G06F17/30306

摘要： To provide efficient table partitioning, a database is described for distributively locating a plurality of sub-tables resulting from partitioning of a table in a database. This includes an acquiring section that monitors access occurrences to each of the sub-tables to acquire a history of access occurrences. Also a deciding section decides a table storage area in which a sub-table is to be located, based on the history of access occurrences to each of the sub-tables.

公开(公告)号：US20090300040A1

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

申请号：US12473322

申请日：2009-05-28

申请人： Soh Kaijima ,  Masahiro Okawa ,  Akira Sakaguchi ,  Masakazu Sano

发明人： Soh Kaijima ,  Masahiro Okawa ,  Akira Sakaguchi ,  Masakazu Sano

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

CPC分类号： G06F17/30492 ,  G06F17/30306

摘要： To provide efficient table partitioning, a database is described for distributively locating a plurality of sub-tables resulting from partitioning of a table in a database. This includes an acquiring section that monitors access occurrences to each of the sub-tables to acquire a history of access occurrences. Also a deciding section decides a table storage area in which a sub-table is to be located, based on the history of access occurrences to each of the sub-tables.

摘要翻译： 为了提供有效的表分区，描述了一种数据库，用于分布式定位由数据库中的表的分区产生的多个子表。 这包括一个获取部分，监视每个子表的访问事件，以获取访问事件的历史记录。 另外，决定部基于各个子表的访问历史来决定其中要存在子表的表存储区。

公开(公告)号：US08301607B2

公开(公告)日：2012-10-30

申请号：US12503308

申请日：2009-07-15

申请人： Soh Kaijima ,  Gou Nakashima ,  Masahiro Okawa

发明人： Soh Kaijima ,  Gou Nakashima ,  Masahiro Okawa

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

CPC分类号： G06F9/542

摘要： An embodiment of the invention includes an information management server with a registration unit that registers a status change condition of a database and a notification action so that they are associated with each other. Also, the information management server includes a communication unit that receives an acquisition request for a status change notification via database connection established with respect to a client and a change detection unit that detects a status change satisfying the condition of the acquisition request and invokes the notification action associated therewith. According to aspect of the invention, a notification unit causes the communication unit to send a notification including a result of the notification action via the database connection as a response to the acquisition request, and returns control of the connection to the client.

摘要翻译： 本发明的实施例包括具有注册单元的信息管理服务器，其注册数据库的状态改变条件和通知动作使得它们彼此关联。 此外，信息管理服务器包括通信单元，其经由针对客户端建立的数据库连接来接收关于状态改变通知的获取请求，以及变更检测单元，其检测满足获取请求的条件的状态变化并调用通知 与此有关的行为。 根据本发明的方面，通知单元使得通信单元作为对获取请求的响应，经由数据库连接发送包括通知动作的结果的通知，并且返回到客户端的连接的控制。

公开(公告)号：US20100017442A1

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

申请号：US12503308

申请日：2009-07-15

申请人： Soh Kaijima ,  Gou Nakashima ,  Masahiro Okawa

发明人： Soh Kaijima ,  Gou Nakashima ,  Masahiro Okawa

IPC分类号： G06F17/30 ,  G06F9/46

CPC分类号： G06F9/542

摘要： An embodiment of the invention includes an information management server with a registration unit that registers a status change condition of a database and a notification action so that they are associated with each other. Also, the information management server includes a communication unit that receives an acquisition request for a status change notification via database connection established with respect to a client and a change detection unit that detects a status change satisfying the condition of the acquisition request and invokes the notification action associated therewith. According to aspect of the invention, a notification unit causes the communication unit to send a notification including a result of the notification action via the database connection as a response to the acquisition request, and returns control of the connection to the client.

摘要翻译： 本发明的实施例包括具有注册单元的信息管理服务器，其注册数据库的状态改变条件和通知动作使得它们彼此关联。 此外，信息管理服务器包括通信单元，其经由针对客户端建立的数据库连接来接收关于状态改变通知的获取请求，以及变更检测单元，其检测满足获取请求的条件的状态变化并调用通知 与此有关的行为。 根据本发明的方面，通知单元使得通信单元作为对获取请求的响应，经由数据库连接发送包括通知动作的结果的通知，并且返回到客户端的连接的控制。

公开(公告)号：US09424316B2

公开(公告)日：2016-08-23

申请号：US13312194

申请日：2011-12-06

申请人： Soh Kaijima ,  Katsuyoshi Katori ,  Seiji Minami ,  Masakazu Sano

发明人： Soh Kaijima ,  Katsuyoshi Katori ,  Seiji Minami ,  Masakazu Sano

IPC分类号： G06F17/30 ,  G06F11/20

CPC分类号： G06F17/30492 ,  G06F11/1451 ,  G06F11/2056 ,  G06F11/2094 ,  G06F17/30519 ,  G06F17/30575 ,  G06F2201/80

摘要： A system for managing a plurality of storage devices that are configured to store a database. The system includes an access instruction acquiring unit configured for acquiring an access instruction to access the database. The system also includes a predicting unit configured for predicting a table to be accessed in response to the acquired access instruction. The system further includes a relocation unit configured for mirroring the table predicted by the predicting unit, the mirroring between the plurality of storage devices.

摘要翻译： 一种用于管理被配置为存储数据库的多个存储设备的系统。 该系统包括访问指令获取单元，被配置为获取访问数据库的访问指令。 该系统还包括：预测单元，被配置为响应于获取的访问指令来预测要访问的表。 该系统还包括：重定位单元，被配置为镜像由预测单元预测的表，多个存储设备之间的镜像。

公开(公告)号：US20120166395A1

公开(公告)日：2012-06-28

申请号：US13312194

申请日：2011-12-06

申请人： Soh Kaijima ,  Katsuyoshi Katori ,  Seiji Minami ,  Masakazu Sano

发明人： Soh Kaijima ,  Katsuyoshi Katori ,  Seiji Minami ,  Masakazu Sano

IPC分类号： G06F7/00

CPC分类号： G06F17/30492 ,  G06F11/1451 ,  G06F11/2056 ,  G06F11/2094 ,  G06F17/30519 ,  G06F17/30575 ,  G06F2201/80

摘要： A system for managing a plurality of storage devices that are configured to store a database. The system includes an access instruction acquiring unit configured for acquiring an access instruction to access the database. The system also includes a predicting unit configured for predicting a table to be accessed in response to the acquired access instruction. The system further includes a relocation unit configured for mirroring the table predicted by the predicting unit, the mirroring between the plurality of storage devices.

摘要翻译： 一种用于管理被配置为存储数据库的多个存储设备的系统。 该系统包括访问指令获取单元，被配置为获取访问数据库的访问指令。 该系统还包括：预测单元，被配置为响应于获取的访问指令来预测要访问的表。 该系统还包括：重定位单元，被配置为镜像由预测单元预测的表，多个存储设备之间的镜像。

公开(公告)号：US08949192B2

公开(公告)日：2015-02-03

申请号：US12254697

申请日：2008-10-20

申请人： Soh Kaijima ,  Masahiro Ohkawa ,  Akira Sakaguchi

发明人： Soh Kaijima ,  Masahiro Ohkawa ,  Akira Sakaguchi

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

CPC分类号： G06F17/30557 ,  G06F17/30575

摘要： A method of controlling access to a database includes autonomously archiving data within a database from a first storage device into a second storage device, according to an archive condition; the archive condition being input in conjunction with the data and being associated with the data; accepting an input of an access command to the database; determining whether data to be accessed in response to the access command input has already been archived in the second storage device based on the access command and the archive condition; and accessing data included in the database or data archived in the second storage device according to the access command based on the determination.

摘要翻译： 控制对数据库的访问的方法包括根据存档条件自动地将数据库内的数据从第一存储设备归档到第二存储设备中; 归档条件与数据一起输入并与数据相关联; 接受对数据库的访问命令的输入; 基于访问命令和存档条件，确定响应于访问命令输入要访问的数据是否已经被存档在第二存储设备中; 以及基于所述确定，根据所述访问命令访问包括在所述数据库中的数据或存储在所述第二存储设备中的数据。

公开(公告)号：US20090187612A1

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

申请号：US12254697

申请日：2008-10-20

申请人： Soh Kaijima ,  Masahiro Ohkawa ,  Akira Sakaguchi

发明人： Soh Kaijima ,  Masahiro Ohkawa ,  Akira Sakaguchi

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

CPC分类号： G06F17/30557 ,  G06F17/30575

摘要： A method of controlling access to a database includes autonomously archiving data within a database from a first storage device into a second storage device, according to an archive condition; the archive condition being input in conjunction with the data and being associated with the data; accepting an input of an access command to the database; determining whether data to be accessed in response to the access command input has already been archived in the second storage device based on the access command and the archive condition; and accessing data included in the database or data archived in the second storage device according to the access command based on the determination.

摘要翻译： 控制对数据库的访问的方法包括根据存档条件自动地将数据库内的数据从第一存储设备归档到第二存储设备中; 归档条件与数据一起输入并与数据相关联; 接受对数据库的访问命令的输入; 基于访问命令和存档条件，确定响应于访问命令输入要访问的数据是否已经被存档在第二存储设备中; 以及基于所述确定，根据所述访问命令访问包括在所述数据库中的数据或存档在所述第二存储设备中的数据。

公开(公告)号：US20080154979A1

公开(公告)日：2008-06-26

申请号：US11614737

申请日：2006-12-21

申请人： Takashi Saitoh ,  Soh Kaijima

发明人： Takashi Saitoh ,  Soh Kaijima

IPC分类号： G06F17/30

CPC分类号： G06F11/1461 ,  G06F11/1464 ,  G06F2201/80

摘要： An apparatus, system, and method for creating a database backup schedule in a SAN environment based on a recovery plan. A user provides a desired recovery point objective (RPO) from a system recovery plan and an identifier of a database for back up. The present invention determines a priority (w) for a recent recovery point and determines a number (N) of volumes for storing backup images and a number (n) of database volumes used by the database. The present invention generates a scheduling formula where RPO is divided by the priority (w) of the most recent recovery point raised to the power of the truncated integer value of the ratio of volumes for storing backup images (N) and the number of volumes in use by the database (n) minus a scheduling interval determinant (i). The scheduling formula is used to determine a backup interval and backup assurance points.

摘要翻译： 一种基于恢复计划在SAN环境中创建数据库备份计划的设备，系统和方法。 用户从系统恢复计划和用于备份的数据库的标识符提供期望的恢复点目标（RPO）。 本发明确定最近的恢复点的优先级（w），并且确定用于存储备份图像的数量（N）和数据库使用的数量（n）数量。 本发明生成调度公式，其中将RPO除以最近的恢复点的优先级（w）提高到用于存储备份图像（N）的卷的比例的截断整数值的功率和在 由数据库（n）使用减去调度间隔行列式（i）。 调度公式用于确定备份间隔和备份保证点。

公开(公告)号：US08082229B2

公开(公告)日：2011-12-20

申请号：US11347487

申请日：2006-02-03

申请人： Soh Kaijima ,  Takashi Saitoh ,  Kenji Seta

发明人： Soh Kaijima ,  Takashi Saitoh ,  Kenji Seta

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

CPC分类号： G06F11/1464

摘要： Various embodiments of a method, system and computer program product backup and recover a database. A database is distributed in a plurality of storage devices. A target designation designating a target database is received. One or more storage devices of the plurality of storage devices, storing at least a portion of the target database, are selected. A quiesce point is established by completing an ongoing transaction for the target database and inhibiting a further transaction. In response to establishing the quiesce point, a backup is generated by collectively copying data on each storage device of the one or more selected storage devices. The backup associated with a quiesce point indication indicating backed up data of the said each storage device of the one or more selected storage devices in accordance with the quiesce point, are recorded.

摘要翻译： 方法，系统和计算机程序产品备份和恢复数据库的各种实施例。 数据库分布在多个存储设备中。 接收指定目标数据库的目标名称。 选择存储目标数据库的至少一部分的多个存储装置中的一个或多个存储装置。 通过完成目标数据库的持续交易并禁止进一步的交易来建立停顿点。 响应于建立停顿点，通过在一个或多个所选存储设备的每个存储设备上集体复制数据来生成备份。 记录与静止点指示相关联的备份，其指示根据静默点的所述一个或多个所选择的存储设备的所述每个存储设备的备份数据。