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 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 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 a storage management system for managing a storage device for storing data, management information for managing the storage device, area assignment information for managing an area assignment state of the storage device, and history information for managing a history on area assuring and release are held. Further, an assignment request for temporarily using an area is received in association with designation of an area size and a using period. It is determined whether or not the requested area can be assigned by referring to information calculated from the held history information. An area with a designated size at a designated period is assigned to a request source if the area can be assigned as a result of the determination. In the determination, transition of a used amount of a storage is obtained from the history information, and it is determined based on the transition of the used amount of the storage whether or not the designated area can be assigned at the designated period.

Abstract: A database management system includes a status analysis processing unit to execute status analysis processing; a reorganization timing estimation processing unit to estimate a future reorganization timing based on data obtained from the status analysis processing unit; a storage status calculation processing unit to calculate a current storage status based on data operation information; a comparison unit to compare the current storage status estimated by the reorganization timing estimation processing unit and the current storage status calculated by the current storage status calculation processing unit; and a reorganization timing re-estimation processing unit to estimate again the future reorganization timing based on the result of the comparison unit.

Abstract: A method of allocating storage areas, intended to reserve the storage areas formed on a storage device for storing data, this method including the steps of: registering beforehand as a storage configuration information table 105, information on multiple storage areas to be managed and on the position where the storage device is installed; registering information on the purposes of use and positions of the storage areas beforehand as a position management table 107; acquiring position information from the position management table 107 in accordance with an allocation request for a storage area associated with the purpose of use; selecting an unallocated storage area from the storage configuration information table 105 with reference to the position information; and sending information on a selected area to a client from which the allocation request was issued.

Abstract: When a trigger and a method for changing partition definition information have been defined, a DBMS monitors the occurrence of the trigger. When the occurrence of the trigger is detected, a specified partition change is executed automatically. When the partition change is executed, migrations of data among storage areas are executed in parallel as long as the migration source storage area and the migration destination storage area of one piece of the data do not overlap those of another piece of the data.

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: In a synchronous multiplex network including a plurality of multiplex transmission apparatuses, an overhead is passed through intervening multiplex transmission apparatuses such that administration and maintenance operation information is transmitted and received through the overhead between arbitrary multiplex transmission apparatuses. The multiplex transmission apparatus receives a multiplexed signal comprising a payload having a plurality of main signals multiplexed therein and overhead bytes including a plurality of administration and maintenance operation information, performs termination processing for the administration and maintenance operation information and transmission processing for the payload, thereafter converts the multiplexed signal into a different multiplexed signal comprising a payload which has been processed for transmission and a plurality of administration and maintenance operation information, and transmits the different multiplexed signal.

Abstract: An optical transmission system accomplishes optical transmission to a long distance by combining a multiplexing line terminal with optical amplifiers, linear repeaters, and regenerators with optical amplifiers combined together. The system also accomplishes the optical transmission to a short distance by directly connecting the linear terminals therebetween, with an electric-to-optic converter replaced by an electric-to-optic converter having a semiconductor amplifier, with an optic-toelectric converter by an optic-to-electric converter having an avalanche photodiode as light receiver, an with no use of any optical booster amplifier and optical preamplifier in the multiplexing line terminal. With these, the optical transmission system can be easily constructed depending on the transmission distance required.

Abstract: A method of eliminating disturbance of database storage areas is provided, which includes the steps of: checking if it is time to execute database storage status analysis; analyzing a state of database storage areas and outputting values corresponding to disturbance factors as a status analysis result; checking whether each of the disturbance factors has reached a state that requires to be eliminated; and referring to an association table matching disturbance resolution processing with factors to be eliminated by the processing and selecting appropriate processing that can eliminate the disturbance caused by the factor.

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: 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 optical transmission system accomplishes optical transmission to a long distance by combining a multiplexing line terminal with optical amplifiers, linear repeaters, and regenerators with optical amplifiers combined together. The system also accomplishes the optical transmission to a short distance by directly connecting the linear terminals therebetween, with an electric-to-optic converter replaced by an electric-to-optic converter having a semiconductor amplifier, with an optic-to-electric converter by an optic-to-electric converter having an avalanche photodiode as light receiver, an with no use of any optical booster amplifier and optical preamplifier in the multiplexing line terminal. With these, the optical transmission system can be easily constructed depending on the transmission distance required.

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 synchronous multiplex network including a plurality of multiplex transmission apparatuses, an overhead is passed through intervening multiplex transmission apparatuses such that administration and maintenance operation information is transmitted and received through the overhead between arbitrary multiplex transmission apparatuses. The multiplex transmission apparatus receives a multiplexed signal comprising a payload having a plurality of main signals multiplexed therein and overhead bytes including a plurality of administration and maintenance operation information, performs termination processing for the administration and maintenance operation information and transmission processing for the payload, thereafter converts the multiplexed signal into a different multiplexed signal comprising a payload which has been processed for transmission and a plurality of administration and maintenance operation information, and transmits the different multiplexed signal.