Automating database schema evolution in information system upgrades

Proceedings of the 2nd International Workshop on Hot Topics in Software Upgrades, HotSWUp '09

Volumn , Issue , 2009, Pages

  Curino, Carlo ^a,b   Moon, Hyun J ^a,c   Zaniolo, Carlo ^a  

^a UNIVERSITY OF CALIFORNIA   (United States)

^b MASSACHUSETTS INSTITUTE OF TECHNOLOGY   (United States)

^c NEC LABORATORIES AMERICA   (United States)

Author keywords

Database design methodologies; Schema evolution; Software upgrades

Indexed keywords

ARCHIVAL INFORMATION SYSTEMS; DATA MIGRATION; DATABASE ADMINISTRATORS; DATABASE DESIGN; DATABASE SCHEMAS; ENABLING TECHNOLOGIES; ERROR PRONES; INVERTIBILITY; LIGHT WEIGHT; MAPPING TECHNIQUES; ON CURRENTS; SCHEMA CHANGES; SCHEMA EVOLUTION; SCIENTIFIC DATABASE; SOFTWARE UPGRADES; STUMBLING BLOCKS; TIME-CONSUMING PROCESS; WEB INFORMATION SYSTEMS;

COMPUTER SOFTWARE; DATA WAREHOUSES; LINGUISTICS; PRISMS;

INFORMATION SYSTEMS;

EID: 76749172198     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1656437.1656444     Document Type: Conference Paper

References (37)

1. D. Barbosa, J. Freire, and A. O. Mendelzon. Designing information-preserving mapping schemes for xml. In VLDB, pages 109-120, 2005.
2. K. Beck. Extreme Programming Explained: Embrace Change. Addison-Wesley Professional, 1st edition, October 1999. ISBN 0201616416.
3. P. A. Bernstein. Applying model management to classical meta data problems. In CIDR, 2003.
4. P. A. Bernstein and E. Rahm. Data warehouse scenarios for model management. In ER, 2003.
5. H. Bounif and R. Pottinger. Schema repository for database schema evolution. DEXA, 0:647-651, 2006.
6. A. Cleve and J.-L. Hainaut. Co-transformations in database applications evolution. LNCS: Generative and Transformational Techniques in Software Engineering, pages 409-421, 2006.
7. C. Curino and C. Zaniolo. Pantha rei data set: http://dataset. schemaevolution.org/. 2009.
8. C. Curino, H. J. Moon, L. Tanca, and C. Zaniolo. Schema Evolution in Wikipedia: toward a Web Information System Benchmark. ICEIS, 2008.
9. C. Curino, H. J. Moon, and C. Zaniolo. Graceful database schema evolution: the prism workbench. Very Large DataBases (VLDB), 1, 2008.
10. C. Curino, H. J. Moon, and C. Zaniolo. Managing the history of metadata in support for db archiving and schema evolution. In ER Workshop on Evolution and Change in Data Management (ECDM), 2008.
11. C. Curino, H. J. Moon, M. Ham, and C. Zaniolo. The prism work-wench: Database schema evolution without tears. In ICDE, pages 1523-1526, 2009.
12. DB2 development team. DB2 Change Management Expert. 2006.
13. A. Deutsch and V. Tannen. Mars: A system for publishing xml from mixed and redundant storage. In VLDB, 2003.
14. A. Deutsch, A. Nash, and J. Remmel. The chase revisited. In Principles of database systems (PODS), pages 149-158, 2008.
15. R. Fagin, P. G. Kolaitis, L. Popa, and W.-C. Tan. Composing schema mappings: Second-order dependencies to the rescue. In PODS, 2004.
16. R. Fagin, P. G. Kolaitis, L. Popa, and W.-C. Tan. Composing schema mappings: Second-order dependencies to the rescue. ACM Trans. Database Syst., 30(4):994-1055, 2005.
17. R. Fagin, P. G. Kolaitis, L. Popa, and W.-C. Tan. Quasi-inverses of schema mappings. In PODS '07, pages 123-132, 2007.
18. R. d. M. Galante, C. S. dos Santos, N. Edelweiss, and A. F. Mor-eira. Temporal and versioning model for schema evolution in object-oriented databases. Data & Knowledge Engineering, 53(2):99-128, 2005.
19. M. Golfarelli, J. Lechtenbörger, S. Rizzi, and G. Vossen. Schema versioning in data warehouses. In ER (Workshops), pages 415-428, 2004.
20. J.-M. Hick and J.-L. Hainaut. Database application evolution: a transformational approach. Data Knowl. Eng., 59(3):534-558, 2006.
21. H. V. Jagadish, I. S. Mumick, and M. Rabinovich. Scalable versioning in distributed databases with commuting updates. In Conference on Data Engineering, pages 520-531, 1997. ISBN 0-8186-7807-0.
22. S. Marche. Measuring the stability of data models. European Journal of Information Systems, 2(1):37-47, 1993.
23. R. C. Martin. Agile Software Development: Principles, Patterns, and Practices. Prentice Hall PTR, Upper Saddle River, NJ, USA, 2003. ISBN 0135974445.
24. S. Melnik, E. Rahm, and P. A. Bernstein. Rondo: A programming platform for generic model management. In SIGMOD, 2003.
25. H. J. Moon, C. Curino, A. Deutsch, C.-Y. Hou, and C. Zaniolo. Managing and querying transaction-time databases under schema evolution. Very Large DataBases (VLDB), 1, 2008.
26. H. J. Moon, C. Curino, M. Ham, and C. Zaniolo. Prima: archiving and querying historical data with evolving schemas. In SIGMOD Conference, pages 1019-1022, 2009.
27. M. M. Moro, S. Malaika, and L. Lim. Preserving XML Queries during Schema Evolution. In WWW, pages 1341-1342, 2007.
28. Oracle development team. Oracle database 10g online data reorganization & redefinition. Oracle White Paper, 2005. URL \url{http://www.oracle. com/technology/deploy/availability/pdf/ha-10gR2-online-reorg-twp.pdf}.
29. Y.-G. Ra. Relational schema evolution for program independency. Intelligent Information Technology, pages 273-281, 2005.
30. S. Ram and G. Shankaranarayanan. Research issues in database schema evolution: the road not taken. In Boston University School of Management, Paper No: 2003-15, 2003.
31. S. Rizzi and M. Golfarelli. X-time: Schema versioning and cross-version querying in data warehouses. In ICDE, pages 1471-1472, 2007.
32. J. Roddick. A Survey of Schema Versioning Issues for Database Systems. Information and Software Technology, 37(7):383-393, 1995.
33. D. I. Sjoberg. Quantifying schema evolution. Information and Software Technology, 35(1):35-44, 1993.
34. V. J. Tsotras and A. Kumar. Temporal database bibliography update. SIGMOD Record, 25(1):41-51, 1996.
35. Y. Velegrakis, R. J. Miller, and L. Popa. Mapping adaptation under evolving schemas. In VLDB, 2003.
36. F. Wang, C. Zaniolo, and X. Zhou. Archis: An xml-based approach to transaction-time temporal database systems. The International Journal of Very Large Databases, 2008.
37. C. Yu and L. Popa. Semantic adaptation of schema mappings when schemas evolve. In VLDB, 2005.