Home
Finance Resources
Investment Planning
Banking
Finance
Stock Market
Futures & Options
Trading
Mutual Funds
Insurance
Taxation
Enquire
Home » Finance Faqs » What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples?

What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples?

OLAP - On-Line Analytical Processing.
Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

MOLAP - Multidimensional OLAP.
This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the request.
Targeted at groups of users because it's a shared environment. Data is stored in an exclusive server-based format. It performs more complex analysis of data.

DOLAP - Desktop OLAP.
Small OLAP products for local multidimensional analysis Desktop OLAP. There can be a mini multidimensional database (using Personal Express), or extraction of a datacube (using Business Objects).
Designed for low-end, single, departmental user. Data is stored in cubes on the desktop. It's like having your own spreadsheet. Since the data is local, end users dont have to worry about performance hits against the server.

ROLAP - Relational OLAP.
Designates one or several star schemas stored in relational databases. This technology permits multidimensional analysis with data stored in relational databases.
Used for large departments or groups because it supports large amounts of data and users.

HOLAP:Hybridization of OLAP, which can include any of the above.



More FAQs
1 2 3 4 5 6 7 8 9 10 11 Next



put comment
Domain Registration | Windows Hosting | Linux Hosting | Java Hosting | Virtual Dedicated Server | Dedicated Server | Reseller Web Hosting | Unlimited Windows reseller hosting | Unlimited Linux reseller hosting | Cheap Windows reseller hosting | Cheap Linux reseller hosting | Cheap Windows hosting | Best Windows hosting | Windows hosting Multiple Domains | Unlimited Windows hosting | Compare hosting plans | Cheap Linux hosting | Best Linux hosting | Linux hosting Multiple Domains | Unlimited Linux hosting | Cheap asp.net hosting | Best asp.net hosting | unlimited asp.net hosting | Cheap asp.net reseller hosting | Unlimited asp.net reseller hosting | Java Features | Cheap Java hosting | Best Java hosting | unlimited Java Hosting | Unlimited Linux reseller hosting | Java Hosting Multiple Domains| | Matargashti Full Song | Matargashti mp3 Download | Matargashti Video Download | Matargashti Song Tamasha | Prem Ratan Dhan Payo Songs Download | Prem Ratan Dhan Payo Songs mp3 Download | Prem Ratan Dhan Payo Songs Video Download | Pinga Song Download | Pinga Full Song mp3 Download | Pinga Song mp3 Download | Pinga Song Video Download | Latest Bollywood Updates | Bollywood Updates | Prem Ratan Dhan Paayo Songs Download|
© ProfitGuruOnline-2024. All Rights Reserved.