Sunday, June 28, 2009

Definitions of OLAP on the Web:

  • On-line retrieval and analysis of data to reveal business trends and statistics not directly visible in the data directly retrieved from a data warehouse. Also known as multidimensional analysis.
  • Online Analytical Processing or OLAP provides multidimensional, summarized views of business data and is used for reporting, analysis, modeling and planning for optimizing the business. SQL Server supports OLAP via Analysis Services. Analysis Services can be used to work with data warehouses or data marts designed for sophisticated enterprise intelligence systems. These systems process queries required to discover trends and analyze critical factors. ...
  • Online Analytical Processing
  • On-line analytical processing. OLAP is defined as providing fast access to shared multi-dimensional data. OLAP is a term used to generically refer to software and applications that provide users with the ability to store and access data in multi-dimensional cubes. (See also Multi-Dimensional Analysis and Cubes.)
  • On-Line Analytical Processing. A category of applications and technologies for collecting, managing, processing and presenting multidimensional data for analysis and management purposes.
  • On-line Analytical Processing. Information analysis that pass the FASMI test: Fast Analysis of Multidimensional Information.
  • On-Line Analytical Processing. OLAP should be designed to provide end users a quick way of slicing and dicing the data.
  • OLAP (online analytical processing) enables a user to easily and selectively extract and view data from different points-of-view.
  • “Drilling down” on various data dimensions to gain a more detailed view of the data. For instance, a user might begin by looking at North American sales and then drill down on regional sales, then sales by state, and then sales by major metro area. Enables a user to view different perspectives of the same data to facilitate decision-making.
  • On-Line Analytical Processing, originally introduced in 1994 in a paper by EF Codd, is a decision support counterpart to On-Line Transaction Processing. OLAP allows users to derive information and business intelligence from Data Warehouse systems by providing tools for querying and analyzing the information in the Warehouse. IN particular, OLAP allows multidimensional views and analysis of the data for decision support processes.
  • (online analytical processing) A technology that uses multidimensional structures to provide rapid access to data for analysis. OLAP data sets for Project Server are stored in SQL Server tables and managed with Project Web Access and SQL Server Analysis Services. See also: cube
  • A multidimensional, multi-user, client/server computing environment for users who need to analyze consolidated enterprise data in real time. OLAP systems feature zooming, data pivoting, complex calculations, trend analyses, and data modeling.
  • Software that assists in fast analysis of data stored in databases or data warehouses across multiple dimensions.
  • OLAP is an acronym for online analytical processing. It is an approach to quickly provide the answer to complex database queries. It is used in business reporting for sales, marketing, management reporting, data mining and similar areas. Some people have suggested that an alternative and perhaps more descriptive term to describe the concept of OLAP is Fast Analysis of Shared Multidimensional Information, or FASMI.

No comments: