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

Information Systems Research

Volumn 12, Issue 1, 2001, Pages 83-102

  Thomas, Helen ^a   Datta, Anindya ^a  

^a GEORGIA INSTITUTE OF TECHNOLOGY   (United States)

Author keywords

Algebra; Data Models; Data Warehouse; Decision Support Databases; Multidimensional Databases; On Line Analytical Processing (OLAP)

Indexed keywords

ALGEBRA; DATA STRUCTURES; DATA WAREHOUSES; DECISION SUPPORT SYSTEMS; QUERY LANGUAGES;

COMPLEX ANALYSIS; CONCEPTUAL MODEL; DECISION SUPPORTS; HISTORICAL DATA; MULTIDIMENSIONAL DATABASE; OLAP QUERIES; ON-LINE ANALYTICAL PROCESSING; RELATIONAL DATABASE;

DATA HANDLING;

EID: 0035606490     PISSN: 10477047     EISSN: None     Source Type: Journal    
DOI: 10.1287/isre.12.1.83.9715     Document Type: Article

References (29)

1. Agrawal, R., A. Gupta, S. Sarawagi. 1997. Modeling multidimensional databases. Proc. 13th ICDE Conf., IEEE, Birmingham, U.K.
2. Agarwal, S., R. Agrawal, P. Deshpande, A. Gupta, J. Naughton, R. Ramakrishnan, S. Sarawagi. 1996. On the computation of multidimensional aggregates. VLDB 506-521.
3. Aho, A., R. Sethi, J. Ullman. 1988. Compilers Principles, Techniques, and Tools. Addison-Wesley Publishing Company, Reading, Massachusetts.
4. Business Intelligence Ltd. 1998. The OLAP Report: Market Share Analysis. Business Intelligence Ltd., London, U.K.
5. Butler Group. 1996. Business Case for Data Warehousing: Strategies and Technologies. Butler Group, London, U.K.
6. Byard, J., D. Schneider. 1996. The ins and outs (and everything in between) of data warehousing. Proc. ACM SIGMOD. Montreal, Quebec, Canada.
7. Chatziantoniou, D., K. Ross. 1996. Querying multiple features of groups in relational databases. Proc. 22nd VLDB Conf., Mumbai, India.
8. Chauduri, S., U. Dayal. 1997. An overview of data warehousing and OLAP technology. SIGMOD Rec., 26(1) 65-74.
9. Codd, E. 1970. A relational model for large shared data banks. Comm. ACM 13(6) 377-387.
10. _. 1971. A data base sublanguage founded on the relational calculus. Proc. ACM SIGFIDET Workshop on Data Description, Access, and Control. San Diego, CA.
11. _. 1972. Relational Completeness of Data Base Sublanguages. Data Base Systems, Prentice Hall, Englewood Cliffs, NJ.
12. _, S. B. Codd, and C. T. Salley. 1993. Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate. E. F. Codd & Associates 〈http://www.arborsoft.com/papers/codd TOC.html〉.
13. DBTG. 1971. Report of the CODASYL Data Base Task Group.
14. Elmasri, R., S. Navathe. 2000. Fundamentals of Database Systems. 3rd ed. Addison-Wesley Publishing Company.
15. Forrester Research Inc. 1997. Software Strategies. Forrester Research Inc.
16. Gray, J., S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, M. Venkatrao, F. Pellow, H. Pirahesh. 1997. Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub totals. Data Mining and Knowledge Discovery 1(1) 29-53.
17. Gupta, A., V. Harinarayan, D. Quass. 1995. Aggregate-query processing in data warehousing environments. Proc. 21st VLDB Conf., Zurich, Switzerland.
18. Gyssens, M., L. V. S. Lakshmanan. 1997. A foundation for multidimensional databases. Proc. 23rd VLDB Conf., Athens, Greece.
19. Harinarayan, V., A. Rajaraman, J. D. Ullman. 1996. Implementing Data Cubes Efficiently. Proc. ACM SIGMOD Conf., Montreal, Canada.
20. Inmon, W. H. 1996. Building the Data Warehouse, 2nd ed. J. Wiley & Sons, Inc., New York.
21. International Standards Organization. 1992. IS 9075 International Standard for Database Language SQL, Document ISO/IEC 9075, New York.
22. Kimball, R. 1996. The Data Warehouse Toolkit. J. Wiley & Sons, Inc.
23. _, A. Strehlo. 1995. Why decision support fails and how to fix it. SIGMOD Rec. 24(3). 92-97.
24. Lacroix, M., A. Pirotte. 1977. Domain-oriented relational languages. Proc. 3rd VLDB Conf., Tokyo, Japan.
25. Li, C., X. S. Wang. 1996. A data model for supporting on-line analytical processing. Proc. Conf. Inform. Knowledge Management Baltimore, MD.
26. O'Neil, P., D. Quass. 1997. Improved query performance with variant indexes. Proc. ACM SIGMOD Conf., Tucson, AZ.
27. Red Brick Systems. 1994. RISQL Reference Guide, Red Brick Warehouse VPT Version 3. Los Gatos, CA.
28. Shoshani, A. 1997. OLAP and statistical databases: Similarities and differences. ACM TODS. 22 185-196.
29. Zloof, M. 1975. Query by example. Proc. of the National Comput. Conf. Anaheim, CA.