ADO Multidimensional
Dave Sussman · Apress eBooks · 2004
The ADO MD library is a companion to the standard ADO library, and is specially developed to integrate with On Line Analytical Processing (OLAP) servers. The best way to think about OLAP is to think of spreadsheets. You could compare a normal spreadsheet to a standard database table; you have rows and columns in both. OLAP data also has rows and columns, but is more like the Pivot Table in Microsoft Excel. OLAP is designed for performing complex analysis, such as calculations, summaries, etc. more easily than can be done with SQL. Some of the analysis you can perform with OLAP is perfectly easy with a spreadsheet (in fact the Pivot Table in Excel is very similar to OLAP analysis), but when the data starts becoming large, the handling of the spreadsheet becomes more complex. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.