Database design in the modern organization - Identifying robust structures under changing query patterns and arrival rate conditions

Decision Support Systems

Volumn 37, Issue 3, 2004, Pages 435-447

  Chen, Andrew N K ^a   Goes, Paulo B ^b   Gupta, Alok ^c   Marsden, James R ^b  

^a ARIZONA STATE UNIVERSITY   (United States)

^b UNIVERSITY OF CONNECTICUT   (United States)

^c UNIVERSITY OF MINNESOTA   (United States)

Author keywords

Database design; Query pattern; Query processing; Queueing

Indexed keywords

DATABASE SYSTEMS; INFORMATION ANALYSIS; QUERY LANGUAGES; QUEUEING NETWORKS; ROBUSTNESS (CONTROL SYSTEMS);

DATABASE DESIGN; QUERY PATTERN; QUERY PROCESSING; QUEUEING;

DECISION SUPPORT SYSTEMS;

EID: 2442425340     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0167-9236(03)00048-4     Document Type: Article

References (16)

1. Barquin R., Edelstein H. Planning and Designing the Data Warehouse. 1997;Prentice Hall, New Jersey.
2. Chaudhuri S., Dayal U. An overview of data warehousing and OLAP technology. ACM SIGMOD Record. 26(1):1997;65-74.
3. A.N.K. Chen, Improving database performance in a changing environment with uncertain and dynamic information demand: an intelligent database system approach, PhD dissertation, University of Connecticut, 1999.
4. Gray J. The Benchmark Handbook for Database and Transaction Processing Systems. 2nd ed. 1993;Morgan Kaufmann Publishers, San Mateo, CA.
5. Harinarayan V., Rajaraman A., Ullman J.D. Implementing data cubes efficiently. SIGMOD '96, Montreal, Canada:1996.
6. Hempel C.G. Philosophy of Natural Science. 1966;Prentice-Hall, Englewood Cliffs, NJ.
7. Hoffman E., Marsden J.R., Whinston A. Laboratory experiments and computer simulation: an introduction to the use of experimental and process model data in economic analysis. Green L., Kagel J. Advances in Behavioral Economics. 1990;1-31 Ablex Publishing, Norwood, NJ.
8. Jain R. The Art of Computer Systems Performance Analysis. 1991;Wiley, New York.
9. J.J. King, Query optimization by semantic reasoning, PhD dissertation, Stanford University, 1981.
10. Kleinrock L. Queueing Systems: Volume 1. Theory. 1975;Wiley, New York.
11. Rodgers U. Denormalization: why, what, and how? Database Programming and Design. 1989;46-53.
12. Sanders G.L., Shin S. Denormalization effects on performance of RDBMS. Proceedings of the Thirty-Fourth Hawaii International Conference on System and Sciences, Maui, HI:2001.
13. Schkolnick M., Sorenson P. Denormalization: a performance oriented database design technique. Proceedings of the AICA, Bologna, Italy:1980.
14. Smith V.L. Experimental economics: induced value theory. American Economic Review. 66:1976;274-279.
15. Smith V.L. Microeconomic systems as experimental science. American Economic Review. 72:1982;923-955.
16. Yang J., Karlapalem K., Li Q. Algorithms for materialized view design in data warehousing environment. Proceedings of the 23rd Very Large Data Base Conference, Athens, Greece:1997