Adaptation of Relational Database Schema
| Thesis title in Czech: | Adaptation of Relational Database Schema |
|---|---|
| Thesis title in English: | Adaptation of Relational Database Schema |
| Key words: | Relační databáze, SQL, mapování, evoluce |
| English key words: | Relational database, SQL, mapping, evolution |
| Academic year of topic announcement: | 2010/2011 |
| Thesis type: | diploma thesis |
| Thesis language: | angličtina |
| Department: | Department of Software Engineering (32-KSI) |
| Supervisor: | doc. RNDr. Irena Holubová, Ph.D. |
| Author: | hidden - assigned and confirmed by the Study Dept. |
| Date of registration: | 08.11.2010 |
| Date of assignment: | 08.11.2010 |
| Date and time of defence: | 30.01.2012 09:00 |
| Date of electronic submission: | 07.12.2011 |
| Date of submission of printed version: | 08.12.2011 |
| Date of proceeded defence: | 30.01.2012 |
| Opponents: | RNDr. Michal Kopecký, Ph.D. |
| Guidelines |
| Since most of the current applications are dynamic, sooner or later the structure of the data needs to be changed and so have to be changed also all related issues. We speak about evolution and adaptability of applications. One of the aspects of this problem is adaptation of the respective storage of the data.
The aim of this work is a research on possibilities and limitations of adaptation of a relational database schema. First of all it is necessary to analyze the related issues (such as, e.g., adaptation of the schema, adaptation of respective queries, integration of new schema etc.) in general and to discuss their key problems and solutions. On the basis of the analysis the author will select one particular direction. The core of the work will be a proposal and implementation of own approach dealing with selected open issue(s) related to database schema evolution. The work will include experimental results. |
| References |
| Mlynkova, I. - Necasky, M. - Pokorny, J. - Richta, K. - Toman, K. - Toman, V.: Technologie XML - Principy a aplikace v praxi. Grada Publishing, Prague, Czech Republic, zari 2008. ISBN 978-80-247-2725-7.
Carlo Curino, Hyun J. Moon, and Carlo Zaniolo. 2009. Automating database schema evolution in information system upgrades. In Proceedings of the 2nd International Workshop on Hot Topics in Software Upgrades (HotSWUp '09). ACM, New York, NY, USA. Carlo A. Curino, Hyun J. Moon, and Carlo Zaniolo. 2008. Graceful database schema evolution: the PRISM workbench. Proc. VLDB Endow. 1, 1 (August 2008), 761-772. Jay Banerjee, Won Kim, Hyoung-Joo Kim, and Henry F. Korth. 1987. Semantics and implementation of schema evolution in object-oriented databases. SIGMOD Rec. 16, 3 (December 1987), 311-322. Barbara Staudt Lerner. 2000. A model for compound type changes encountered in schema evolution. ACM Trans. Database Syst. 25, 1 (March 2000), 83-127. Yuan An, Xiaohua Hu, and Il-Yeol Song. 2008. Round-Trip Engineering for Maintaining Conceptual-Relational Mappings. In Proceedings of the 20th international conference on Advanced Information Systems Engineering (CAiSE '08), Springer-Verlag, Berlin, Heidelberg, 296-311. |