Skip to main content
Springer Nature Link
Log in

Asynchronous Replication for Evolutionary Database Development: A Design for the Experimental Assessment of a Novel Approach

  • Conference paper
On the Move to Meaningful Internet Systems: OTM 2011 (OTM 2011)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 7045))

  • 716 Accesses

Abstract

Environments with frequent changes in application requirements demand an evolutionary approach for database modeling. The challenge is greater when the database must support multiple applications simultaneously. An existing solution for database evolution is refactoring with a transition period. During this period, both the old and the new database schemas coexist and data is replicated in a synchronous process. This solution brings several difficulties, such as interference with the operation of applications. To minimize these difficulties, in this paper we present an asynchronous approach to keep these schemas updated. This paper presents the design for an experimental assessment of this novel approach for evolutionary database development.

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

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.

Similar content being viewed by others

References

  1. Ambler, S.W.: Agile modeling: effective practices for eXtreme programming and the unified process. John Wiley and Sons (2002)

    Google Scholar 

  2. Ambler, S.W.: Agile Database Techniques. John Wiley & Sons Inc. (2003)

    Google Scholar 

  3. Ambler, S.W., Sadalage, P.J.: Refactoring Databases: Evolutionary Database Design (Addison Wesley Signature Series). Addison-Wesley Professional (2006)

    Google Scholar 

  4. Balsters, H., de Brock, B., Conrad, S. (eds.): Database Schema Evolution and Meta-Modeling. Springer, Heidelberg (2001)

    MATH  Google Scholar 

  5. Continuent: Bristlecone performance test, http://www.continuent.com/community/lab-projects/bristlecone (last access on February 18, 2011)

  6. Curino, C., Moon, H.J., Zaniolo, C.: Managing the history of metadata in support for db archiving and schema evolution. In: Fifth International Workshop on Evolution and Change in Data Management, pp. 78–88. Springer, Heidelberg (2008)

    Google Scholar 

  7. Domingues, H., Correia, R., Kon, F., Kon, R., Ferreira, J.E.: Análise e modelagem conceitual de um sistema de prontuário eletrônico para centros de saúde. In: SBC - Workshop de Informática Médica, pp. 31–40. Belém, Brasil (2008)

    Google Scholar 

  8. Domingues, H., Kon, F., Ferreira, J.E.: Replicação assíncrona em modelagem evolutiva de banco de dados. In: SBBD - XXIV Simpósio Brasileiro de Banco de Dados (Brazilian Symposium on Databases), pp. 121–135. Ceará, Brazil (2009)

    Google Scholar 

  9. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, quinta edn. Addison-Wesley Longman Publishing Co., Inc., Boston (2006)

    Google Scholar 

  10. Fowler, M.: Evolutionary database design (2003), http://www.martinfowler.com/articles/evodb.html (last access on February 18, 2011)

  11. Hick, J.-M., Hainaut, J.-L.: Database application evolution: A transformational approach. Data & Knowledge Engineering 59(3), 534–558 (2006)

    Article  Google Scholar 

  12. Moon, H.J., Curino, C.A., Deutsch, A., Hou, C.-Y., Zaniolo, C.: Managing and querying transaction-time databases under schema evolution. Proceedings of the VLDB Endowment 1(1), 882–895 (2008)

    Article  Google Scholar 

  13. Oertly, F., Schiller, G.: Evolutionary database design. In: Fifth International Conference on Data Engineering, pp. 618–624 (1989)

    Google Scholar 

  14. Rahm, E., Bernstein, P.A.: An online bibliography on schema evolution. SIGMOD Rec. 35, 30–31 (2006), http://doi.acm.org/10.1145/1228268.1228273

    Article  Google Scholar 

  15. Rashid, A., Sawyer, P.: A database evolution taxonomy for object-oriented databases. Journal of Software Maintenance and Evolution: Research and Practice 17(2), 93–141 (2005)

    Article  Google Scholar 

  16. Support, A.: Java for mac os x 10.5 update 8. http://support.apple.com/kb/DL971 (last access on February 18, 2011)

  17. VMware: Desktop products, vmware fusion 3, http://www.vmware.com/products/fusion (last access on February 18, 2011)

  18. Wiesmann, M., Pedone, F., Schiper, A., Kemme, B., Alonso, G.: Understanding replication in databases and distributed systems. In: Proceedings of ICDCS 2000, pp. 264–274. IEEE Computer Society (2000)

    Google Scholar 

  19. Wohlin, C., Runeson, P., Host, M., Ohlsson, M.C., Regnell, B., Wesslen, A.: Experimentation in Software Engineering: An Introduction. Kluwer (2000)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of São Paulo, Brazil

    Helves Humberto Domingues, Fabio Kon & João Eduardo Ferreira

Authors
  1. Helves Humberto Domingues
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Fabio Kon
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. João Eduardo Ferreira
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. STAR Lab, Vrije Universiteit Brussel (VUB), Bldg G/10, Pleinlaan 2, 1050, Brussel, Belgium

    Robert Meersman

  2. DEBII, Curtin University of Technology, Technology Park, De Laeter Way, 6102, Bentley, WA, Australia

    Tharam Dillon

  3. Facultad de Informática, Universidad Politécnica de Madrid, Campus de Montegancedo S/N, 28660, Boadilla del Monte, Madrid, Spain

    Pilar Herrero

  4. Smeal College of Business, Pennsylvania State University, University Park, 16802, P.O. Box, PA, U.S.A.

    Akhil Kumar

  5. Institute of Databases and Information Systems, Ulm University, Germany

    Manfred Reichert

  6. City University of Hong Kong, Hong Kong

    Li Qing

  7. National University of Singapore (NUS), Singapore

    Beng-Chin Ooi

  8. Dipartemento Tecnologie dell’Informazione, Universitá degli Studi di Milano, Via Bramante 65, 26013, Crema, Italy

    Ernesto Damiani

  9. Vanderbilt University, VU, Station B #1829, 2015 Terrace Place, 37203, Nashville, TN, USA

    Douglas C. Schmidt

  10. Virginia Tech, 24060, Blacksburg, VA

    Jules White

  11. Digital Enterprise Research Institute (DERI),, National University of Ireland, IDA Business Park, Lower Dangan, Galway, Ireland

    Manfred Hauswirth

  12. Kno.e.sis Center, Wright State University, Dayton,, Ohio

    Pascal Hitzler

  13. IBM India Research Lab, 4, Block C, Institutional Area, 110 070, Vasant Kunj, New Delhi, India

    Mukesh Mohania

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Domingues, H.H., Kon, F., Ferreira, J.E. (2011). Asynchronous Replication for Evolutionary Database Development: A Design for the Experimental Assessment of a Novel Approach. In: Meersman, R., et al. On the Move to Meaningful Internet Systems: OTM 2011. OTM 2011. Lecture Notes in Computer Science, vol 7045. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-25106-1_29

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-25106-1_29

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-25105-4

  • Online ISBN: 978-3-642-25106-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics