Sensitivity of the Physical Database Design to Changes in Underlying Factors

UNCG Author/Contributor (non-UNCG co-authors, if there are any, appear on document)
Prashant Palvia, Joe Rosenthal Excellence Professor and Director of the McDowell Research Center for Global IT Management (Creator)
Institution
The University of North Carolina at Greensboro (UNCG )
Web Site: http://library.uncg.edu/

Abstract: Several articles have reported on the optimization of the complete physical database design or significant parts of it. However, few results are available on the sensitivity of the physical database design to change in underlying factors that influence the design decisions. Such tenths would be of significant practical value in both the design of the initial physical database and its subsequent restructuring. This paper considers underlying factors related to logical data structure, queries, computer system and physical implementation. An experimental design based on these factors is developed and experiments are conducted to determine the sensitivity effects, and these are reported and discussed.

Additional Information

Publication
Information & Management, Vol. 15, 1988, pp. 151-161.
Language: English
Date: 1988
Keywords
Database, Database design, Physical database, Initial database design, Database restructurings, Database monitoring, Sensitivity analysis, Performance evaluation, Optimization, Input-output analysis