Selected research issues in decision support databases

Journal of Intelligent Information Systems

Volumn 11, Issue 2, 1998, Pages 169-191

  Maier, David ^a   Meredith, Mary Edie ^b   Shapiro, Leonard ^c  

^a OREGON HEALTH AND SCIENCE UNIVERSITY   (United States)

^b Sequent Computer Systems   (United States)

^c PORTLAND STATE UNIVERSITY   (United States)

Author keywords

Data warehouse; Databases; Decision support; Dimensional; Multidimensional

Indexed keywords

DECISION-SUPPORT DATABASES; OPERATIONAL DATABASES; TRANSACTION PROCESSING;

DATA WAREHOUSES; DATABASE SYSTEMS; MAGNETIC DISK STORAGE; PROJECT MANAGEMENT; RESEARCH AND DEVELOPMENT MANAGEMENT; COMPUTER ARCHITECTURE; COMPUTER HARDWARE; COMPUTER SOFTWARE; DATA STORAGE EQUIPMENT; DECISION SUPPORT SYSTEMS; QUERY LANGUAGES;

DECISION SUPPORT SYSTEMS; DATABASE SYSTEMS;

DATA WAREHOUSE; DECISION SUPPORT DATABASES;

EID: 0032155741     PISSN: 09259902     EISSN: None     Source Type: Journal    
DOI: 10.1023/A:1008627001818     Document Type: Article

References (48)

