Typically, this is a relational, multidimensional, or other specialized database designed to facilitate complex queries. Relational databases are the most popular platform for supporting data warehouses and data marts. The existence of SQL as a relatively standard query language and ODBC as a common access method has enabled the proliferation of relational databases for analytic applications. And since relational databases can leverage the parallel processing capabilities afforded by highly scalable, multiprocessing Unix platforms, companies are using these data management systems to build terabyte-capacity data warehouses and staging areas. A staging area is a place where companies can load cleansed and integrated operational data before heavily transforming them into specialized data marts.
Multidimensional databases are akin to spreadsheets, storing data in a matrix-like structure.
In most cases, multidimensional databases are used to support application-specific data marts. There are a number of databases that employ specialized index structures, such as bitmaps, to speed responses to complex queries. In addition, there are compression and parallelization tools on the market today that companies can use to dramatically speed up the performance of relational databases. Web servers can be used to store data files, usually pre-executed reports that Web users can download in HTML or native format. Server is a strategic analytical platform optimized for enterprise management reporting, analysis and planning applications.