Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what does OLAP mean??

Status
Not open for further replies.

Rousseau10

Programmer
Feb 22, 2005
242
US
what does OLAP mean.

Also could some explain what a data wharehouse and warehousing and data mining are.

I feel so stupid to not know these things yet??!!

thanks
 
thanks for the link but I think it the page may have been removed already .hmmm
 
I found the answer, thanks


OLAP
OLAP is an acronym for ...
* On-Line Analytical Processing
--------------------------------------------------------------------------------

More information about the definition of OLAP may appear below:


Online Analytical Processing



On-Line Analytical Processing. A category of applications and technologies for collecting, managing, processing and presenting multidimensional data for analysis and management purposes.



Online Analytical Processing. OLAP systems allow workers to, quickly, and flexibly manipulate operational data using familiar business terms, in order to provide analytical insight.



On-Line Analytical Processing.



Acronym for On-line Analytical Processing.



On-Line Analytic Processing



Acronym for Online Analytical Processing, describing data mining within a DBMS. See discussion on Active Data Warehousing page.



– Online Analytical Processing



Online Analytical Processing.



stands for "online analytical processing", a type of application that attempts to facilitate multidimensional (i.e., data that has been aggregated into various categories or "dimensions") analysis. That is, OLAP should help a user synthesize enterprise information through comparative, personalized viewing as well as through analysis of historical and projected data. View records related to this term



—On-Line Analytical Processing. See Data retailing. Using a decision support system to access a data warehouse. Allows fast and efficient analysis of data that would be slow and difficult in a transaction-oriented system. See OLTP. OLTP—On-Line Transaction Processing. A class of systems that efficiently handle immediately-acquired active data, such as production data, orders being entered, etc. Good for managing sales and purchasing transactions, but poor for analyzing them for trends.



On-line Analytical Processing



Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. The chief component of OLAP is the OLAP server, which sits between a client and a database management systems (DBMS). The OLAP server understands how data is organized in the database and has special functions analyzing the data.



On-line analytical process; applications which allow data to be interrogated



On-line Analytical Processing. Datasets built from the OLTP database, but the output is analytical in nature. Multidimensional databases are called OLAP applications.



(noun, database) Acronym for OnLine Analytical Processing. A category of software technology that enables analysts, managers and executives to perform ad hoc Data access and analysis based on its dimensionality. This form of multidimensional analysis provides business insight through fast, consistent, interactive access to a wide variety of possible views of information.



Class of database optimized for ad hoc analytical queries and cross-dimensional operations.



On-Line-Analytical-Processing



On-Line Analytical Processing. These are applications that seek to verify complex hypothesis. An example of an OLAP query might be "Compare the costs of shipping to customers in Europe to those in South America".



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.)



(Data Warehousing Guide; search in this book)



(Data Warehousing Guide)



Delivers information to meet the needs of Buenos analysts.



Oil Labeling Assessment Program



Online Analytical Processing. A multi-dimensional database used for decision support analysis and data warehousing.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top