Abstract: Provided is a database processing system including: a computer for outputting data in response to a received query request; and a storage system including a storage device for storing the data, in which: the storage device stores a plurality of partial indices indicating a storage location of the data; the data stored in the storage device is grouped; and the computer is configured to: receive the query request for the data; acquire one of the plurality of partial indices; specify, based on the query request for the data and the acquired one of the plurality of partial indices, a location at which the requested data is stored; and send a request to acquire the data stored at the specified location to the storage system. Accordingly, in the database processing system, a time period necessary to input and output the data is shortened.

Abstract: Provided is a database system in which sorting of query results is sped up. The database system stores storage location information in which storage locations of the pieces of data are recorded in a given order. When there is no second task, which is executed based on data that is fetched in a first task, whether every piece of data requested in a third task, which is executed before the first task, has been fetched is determined. In the case where every piece of data requested in the third task has been fetched, data fetched in the first task is output. In the case where some of the data requested in the third task has not been fetched, data fetched in the first task is kept in a temporary buffer until every piece of data requested in the third task is fetched, and then output.

Abstract: A retrieval apparatus 100 for searching document data comprises a document storage area 141 for storing documents to be searched and a document management table 142 for storing a data size of a document such that the data size is associated with a document ID for identifying the document. The retrieval apparatus 100 reads out from the document management table data sizes of documents to be searched, and calculates a retrieval document size by adding up the read out data sizes, and calculates an estimated time t1 taken for a retrieval process by the index scan method and an estimated time t2 taken for the retrieval process by the text scan method, based on the retrieval document size. The retrieval apparatus 100 compares the estimated times t1 and t2, and decides which method to use for a retrieval process, the index scan method or the text scan method.

Abstract: An information management system for modifying action of system in accordance with previously set policy with reference to metadata and/or log data accompanying data to be managed makes efficient information lifecycle management by reducing the grading of the data to be managed and increasing the expressive power of the definable policy while suppressing increase of the amount of necessary metadata and/or log data. The ontology for defining the relation between terms referred in business level is introduced and analyzed together with the policy, so that the range necessary for acquisition of information can be clearly decided to thereby reduce time and labor required for modification of setting and the operation management cost and optimize necessary resources.

Abstract: A database management system has a plurality of database servers and data can be transferred between them by partitioning a data area into small areas and altering allocation of the small areas to the database servers. After altering the configuration, there occurs degradation in processing speed that accompanies re-creation of the index. If this problem is solved by using conventional techniques, noticeable degradation in processing speed will occur to a specific query at the time of a steady state operation. Accordingly, an index created for each of the small areas and an index to all of the small areas are allocated to the database server and used in combination.

Abstract: When operating a database management system that consists of a plurality of database servers and enables the database servers to transfer data between them by partitioning a data area into small areas and altering allocation of the small areas to the database servers, after altering the configuration, there occurs degradation in processing speed that accompanies re-creation of the index. If this problem is solved by using the conventional technique, noticeable degradation in processing speed will occur to a specific query at the time of a steady state operation. When operating the database management system that consists of the plurality of database servers and enables the database servers to transfer data between them by partitioning the database area into small areas and altering the allocation of the small areas to the database server, an index created for each of the small areas and an index to all the small areas allocated to the database server are used in combination.

Abstract: Even when information lifecycle management is applied to management object data of a database management system, inquiry service performance offered by the database management system can be guaranteed. Data arrangement managing system performs data arrangement settings in respect of management object data of the database management system and has a data arrangement setting creating module for determining possible data arrangement candidates and a data arrangement setting exchanging module for transferring the data arrangement candidates to the database management system. In the database management system, in respect of the individual data arrangement candidates transmitted to the database management system, execution profiles of service presupposing the candidates are created which are decided as to whether to satisfy a condition on database performance designated by a user and a narrowing down module narrows down the candidates to only data arrangement candidates satisfying the condition.

Abstract: A document search apparatus capable of an index-type search and a scan-type search performs a search in a combination of the two search types while compensating for the disadvantages of the two search types with each other. A search query for index-type search and a search query for scan-type search are constructed based on a search query consisting of a logical formula of keywords. Then, a character 2-gram for performing an index search is set to shorten the whole search time, and the index-type search is performed. Finally, a scan-type search is performed on this search result of the index-type search.

Abstract: A shared-nothing database management system employs a method of adding and removing a database server without significantly affecting the processing performance for accessing a table from a user or an application. A scheduler module creates a schedule which separately handles the addition of a CPU resource and the addition of a storage I/O resource, and a server is added in accordance with the created schedule. A common disk is used to remove a disk at an arbitrary timing. Further, a data region is previously subdivided on the common disk to eliminate a movement of data associated with the addition of a server.

Abstract: A retrieval apparatus 100 for searching document data comprises a document storage area 141 for storing documents to be searched and a document management table 142 for storing a data size of a document such that the data size is associated with a document ID for identifying the document. The retrieval apparatus 100 reads out from the document management table data sizes of documents to be searched, and calculates a retrieval document size by adding up the read out data sizes, and calculates an estimated time t1 taken for a retrieval process by the index scan method and an estimated time t2 taken for the retrieval process by the text scan method, based on the retrieval document size. The retrieval apparatus 100 compares the estimated times t1 and t2, and decides which method to use for a retrieval process, the index scan method or the text scan method.

