submit urlsubmit rss feedadd directory

article

OLAP is an acronym for On Line Analytical Processing. It is an approach to quickly provide the answer to analytical queries that are dimensional in nature. It is part of the broader category business intelligence, which also includes ETL, relational reporting and data mining. The typical applications of OLAP are in business reporting for sales, marketing, management reporting, business performance management (BPM), budgeting and forecasting, financial reporting and similar areas. The term OLAP was created as a slight modification of the traditional database term OLTP (On Line Transaction Processing).

Databases configured for OLAP employ a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. Nigel Pendse has suggested that an alternative and perhaps more descriptive term to describe the concept of OLAP is Fast Analysis of Shared Multidimensional Information (FASMI). They borrow aspects of navigational databases and hierarchical databases that are speedier than their relational kin.

Functionality


OLAP takes a snapshot of a set of source data and restructures it into an OLAP cube. The queries can then be run against this. It has been claimed that for complex queries OLAP can produce an answer in around 0.1% of the time for the same query on OLTP relational data.

More on [ OLAP ]


directory of related categories

 

 
directory of related topics

Data Mining :: Databases
Data Warehousing :: Databases

 
OLAP RSS feed
Business Applications - RSS Sponsorship

HP's first 13.3-inch Pavilion vs. the competition
Wed, 01 Oct 2008 12:34:18 -0700
HP is shipping its first laptop with a 13.3-inch widescreen display. The HP Pavilion dv3500t series is already available on HP's site starting at $1,000, and a slightly higher-end configuration, the dv3520nr, is available for pre-order at Best Buy for $1,200. Other sites have reported that this model will be...
A new mystery: What's Microsoft got up its Office Live sleeve?
Wed, 01 Oct 2008 12:22:06 -0700
It sounds like Microsoft has yet another Professional Developers Conference PDC announcement percolating -- beyond the Windows 7, Oslo, cloud OS (Red Dog/Zurich) and Mesh Platform stuff about which the company already has been dropping hints. by Mary Jo Foley
Google talks efficient data centers
Wed, 01 Oct 2008 12:18:32 -0700
Google is known as a search titan, but its real business is running data centers. On Wednesday, Google handed out a few key tips as it touted its data center efficiency and sustainability efforts. In a blog post, Google's senior vice president of operations Urs Hölzle outlined...
Apple strikes back against Psystar, asks for counterclaim to be dismissed
Wed, 01 Oct 2008 12:17:23 -0700
Apple has hit back against claims made by Mac-clone maker Psystar that the company is operating in violation of the Sherman Antitrust Act and the Clayton Antitrust Act and will be asking the U.S. District Court judge to dismiss to dismiss the counterclaim. by Adrian Kingsley-Hughes
Microsoft HealthVault offers the nickel tour
Wed, 01 Oct 2008 12:08:55 -0700
Nolan insists that "third party applications" will be what get HealthVault over the top, and it's in making those available that he hopes the system will prove its value. by Dana Blankenhorn
Student Technology Day: "Windows Cloud" revealed
Wed, 01 Oct 2008 11:47:18 -0700
Steve Ballmer was next door in the Queen Elizabeth Hall talking to the TechNet/TechEd people about Office Live, and mentioning that there would be a major announcement at the PDC on the 27th October. Once he finished there, he popped next door and told us a similar thing. ...

 
Subscribe to Software RSS feed

directory of related sites

