Browse > Article

Application Program Independent Schema Evolution in Relational Databases  

나영국 (서울시립대학교 전자전기컴퓨터공학과)
Publication Information
Journal of KIISE:Databases / v.31, no.5, 2004 , pp. 445-456 More about this Journal
Abstract
The database schema is assumed to be stable enough to remain valid even as the modeled environment changes. However, in practice. data models are not nearly as stable as commonly assumed by the database designers. Even though a rich set of schema change operations is provided in current database systems, the users suffer from the problem that schema change usually impacts existing application programs that have been written against the schema. In this paper, we are exploring the possible solutions to overcome this problem of impacts on the application programs. We believe that for continued support of the existing programs on the old schema, the old schema should continue to allow updates and queries, as before. Furthermore, its associated data has to be kept up-to-date. We call this the program independency property of schema change tools. For this property. we devise so-called program independency schema evolution (PISE) methodology. For each of the set of schema change operations in the relational schemas, the sketch of the additional algorithms due to the PISE compliance is presented in order to prove the comprehensiveness and soundness of our PISE methodology.
Keywords
program independency; database view; relational database; data model; schema version; database schema; capacity-augmenting schema change; type mismatch; shared database;
Citations & Related Records
연도 인용수 순위
  • Reference
1 S. M. Clamen, 'Type evolution and instance adaptation,' Technical Report CMU-CS-92-133R, Carnegie Mellon University, School of Computer Science, 1992
2 G. Thomas and B. Shneiderman, 'Automatic database system conversion: A transformation language approach to sub-schema implementation,' IEEE Computer Software and Applications Conference, pp. 80-88, 1980
3 W. Kim and H. Chou, 'Versions of schema for OODB', Proc. 14th Very large Databases Conference, pp. 149-159, 1988
4 M. Tresch and M. H. Scholl, 'Schema transformation without database reorganization,' SIGMOD RECORD, pp. 21-27, 1992   DOI
5 J. Ullman, 'Principle of Database Systems and Knowledge-Based Systems,' Vol. 1, Computer Science Press, 1988
6 Y. G. Ra and E. A. Rundensteiner, 'A transparent schema evolution system based on object-oriented view technology,' IEEE Transactions on Knowledge and Data Engineering, Vol. 9, No.4, 1997   DOI   ScienceOn
7 A. Mehta, D. L. Spooner and M. Hardwick, 'Resolution of type mismatches in an engineering persistent object system,' Tech Report, Computer Science Dept., Rensselaer Polytechnic Institute, 1993
8 S. Monk and I. Sommerville, 'Schema evolution in oodbs using class versioning,' SIGMOD RECORD, Vol. 22, No.3, 1993   DOI   ScienceOn
9 E. Bertino, 'A view mechanism for object-oriented databases,' 3rd International Conference on Extending Database Technology, pp. 136-151, 1992
10 A. H. Skarra and S. B. Zdonik, 'The management of changing types in object-oriented databases,' Proc. 1st Conference on Object-Oriented Programming Systems, Languages, and Applications, pp. 483-494, 1986   DOI
11 Adriana Marotta, Regina Motz, and Paul Ruggia, 'Managing source schema evolution,' Web Warehouses. Workshop on Information Integration on the Web, pp. 148-155, 2001   DOI
12 Henderik Alex Proper, 'Data schema design as a schema evolution process,' Data and Knowledge Engineering, Vol. 22, No.2, pp. 159-189, 1997   DOI   ScienceOn
13 Zohra Bellahsene, 'Schema evolution in data warehouses,' Knowledge and Information Systems Vol. 4, No.3, pp. 283-304, 2002   DOI
14 Can Turker, 'Schema evolution in SQL-99 and Commercial (Obiect-) Relational DBMS,' Workshops on Foundations of Models and Languages for Data and Objects, pp. 1-32, 2000
15 Edelweiss and Clesio Saraiva dos Santos, 'Dynamic schema evolution management using version in temporal object-oriented databases,' International Workshop on Database and Expert Systems Application, pp. 524-533, 2002
16 Axel Wienberg, Matthias Ernst, Andreas Gawecki, Olaf Kummer, Frank Wienberg, and Joachim W. Schmidt, 'Content schema evolution in the Core-Media,' International Conference on Extending Database Technology, pp. 712-721, 2002
17 Lex Wedemeijer, 'Defining Metrics for Conceptual Schema Evolution,' Workshops on Foundations of Models and Languages for Data and Objects, pp. 2210-244, 2000
18 Peter McBreien and Alexandra Poulovassilis, 'Schema evolution in heterogeneous database architecture, a schema transformation approach,' Conference on Advanced Information Systems Engineering, pp. 484-499, 2002
19 Susanne Busse and Claudia Pons, 'Schema evolution in Federated Information Systems,' Database Systems in Business, Technology and Web, pp. 26-43, 2001
20 J. H. Jahnke, U. A. Nickel, and D. Wagenblasst, 'A case study in supporting Schema Evolution of Complex Engineering Information Systems,' International Computer Software and Applications Conference, pp. 513-521, 1988   DOI
21 Ben Shneiderman and Glenn Thomas, 'An architecture for automatic relational database system conversion,' ACM Transactions on Database Systems Vol. 7, No.2, pp. 235-257, 1982   DOI   ScienceOn