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

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: To store data in an insertion process, a process 1 that inserts data into a new block and a process 2 that inserts, within the block reserved, data into areas that became free when data was deleted are prepared. A switching event to switch from the process 1 to the process 2 is designated in advance. The occurrence of the designated event is checked while executing the process 1 in an insertion process, and if the designated event occurs, the insertion process executes the process 2. If during the execution of the process 2, areas that can be reused become depleted, the execution of the insertion process reverts back to the process 1. As a result, free areas resulting from deletions can be reused according to the switching event designated.

Abstract: A database access management unit manages accesses to databases managed by a plurality of data processing servers each provided for each data kind. A request analysis unit analyzes a request from an application containing a process request for each data kind. A process server selection unit selects the data processing server for executing a data process in accordance with the data kind. A data process request unit requests the data processing server to execute the data process. A process result edition unit edits the process result by the data processing server.

Abstract: The present invention provides a network in which the installation of working lines may be enabled based on the required traffic and the high speed switching of the transmission lines may be realized, as well as a transmission equipment used for that network and a method of control thereof. The transmission equipment comprises an APS byte transmitter/receiver for exchanging information on failures with adjacent transmission equipment through a protection line, a monitor for monitoring anomalies on a plurality of the working lines, a Network Table for storing data indicating network structure, a processing unit for determining working lines to be switched based on the data stored in the Network Table and for processing APS bytes. APS bytes are allocated with the working line number, its priority, and the source node number of switching signal.

Abstract: In reference, update, and insertion processing, the lock of an un-transferred object is released, and then the lock of a transferred object is set when the pointer is traced for transfer between objects to thereby improve the parallel execution capability of the reference, update, and insertion. At that time, the IS-mode (in the case of reference processing) or the IX-mode (in the case of update and insertion processing) is set at the starting of the processing, and the lock is released at the time of completion of the processing. Furthermore, in deletion processing, after the pointer to a deletion target is separated or replaced and all the processing that acquires the lock of an object group has been completed, the region of the deletion target object is released.

Abstract: A database management system for executing database operations in parallel by a plurality of nodes and a query processing method are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

Abstract: A method and a system for estimating electricity consumption of electric appliances and an abnormality alarm system, enabling estimation of individual electricity consumption of electric appliances in operation in a building or the like by a non-intrusive method, and comprising a measuring sensor (11), data extracting means (12), and estimating means (13) such as an LMC. The estimating means (13) learns based on a training set in advance, and is able to estimate individual electricity consumption of electric appliances in operation. Fundamental and higher harmonics of total load current and their phase differences from voltage are obtained by the data extracting means (12) from measurement data VA, VB, IA, IB detected by an instrument transformer (111) and an instrument current transformer (112) provided in the vicinity of a service entrance 6 of a feeder 4 to a user 2. They are inputted to the estimating means (13) as inputs, thereby estimating individual electricity consumption of the electric appliances.

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 management system for executing database operations in parallel by a plurality of nodes and a query processing method for it are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

Abstract: A database processing method is provided 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, thereby making it possible to improve the integrity of the database.

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 database system for storing table data as divided in a plurality of storages has a processing request acceptance section and an execution section which, at the time of rebalancing already stored data in response to addition of a storage, can execute inquiry operations concurrently. The system determines data to be moved from existing storages to the additional storage. When search, update and delete processing requests are issued during execution of the rebalance operation of copying the data to the additional storage and deleting the original data, both the DBMS acceptance section and DBMS executor section execute the operation corresponding to the requests. When an insert processing request is issued, the system determines a data insert destination on the basis of contents of a step of dividing the data from the existing storages to the additional storage.

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: In a parallel database system having an execution device on a front end side (hereinafter referred to as the “front end side”) and a plurality of execution devices on a database operation side (hereinafter referred to as the “divided data side”), the front end side analyzes a definition statement of a routine such as a function or a procedure inputted from a user to create routine execution process instructions for executing the routine. Simultaneously, the front end side determines whether or not a database operation statement is contained in the routine, and creates check information indicative of the determination result. The front end side analyzes a query statement inputted from the user to create a first query execution precess instruction to be executed on the front end side and a second query execution process instruction to be executed on the divided data side.

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 multiplex type transmitting apparatus is arranged to have a plurality of slow signal receive/transmit sections for accommodating a counterpart for a SONET system or an SDH system, a multiplex separation converting section, and a receive/transmit section for a SONET system or SDH system fast signal.

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 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: In a parallel database system having an execution device on a front end side and a plurality of execution devices on a database operation side (hereinafter referred to as the “divided data side”), the front end side analyzes a definition statement of a routine such as a function or a procedure inputted from a user to create routine execution process instructions for executing the routine. Simultaneously, the front end side determines whether or not a database operation statement is contained in the routine, and creates check information indicative of the determination result. The front end side analyzes a query statement inputted from the user to create a first query execution process instruction to be executed on the front end side and a second query execution process instruction to be executed on the divided data side.