• 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