Steps to Create a Good Self-tuning Logical Database Design{3}

by Andrew S
The journal talks about logical database design and how database administrators have to maintain efficient databases to keep up with the current trends.  There is a lot of talk about self-tuning physical database design, but the self-tuning logical database design aspect is understudied.  The author of the article explores a framework in which a database should be able to self-tune its logical database schema that have SQL workloads.  Self-tuning of a logical database is necessary if it has to adapt and evolve to better match its user’s requirements.

This journal relates to what we learned in class because it explores the necessary qualities that are required of a good and efficient database.  One of the important things that the journal stresses is the use of duplicate attributes and the inefficiency of redundant information in a database model.   This is one of the things that we talked about in class in which to avoid when constructing a database model.  The journal also talks about how we can improve the efficiency of the logical database design through a proper and well-constructed framework.

I really enjoyed reading this journal because it was something I could relate to from things I learned in class.  It gave me valuable information on constructing a good logical database design.  There were also many factors that I learned to avoid when created the design as it would be inefficient.  The idea of creating and maintaining a coherent database is important when dealing with end users that you must cater towards.  I was able to learn the importance of maintaining efficient databases for end users and maintaining coherent databases for database programmers.

De Marchi, F. (2005, April 5-8). Some Remarks on Self-Tuning Logical Database Design. IEEE Conference Publications