Abstract: A shared-nothing database management system employs a method of adding and removing a database server without significantly affecting the processing performance for accessing a table from a user or an application. A scheduler module creates a schedule which separately handles the addition of a CPU resource and the addition of a storage I/O resource, and a server is added in accordance with the created schedule. A common disk is used to remove a disk at an arbitrary timing. Further, a data region is previously subdivided on the common disk to eliminate a movement of data associated with the addition of a server.

Abstract: A data relay server connected between a client computer and a database server produces a query message obtained by encrypting a retrieval condition designated by the client computer, and transmits the query message to the database server. The database server encrypts a specific data item which is designated by the retrieval condition and read out from the database, retrieves service information matched with the retrieval condition by encrypted data matching, and replies the service information as a retrieval result to the data relay server.

Abstract: A data relay server connected between a client computer and a database server produces a query message obtained by encrypting a retrieval condition designated by the client computer, and transmits the query message to the database server. The database server encrypts a specific data item which is designated by the retrieval condition and read out from the database, retrieves service information matched with the retrieval condition by encrypted data matching, and replies the service information as a retrieval result to the data relay server.

Abstract: The present invention aims to dynamically re-configure hosts and storage in a shared-nothing database. In the shared-nothing database, processes 24 to 29 executed in the hosts 11 to 14 access data of a storage device 30. A system manager 70 and a database manager 10 manage the hosts 11 to 14 and the storage device 30. The processes 24 to 29 access one or more disks 51 to 54 of the storage device. To add or reduce the number of the hosts, the processes 24 to 29 are reassigned among the hosts 11 to 14.

Abstract: When operating a database management system that consists of a plurality of database servers and enables the database servers to transfer data between them by partitioning a data area into small areas and altering allocation of the small areas to the database servers, after altering the configuration, there occurs degradation in processing speed that accompanies re-creation of the index. If this problem is solved by using the conventional technique, noticeable degradation in processing speed will occur to a specific query at the time of a steady state operation. When operating the database management system that consists of the plurality of database servers and enables the database servers to transfer data between them by partitioning the database area into small areas and altering the allocation of the small areas to the database server, an index created for each of the small areas and an index to all the small areas allocated to the database server are used in combination.

Abstract: An information management system for modifying action of system in accordance with previously set policy with reference to metadata and/or log data accompanying data to be managed makes efficient information lifecycle management by reducing the grading of the data to be managed and increasing the expressive power of the definable policy while suppressing increase of the amount of necessary metadata and/or log data. The ontology for defining the relation between terms referred in business level is introduced and analyzed together with the policy, so that the range necessary for acquisition of information can be clearly decided to thereby reduce time and labor required for modification of setting and the operation management cost and optimize necessary resources.

Abstract: In order to realize a practical data warehouse system with the use of a network in a distributed environment, for example, data collectors for creating/managing each replica of server data for clients shown in FIG. 1 are connected to a network. A data collector holds a data request condition given from a user via a client and negotiates with a server which supplies data according to such resources as a storage unit, a CPU, etc., usable by the data collector, thereby the range and quality of the data for which a replica is to be created can be adjusted. For query processing, a part or the whole of a query from a client is processed with the use of a replica created in the data collector. Queries which cannot be processed with any replica in the data collector are transferred to the server. Because a replica created in the data collector can be used to process a query from a client in such a way, the server load can be reduced.

Abstract: In order to realize a practical data warehouse system with the use of a network in a distributed environment, for example, data collectors (101 and 102) for creating/managing each replica of server data for clients (103 and 104) as shown in FIG. 1 are connected to a network (113). A data collector holds a data request condition given from a user via a client and negotiates with a server (114, 122) which supplies data according to such resources as a storage unit, a CPU, etc. usable by the data collector, thereby the range and quality of the data for which a replica is to be created can be adjusted. For query processing, a part or the whole of a query from a client is processed with the use of a replica (123) created in the data collector. Queries which cannot be processed with any replica in the data collector are transferred to the server. Because a replica created in the data collector can be used to process a query from a client device such a way, the server load can be reduced.

Abstract: Even when information lifecycle management is applied to management object data of a database management system, inquiry service performance offered by the database management system can be guaranteed. Data arrangement managing system performs data arrangement settings in respect of management object data of the database management system and has a data arrangement setting creating module for determining possible data arrangement candidates and a data arrangement setting exchanging module for transferring the data arrangement candidates to the database management system. In the database management system, in respect of the individual data arrangement candidates transmitted to the database management system, execution profiles of service presupposing the candidates are created which are decided as to whether to satisfy a condition on database performance designated by a user and a narrowing down module narrows down the candidates to only data arrangement candidates satisfying the condition.

Abstract: A shared-nothing database management system employs a method of adding and removing a database server without significantly affecting the processing performance for accessing a table from a user or an application. A scheduler module creates a schedule which separately handles the addition of a CPU resource and the addition of a storage I/O resource, and a server is added in accordance with the created schedule. A common disk is used to remove a disk at an arbitrary timing. Further, a data region is previously subdivided on the common disk to eliminate a movement of data associated with the addition of a server.