Abstract: To perform data search from a multiphase viewpoint in a circumstance where a multidimensional database if only one partitioning key is used all data is to be subject of searching. Also, the improvement of the same is dependent on the system configuration of hardware. The partitioning table is defined by specifying a partitioning condition for each of respective partitioning keys to simultaneously specifying a plurality of storage areas of multi-dimension made of a combination of these partitioning ranges. From the partitioning definition information stored in the dictionary table on the same layer, the storage area to be searched may be narrowed to the least necessary even when any partitioning key value is specified as the search condition.

Abstract: To perform data search from a multiphase viewpoint in a circumstance where a multidimensional database if only one partitioning key is used all data is to be subject of searching. Also, the improvement of the same is dependent on the system configuration of hardware. The partitioning table is defined by specifying a partitioning condition for each of respective partitioning keys to simultaneously specifying a plurality of storage areas of multi-dimension made of a combination of these partitioning ranges. From the partitioning definition information stored in the dictionary table on the same layer, the storage area to be searched may be narrowed to the least necessary even when any partitioning key value is specified as the search condition.

Abstract: The input video signal and/or audio signal is high compressed and stored and it also is low compressed and stored. The high-compressed storied video signal is used to form an editing execution order list which includes an execution order for editing the low-compressed signal.

Abstract: In the video signal processing device which records video signal (D60) as the material by the predetermined recording reproducing means (64) and conducts the desired editing processing upon reading out the video signal recorded in said recording reproducing means, the detection means (61) for detecting the material information (D72) added to the video signal in the case of recording the video signal by the recording reproducing means and for forming the predetermined control information (D62) based on said material information, and the memory means (35) for storing the control information formed by the detection means are provided. And thus, even if the operator would not enter the control information, it can be easily set and the editing processing based on this control information can be conducted. And thereby, the video signal processing device having further improved usability can be realized.