More Web Proxy on the site http://driver.im/

Article

Schema Evolution in Heterogeneous Database Architectures, A Schema Transformation Approach

Authors:

Alexandra PoulovassilisAuthors Info & Claims

CAiSE '02: Proceedings of the 14th International Conference on Advanced Information Systems Engineering

Pages 484 - 499

Published: 27 May 2002 Publication History

Abstract

This paper presents a new approach to schema evolution, which combines the activities of schema integration and schema evolution into one framework. In previous work we have developed a general framework to support schema transformation and integration in heterogeneous database architectures. Here we show how this framework also readily supports evolution of source schemas, allowing the global schema and the query translation pathways to be easily repaired, as opposed to having to be regenerated, after changes to source schemas.

References

[1]

J. Andany, M. Leonard, and C. Palisser. Management of schema evolution in databases. In Proceedings of VLDB'91. Morgan-Kaufman, 1991.

[2]

N. Ashish and C.A. Knoblock. Wrapper generation for semi-structured internet sources. SIGMOD Record, 26(4):8-15, December 1997.

[3]

R.J. Bayardo et al. InfoSleuth: Agent-based semantic integration of information in open and dynamic environments. SIGMOD Record, 26(2):195-206, June 1997.

[4]

Z. Bellahsene. View mechanism for schema evolution in object-oriented dbms. In Advances in Databases: 14th British National Conference on Databases, BN- COD14, volume 1094, pages 18-35. Springer-Verlag, 1996.

[5]

B. Benatallah. A unified framework for supporting dynamic schema evolution in object databases. In Proceedings of ER99, LNCS, pages 16-30. Springer-Verlag, 1999.

[6]

S.S. Chawathe, H. Garcia-Molina, J. Hammer, K. Ireland, Y. Papakonstantinou, J.D. Ullman, and J. Widom. The TSIMMIS project: Integration of heterogeneous information sources. In Proceedings of the 10th Meeting of the Information Processing Society of Japan, pages 7-18, October 1994.

[7]

