MDDB paper - Multidimensional database technology is a key...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Multidimensional database technology is a key factor in the interactive analysis of large amounts of data for decision making purposes. In contrast to previous technologies, these databases view data as multidimensional cubes that are particularly well suited for data analysis. Multidimensional models categorize data either as facts with associated numerical measures or as textual dimensions that characterize the facts. Queries aggregate measure values over a range of dimension values to provide results such as total sales per month of a given product. Multidimensional database technology is being applied to distributed data and to new types of data that current technology often cannot adequately analyze. Multidimensional databases are optimized for data warehouse and online analytical processing known as OLAP applications. These databases are frequently created using input from existing relational databases. Multi- dimensional databases are especially useful in a sales and marketing applications that involve time series. Large volumes of sales and inventory data can be stored to ultimately be used for logistics and executive planning. For example, data can be more readily segregated by sales region, product, or time period.( Kimball) This paper discusses the advantages, tools/applications and SAS/MDDB Server software of Multidimensional Databases which makes it beneficial for organizations across the world. Inherent advantages of using a multi-dimensional array structure is the enhanced data presentation and navigation which is an intuitive spreadsheet-like view of the data are the output of multi-dimensional databases. Such views are difficult to generate in relational systems without the use of complex SQL queries, while others cannot be performed by SQL at all, e.g. top ten exam results (Gray). The ease of maintenance of MDDB is easy to main. Because data is stored in the same way as it is viewed, that is according to its fundamental attributes, so no additional computational overhead is required for queries of the database. To compare this to relational
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
systems, where complex indexing and joins may be used that require significant maintenance and overhead. Lastly, Increased Performance of MDDB to achieve performance levels is beneficial. Multi-dimensional database achieve performance levels that are well in excess of that of relational systems performing similar data storage requirements. These high performance levels encourage and enable OLAP applications. We define OLAP as Fast Analysis of Shared Multidimensional information. There are many applications where this approach is relevant, and this section describes the characteristics of some of them. In an increasing number of cases, specialist OLAP applications have been pre-built and you can buy a solution that only needs limited customizing; in others, a general-purpose OLAP tool can be used (Zurek). A general- purpose tool will usually be versatile enough to be used for many applications, but there may be
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/14/2010 for the course MIS 316 taught by Professor Kristine during the Spring '10 term at York University.

Page1 / 11

MDDB paper - Multidimensional database technology is a key...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online