Methods for estimating the performance of DBMSs can aid the design of database systems by identifying potential performance bottlenecks or by predicting the relative performance of di erent designs. Performance estimation is critical in parallel database systems with distributed memory where an e ective overall performance depends on a good choice among a wide range of ways of placing data. This paper describes an approach to performance estimation for shared-nothing parallel database systems. It estimates system throughput for a given benchmark or set of queries, and can exercise di erent data placement schemes to determine the data layout which provides the best throughput value.
Cache modelling is an important issue in developing an unulyticul performance evaluator to estimate performance for upplicutions running on parallel DBMSs. This paper describes U cache model developed for parallel cache management in Oracle7 Parallel Server: Some preliminary results have also been obtained by using the cache model to predict cache hit ratios for varying database size and varying number of participating processing elements.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.