JP2001282816A - System and method for processing multi-dimensional database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a multi-dimensional database processing system that can cut drastically a processing time required for accumulating data prior to processing the data with a OLAP(online analytical processing) server. SOLUTION: The multi-dimensional database processing system has an arrays of disk for original data 30 that stores the required original data being timely staggered into multi-storage segments. The database processing system has arithmetic processing modules 201, 202, 203, and 204, which read the original data stored in the arrays of disk from the segment where no data is accessed yet and process arithmetic operations for the data. The processing system executes sequentially but almost concurrently the arithmetic operations and stores results in the OLAP tables T1, T2, T3, and T4 and has the OLAP database that displays the data in an interleaved mode.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a multidimensional database processing method and processing system for extracting necessary elementary data from a plurality of databases and performing various arithmetic processing.

[0002]

2. Description of the Related Art Conventionally, when designing a multidimensional database processing system using this kind of OLAP database, information data to be handled on an OLAP server is first enumerated based on intended business requirements, and based on the specifications thereof. O
We are building a LAP database. For example, the conventional multidimensional database processing system 500 shown in FIG.
Has an elementary data aggregation device 50 and an OLAP database 60, and as shown in FIGS.
The AP database 60 is configured to take in various elementary data from the elementary data aggregation device 50 and generate multidimensional data 602.

[0003]

As described above, a conventional multidimensional database processing system is constructed to generate a multidimensional database using an OLAP database or the like. In the construction process, an OLAP server is used. In satisfying the data as specified in the processing time, the processing time for the satisfaction depends on the complexity of the retrieval / aggregation processing (a;
FIG. 5) and the performance (e) of the search and aggregation system, such as the size (b) of the total parameter of the elementary data, and the OLAP, such as the number of types of data (c) and the number of hierarchical combinations of data (d). Due to several system factors including the performance (f) of the system by the database, a time tc at which the operation can be started from the time ta of the new data update start for the OLAP shown in FIG.
The time until is huge.

[0004] The present invention has been made to solve the above-described problem, and is intended for use in constructing a multidimensional database processing system using an OLAP database or the like.
It is an object of the present invention to provide a multidimensional database processing method and a processing system capable of greatly reducing the data processing time required for prior aggregation processing of information data to be handled on an AP server.

[0005]

According to the present invention, there is provided a multidimensional database processing method for extracting necessary elementary data from a plurality of databases and performing various arithmetic processing. Data is stored in a plurality of storage areas while being shifted in time, and arbitrary arithmetic processing is performed by arbitrarily extracting data from a storage area in which data is not currently obtained from among elementary data stored in the plurality of storage areas. Is performed and a plurality of the above-mentioned arbitrary calculation processes are performed as a plurality of different calculation processes at substantially the same time.

[0006] According to such a configuration, data is arbitrarily extracted from the storage area from which the current data acquisition is not performed among the elementary data stored in the plurality of storage areas, and an arbitrary operation process is performed. Since the arbitrary arithmetic processing is performed as a plurality of different arithmetic processings at substantially the same time, the results of the plurality of arithmetic processings can be obtained in a short time.

Further, according to the present invention, in a multidimensional database processing system for extracting required elementary data from a plurality of databases and performing various arithmetic processing, the required elementary data is stored in a plurality of storage areas while being shifted in time. A processing means for arbitrarily extracting data from a storage area in which the current data is not obtained from among the raw data stored in the plurality of storage areas and performing an arbitrary calculation processing; Parallel operation processing means for performing a plurality of operation processes at substantially the same time as a plurality of different operation processes.

[0008] In the present invention, the plurality of arithmetic processings to be performed substantially simultaneously are tabulation and calculation in OLAP, and the storage is in a multidimensional hierarchy.

Further, in the present invention, the calculation result is displayed on a display unit, and whether or not the current operation is possible can be displayed.

[0010]

