Abstract:
There is a strong demand for facilitation of management of storage region for DB data is required in a computer system combining an apparatus having the DBMS and virtualization function and software. In order to realize such requirement, the requirements for system management regarding a newly created DB and the information about the function to be set for the DB data are given to a system management server. The system management server detects a data structure of DB from such information and sends independently instructions to virtualization apparatuses to create virtual volumes or the like to which the data of each data structure is stored separately and set the function to the virtual volume as required. Thereafter, the system management server also issues an instruction to the DBMS to create a DB to store the data of data structure to the corresponding virtual volume.
Abstract:
A computer system identifies jobs affected by a fault which occurs in any device or mechanism in a storage system to control the execution of such jobs. The computer system includes a DBMS server device, a virtualization switch device, and storage device. Each of these devices holds part of data mapping information on a data mapping path from a particular DB table accessed by a job, through a logical volume for storing the table, to physical disk units for distributively storing data on the volume. The management server device acquires the part of data mapping information from each device, and integrates the data mapping information on a job-by-job basis. When any device or mechanism fails on the data mapping path, the management server device identifies jobs affected by the fault with reference to the data mapping information. The management server device also controls the execution of these jobs.
Abstract:
In a system in which a DB is built in a virtualization environment, a management server obtains DB processing information such as a DB processing execution plan and a degree of processing priority from a DBMS, predicts data to be accessed in the near future and the order of such accesses based on the information, instructs to read into caches of storage devices data to be accessed in the near future based on the prediction results, and reads the data that will be accessed in the nearest future into a cache memory within the management server.
Abstract:
A method include a configuration definition creation step of writing configuration information on a primary site into a storage subsystem; a data transfer step of copying the configuration information, which is written into a storage device, to a storage subsystem in a secondary site over a network; a data reception step of receiving the transferred configuration information and storing it in the storage subsystem in the secondary site; and a configuration definition step of reading the stored configuration information and settings up a server in the secondary site.
Abstract:
A storage system for providing a preferable data access performance by performing controls considering database management system (DBMS) execution information or database process priorities, by acquiring static configurational information of a DBMS by means of a DBMS information acquisition and communication program, a DBMS information communication section, and a host information setting program; acquiring DBMS execution information by means of a query plan acquisition program, the DBMS information communication section, and a process performance management program; acquiring information on priorities of database processes given by the process performance management program; and storing them in disk I/O management information with process priorities, DBMS execution information, and DBMS data information, in which cache control section in a storage system control program controls a data cache by referring to the above information.
Abstract:
Even when an assignment request of storage areas exceeding unassigned areas is issued from a server, storage areas can be assigned to the server, so that storage areas in a storage pool can be utilized effectively. A management server connected to a plurality of servers and storage apparatuses to manage physical storage areas of the storage apparatuses used by the plurality of servers as virtual areas (storage pool) is responsive to an area assignment instruction of storage areas exceeding unassigned areas received from a server to release at least part of assignment areas of other servers to be assigned to the server which issued the area assignment instruction.
Abstract:
A diversity receiver has distributors each of which is connected with each of a plurality of antennas, and as many antenna switches as there are receivers. Each of the antenna switches has as many contacts as there are distributors. The distributor distributes a radio frequency signal from the antenna into as many signal paths as there are receivers. Each of the antenna switches is connected with each of the distributors via the contact connected with the signal path. A demodulated signal selecting circuit has as many contacts as there are said receivers. The demodulated signal selecting circuit receives the demodulated output of the receivers via each of said second contacts to selectively output the demodulated outputs of the receivers.
Abstract:
A management system manages a plurality of data units constituting schemas of a database in a storage device, which includes a plurality of first storage device sets having a plurality of storage areas. An ordered schema constituted of the plurality of data units having order properties defining respective orders is included in the schemas. When a second storage device set, which is a set of one or more second storage devices and in which each of the storage areas is a free storage area, is added to the first storage device set, the management system migrates two or more data units not consecutive in the order among a plurality of data units stored in the plurality of storage areas in the first storage device set respectively from at least the one first storage device set to the free storage areas of the second storage device set.
Abstract:
A database management system (DBMS) generates a query execution plan including information representing one or more database (DB) operations necessary for executing a query, and executes the query in accordance with the query execution plan. In the execution of the query, the DBMS dynamically generates tasks for executing the DB operations and executes the dynamically generated tasks. The query execution plan includes a plurality of query blocks, which are sets of one or more DB operations. When newly generating a task, the DBMS executes determination processing of simultaneous-task-generation number. The determination processing of simultaneous-task-generation number is to calculate, targeting each of the query blocks, the number of simultaneous task generation, which is the number of tasks simultaneously generatable as tasks for executing the query block. The number of the dynamically generated tasks is equal to or smaller than the number of simultaneous task generation.
Abstract:
A parallel data processing system includes a parallel data processing execution unit for reading a data from a data set including a first data set that includes a plurality of first data and a second data set that includes a plurality of second data and executing processing. The parallel data processing execution unit (A) reads the first data from the first data set, and acquires a first value from the first data based on first format information acquired from an application, (B) generates one or more threads for respectively reading one or more second data corresponding to the first value from the second data set based on first reference information acquired from the application, (C) executes (A) and (B) on one or more first data in the first data set, and (D) executes a plurality of the threads in parallel.