×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

What is olap?

What is olap?

What is olap?

(OP)
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?

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?

(OP)
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?

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?

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 loginjames@extra.co.nz
Cheers
SASMAN

RE: What is olap?

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?

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 - see thread "Pros and cons of choosing MS OLAP Services"

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close