article

Free access

Beyond schema evolution to database reorganization

Authors:

Barbara Staudt Lerner,

A. Nico HabermannAuthors Info & Claims

ACM SIGPLAN Notices, Volume 25, Issue 10

Pages 67 - 76

https://doi.org/10.1145/97946.97956

Published: 01 September 1990 Publication History

PDF eReader

Abstract

While the contents of databases can be easily changed, their organization is typically extremely rigid. Some databases relax the rigidity of database organization somewhat by supporting simple changes to individual schemas. As described in this paper, OTGen supports not only more complex schema changes, but also database reorganization. A database administrator uses a declarative notation to describe mappings between objects created with old versions of schemas and their corresponding representations using new versions. OTGen generates a transformer that applies the mappings to update the database to the new definitions, thus facilitating improvements in performance, functionality, and usability of the database.¹

References

[1]

Jay Banerjee, Won Kim, Hyoung-Joo Kim, and Henry F. Korth. Semantics and Implementation of Schema Evolution in Object-Oriented Databases. In Umeshwar Dayal and Irv Traiger (editors), Proceedings of the A CM SIGMOD 1987 Annual Conference, pages 311-322. San Francisco, May, 1987.

Digital Library

Google Scholar

[2]

David Garlan, Charles W. Krueger, Barbara J. Staudt. A Structural Approach to the Maintenance of S tructure-Oriented Environments. In Proceedings of the ACM SIGSOFT/SIGPLAN Software Engineering Symposium on Practical Software Development Environments, pages 160-170. Palo Alto, December, 1986. Reprinted in SIGPLAN Notices, January 1987.

Digital Library

Google Scholar

[3]

D. Jason Penney and Jacob Stein. Class Modification in the GemStone Object- Oriented DBMS. In OOPSLA '87 Proceedings, pages 111-117. Orlando, Florida, October, 1987.

Digital Library

Google Scholar

[4]

Andrea H. Skarra and Stanley B. Zdonik. The Management of Changing Types in an Object-Oriented Database. In OOPSLA '86 Proceedings, pages 483-495. September, 1986.

Digital Library

Google Scholar

[5]

Barbara Staudt, Charles Krueger, and David Garlan. TransformGen: Automating the Maintenance of Structure-Oriented Environments. Technical Report CMU-CS-88-186, Department of Computer Science, Carnegie Mellon University, November, 1988.

Google Scholar

Cited By

View all

Chiao CKünzle VReichert M(2013)Schema Evolution in Object and Process-Aware Information Systems: Issues and ChallengesBusiness Process Management Workshops10.1007/978-3-642-36285-9_37(328-339)Online publication date: 2013
https://doi.org/10.1007/978-3-642-36285-9_37
Dragoni MGhidini C(2012)Ontology Evolution with Semantic WikisProgress in Pattern Recognition, Image Analysis, Computer Vision, and Applications10.1007/978-3-642-31069-0_9(105-116)Online publication date: 2012
https://doi.org/10.1007/978-3-642-31069-0_9
Fröbel TFirmenich BKoch C(2011)Quality assessment of coupled civil engineering applicationsAdvanced Engineering Informatics10.1016/j.aei.2011.08.00525:4(625-639)Online publication date: 1-Oct-2011
https://dl.acm.org/doi/10.1016/j.aei.2011.08.005
Show More Cited By

Index Terms

Beyond schema evolution to database reorganization
1. Information systems
  1. Data management systems
2. Software and its engineering
  1. Software creation and management
    1. Designing software
      1. Software implementation planning
        Software design techniques
    2. Software development process management

Recommendations

Beyond schema evolution to database reorganization
OOPSLA/ECOOP '90: Proceedings of the European conference on object-oriented programming on Object-oriented programming systems, languages, and applications

While the contents of databases can be easily changed, their organization is typically extremely rigid. Some databases relax the rigidity of database organization somewhat by supporting simple changes to individual schemas. As described in this paper, ...
Database schema evolution using EVER diagrams
AVI '94: Proceedings of the workshop on Advanced visual interfaces

