About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Publication
IEEE TSE
Paper
A Design of an Experiment to Model Data Base System Performance
Abstract
A statistical design of an experiment for modeling the performance (access time) of a data base (DB) system in a controlled environment has been outlined. A three-factor pilot experiment with retrieval sequence, logical view (combined with access method), and target segment type as factors was designed and the results analyzed for a specific IMS batch DB. It was found that: 1) the variation of sequences of DB retrieval calls in the application program did not have any significant effect on the access time, whereas the other two factors did have significant effect; 2) the variability in access time is not completely explained by these three factors; and 3) the distribution of the residual error is “nonnormal,” with a large positive skew. Copyright © 1976 by The Institute of Electrical and Electronics Engineers, Inc.