Embodiments of the present invention will be described below with reference to the accompanying drawings. Embodiment 1 FIG. FIG. 1 is a block diagram for explaining the operation of the first embodiment of the multidimensional database processing system of the present invention, FIG. 2 is a time chart for explaining the operation of FIG. 1 in more detail, and FIG. Embodiment 2 of the invention
FIG. 4 is a block diagram for explaining the operation of FIG. 3, and FIG. 4 is a time chart for explaining the operation of FIG. 3 in more detail.
The multidimensional database processing system 100 of FIG. 1 includes an elementary data aggregation device 10 and an OLAP (On-line Analytical P
rocessing) database 20. The raw data aggregation device 10 (for example, RDB (Relational Datab
ase)) holds various elementary data. OLAP
The database 20 cyclically interleaves the aggregated data 211, 212, 213, 214 by sequentially shifting the time via the four processing modules 201, 202, 203, and 204 from the system 1 to the system 4. . The OLAP database 20 stores the data 211, 212, 213,
214 to data tables T1, T2, T3, T
4 and sequentially displayed on the display.

The above operation will be further described with reference to FIG. At time t1, the elementary data aggregate device 10
Starts counting of predetermined data for the processing module 201 of the system 1 on the elementary data aggregation device side regarding elementary data of a predetermined block (for example, a certain time series section),
Upon completion, data transfer to the processing module 201 is performed.
On the other hand, the OLAP database 20 receives the data transfer from the raw data aggregation device 10 to the processing module 201, and the processing module 201 performs data aggregation on the OLAP database side, and between time t4 and t5, as shown in FIG. The indicated multi-dimensional total data 211 (for example, three-dimensional sales data for each month S for each branch S and for each product G) is recorded in the OLAP data table T1, displayed on a display, and operated on the total data 211. Enable. Further, from time t5 to time t9
Until the above, tallying is performed on the raw data of the predetermined block corresponding to the next cycle, and the same operation is repeated.

At time t2, the raw data aggregate device 10
Is the data related to the block next to the block processed by the processing module 201 of the system 1, and starts a predetermined data collection for the processing module 202 of the system 2 on the elementary data aggregation device side. 2
02 is transferred. On the other hand, the OLAP database 20 stores the processing module 2
02, the processing module 202 performs data aggregation on the OLAP database side, and obtains multidimensional aggregated data 2 between times t5 and t6.
12 is recorded in the OLAP data table T2 and displayed on the display, and the operation with respect to the tally data 212 is enabled. Further, from time t6 to time t10
Until the above, tallying is performed on the raw data of the predetermined block corresponding to the next cycle, and the same operation is repeated.

The system 3 and the system 4 can also be processed between times t3 and t7 and between times t4 and t8, respectively. As apparent from these descriptions, regarding this multidimensional database processing system, from the user's point of view, the processing modules 20 of the systems 1 to 4
The operation can be started from the operable 1 portion without waiting for the processing of 1, 202, 203, and 204 to be completed. It can be operated cyclically as a cycle, and if necessary, the same processing can be continuously performed by repeating the subsequent cycle. That is, if the number of streams is n, the operation in the OLAP database can be started in 1 / n the data acquisition processing time compared to the conventional method.

Embodiment 2 FIG. Next, a second embodiment of the present invention will be described with reference to FIGS. This multidimensional database processing system 200 has one elementary data aggregate device 30 and a plurality (four in this example) of OLAP databases 41, 42, 43, 44. OLAP database 4 of these 4 systems
1, 42, 43 and 44 are processing modules 411, 421, 431 and 44 similar to those shown in FIG.
1, the aggregated data 412, 422, 432, 44
The interleave capture is performed cyclically with the time sequentially shifted for 2. OLAP databases 41, 42,
Each of 43 and 44 is multi-dimensional aggregated data 412, 422 and 43 interleaved in this way.
2, 442 are stored in the respective data storage units 413, 423,
433 and 443, and sequentially displayed on the display.

The multidimensional database processing system 2 shown in FIG.
Compared with the multi-dimensional database processing system 100 of FIG.
Are processing modules 201, 202, and 20 from system 1 to system 4 in a single OLAP database 20.
3, 204, the multidimensional database processing system 200 collects the totalized data via the processing modules 411, 421, 431, 441 to which the four independent OLAP databases 41, 42, 43, 44 belong. 412, 422, 432, and 442 are interleaved in a cyclic manner at sequentially shifted times.