We present an approach to schema evolution through changes to the ER diagram representing the schema of a database. In order to facilitate changes to the ER schema we enhance the graphical constructs used in ER diagrams, and develop EVER, an ...
On transformation to redundancy free XML schema from relational database schema
APWeb'03: Proceedings of the 5th Asia-Pacific web conference on Web technologies and applications

While XML is emerging as the universal format for publishing and exchanging data on the Web, most business data is still stored and maintained in relational database management systems. As a result, there is an increasing need to efficiently publish ...

Comments

Information & Contributors

Information

Published In

ACM SIGPLAN Notices Volume 25, Issue 10

Oct. 1990

320 pages

ISSN:0362-1340

EISSN:1558-1160

DOI:10.1145/97946

Editor:
Norman Meyrowitz

Issue’s Table of Contents

OOPSLA/ECOOP '90: Proceedings of the European conference on object-oriented programming on Object-oriented programming systems, languages, and applications
September 1990
336 pages
ISBN:0897914112
DOI:10.1145/97945
Chairman:
Akinori Yonezawa
Univ. of Tokyo, Tokyo, Japan

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 September 1990

Published in SIGPLAN Volume 25, Issue 10

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

115
Total Citations
View Citations
847
Total Downloads

Downloads (Last 12 months)121
Downloads (Last 6 weeks)25

Reflects downloads up to 24 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Chiao CKünzle VReichert M(2013)Schema Evolution in Object and Process-Aware Information Systems: Issues and ChallengesBusiness Process Management Workshops10.1007/978-3-642-36285-9_37(328-339)Online publication date: 2013
https://doi.org/10.1007/978-3-642-36285-9_37
Dragoni MGhidini C(2012)Ontology Evolution with Semantic WikisProgress in Pattern Recognition, Image Analysis, Computer Vision, and Applications10.1007/978-3-642-31069-0_9(105-116)Online publication date: 2012
https://doi.org/10.1007/978-3-642-31069-0_9
Fröbel TFirmenich BKoch C(2011)Quality assessment of coupled civil engineering applicationsAdvanced Engineering Informatics10.1016/j.aei.2011.08.00525:4(625-639)Online publication date: 1-Oct-2011
https://dl.acm.org/doi/10.1016/j.aei.2011.08.005
Simanovsky A(2008)Data schema evolution support in XML-relational database systemsProgramming and Computing Software10.1134/S036176880801003934:1(16-26)Online publication date: 1-Jan-2008
https://dl.acm.org/doi/10.1134/S0361768808010039
Nguyen T(2007)Integration of Configuration Management and Hypermedia for Managing Changes in Database Applications6th IEEE/ACIS International Conference on Computer and Information Science (ICIS 2007)10.1109/ICIS.2007.119(188-193)Online publication date: Jul-2007
https://doi.org/10.1109/ICIS.2007.119
Nguyen T(2006)Model-oriented Configuration Management for Relational Database ApplicationsProceedings of the Sixth IEEE International Conference on Computer and Information Technology10.1109/CIT.2006.122Online publication date: 20-Sep-2006
https://dl.acm.org/doi/10.1109/CIT.2006.122
Andonoff EHubert GLe Parc AZurfluh G(2005)Integrating versions in the OMT modelsConceptual Modeling — ER '9610.1007/BFb0019941(472-487)Online publication date: 25-Jun-2005
https://doi.org/10.1007/BFb0019941
Parets JAnaya ARodríguez MPaderewski P(2005)A representation of software systems evolution based on the theory of the General SystemComputer Aided Systems Theory — EUROCAST '9310.1007/3-540-57601-0_43(96-109)Online publication date: 31-May-2005
https://doi.org/10.1007/3-540-57601-0_43
Bordbar BDraheim DHorn MSchulz IWeber G(2005)Integrated model-based software development, data access, and data migrationProceedings of the 8th international conference on Model Driven Engineering Languages and Systems10.1007/11557432_28(382-396)Online publication date: 2-Oct-2005
https://dl.acm.org/doi/10.1007/11557432_28
Rashid ASawyer P(2005)A database evolution taxonomy for object-oriented databasesJournal of Software Maintenance and Evolution: Research and Practice10.1002/smr.31017:2(93-141)Online publication date: 2005
https://doi.org/10.1002/smr.310
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

References

Cited By

Index Terms

Recommendations