The end user directly does search totaling of the database, from among those it is the problematical point and concept of the analysis which discovers topic, or the system or the tool for that.
The concept of OLAP was lectured has been based on San Jose laboratory (E.F.Codd) by the doctor in 1993, the latest edition has become rule of 18 (after that depending upon addition).
The multidimensional analysis with OLAP for example is the sale result of a certain company, if is, it sets the axis "classified by area," "product" "month" and so on as, "every" of product sale result product sale result classified by area "every of area", replacing the axis, it compares (the dies), locking "classified by area" "product", sale of a certain commodity which compares the change "classified by month" (slice), in a certain area it is not classified by month, furthermore the data classified by day is indicated finely It is done by the fact that operation is repeated.
It is not the static kind of information system where in month 1 time, the report is made in the form which is decided, while end user itself you think that analysis is necessary, to do trial and error, the point which directly operates the data dynamically differs, thedecision support system of time before the that (DSS) with.
OLAP is roughly classified to ROLAP which utilizes the relational database and MOLAP which utilizes the multidimensional database.
1. Multidimensional conceptual view
2. Permeability
3. Accessibility
4. Efficiency of the reporting which is consistent
5. Client/server architecture
6. Universalness of dimension
7. Dynamic queue processing
8. Support of multi-user
9. Transaction of operation between the dimension which does not have restriction
10 Intuitively know data handling
11. The reporting which has pliability
12. Dimension and the intensive level which do not have restriction
(E.F.Codd, 1993)
|
