What is olap? What is olap? ajaygk (MIS) (OP) 6 Jun 99 04:38 What is olap ,i understood it as online analytical application processing but what is its play in the dbase side? pls explain RE: What is olap? Voila (Programmer) 7 Jun 99 06:26 OLAP stands for OnLine Analytical Processing. It is typically a term used to describe multi-dimensional databases, which are structured by the data they contain, rather than the Relational model where the table describes the data. If you are familiar with Relational, Multi-dimensionality is best described by a star schema. Overall, it is a very quick way of accessing massive amounts of data through its logical hierarchies and relationships. Its a tough subject to describe, so please expand if you feel it is necessary. The OLAP marketplace is quite busy at the moment, as MS have just shipped the OLAP engine with SQL Server 7.0, which brings the price band down on this typically expensive architecture. The key marketplace players are Oracle, Gentia and Hyperion. RE: What is olap? ajaygk (MIS) (OP) 7 Jun 99 15:14 may i take it for granted that adomd is a good eg for the OLAP likewise this follows the multidimensions of the data and structure like cubedefs and catalogs RE: What is olap? bitbrain (Programmer) 11 Jun 99 11:43 The following definition comes from a popular research group (rhymes with partner): OLAP (On-Line Analytical Processing) A definition of multidimensional business intelligence servers that originated with a Codd and Date white paper which lined 12 "OLAP product-evaluation rules" as the basis for selecting multidimensional products. OLAP is in truth only a new name for a class of business intelligence products, some of which have existed for two decades. The 12 evaluation rules for providing OLAP to user-analysts are: 1. Multidimensional conceptual view 2. Transparency 3. Accessibility 4. Consistent reporting performance 5. Client/server architecture 6. Generic dimensionality 7. Dynamic sparse matrix handling 8. Multiuser support 9. Unrestricted cross-dimensional operations 10. Intuitive data manipulation 11. Flexible reporting 12. Unlimited dimensions and aggregation levels Clear as mud huh? RE: What is olap? SASMAN (Programmer) 29 Jul 99 05:44 Hi folks, "Online Analytical Processing (OLAP) - enables better decision making by giving business users quick, unlimited views of multiple relationships in large quantities of summarized data. OLAP offers high-performance access to large amounts of summarized data for complex multidimensional analysis and easy reporting. With OLAP managers and analysts can rapidly and easily examine key performance data and perform powerful comparison and trend analyses, even on very large data volumes. Data comparisons can be used in a wide variety of business areas, including sales and marketing analysis, financial reporting, quality tracking, profitability analysis, manpower and pricing applications, and many others. OLAP uses data warehousing to create a repository of information that is built from data from across your organization's systems of enterprise-wide computing. Regardless of where your data resides, it is accessible to requesting applications on any supported platform anywhere on the network, including Web-based applications." SLICE AND DICE IS THE NAME OF THE GAME. Here are some interesting definitions: OLAP - Online Analytical Processing ROLAP - Relational OLAP MOLAP - Multidimensional OLAP WEB OLAP - you guessed it....OLAP on the WEB HOLAP - You want to know? email me firstname.lastname@example.org Cheers SASMAN RE: What is olap? Pewo (Vendor) 23 Aug 99 06:06 I am deviating a little from the topic in question, but I am wondering - why pay a huge sum of money for an OLAP tool when MS provides it in an all-in-one package? The only reason I can come up with is that i) the MS OLAP technology is very new, therefore it has not been proven yet ii) it is free so it cant be that good and iii) anyone wants to add anything in this list???? RE: What is olap? Pewo (Vendor) 23 Aug 99 06:06 I am deviating a little from the topic in question, but I am wondering - why pay a huge sum of money for an OLAP tool when MS provides it in an all-in-one package? The only reason I can come up with is that i) the MS OLAP technology is very new, therefore it has not been proven yet ii) it is free so it cant be that good and iii) anyone wants to add anything in this list???? RE: What is olap? bitbrain (Programmer) 27 Aug 99 11:53 Pewo - see thread "Pros and cons of choosing MS OLAP Services"