From Nico's Website

Contents 1 Subpages 2 Project Plan 2.1 Deadlines 2.2 Next steps 2.3 Footprint Types of Changes Mediawiki 2.4 Dekiwiki Footprint

[edit] Subpages

• CSMC724/ClassProject/ProjectProposal
• CMSC724/ClassProject/PaperDraft
• CMSC724/ClassProject/RelatedWork

[edit] Project Plan

[edit] Deadlines

• Group Members and the Project Idea/Proposal (Due: 2/21/08)
  • A one-page proposal stating and motivating the problem.
  • CSMC724/ClassProject/ProjectProposal
• Literature survey (Due: 3/7/08)
  • A 3-4 page report that surveys the prior work, and puts your proposed work in context of the related prior work.
  • Collection of related work: CMSC724/ClassProject/RelatedWork
  • CMSC724/ClassProject/PaperDraft
• Intermediate Progress Report (Due: 4/4/08)
  • A 5-7 progress report: Media:CMSC724_Interim_Report.pdf
• Final Report and Presentation (Due: 5/8/08)
  • Final report (about 10-15 pages) should follow a research paper format. There may be either an oral presentation or a poster session.

[edit] Next steps

• evaluate how exact the similarity algorithm is working for tables and columns
• find another testbed:
  • < http://dekiwiki.svn.sourceforge.net/viewvc/dekiwiki/deki/web/maintenance/tables.sql?revision=8587&view=markup
  • http://mantisbt.svn.sourceforge.net/viewvc/mantisbt/trunk/mantisbt/admin/schema.php?view=markup&pathrev=4848
• evaluate goals again and come up with a analysis technique
• tables.sql changes CMSC724/ClassProject/Wikimedia

[edit] Footprint Types of Changes Mediawiki

Table added=12, 
Table deleted=2, 
Table renamed=4, 

Column added=46,
Column deleted=7, 
Column renamed=1, 
Column type changed=58, 

 Changed Type: BYTEA -> TEXT=5,
 Changed Type: CHAR -> bool=1,
 Changed Type: CHAR -> INTEGER=1, 
 Changed Type: CIDR -> TEXT=3, 
 Changed Type: INTEGER -> SMALLINT=11, 
 Changed Type: INTEGER -> SERIAL=2, 
 Changed Type: INTEGER -> CHAR=1, 
 Changed Type: TEXT -> =2, 
 Changed Type: TEXT -> CHAR(64)=1, 
 Changed Type: TEXT -> TIMESTAMPTZ=1,  
 Changed Type: TEXT -> CHAR(255)=1, 
 Changed Type: TEXT -> VARCHAR(16)=1, 
 Changed Type: TEXT -> CIDR=2, 
 Changed Type: TEXT -> CHAR(32)=2
 Changed Type: SMALLINT -> INTEGER=5, 
 Changed Type: SMALLINT -> CHAR=18, 
 Changed Type: SMALLINT -> TEXT=1,

[edit] Dekiwiki Footprint

Table added=8, 
Table deleted=15,
Table renamed=0,

Column added=18,
Column deleted=5,  
Column renamed=0
Column type changed=7,

 Changed Type: MEDIUMINT -> MEDIUMINT(8)=2, 
 Changed Type: BIGINT(8) -> MEDIUMINT=1,   
 Changed Type: INT(4) -> VARCHAR(255)=1, 
 Changed Type: INT(10) -> INT=1, 
 Changed Type: INT(10) -> INT(4)=2,