Optimal database reorganization policies: a stochastic control approach

The problem of determining optimal reorganization policies for databases which use file structures with overflow chaining is studied. The dynamics of the file performance driven by update transactions and reorganizations is formulated as a stochastic control model which incorporates microlevel design parameters of the physical file structure. Polynomial-time procedures for solving the optimization models are developed for two cases: when the file size is stationary as in the steady-state and when the file size evolves stochastically with a nonlinear trajectory. The model and the solution procedures are applied to an ISAM file, an order-preserving random-access file, revealing the effectiveness of the solution procedures and the relationship between file-design parameters and the optimal policy