1. Ballinger, C. and Olson, M. (1997). High Noon for TPC-D, Database Programming and Design.
2. Billings, K. (1997). Bottom-up Optimization of TPC-D. Master's Thesis, Portland State University Computer Science Department, in preparation. http://www.cs.pdx.edu/~kgb/t/title.html.
3. Bulos, D. (1996). OLAP Database Design: A New Dimension, Database Programming and Design, 33-37.
4. Chaudhuri, S., Krishnamurthy, R., Potamianos, S., and Shim, K. (1995). Optimizing queries with materialized views. Proceedings of the 11th Conference on Data Engineering (pp. 190-200).
5. Chaudhuri, S. and Shim, K. (1995). An Overview of Cost-Based Optimization of Queries with Aggregates, Data Engineering, 18(3).
6. Codd, E.F. and Codd, S.B. (1994). OLAP (On-Line Analytical Processing). White Paper, E.F. Codd & Associates.
7. Croteau, K., Heller, J., Krawiec, T., Maier D., and Russell, B. (1979a). The Conceptual Model for EEMIS. Dept. of Computer Science, SUNY Stony Brook.
8. Croteau, K., Heller, J., Krawiec, T., Maier, D., Russell, B., and Wolk, P. (1979b). Final Report: The Conceptual Model for EEMIS. Dept. of Computer Science, SUNY Stony Brook.
9. Croteau, K., Kydes, A.S., and Maier, D. (1979c). EEMIS Data Sector Correspondence with Conceptual Database Design. Brookhaven National Laboratory Report BNL 51091.
10. D'Acierno, J., Hermelee, A., Frederickson, C.P., and Van Valkenburg, K. (1979). Methodology for Coding the Energy Emergency Management Information System, Brookhaven National Laboratory Report BNL 51086.
11. Demarest, M. (1994). Building the Data Mart, DBMS.
12. DSS Agent. (1997/1998). By Microstrategy, 8000 Towers Crescent Dr., Vienna, VA 22182, 800-927-1868, Informix Metacube Aggregator, http://www.informix.com/informix/products/techbrfs/metacube/2129274.htm
13. ESSBASE, by Arbor, Inc, 1344 Crossman Avenue, Sunnyvale, CA 94089 800-858-1666, info@arborsoft.com, http://www.arborsoft.com
14. Finkelstein, R. (1995). MDD: Database Reaches the Next Dimension, Database Programming & Design, 8(4).
15. Frank, M. (1994). A Drill-Down Analysis of Dimensional Databases, DBMS.
16. Ghandeharizadeh, S., DeWitt, D., and Qureshi, W. (1992). Performance analysis of alternative multi-attribute declustering strategies. Proc. ACM SIGMOD Conf. (p. 29). San Diego, CA.
17. Gray, J., Bosworth, A., Layman, A., and Pirahesh, H. (1996). Data cube: A relational aggregation operator generalizing group-by, cross-tab and sub-totals. Proc. Twelfth Intl. Conf. on Data Engineering. New Orleans, LA: EEE.
18. Hammer, J., Garcia-Molina, H., Widom, J., Labio, W., and Zhuge, Y. (1995). The Stanford Data Warehouse Project. IEEE Data Engineering Bulletin (Special Issue on Materialized Views and Data Warehousing), 18(2), 41-48.
19. Harinarayan, V., Rajaraman, A., and Ullman, J.D. (1996). Implementing data cubes efficiently. Proceedings of the ACM SIGMOD Intl. Conf. on Management of Data.
20. Informix, http://www.informix.com
21. Informix Dynamic Server, http://www.informix.com/informix/products/techbrfs/servconn/2073177/idstbrf.htm
22. Kenan Technologies. (1994). An Introduction to Dimensional Database Technology, Cambridge, MA: Kenan Systems Corporation. http://www.ultranet.com/~kenan/acumate/mddb.htm
23. Kimball, R. (1996). The Data Warehouse Toolkit, Wiley.
24. Kimball, R. and Strehlo, K. (1995). Why Decision Support Fails and How to Fix it, ACM SIGMOD Record, 24(3).
25. Lenz, H. and Shoshani, A. (1997). Summarizability in OLAP and Statistical Databases. Statistical and Scientific Database Management, Olympia, Washington, USA.
26. Madsen, M. (1997). Warehouse Design in the Aggregate, Database Programming and Design, 9(7).
27. Maier, D., Meredith, M.E., and Shapiro, L. (1996). Bringing Knowledge to Bear: Challenges for Decision Support Makers. Multimedia, Knowledge-Based & Object Oriented Databases, Springer-Verlag.
28. Meredith, M. and Khader, A. (1996). Divide and Aggregate: Designing Large Warehouses. Database Programming and Design, http://www.dbpd.com/khader.htm
29. Mumick, I.S. and Gupta, A. (1996). Workshop on Materialized Views: Techniques and Applications, following SIGMOD'96.
30. OLAP Council, OLAP Benchmark, http://olapcouncil.org/bmark.html
31. Oracle8(TM) Partitioning Option. (1997). An Oracle Business White Paper, http:www.oracle.com/st/o8collateral/html/xo8pbwp4.html
32. Oracle8 Boosts Data Warehousing. (1997). Data Mart Support for Network Computing Era, http://www.oracle.com/corporate/pressroom/html/PR62497.1ora8.html.
33. O'Neil, P.E. (1987). Model 204 Architecture and Performance. Second Annual Workshop on High Performance Transaction Systems. Springer-Verlag LNCS, 359, 40-57.
34. Platinum Technology, Inc, INfoBeacon, http://www.wcmh.com/lantimes/96jul/607a041b.html
35. Rafanelli, M. and Shoshani, A. (1990). STORM: A statistical object representation model. Proceedings of 5th International Conference SSDBM. Charlotte, NC. Lecture Notes in Computer Science, 420, Springer.
36. Red Brick Systems. (1995). The Data Warehouse: The Competitive Advantage for the 1990's. White paper, Los Gatos, CA.
37. Red Brick demonstrates industry's first and only aggregate-aware RDBMS for data warehouse applications at 1997 Builder Forum User Meeting, http://www.redbrick.com/cgi-bin/nph-press/rbs-g/html/rbspress.html?/rbsg/press/ 97-06-11-97aggr_aware
38. Salzberg, B. and Reuter, A. (1995). Indexing for aggregation. Unpublished memorandum, College of Computer Science, Northwestern University.
39. Shoshani, A. (1995). OLAP and statistical databases: Similarities and differences. ACM SIGMOD Intl. Conf. on Management of Data. San Jose.
40. Squire, C. (1995/1997). Data extraction and transformation for the data warehouse. Proc. ACM SIGMOD. Intl. Conf. on Management of Data, San Jose, PODS, Tucson (pp. 195-196).
41. Stacey, D. (1994/1995). Replication: DB2, Oracle or Sybase, Database Programming and Design, 7(12). Reprinted in SIGMOD Record, 24(4).
42. Stacey, D. (1994/1995). Replication: DB2, Oracle or Sybase, Database Programming and Design, 7(12). Reprinted in SIGMOD Record, 24(4).
43. Stanford Technology Group, Metacube White Paper, 88 Kearney St., 17th Floor, San Francisco, 415/288-7960.
44. Stanford Techology Group, Metacube, http://www.informix.com/informix/products/techbrfs/metacube/2129274.htm
45. SYBASE, 6475 Christie Ave, Emeryville, CA 94608, 800-8-SYBASE. http://www.sybase.com/products/dataware/iq.html
46. Thé, L. (1995). OLAP Answers Tough Business Questions, Datamation.
47. Wong, H., Li, J., Olken, F., Rotem, D., and Wong, L. (1986). Bit Transposition for Very Large Scientific and Statistical Databases, Algorithmica, 1(3), 289-309.
48. Wong, H., Liu, H., Olken, F., Rotem, D., and Wong, L. (1985). Bit transposed Files. Proc. Conf. on Very Large Databases (pp. 448-457).