Actuate Corporation - Builds Java based OLAP software for the enterprise and offers business process solutions for HR, Sales, Customer Service and Financial Services.
Meta Description: [ Actuate's business intelligence analytics tools provide real time enterprise reporting with user-friendly executive dashboards. ]

Alta Plana: Online Analytical Processing (OLAP) - A collection of information related to Online Analytical Processing and selected related disciplines including Data Warehousing (DW), Decision Support Systems (DSS), and Executive Information Systems (EIS). Maintained as a public service by Alta Plana Corporation.
Meta Description: [ A collection of information related to Online Analytical Processing and selected related disciplines including Data Warehousing (DW), Decision Support Systems (DSS), and Executive Information Systems (EIS). Maintained as a public service by Alta Plana Corporation. ]

Ariel Alert - Business intelligence solution for automated scheduling and web-based distribution of exception reports, information snapshots and threshold alerts.

Brio Technology - Leading edge enterprise business intelligence solutions for organizations worldwide.
Meta Description: [ Business performance management solutions, Brio software, Brio products, and Hyperion products. ]

Business Intelligence Technologies, Inc. - BIXL delivers data from Microsoft's SQL Server Analysis Server component, as well as other OLE DB for OLAP compliant cubes, right into Excel.

Business Objects - Business intelligence software and solutions including: enterprise reporting, query and analysis, data integration, and performance management tools.
Meta Description: [ Business Objects is the world's leading provider of enterprise business intelligence solutions, enabling organizations to track, understand, and manage enterprise performance. ]

Codework - 3-way Tangram is desktop OLAP for Windows 95/98 and NT-based platforms. Typical applications include sales analysis, marketing, and reporting, as well as budget and consolidation. Based on the Dyalog APL notation.

Cognos Incorporated - Business intelligence and planning software for performance management. Vendor of reporting, analysis, scorecarding, planning, and consolidation solutions for the enterprise.
Meta Description: [ Business intelligence & corporate performance management software for better business decisions. All data, reports, plans, & scorecards- one view- Cognos. ]

Comshare - Comshare's client/server and Web-based decision support applications allow employees across the enterprise easy access to business information to help your organization plan and operate effectively. Full-service software vendor, worldwide support.
Meta Description: [ Financial Planning & Management Applications, Enterprise Business Process Automation, Budgeting & Forecasting Systems, Sales Forecasting and Manufacturing Software ]

Contour Components Limited - OLAP software for interactive reporting, data analysis and information delivery.
Meta Description: [ Innovative OLAP software for Interactive Reporting, Data Analysis and Information Delivery ]

Data Dynamics Ltd. - Develop ActiveReports and DynamiCube, ActiveX components that provide OLAP and reporting facilities for applications written in Visual Basic. ActiveReports won Productivity Award in the 10th Jolt Product Excellence and Productivity Awards.

Databeacon Inc. - Software for web-based information analysis and reporting. Company, product, and solutions information.
Meta Description: [ Databeacon is .NET Smart Client or Java Open Client. Databeacon provides Web Reporting and Data Analysis software for the Mid-market enterprise and departmental applications. ]

Dimensional Insight - Privately held company specializing in the development and marketing of multidimensional data visualization, analysis, and reporting software.

Gentia do Brasil - South American Gentia distributor with consulting involving Balanced Scorecard and risk strategies.

Geppetto's Workshop L.L.C. - AntMDX and AntSQL. Query technology for enterprise relational and multi-dimensional data sources.

German OLAP and Data Warehouse Forum - Comprehensive list of links to white papers, (research) organizations, companies and product related to Data Warehousing, Online Analytical Processing (OLAP), and Data Mining. Content provided in both English and German.

Hyperion Solutions Corporation - Develops high performance, OLAP software for business planning, analysis, management reporting, and data warehousing applications.
Meta Description: [ Hyperion Solutions Corporation is the global leader in Business Performance Management software. ]

IAF Software, Inc. - Provides business intelligence solutions, including online analytical processing (OLAP) management and analytical tools.
Meta Description: [ Provides business intelligence, OLAP and management software for Oracle OLAP. ]

IBM DB2 OLAP Server - An online analytical database supporting diverse platforms including Windows, UNIX, OS/390 and OS/400.
Meta Description: [ Use IBM DB2 OLAP Server to deliver analytic applications that give your business a competitive edge. DB2 OLAP Server gives you fast, intuitive multidimensional analysis. With the many applications, tools, and solutions providers who support DB2 OLAP Server, you can create your own applications or... ]

Information Builders - WebFOCUS - Business intelligence solution designed to support e-business and e-government initiatives.
Meta Description: [ WebFOCUS is a comprehensive and fully-integrated enterprise business intelligence and reporting platform whose architecture, integration, and simplicity permeate every level of the global organization - executive, analytical, and operational. ]

instantOLAP - Java OLAP and web reporting tool to perform multidimensional analysis on relational database servers.
Meta Description: [ Java OLAP and web reporting tool to perfom multidimensional analysis on relational databases and other datasources ]

Introduction to OLAP - Understanding OLAP technology by example.
Meta Description: [ Understanding OLAP technology by example. ]

JPivot - JPivot is a JSP custom tag library that renders an OLAP table and chart. Users can perform typical OLAP navigations like drill down, slice and dice. It uses Mondrian and XMLA as its OLAP engines.

KD Nuggets Directory - Data mining and knowledge discovery resources.
Meta Description: [ Data Mining, Web Mining, Analytics, Knowledge Discovery ]

LogiXML - Business Intelligence and Reporting Software - LogiXML provides OLAP based business intelligence reporting and analytics software tools. .net based Ad hoc and managed reporting software solutions.

Microsoft Analysis Services - A component of Microsoft SQL Server, Analysis Services provides a client/server solution that enables users to perform sophisticated analyses on large volumes of data using MOLAP, ROLAP or HOLAP storage models. Data sources can include any OLE DB provider, such as SQL Server, Oracle, DB2, other relational databases, and flat files.
Meta Description: [ SQL Server 2005 provides many new and enhanced business intelligence features designed to give you a competitive advantage, including Integration Services, Analysis Services, Reporting Services, and more. ]

Microsoft OLAP Information - Mosha Pasumansky's site containing technical information, whitepapers, utilities, code samples and other resources about Microsoft OLAP products.

MicroStrategy Inc. - Provider of intelligent e-business software and services.
Meta Description: [ Business Intelligence Software Solutions Pixel-Perfect Print-Perfect Seamless BI Integration ]

MIK AG - Provides OLAP software and services for performance measurement.
Meta Description: [ Führender Anbieter für BI-Lösungen, Management-Informationssysteme - MIS - und Controlling für anwenderorientierte Lösungen. ]

Mondrian - An open-source OLAP server written in Java.
Meta Description: [ The world's largest development and download repository of Open Source code and applications ]

404 Occam Research Corp. - Developers of MUSE, a natural language, multidimensional data-analysis and visualization tool. Available for Macintosh and Windows platforms.

OLAP Information Site - Provides links to selected articles, whitepapers, and glossary of OLAP-terms.
Meta Description: [ Information center for OLAP and Data Warehouse interested people. We provide links to selected articles, whitepapers, a huge glossary of online analytical processing terms and more. ]

OLAP Insider - Provides interactive data visualization and data creation tools. By PEYO.
Meta Description: [ SQL database tools,OLAP,data mining - by PEYO ]

OLAP Services User Community - Provides information, resources and forums dedicated to the development and administration of solutions based around Microsoft OLAP Services. Frequented by members of the development team; registration not required for read-only access.
Meta Description: [ This is the place where all MS OLAP users can exchange knowledge, information and ideas. Post your tips, tricks or even complete papers ]

OlapX Software - OLAP multidimensional database creation and browsing tool that enables the interactive analysis, reporting and presentation of Microsoft Analysis Services databases.
Meta Description: [ OlapX is a sophisticated OLAP multidimensional database browsing tool. ]

Oracle Express - Oracle Express OLAP products support strategic decision making across a range of enterprises, including government, pharmaceuticals, retail, utilities, insurance, health care, entertainment, manufacturing, brewing, banking, and telecommunications.

Orenburg BOARD M.I.T. - Programming free, integrated multi-dimensional database for fast information analysis and modeling.

PivotCube VCL - Offers OLAP solutions for Delphi and C++ Builder programmers.
Meta Description: [ PivotCube is a high-performance visual component suite (Delphi and C++ Builder VCL and ActiveX) for rapid development of Internet, client-server and desktop business intelligence applications. It allows end users to perform OLAP and statistical analisys using current data from any relational data... ]

ProClarity Inc. - Provides the foundation for building a business analysis environment around Microsoft SQL Server with integrated Analysis Services and provides an open, flexible and extensible ActiveX/COM platform for the development of custom analytical applications.
Meta Description: [ Business intelligence products and services from ProClarity include software for business intelligence management. ]

QlikTech International AB - Provider of QlikView Business intelligence software that delivers multi-dimensional data analysis for ODBC-enabled enterprise data.
Meta Description: [ QlikTech´s QlikView Business Intelligence Software delivers analytical applications in one quarter of the time, at half the cost, and with twice the value of traditional OLAP-based solutions. QlikView - Business Intelligence. Now Smarter. ]

Rapiddecision.net - RapidDecision is a business intelligence solution that uses real-time information without regard to underlying ERP or dashboard applications.

SAS Business Intelligence - OLAP - SAS OLAP Server - a multidimensional data store designed to provide quick access to presummarized data, generated from vast amounts of detailed data.

Sight Software, Inc. - Pro/Sight Process Intelligence software combines the process analysis of Six Sigma statistical decision tools with the accessibility of Business Intelligence software.

500 Speedware Corporation, Inc. - Media/MR combines relational (ROLAP) and multidimensional (MOLAP) technologies to deliver hybrid (HOLAP) analysis.
Meta Description: [ Speedware is a provider of innovative enterprise software solutions, including application development technology, industry-specific business intelligence solutions and complete HP e3000 migration solutions. ]

Strategy.com - Personal intelligence network from MicroStrategy which actively delivers personalized, relevant and timely information to individuals via digital devices and the web.
Meta Description: [ Business Intelligence Software Solutions Pixel-Perfect Print-Perfect Seamless BI Integration ]

Tek-Tips Forums - OLAP - OLAP technical support forums and mutual help system for computer professionals. Selling and recruiting forbidden.

Temtec International B.V. - Provides OLAP reporting and analysis software and business intelligence solutions.
Meta Description: [ OLAP Software from Temtec provides self-service analysis, OLAP Reporting Software, and Executive Viewer Analysis Services. Temtec provides web-based OLAP analysis and reporting software and business intelligence solutions worldwide. ]

The OLAP Report - Provides regularly updated, detailed and unbiased information on the OLAP market and OLAP products.

OLAP related videos
I made this presentation for a client. It is twenty-seven minutes long, and is unlike any of the other videos I have ...
Next Video

 

HOMEADVERTISINGABOUT US

articlesartsbusinesscomputersgameshealthhospitalshomekids & teensnewsmobilephysiciansrecreationreferenceregionalscienceshoppingsocietysportsworld


Submit a Site About Become an Editor