Hitachi, Ltd.

Hitachi Software Engineering Company, Ltd.

Other

Hitachi Microcomputer Engineering, Ltd.

Masashi Tsuchida

Yukio Nakano

Morihiro Iwata

Norihiro Hara

Yoshito Kamegi

Nobuo Kawamura

Shunichi Torii

Susumu Kobayashi

Masato Asami

Kazuo Masai

Kazuyoshi Negishi

Kazuhiko Ohmachi

Akira Yamamoto

Nobuyuki Yamashita

Hiroyuki Kitajima

Yoichi Yamamoto

Tadashi Ohsone

Toshio Honma

Hitoshi Ashida

Yasuhiro Imai

Yoshiaki Yamashita

Nobuhiro Taniguchi

Norifumi Nishikawa

Eiji Kaneko

Mitsuhiko Yoshimura

Youichi Yamamoto

Kiyoshi Yata

Kazuhiro Satoh

Hideo Mutoh

Yuzuru Tanaka

Shoo Urabe

Takashi Kotera

Nobuhiro Taniquchi

Naoko Taniguchi

Shohei Matsuura

Kentarou Chigusa

Shinichi Fukushima

Naohumi Sakai

A search method and apparatus, and storage medium capable of enhancing response accuracy of a search result is proposed. A search apparatus for searching among a plurality of conversation history documents, each of which includes an inquiry from a customer and a response to the inquiry, for the conversation history documents whose content of the inquiry is similar to an inquiry text representing content of a new inquiry from the customer: classifies the plurality of conversation history documents into a plurality of clusters according to content of the conversation history documents; extracts a conversation history document representative of each of the clusters as a representative document for the relevant cluster; and searches for the conversation history documents having a relation with the inquiry text and presents the representative document for the cluster, to which the conversation history documents detected by the search belong, as a result of the search.

Search method and apparatus and storage medium

A data analysis method for analyzing data on a data analysis apparatus having: setting, a plurality of dimension tables each having a first identifier for identifying data to be analyzed and attributes corresponding to the first identifier; setting, a history table having a second identifier associated with each of the first identifiers of the dimension tables, and having attributes corresponding to the second identifier; setting, a relation table for storing attributes relating to the first identifier, the dimension tables having a first dimension table associated with the relation table through the attribute relating to the first identifier; associating, the first identifiers that refers to the first identifier of a first dimension table with the attributes; and processing, a query for the relation table and the first dimension table, and generating a second dimension table.

Data analysis method, data analysis device, and storage medium storing processing program for same

A method and a system of database divisional management for use with a parallel database system comprising an FES (front end server), BES's (back end servers), an IOS (I/O server) and disk units. The numbers of processors assigned to the FES, BES's and IOS, the number of disk units, and the number of partitions of the disk units are determined in accordance with the load pattern in question. Illustratively, there may be established a configuration of one FES, four BES's, one IOS and eight disk units. The number of BES's is varied from one to four depending on the fluctuation in load, so that a scalable system configuration is implemented. When the number of BES's is increased or decreased, only the management information thereabout is transferred between nodes and not the data, whereby the desired degree of parallelism is obtained for high-speed query processing.

Method and system of database divisional management for parallel database system

The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database. When the above duplication or incorporation is completed, the intermediate storage unit is updated for the transactions that have taken place during the above operations to be synchronized with the main storage unit.

Method and system for managing multiple database storage units

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.

Querying database system to execute stored procedures using abstract data type attributes, retrieving location information of data, sub-data between first and second servers

In an MD schema definition modifying process for specifying tables to be modified in terms of addition of columns or the like when modification such as addition of a dimension is applied to an MD schema in a BI system having a fixed model such as a data model, tables to be modified in terms of addition of columns or the like are specified on the basis of information of modification such as addition of the dimension to the MD schema. In an extraction process of modification candidate tables, all combinations of tables and columns to be modified in terms of addition of columns or the like are output. In a decision process of modification target tables, a combination of tables to be modified can be output.

Method and system for detecting tables to be modified

An electrical form design and management method for conducting design and management on electrical forms provides a technique capable of improving the maintenance efficiency of electrical forms. The method includes a step of referencing mapping information, which associates electrical forms with components used in the electrical forms, and searching for electrical forms using an updated component, and a step of updating or adding components used in the electrical forms obtained by the search or mapping information of the electrical forms, and thereby updating or generating electrical forms.

Electrical form design and management method, and recording medium

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.

Database processing method, apparatus for implementing same, and medium containing processing program therefor

There is provided such a technique that database processing of accessing a specific DB resource can be conducted efficiently. When invoking a module for implementing a function related to a data type of a query subject, and conducting database processing, a query given by a user is analyzed. It is determined whether database resource access information of a module for implementing a function in the query given by the user indicates that access to a specific database resource should be conducted. If it is indicated that access to a specific database resource should be conducted, then an execution procedure is determined so as to execute the module in a database processing apparatus storing and managing the database resource.

Database processing method and apparatus, and medium for recording processing program thereof

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.

Database processing method and apparatus using handle

In a database management system including a request reception server and a plurality of execution servers, each having a plug-in program module incorporated by a user, the request reception server analyzes a processing request from the user to determine whether or not the plurality of execution servers require currently unidentified input parameters when executing external functions in their plug-in modules, based on a definition information table created from descriptions of interface specifications for the plug-in program modules. When it is determined that the execution servers require such input parameters, an external function in the plug-in program module in the request reception server is executed to previously acquire the unidentified input parameters. The request reception server creates an execution processing procedure code, to be executed by the plurality of execution servers, assuming that the unidentified input parameters have already been inputted, and passes the execution processing procedure code together with the input parameters acquired by the request reception server to the plurality of execution servers.

Database processing method and apparatus for processing data by analyzing query input

Growing community of inventors

Machida, Japan

Masashi Tsuchida