OLAP Using ASP.NET
(Page 1 of 7 )
This is a quick and easy introduction to OLAP, its architecture, its installation and discussion on how to access the OLAP information/data through ASP.NET using VB.NET with a demonstration of a simple web application. Here you will find the answers to questions such as "What is OLAP?", "What is its architecture?", and "How do I create a .NET web application to access OLAP?"
What is OLAP
Databases store information about business transactions, plus other data such as employee records. Those types of systems are called online transaction processing (OLTP) databases. OLTP data contains a wealth of information that can help you make informed decisions about your business. The process of analyzing your data for that type of information, and the data that results, are collectively called business intelligence.
You can spend a lot of time and money trying to extract business intelligence information from your database. The time and expense involved in retrieving answers (queried information) from databases means that much business intelligence information often goes unused. The reason: most operational databases are designed to store your data, not to help you analyze it. The solution: an online analytical processing (OLAP) database, a specialized database designed to help you extract business intelligence information from your data in a structured manner.
Microsoft® SQL Server™ 2000 Analysis Services is a high-performance online analytical processing (OLAP) tool for performing data analysis and data mining.
Next: Introduction to OLAP Architecture >>
More ASP.NET Articles
More By Jon Jagger