DocumentCode
1553126
Title
Multidimensional database technology
Author
Pedersen, Torben Bach ; Jensen, Christian S.
Author_Institution
Dept. of Comput. Sci., Aalborg Univ., Denmark
Volume
34
Issue
12
fYear
2001
fDate
12/1/2001 12:00:00 AM
Firstpage
40
Lastpage
46
Abstract
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. For example, classic techniques such as preaggregation cannot ensure fast query response times when data-such as that obtained from sensors or GPS-equipped moving objects-changes continuously. Multidimensional database technology will increasingly be applied where analysis results are fed directly into other systems, thereby eliminating humans from the loop. When coupled with the need for continuous updates, this context poses stringent performance requirements not met by current technology
Keywords
data analysis; data mining; data warehouses; decision support systems; query processing; continuous updates; decision making; distributed data; facts; interactive data analysis; multidimensional cubes; multidimensional database technology; numerical measures; preaggregation; queries; textual dimensions; Aggregates; Data analysis; Data models; Data warehouses; Decision making; Industrial relations; Marketing and sales; Multidimensional systems; Relational databases; Transaction databases;
fLanguage
English
Journal_Title
Computer
Publisher
ieee
ISSN
0018-9162
Type
jour
DOI
10.1109/2.970558
Filename
970558
Link To Document