ridle278fj
Dołączył: 14 Mar 2011
Posty: 81
Przeczytał: 0 tematów
Ostrzeżeń: 0/5
Skąd: England
|
 Wysłany: Czw 9:04, 26 Maj 2011 Temat postu: Air Force 1 High OLAP-A Computer Program That Anal |
 |
|
ser might request for a diagnosed file apt outlook a sheet which shows how many products got sold in July in New York, then he may want apt liken the revenue with the sale of those in September and then wants to penetrate the approximation of the bargain of other products in New York during the same time. To make this variety of thinking feasible, we store the data in multi-dimensional database which is used by OLAP. In comparison, a respective database is 2 dimensional databases.
OLAP does not absence a colossal database; instead, it uses open database connectivity (ODBC) to import the data from relational databases and creates a multi-dimensional database to execute queries. It allows quick access to data from another angles. It supports analysts and the treatment throughout the enterprise in this process. OLAP is a type of technology which enables managers, executives and rendition analysts win their data or reports hasty with consistency and wide ways of gathering information in an understandable format, transforming from the raw data.
In short, OLAP performs commerce data analysis and is experienced of act complex measurements [link widoczny dla zalogowanych], data modeling and trend analysis in a multi dimensional direction. It is a foundation of intelligent solutions which includes business performance management, rationing and blueprinting, financial reporting [link widoczny dla zalogowanych], forecasting, commerce analysis and reporting.
OLAP query Results are normally available in Pivot Table format. OLAP system is discriminated in the following categories, which depends on the ask type it goes on. They are Relational (ROLAP), Multi dimensional OLAP (MOLAP), Hybrid (HOLAP) [link widoczny dla zalogowanych], Desktop (DOLAP), Real time OLAP (RTOLAP) and Web based (WOLAP).
Since every OLAP type has some benefits, there namely a disparity aboard the particulars of the benefits surrounded its providers.
Choosing the right OLAP production becomes important here, whereas it is no effortless. There are decisive network sites which assist the consumer quest the right product along giving detailed and updated information on the market and OLAP products. Some of the examples of OLAP products are ESSbase (Hyperian Solution) and Express Server (Oracle). These products are charted because multi-user environments and their spend depends on how numerous users will use them.
Post został pochwalony 0 razy
|
|
