Abstract: There is provided a method performed by a processor. The method comprises: showing a set of security candidates on a display device; receiving from an input device a selection input indicating a selection of two or more securities to be added to an ideal portfolio from the set of security candidates; adding the two or more securities to the ideal portfolio; determining an ideal allocation for the ideal portfolio such that an ideal expectation of return of the ideal portfolio and an ideal risk value indicating a magnitude of variation in the return of the ideal portfolio satisfy a predefined condition; and showing the ideal allocation on the display device.

Abstract: Methods and apparatus, including computer program products, implementing and using techniques for recovering a database, distributed in two or more storage devices, based on a backup of each storage device. The backup of each storage device is acquired. In association with the backup for each storage device, a quiesce point indication is acquired. The quiesce point indication indicates backed up data of each storage device. The backed up data is based on a quiesce point. For each storage device, a recovery process is selected. For each storage device, in response to the selected recovery process being a collective copying process, recovering contents of each storage device is done by collective copying. In response to the selected recovery process being to recover based on the quiesce point indication, the contents of each storage device is recovered based on the indicated backed up data of the quiesce point indication.

Abstract: A method, system and computer program product for storing a sub-table by deciding one of a plurality of table storage areas, the sub-tables resulting from partitioning of a table in a database. 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.

Abstract: 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.

Abstract: A method, system and computer program product for storing a sub-table by deciding one of a plurality of table storage areas, the sub-tables resulting from partitioning of a table in a database. 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.

Abstract: A method, system and computer program product for storing a sub-table by deciding one of a plurality of table storage areas, the sub-tables resulting from partitioning of a table in a database. 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.

Abstract: A method, system and computer program product for storing a sub-table by deciding one of a plurality of table storage areas, the sub-tables resulting from partitioning of a table in a database. 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: Methods and apparatus, including computer program products, implementing and using techniques for recovering a database, distributed in two or more storage devices, based on a backup of each storage device. The backup of each storage device is acquired. In association with the backup for each storage device, a quiesce point indication is acquired. The quiesce point indication indicates backed up data of each storage device. The backed up data is based on a quiesce point. For each storage device, a recovery process is selected. For each storage device, in response to the selected recovery process being a collective copying process, recovering contents of each storage device is done by collective copying. In response to the selected recovery process being to recover based on the quiesce point indication, the contents of each storage device is recovered based on the indicated backed up data of the quiesce point indication.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.