Therefore, the multidimensional database processing system 200 of FIG. 3 is similar to the multidimensional database processing system 100 of FIG. 1 and, from the user's perspective, the OLAP databases 41, 42, 43, and 4 of the systems 1 to 4.
The operation can be started from the operable part 1 without waiting for the end of the processing of step 4, and the operable steps 1 to 4 can be operated as one cycle. If necessary, the subsequent cycle can be repeated to continue operation. A similar process can be performed by circulating. In this way, if the number of streams is n, the operation in the OLAP database can be started and continued in 1 / n the data acquisition processing time compared to the conventional method.

[0017]

Since the multidimensional database processing method and processing system of the present invention are configured as described above, the storage in which the current data is not obtained from the raw data stored in the plurality of storage areas is performed. Arbitrarily taking out data from the area and performing arbitrary arithmetic processing, and furthermore, since the arbitrary arithmetic processing is performed almost simultaneously as a plurality of different arithmetic processing, a result of a plurality of arithmetic processing can be obtained in a short time, As a result, the data processing time required for the pre-aggregation processing of the information data to be handled can be greatly reduced.

[Brief description of the drawings]

FIG. 1 is a block diagram for explaining an operation of a first embodiment of a multidimensional database processing system according to the present invention;

FIG. 2 is a time chart for explaining the operation of FIG. 1 in more detail;

FIG. 3 is a block diagram for explaining an operation of a second embodiment of the multidimensional database processing system according to the present invention;

FIG. 4 is a time chart for explaining the operation of FIG. 3 in more detail;

FIG. 5 is a block diagram for explaining a conventional example of a multidimensional database processing system.

FIG. 6 is a time chart for explaining the operation of the conventional example of FIG.

[Explanation of symbols]

10, 30 elementary data aggregation device 20, 41, 42, 43, 44 OLAP database 100, 200 multidimensional database processing system 201, 202, 203, 204, 411, 421, 4
31,441 processing module 211,212,213,214,412,422,4
32,442 Multidimensional data 413,423,433,443 Data storage unit

 ──────────────────────────────────────────────────続 き Continued on the front page (72) Inventor Shigenori Tanabe 3-14-20 Higashinakano, Nakano-ku, Tokyo Kokusai Electric Co., Ltd. (72) Inventor Kiyoshi Kanai 3-14-20 Higashinakano, Nakano-ku, Tokyo Kokusai Electric Incorporated (72) Inventor Hisanori Kobayashi 3-14-20 Higashinakano, Nakano-ku, Tokyo Kokusai Electric F-term (reference) 5B045 AA07 GG11 5B049 AA04 EE02 EE04 FF01 5B075 ND02 PQ02 QS05

Claims (4)

[Claims] 1. A multidimensional database processing method for extracting necessary elementary data from a plurality of databases and performing various arithmetic processing, wherein the required elementary data is stored in a plurality of storage areas while being shifted in time, Arbitrarily taking out data from the storage area where the current data acquisition is not performed from among the raw data stored in the storage area of the storage area and performing any operation processing, A multidimensional database processing method characterized by being performed simultaneously. 2. A multidimensional database processing system for extracting necessary elementary data from a plurality of databases and performing various arithmetic processing, wherein a storage means for storing the required elementary data in a plurality of storage areas while shifting the time. An arithmetic processing means for arbitrarily extracting data from a storage area in which data is not currently obtained from among elementary data stored in the plurality of storage areas and performing an arbitrary arithmetic processing; A multi-dimensional database processing system comprising: a plurality of parallel processing units that perform a plurality of processing operations substantially simultaneously. 3. The method according to claim 1, wherein the plurality of operations performed substantially simultaneously include:
3. The multi-dimensional database processing system according to claim 2, wherein the storage is multi-dimensional hierarchies, wherein the storage is multi-dimensional hierarchies. 4. The multidimensional database processing system according to claim 2, wherein the calculation result is displayed on a display unit, and whether or not the current operation is possible is displayed.