Hello, You may remember a post by myself a few months ago on behalf of my group members (http://archives.neohapsis.com/archives/mysql/2005-q4/0729.html) about a project component of a course we were taking, Software Architecture, taught by professor Ric Holt. We were going to look at the architecture of MySQL and suggest refactoring to implement materialized views. First off, thanks for all the responses we got; we got some good ideas from them.
Since we are all fans of MySQL, I promised to post our results in the hope that it would be of help to MySQL. Our full final report can be found here: http://roth.textdriven.com/other/final_mysql_report.pdf The total length of our report is 10 pages. I'll paste the abstract of the paper to give an idea of what is covered. -Andrew Roth on behalf of Hobbe Smit (hsmit A+ cs D0+ uwaterloo D0+ ca) and Steve Hanov ([EMAIL PROTECTED]). ABSTRACT: In this paper, we try to determine the refactoring necessary to implement a new feature in MySQL, a popular open source database system. The first step is to obtain the conceptual and concrete architectures. We find the conceptual architecture by examining literature that has been written about MySQL by database experts. Conceptually, the architecture of MySQL matches what one would expect in a database system. Next, we use a number of tools to extract the concrete architecture from the source code into a software landscape. The tool that was most successful is BFX, which is part of the SWAG kit owned by the software architecture group at the University of Waterloo. It was found that the concrete architecture is very different picture from the conceptual architecture, with different conceptual components being implemented by several concrete modules. In other cases, a single concrete module implements multiple conceptual components. Based on results, several refactorings are suggested. Finally, a number of tools are suggested to support the process of architectural refactoring. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
