What are the characteristics of OLAP?

Data MiningDatabaseData Structure

The FASMI Test

It can represent the characteristics of an OLAP application in a specific method, without dictating how it should be performed.

Fast − It defines that the system is targeted to produce most responses to users within about five seconds, with the understandable analysis taking no more than one second and very few taking more than 20 seconds.

Independent research in the Netherlands has shown that end-users consider that a process has declined if results are not received with 30 seconds, and they are suitable to hit ‘ALT+Ctrl+Delete’ unless the system needs them that the report will take longer.

Analysis − It defines that the system can manage with any business logic and statistical analysis that is appropriate for the application and the user, the keep it easy enough for the target user. Although some pre-programming can be required, it does not think it acceptable if all application definitions have to be completed using a professional 4GL.

It is necessary to enable the user to represent new ad hoc calculations as part of the analysis and to report on the data in any desired method, without having to program, so it can exclude products (like Oracle Discoverer) that do not enable the user to represent new ad hoc calculations as an element of the analysis and to report on the data in any desired method, without having to program, so it can exclude products (like Oracle Discoverer) that do not enable adequate end-user oriented calculation flexibility.

Shared − It defines that the system implements all the security requirements for confidentiality (probably down to cell level) and, multiple write access is required, concurrent update areas at a suitable level. It is not all applications required users to write data back, but for the increasing number that does, the system must be able to handle several updates in an appropriate, secure manner. This is a major field of weakness in some OLAP products, which tend to consider that all OLAP applications will be read-only, with simple security controls.

Multidimensional − The system should support a multidimensional conceptual view of the data, including complete support for hierarchies and multiple hierarchies. It is not setting up a specific minimum number of dimensions that should be managed as it is too software dependent and most products seem to have enough for their target industry.

Information − Information is all of the data and derived data required, whether it is and however much is relevant for the software. We are measuring the capacity of several products in terms of how much input data can manage, not how many Gigabytes they take to save it.

raja
Updated on 24-Nov-2021 06:44:24

Advertisements