T. Critchlow, M. Ganesh, and R. Musick. Automatic generation of warehouse mediators using an ontology engine. In Proceedings of the 5th International Workshop on Knowledge Represenation Meets Databases (KRDB '98), volume 10. CEUR Workshop Proceedings, 1998.

[8]

J. Hammer, H. Garcia-Molina, S. Nestorov, R. Yerneni, M. Breunig, and V. Vassalos. Template-based wrappers in the TSIMMIS system. SIGMOD Record, 26(2):532-535, June 1997.

[9]

R. Hull. Managing sematic heterogeneity in databases: A theoretical perspective. In Proceedings of PODS, 1997.

[10]

E. Jasper. Query translation in heterogeneous database environments. MSc thesis, Birkbeck College, September 2001.

[11]

M. Kradolfer and A. Geppert. Dynamic workflow schema evolution based on workflow type versioning and workflow migration. In Proceedings of CoopIS 1999, pages 104-114, 1999.

[12]

L.V.S. Lakshmanan, F. Sadri, and I.N. Subramanian. On the logical foundations of schema integration and evolution in heterogeneous database systems. In Proceedings of DOOD'93, pages 81-100, Phoenix, AZ, December 1993.

[13]

A. Levy, A. Rajamaran, and J.Ordille. Querying heterogeneous information sources using source description. In Proc 22nd VLDB, pages 252-262, 1996.

[14]

P.J. McBrien and A. Poulovassilis. A formal framework for ER schema transformation. In Proceedings of ER'97, volume 1331 of LNCS, pages 408-421, 1997.

[15]

P.J. McBrien and A. Poulovassilis. A formalisation of semantic schema integration. Information Systems, 23(5):307-334, 1998.

[16]

P.J. McBrien and A. Poulovassilis. Automatic migration and wrapping of database applications --a schema transformation approach. In Proceedings of ER99, volume 1728 of LNCS, pages 96-113. Springer-Verlag, 1999.

[17]

P.J. McBrien and A. Poulovassilis. A uniform approach to inter-model transformations. In Advanced Information Systems Engineering, 11th International Conference CAiSE'99, volume 1626 of LNCS, pages 333-348. Springer-Verlag, 1999.

[18]

R.J. Miller, M.A. Hernández, L.M. Haas, L.-L. Yan, C.T.H. Ho, R. Fagin, and L. Popa. The Clio project: Managing heterogeneity. SIGMOD Record, 30(1):78- 83, 2001.

[19]

A. Poulovassilis and P.J. McBrien. A general formal framework for schema transformation. Data and Knowledge Engineering, 28(1):47-71, 1998.

[20]

M.T. Roth and P. Schwarz. Don't scrap it, wrap it! A wrapper architecture for data sources. In Proceedings of the 23rd VLDB Conference, pages 266-275, Athens, Greece, 1997.

[21]

A. Sheth and J. Larson. Federated database systems. ACM Computing Surveys, 22(3):183-236, 1990.

[22]

M. Templeton, H. Henley, E. Maros, and D.J. Van Buer. InterViso: Dealing with the complexity of federated database access. The VLDB Journal, 4(2):287-317, April 1995.

[23]

M.E. Vidal, L. Raschid, and J-R. Gruser. A meta-wrapper for scaling up to multiple autonomous distributed information sources. In Proceedings of the 3rd IFCIS International Conference on Cooperative Information Systems (CoopIS98), pages 148-157. IEEE-CS Press, 1998.

Cited By

Caruccio LPolese GTortora G(2016)Synchronization of Queries and Views Upon Schema EvolutionsACM Transactions on Database Systems10.1145/290372641:2(1-41)Online publication date: 11-May-2016
https://dl.acm.org/doi/10.1145/2903726
Rae IRollins EShute JSodhi SVingralek R(2013)Online, asynchronous schema change in F1Proceedings of the VLDB Endowment10.14778/2536222.25362306:11(1045-1056)Online publication date: 1-Aug-2013
https://dl.acm.org/doi/10.14778/2536222.2536230
Terwilliger JCleve ACurino C(2012)How clean is your sandbox?Proceedings of the 5th international conference on Theory and Practice of Model Transformations10.1007/978-3-642-30476-7_1(1-23)Online publication date: 28-May-2012
https://dl.acm.org/doi/10.1007/978-3-642-30476-7_1
Show More Cited By

Recommendations

Constraint Preserving Transformation from Relational Schema to XML Schema

XML has become the standard for publishing and exchanging data on the Web. However, most business data is managed and will remain to be managed by relational database management systems. As such, there is an increasing need to efficiently and accurately ...
Data schema evolution support in XML-relational database systems

Many XML-relational systems, i.e., the systems that use an XML schema as an external schema and a relational schema as an internal schema of the data application representation level, require modifications of the data schemas in the course of time. ...
Schema Mediation for Heterogeneous XML Schema Sources
WAINA '09: Proceedings of the 2009 International Conference on Advanced Information Networking and Applications Workshops

Due to the increasingly widespread use of XML, many XML-related applications require the service of schema mediation, which is to find semantically similar elements from two or more schema sources. Current approaches to schema mediation require much ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image Guide Proceedings

CAiSE '02: Proceedings of the 14th International Conference on Advanced Information Systems Engineering

May 2002

797 pages

ISBN:354043738X

Publisher

Springer-Verlag

Berlin, Heidelberg

Publication History

Published: 27 May 2002

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

22
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 13 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

Caruccio LPolese GTortora G(2016)Synchronization of Queries and Views Upon Schema EvolutionsACM Transactions on Database Systems10.1145/290372641:2(1-41)Online publication date: 11-May-2016
https://dl.acm.org/doi/10.1145/2903726
Rae IRollins EShute JSodhi SVingralek R(2013)Online, asynchronous schema change in F1Proceedings of the VLDB Endowment10.14778/2536222.25362306:11(1045-1056)Online publication date: 1-Aug-2013
https://dl.acm.org/doi/10.14778/2536222.2536230
Terwilliger JCleve ACurino C(2012)How clean is your sandbox?Proceedings of the 5th international conference on Theory and Practice of Model Transformations10.1007/978-3-642-30476-7_1(1-23)Online publication date: 28-May-2012
https://dl.acm.org/doi/10.1007/978-3-642-30476-7_1
Bykau SMylopoulos JRizzolo FVelegrakis Y(2011)Supporting queries spanning across phases of evolving artifacts using Steiner forestsProceedings of the 20th ACM international conference on Information and knowledge management10.1145/2063576.2063815(1649-1658)Online publication date: 24-Oct-2011
https://dl.acm.org/doi/10.1145/2063576.2063815
Terwilliger JBernstein PUnnithan A(2010)Automated co-evolution of conceptual models, physical databases, and mappingsProceedings of the 29th international conference on Conceptual modeling10.5555/1929757.1929772(146-159)Online publication date: 1-Nov-2010
https://dl.acm.org/doi/10.5555/1929757.1929772
Hu XSong IAn Y(2010)Maintaining Mappings between Conceptual Models and Relational SchemasJournal of Database Management10.4018/jdm.201007010221:3(36-68)Online publication date: 1-Jul-2010
https://dl.acm.org/doi/10.4018/jdm.2010070102
Terwilliger JDelcambre LMaier DSteinhauer JBritell S(2010)Updatable and evolvable transforms for virtual databasesProceedings of the VLDB Endowment10.14778/1920841.19208833:1-2(309-319)Online publication date: 1-Sep-2010
https://dl.acm.org/doi/10.14778/1920841.1920883
Terwilliger JBernstein PUnnithan AElmagarmid AAgrawal D(2010)Worry-free database upgradesProceedings of the 2010 ACM SIGMOD International Conference on Management of data10.1145/1807167.1807316(1191-1194)Online publication date: 6-Jun-2010
https://dl.acm.org/doi/10.1145/1807167.1807316
Passi KMorgan DMadria SDesai BSacca DGreco S(2009)Maintaining integrated XML schemaProceedings of the 2009 International Database Engineering & Applications Symposium10.1145/1620432.1620461(267-274)Online publication date: 16-Sep-2009
https://dl.acm.org/doi/10.1145/1620432.1620461
Fernández-Moctezuma RTerwilliger JDelcambre LMaier D(2009)Toward Formal Semantics for Data and Schema Evolution in Data Stream Management SystemsProceedings of the ER 2009 Workshops (CoMoL, ETheCoM, FP-UML, MOST-ONISW, QoIS, RIGiM, SeCoGIS) on Advances in Conceptual Modeling - Challenging Perspectives10.1007/978-3-642-04947-7_11(85-94)Online publication date: 15-Nov-2009
https://dl.acm.org/doi/10.1007/978-3-642-04947-7_11
Show More Cited By

View Options

View options

Media

Figures

Other

Tables

View Table of Contents