UCL  IRIS
Institutional Research Information Service
UCL Logo
Please report any queries concerning the funding data grouped in the sections named "Externally Awarded" or "Internally Disbursed" (shown on the profile page) to your Research Finance Administrator. Your can find your Research Finance Administrator at http://www.ucl.ac.uk/finance/research/post_award/post_award_contacts.php by entering your department
Please report any queries concerning the student data shown on the profile page to:

Email: portico-services@ucl.ac.uk

Help Desk: http://www.ucl.ac.uk/ras/portico/helpdesk
Publication Detail
Impact Analysis of Database Schema Changes
  • Publication Type:
    Conference
  • Authors:
    Maule A, Emmerich W, Rosenblum DS
  • Publisher:
    IEEE
  • Publication date:
    2008
  • Pagination:
    451, 460
  • Published proceedings:
    2008 30TH INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING: (ICSE), VOLS 1 AND 2
  • ISBN-13:
    978-1-4244-4486-1
  • Name of conference:
    30th International Conference on Software Engineering
  • Conference place:
    Leipzig, GERMANY
  • Conference start date:
    10/05/2008
  • Conference finish date:
    18/05/2008
  • Print ISSN:
    0270-5257
  • Language:
    EN
  • Addresses:
    Maule, A
    UCL
    Dept Comp Sci
    London
    WC1E 6BT
    England
Abstract
We propose static program analysis techniques for identifying the impact of relational database schema changes upon object-oriented applications. We use dataflow analysis to extract all possible database interactions that an application may make. We then use this information to predict the effects of schema change. We evaluate our approach with a case-study of a commercially available content management system, where we investigated 62 versions of between 70k-127k LoC and a schema size of up to 101 tables and 568 stored procedures. We demonstrate that the program analysis must be more precise, in terms of context-sensitivity than related work. However, increasing the precision of this analysis increases the computational cost. We use program slicing to reduce the size of the program that needs to be analysed. Using this approach, we are able to analyse the case study in under 2 minutes on a standard desktop machine, with no false negatives and a low level of false positives.
Publication data is maintained in RPS. Visit https://rps.ucl.ac.uk
 More search options
UCL Researchers
Author
Dept of Computer Science
University College London - Gower Street - London - WC1E 6BT Tel:+44 (0)20 7679 2000

© UCL 1999–2011

Search by