CS746: Fall 2008 - Assignments and Project

Software to Analyze: MySQL: Open Source Database


Overview

Assignment A1: Conceptual Architecture

A1.1

Thu

Sep 18

2008

Team

A1.2

Thu

Sep 18

2008

References

A1.3

Thu

Sep 18

2008

Architectural Diagram

A1.4

Thu

Sep 25

2008

Conceptual Architecture Report

Assignment A2: Concrete Architecture

A2.1

Thu

Oct 02

2008

Landscape

A2.2

Thu

Oct 9

2008

Clustered Landscape

A2.3

Thu

Oct 12

2008

Concrete Architecture Report

Course Project

Part 1

Thu

Oct 23

2006

Proposal

Part 2

Thu

Nov 27

2006

Final Report


Assignment A1: Conceptual Architecture

Find out the abstract (conceptual) architecture of MySQL, an open source database system. 

 

Note that there was a 2002 report for this course (then numbered CS798) on MySQL Conceptual Archtecture by Bannon et al  that you can reference.  It would be valuable to document how MySQL or your interpretatoin of MySQL’s architecture varies from that 2002 report.

Assignment A1.1

Email a list of team members (size about 3 people) to  cs746@swag.uwaterloo.ca. Each group gets a swag account for doing the assignments and project.

Assignment A1.2

Email a list of references (articles, books and URLs) on MySQL architecture to cs746@swag.uwaterloo.ca.

Assignment A1.3

Submit a diagram of the top-level architecture of MySQL and a one-page description of its high-level subsystems with their interactions. Bring a hardcopy to class and email a PDF version to cs746@swag.uwaterloo.ca.

Assignment A1.4

Submit your conceptual architecture report of MySQL. Limit your paper to at most 10 pages. Bring a hardcopy to class and email a PDF version to cs746@swag.uwaterloo.ca For guidance, see Description of Conceptual Architecture.


Assignment A2: Concrete Architecture

Produce the concrete architecture of MySQL. Links to the tools to be used:

Assignment A2.1

Using the ASX Pipeline, produce a software landscape of MySQL. You do not need to group files into subsystems. Store the landscape, in TA format, somewhere on your course account and email the location to cs746@swag.uwaterloo.ca. Do not email the TA file.

Assignment A2.2

Group the top-level entities of your landscape from A2.1 into subsystems (and those subsystems into subsystems if necessary). Place the new landscape, the TA and the contain.rsf file, somewhere on the course account and email the location to cs746@swag.uwaterloo.ca. Do not email the files.

Assignment A2.3

Submit your concrete architecture of MySQL. Give a clear description of each subsystem or module within you top-level subsystem. Explain the differences from the conceptual architecture. Describe the architecture of one of the top-level subsystems. Please choose the subsystem to be distinct from subsystems chosen by other groups. Ideally, the set of groups together will cover all the main top-level MySQL subsystems. Use LSEdit to produce diagrams of the concrete architecture.

Your report should be organized approximately like your report for Assignment A1.4. Limit your paper to at most 10 pages. Bring a hardcopy to class and email a PDF version to cs746@swag.uwaterloo.ca.


Course Project

Following are some suggested topics for the course project. You are encouraged to propose new interesting topics relevant to this course.

1. Architecture Refactoring: Future

Description

Refactor the architecture of a large software system to support a new feature. Take one of the systems that were studied in previous years, or choose a new program. Specify a new feature, extract its architecture, identify architecture refactorings to accommodate the feature and analyze impacts and risks. Identify possible tool support (and possibly implement) for this process.

You can also identify an architectural problem and come up with a refactoring to solve the problem.

Requirements

You must choose a software system larger than 100 KLOC. Example systems: Linux, Mozilla, PostgreSQL, MySQL, Emacs, Gnumeric etc. Your project submission should discuss tools actually used, and tools that would have been ideal to use.

2. Architecture Refactoring: Historical

Description

Analyze the historical sequence of refactorings of the architecture of a large software system. Take one of the systems that were studied in previous years, or choose a new program. Extract the architectures over a historical sequence of versions, discover architectural changes, identify the causes for changes and the kind of architectural refactorings have been performed. Identify possible tool support (and possibly implement) for this process.

Requirements

You must choose a software system larger than 100 KLOC. Extract at least 5 versions. Example systems: Linux, Mozilla, PostgreSQL, MySQL, Emacs, Gnumeric etc. Your project submission should discuss tools actually used, and tools that would have been ideal to use.

3. Architectural Repair

Description

Studies on the architecture of many systems in previous years showed how different the concrete architecture was from their conceptual architecture. Take one of these systems, identify how their concrete and conceptual architectures differ, and repair both the conceptual and concrete architectures. Identify possible automated tool support (and possibly implement such support) for this process.

Requirements

Example systems: Linux, Mozilla, PostgreSQL, MySQL, Emacs, Gnumeric etc.

4. New Tools

Description

Build new tools or integrate existing tools into the toolkit used in this course. Examples:

Requirements

Before implementing anything new, study existing tools that accomplish similar tasks and identify the weaknesses that your tool will overcome. Validate usefulness of the tool by using it in the study of a system.

5. New Landscapes

Description

Produce a landscape of a large piece of software. Examples:

Requirements

Landscape that was not done in previous years.

6. Architecture of a Family of Systems

Description

Extract the architecture of a family of systems. Identify the commonalities and variablities of features in the systems family. Decompose the architecture based on the features. The configuration of the architectural components may be extracted from the pre-processor directives (#ifdef), makefiles or other artifacts.


Last update 8 Sept 2008 -- RCH