Abstract: The present invention grasps in advance a portion in which traffic is concentrated and which may become a bottleneck and simplifies management of an access path. In a storage network system that forms multiple paths between a large-capacity data storage device and a host computer that employs the data storage device, and transfers data by means of a selected path, access paths are managed by a management server. The management server selects a second access path that can be used as a replacement of a first access path that connects the data storage device with the host computer, and calculates the quantity of traffic on the first access path which is associated with a device disposed on the first access path. Also, the management server calculates a variation of the quantity of traffic on the second access path which is associated with a device disposed on the second access path taking the calculated quantity of traffic into consideration.

Abstract: The amount of work processing (main processing amount) of a database is acquired and accumulated. A value (main processing index) indicating the transition of the amount of main processing amount available in a time frame that is presumed to be required for backup is calculated by using the amounts of main processing accumulated during the latest period of time. The main processing index is compared with the backup executability reference value which is a threshold value determining the backup executability. If the main processing index is smaller than the threshold value, backup is executed. If the main processing index is larger than the threshold value, backup is not executed but the amount of main processing is again acquired to calculate the main processing index, and the main processing index is compared with the backup executability reference value.

Abstract: A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.

Abstract: A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.

Abstract: The present invention grasps in advance a portion in which traffic is concentrated and which may become a bottleneck and simplifies management of an access path. In a storage network system that forms multiple paths between a large-capacity data storage device and a host computer that employs the data storage device, and transfers data by means of a selected path, access paths are managed by a management server. The management server selects a second access path that can be used as a replacement of a first access path that connects the data storage device with the host computer, and calculates the quantity of traffic on the first access path which is associated with a device disposed on the first access path. Also, the management server calculates a variation of the quantity of traffic on the second access path which is associated with a device disposed on the second access path taking the calculated quantity of traffic into consideration.

Abstract: In display processing and input processing of multidimensional aggregate patterns, a graph including coordinate axes for displaying aggregation levels of respective dimensions is used. An aggregate pattern of each aggregate cube is displayed as a figure on the graph. By using position relations on the graph, the relation between pre-aggregate data and aggregated data is visualized. On the basis of the position relations on the graph, the user can select a pre-aggregate cube.

Abstract: A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: In display processing and input processing of multidimensional aggregate patterns, a graph including coordinate axes for displaying aggregation levels of respective dimensions is used. An aggregate pattern of each aggregate cube is displayed as a figure on the graph. By using position relations on the graph, the relation between pre-aggregate data and aggregated data is visualized. On the basis of the position relations on the graph, the user can select a pre-aggregate cube.

Abstract: A request accepting server accepts a processing request of data of a predetermined type, analyzes the request, and allocates a process corresponding to the request to either one of the request accepting server and at least one database processing server. A handle is a control block to manage a storage area of data as a processing target and has a server in which the processing target data has been stored and information regarding its storing position. When the processing target data corresponding to the processing request is processed in accordance with the processing request, the request accepting server executes a process according to the processing request by using a handle regarding the processing target data. When an entity of the processing target data is necessary, the entity of the processing target data is obtained on the basis of the handle and is processed.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: An operations management method for performing an operations management of a database, which is used by at least one of an application and a middleware is proved. In the operations management method, operations management information including execution details information and execution timing information required for performing the operations management of the database are registered in a database from at least one of the application and the middleware. At a specified time to start operations management of the application, a database operations management execution processing judges an execution timing for executing the operations management according to contents of the operations management information. At the execution timing of the operations management, the database operations management execution processing starts operating management utilities of the database to execute the operations management of the database.

Abstract: The execution time frame of on-line backup which lowers the degradation in services will be determined, even in a case where the amount of main processing of a database management system irregularly varies.

Abstract: A database management system that performs a first internal database operational management according to instruction information concerning the first database operational management. When a second database operational management additionally is performed by the database management system according to instruction information given from outside concerning the second database operational management, the database management system extracts information that includes a time range scheduled for executing the second database operational management.

Abstract: A database processing method for defining and operating data of file reference type which references a file. A column data insert request for specifying position information indicative of a storage location of a file and watch information for watching the file is received from a database client. A request for watching a file indicated by the position information is issued in accordance with the watch information. The position information and the watch information are stored in a database. The foregoing operations permit data in an external file placed outside a database to be treated as data equivalent to ordinary column data stored in the database to improve the integrity of the database.

Abstract: A request accepting server accepts a processing request of data of a predetermined type, analyzes the request, and allocates a process corresponding to the request to either one of the request accepting server and at least one database processing server. A handle is a control block to manage a storage area of data as a processing target and has a server in which the processing target data has been stored and information regarding its storing position. When the processing target data corresponding to the processing request is processed in accordance with the processing request, the request accepting server executes a process according to the processing request by using a handle regarding the processing target data. When an entity of the processing target data is necessary the entity of the processing target data is obtained on the basis of the handle and is processed.

Abstract: A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.

Abstract: A parallel database system retrieval method and system for transferring from database operation servers to a front end server only those data items that are used in subsequent processing, thereby shortening the query time when the unused data are massive. The invention allows an initial retrieval query to transfer only location information about the target data from a database operation server to the front end server. Using the location information the invention permits a subsequent query to get variable-bound location information so that the latter query will retrieve a desired sub-data item according to the acquired location information and dictionary information about the sub-data item locations within the data.