论文信息 - Workload Modeling for Relational Database Systems

Workload Modeling for Relational Database Systems

The paper presents a pragmatic approach to the workload analysis in relational database systems. A set of extensional and statistical parameters is proposed, that can be easily estimated for the permanent relations of the database, and then computed for any derived relation. In this way arbitrarily complex transactions can be analized.

Silvio Salza | Mario Terranova

[1] To-Yat Cheung. A Statistical Model for Estimating the Number of Records in a Relational Database , 1982, Inf. Process. Lett..

[2] Arnon Rosenthal. Note on the expected size of a join , 1981, SGMD.

[3] Philippe Richard,et al. Evaluation of the size of a query expressed in relational algebra , 1981, SIGMOD '81.

[4] Stavros Christodoulakis,et al. Estimating block transfers and join sizes , 1983, SIGMOD '83.

[5] Kenneth C. Sevcik. Data Base System Performance Prediction Using an Analytical Model (Invited Paper) , 1981, VLDB.

[6] Gio Wiederhold,et al. Separability —An Approach to Physical Database Design , 1984, IEEE Transactions on Computers.

[7] E. F. Codd,et al. Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[8] Paola Velardi,et al. Performance Modeling of the DBMAC Architecture , 1983, IWDM.

[9] Michel Scholl,et al. VERSO: A Relational Backend Database Machine , 1983, Advanced Database Machine Architecture.

[10] Paula B. Hawthorn. The effect of target applications on the design of database machines , 1981, SIGMOD '81.

[11] Erol Gelenbe,et al. The Size of Projections of Relations Satisfying a Functional Dependency , 1982, VLDB.

[12] Robert Demolombe,et al. Estimation of the Number of Tuples Satisfying a Query Expressed in Predicate Calculus Language , 1980, VLDB.