IDEAS home Printed from https://ideas.repec.org/a/inm/orisre/v12y2001i1p83-102.html
   My bibliography  Save this article

A Conceptual Model and Algebra for On-Line Analytical Processing in Decision Support Databases

Author

Listed:
  • Helen Thomas

    (DuPree College of Management, Georgia Institute of Technology, Atlanta, Georgia 30318-0520)

  • Anindya Datta

    (DuPree College of Management, Georgia Institute of Technology, Atlanta, Georgia 30318-0520)

Abstract

Data warehousing and On-Line Analytical Processing (OLAP) are two of the most significant new technologies in the business data processing arena. A data warehouse, or decision support database, can be defined as a “very large” repository of historical data pertaining to an organization. OLAP refers to the technique of performing complex analysis over the information stored in a data warehouse. The complexity of queries required to support OLAP applications makes it difficult to implement using standard relational database technology. Moreover, currently there is no standard conceptual model for OLAP. There clearly is a need for such a model and an algebra as evidenced by the numerous SQL extensions offered by many vendors of OLAP products. In this paper we address this issue by proposing a model of a data cube and an algebra to support OLAP operations on this cube. The model we present is simple and intuitive, and the algebra provides a means to concisely express complex OLAP queries.

Suggested Citation

  • Helen Thomas & Anindya Datta, 2001. "A Conceptual Model and Algebra for On-Line Analytical Processing in Decision Support Databases," Information Systems Research, INFORMS, vol. 12(1), pages 83-102, March.
    • Handle: RePEc:inm:orisre:v:12:y:2001:i:1:p:83-102
    DOI: 10.1287/isre.12.1.83.9715
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/isre.12.1.83.9715
    Download Restriction: no
    File URL: https://libkey.io/10.1287/isre.12.1.83.9715?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Huang, Chun-Che & (Bill) Tseng, Tzu-Liang & Li, Ming-Zhong & Gung, Roger R., 2006. "Models of multi-dimensional analysis for qualitative data and its application," European Journal of Operational Research, Elsevier, vol. 174(2), pages 983-1008, October.
    2. Gediminas Adomavicius & Alexander Tuzhilin & Rong Zheng, 2011. "REQUEST: A Query Language for Customizing Recommendations," Information Systems Research, INFORMS, vol. 22(1), pages 99-117, March.
    3. Olãh Judit & Erdei Edina & Popp Jozsef, 2017. "Applying Big Data Algorithms For Sales Data Stored In Sap Hana," Annals of Faculty of Economics, University of Oradea, Faculty of Economics, vol. 1(1), pages 453-461, July.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:orisre:v:12:y:2001:i:1:p:83-102. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.