Christian Marcelo Garcia-Arellano

Control Theory: a Foundational Technique for Self Managing Databases

Control theory is a well established discipline that has emerged from aeronautical, electrical, and mechanical engineering to provide a formal approach to building robust systems. While similar robustness concerns exist in database management systems, control theory is rarely used due to the lack of canonical control models and a dearth of control theory expertise among database researchers. We discuss our experience with using control theory to build self managing databases, showing experimental results, discussing pitfalls and limitations, and contrasting formal models against with feedback loops. While our experience indicates that control theory is a good paradigm for database self management, control theory should be used Judiciously since its techniques are not suited to all problems in database administration.

Autonomic features of the IBM DB2 universal database for linux, UNIX, and windows

Thevast majority of the worlds structured data are now stored and managed by relational database management systems (RDBMSs). These systems provide powerful data management capabilities. However, as the power and functionality of these systems has grown, so has the complexity of their administration. In this paper, we show how the IBM DB2 Universal Database for Linux, UNIX, and Windows (DB2 UDB) product has exploited autonomic computing to reduce this administration complexity and become more self-managing. We survey the major autonomic computing features in the DB2 UDB product and describe the benefits, with experimental data in some cases