Skip to main content
SpringerLink
Log in

Relational Schema Evolution for Program Independency

  • Conference paper
Intelligent Information Technology (CIT 2004)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 3356))

Included in the following conference series:

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 overview of the additional code blocks due to the PISE compliance is presented in order to prove the comprehensiveness and soundness of our PISE methodology.

This work was supported by the University of Seoul, in 2003.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Shneiderman, B., Thomas, G.: An architecture for automatic relational database system conversion. ACM transactions on Database Systems 7(2), 235–257 (1982)

    Article  Google Scholar 

  2. McBreien, P., Poulovassilis, A.: Schema evolution in heterogeneous database architecture, a schema transformation approach. In: Conference on Advanced Information Systems Engineering, pp. 484–499 (2002)

    Google Scholar 

  3. Edelweiss, dos Santos, C.S.: Dynamic schema evolution managementusing version in temporal object-oriented databases. In: International Workshop on Database and Expert Systems Application, pp. 524–533 (2002)

    Google Scholar 

  4. Skarra, A.H., Zdonik, S.B.: The management of changingtypes in objectoriented databases. In: Proc. 1st Conference on Object-Oriented Programming Systems, Languages, and Applications, pp. 483–494 (1986)

    Google Scholar 

  5. Mehta, A., Spooner, D.L., Hardwick, M.: Resolution of type mismatches in an engineering persistent object system. Tech. Report, Computer Science Dept., Rensselaer Polytechnic Institute (1993)

    Google Scholar 

  6. Monk, S., Sommerville, I.: Schema evolution in oodbs using class versioning. SIGMOD RECORD 22(3) (1993)

    Google Scholar 

  7. Bertino, E.: A view mechanism for object-oriented databases. In: 3rd International Conference on Extending Database Technology, pp. 136–151 (1992)

    Google Scholar 

  8. Tresch, M., Scholl, M.H.: Schema transformation without database reorganization. SIGMOD RECORD, 21–27 (1992)

    Google Scholar 

  9. Ullman, J.: Principle of database systems and knowledge-based systems, vol. 1. Computer Science Press (1988)

    Google Scholar 

  10. Ra, Y.G., Rundensteiner, E.A.: A transparent schema evolution system based on object-oriented view technology. IEEE Transactions on Knowledge and Data Engineering 9(4) (1997)

    Google Scholar 

  11. Kim, W., Chou, H.: Versions of schema for OODB. In: Proc. 14th Very large Databases Conference, pp. 149–159 (1988)

    Google Scholar 

  12. Clamen, S.M.: Type evolution and instance adaptation. Technical Report CMUCS- 92-133R, Carnegie Mellon University, School of Computer Science (1992)

    Google Scholar 

  13. Thomas, G., Shneiderman, B.: Automatic database system conversion: a transformation language approach to sub-schema implementation. In: IEEE Computer Software and Applications Conference, pp. 80–88 (1980)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Electrical and Computer Engineering, University of Seoul, Korea

    Young-Gook Ra

Authors
  1. Young-Gook Ra
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Sc and Engineering, University of Texas At Arlington, TX-76019, Arlington

    Gautam Das

  2. Tata Consultancy Services, Software Units Layout, Madhapur, 500081, Hyderabad, India

    Ved Prakash Gulati

Rights and permissions

Reprints and permissions

Copyright information

© 2004 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Ra, YG. (2004). Relational Schema Evolution for Program Independency. In: Das, G., Gulati, V.P. (eds) Intelligent Information Technology. CIT 2004. Lecture Notes in Computer Science, vol 3356. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30561-3_29

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-30561-3_29

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-24126-3

  • Online ISBN: 978-3-540-30561-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation