Abstract
One of the problems arising upon the evolution of a database schema is that some queries and views defined on the previous schema version might no longer work properly. Thus, evolving a database schema entails the redefinition of queries and views to adapt them to the new schema. Although this problem has been mainly raised in the context of traditional information systems, solutions to it are also advocated in other database-related areas, such as Data Integration, Web Data Integration, and Data Warehouses. The problem is a critical one, since industrial organizations often need to adapt their databases and data warehouses to frequent changes in the real world. In this article, we provide a survey of existing approaches and tools to the problem of adapting queries and views upon a database schema evolution; we also propose a classification framework to enable a uniform comparison method among many heterogeneous approaches and tools.
- Serge Abitebul, Richard Hull, and Victor Vianu. 1995. Foundation of Databases. Addison-Wesley. Google ScholarDigital Library
- Alanoly J. Andrews, Nematollaah Shiri, Laks V. S. Lakshmanan, and Iyer N. Subramanian. 1996. On implementing schemaLoga database programming language. In Proceedings of the 5th International Conference on Information and Knowledge Management (CIKM’96). ACM, 309--316. Google ScholarDigital Library
- Jay Banerjee, Won Kim, Hyoung-Joo Kim, and Henry F. Korth. 1987. Semantics and Implementation of Schema Evolution in Object-Oriented Databases. Vol. 16. ACM Press. 311--322 pages. Google ScholarDigital Library
- Jonas Barklund, Pierangelo DellAcqua, Stefania Costantini, and Gaetano A. Lanzarone. 1997. Metareasoning agents for query-answering systems. In Flexible Query Answering Systems. Springer, 103--121. Google ScholarDigital Library
- Zohra Bellahsene. 2002. Schema evolution in data warehouses. Knowledge and Information Systems 4, 3 (2002), 283--304. Google ScholarDigital Library
- Philip A. Bernstein. 2001. Generic model management: A database infrastructure for schema manipulation. In Cooperative Information Systems. Springer, 1--6. Google ScholarDigital Library
- Philip A. Bernstein. 2003. Applying model management to classical meta data problems. In Proceedings of the 1st Biennial Conference on Innovative Data Systems Research (CIDR'03).Google Scholar
- Phillip A. Bernstein, Alon Y. Halevy, and Rachel A. Pottinger. 2000. A vision for management of complex models. ACM Sigmod Record 29, 4 (2000), 55--63. Google ScholarDigital Library
- Philip A. Bernstein and Sergey Melnik. 2007. Model management 2.0: Manipulating richer mappings. In Proceedings of the ACM SIGMOD International Conference on Management of Data (COMAD’07). ACM, 1--12. Google ScholarDigital Library
- Philip A. Bernstein and Erhard Rahm. 2000. Data warehouse scenarios for model management. In Conceptual Modeling (ER’00). Springer, 1--15. Google ScholarDigital Library
- Elisa Bertino. 1992. A view mechanism for object-oriented databases. In Advances in Database Technology (EDBT’92). Springer, 136--151. Google ScholarDigital Library
- Philip Bohannon, Wenfei Fan, Floris Geerts, Xibei Jia, and Anastasios Kementsietsidis. 2007. Conditional functional dependencies for data cleaning. In Proceedings of the IEEE 23rd International Conference on Data Engineering, 2007 (ICDE’07). IEEE, 746--755.Google ScholarCross Ref
- Mokrane Bouzeghoub, Bernadette Farias Lóscio, Zoubida Kedad, and Ana Carolina Salgado. 2003. Managing the evolution of mediation queries. In On The Move to Meaningful Internet Systems 2003: CoopIS, DOA, and ODBASE. Springer, 22--37.Google Scholar
- Michael Boyd, Sasivimol Kittivoravitkul, Charalambos Lazanitis, Peter McBrien, and Nikos Rizopoulos. 2004. AutoMed: A BAV data integration system for heterogeneous data sources. In Advanced Information Systems Engineering. Springer, 82--97.Google Scholar
- Peter McBrien and Alexandra Poulovassilis. 2001. A semantic approach to integrating XML and structured data sources. In Advanced Information Systems Engineering. Springer, 330--345. Google ScholarDigital Library
- Loredana Caruccio, Vincenzo Deufemia, and Giuseppe Polese. 2014. Visual data integration based on description logic reasoning. In Proceedings of the 18th International Database Engineering & Applications Symposium. ACM, 19--28. Google ScholarDigital Library
- Loredana Caruccio, Vincenzo Deufemia, and Giuseppe Polese. 2016. Relaxed functional dependencies - a survey of approaches. IEEE Transactions on Knowledge and Data Engineering 28, 1 (2016), 147--165. Google ScholarDigital Library
- Shi-Kuo Chang, Vincenzo Deufemia, Giuseppe Polese, and Mario Vacca. 2007. A normalization framework for multimedia databases. IEEE Transactions on Knowledge and Data Engineering 19, 12 (2007), 1666--1679. Google ScholarDigital Library
- Alcino Cunha and Joost Visser. 2007a. Strongly typed rewriting for coupled software transformation. Electronic Notes in Theoretical Computer Science 174, 1 (2007), 17--34. Google ScholarDigital Library
- Alcino Cunha and Joost Visser. 2007b. Transformation of structure-shy programs: Applied to XPath queries and strategic functions. In Proceedings of the 2007 ACM SIGPLAN Symposium on Partial Evaluation and Semantics-Based Program Manipulation. ACM, 11--21. Google ScholarDigital Library
- Frédéric Cuppens and Robert Demolombe. 1988. Cooperative answering: A methodology to provide intelligent access to databases. In Proceedings of 2nd International Conference Expert Database Systems. 621--643.Google Scholar
- Carlo Curino, Hyun Jin Moon, Alin Deutsch, and Carlo Zaniolo. 2013. Automating the database schema evolution process. VLDB Journal International Journal on Very Large Data Bases 22, 1 (2013), 73--98. Google ScholarDigital Library
- Carlo Curino, Hyun Jin Moon, and Carlo Zaniolo. 2008a. Managing the history of metadata in support for DB archiving and schema evolution. In Proceedings of Advances in Conceptual Modeling -- Challenges and Opportunities. Springer, 78--88. Google ScholarDigital Library
- Carlo Curino, Hyun J. Moon, and Carlo Zaniolo. 2009. Automating database schema evolution in information system upgrades. In Proceedings of the 2nd International Workshop on Hot Topics in Software Upgrades. ACM, 5. Google ScholarDigital Library
- Carlo A. Curino, Hyun Jin Moon, Alin Deutsch, and Carlo Zaniolo. 2010. Update rewriting and integrity constraint maintenance in a schema evolution support system: Prism++. Proceedings of the VLDB Endowment 4, 2 (2010), 117--128. Google ScholarDigital Library
- Carlo A. Curino, Hyun Jin Moon, MyungWon Ham, and Carlo Zaniolo. 2009. The PRISM workwench: Database schema evolution without tears. In Proceedings of 25th International Conference on Data Engineering (ICDE’09). IEEE, 1523--1526. Google ScholarDigital Library
- Carlo A. Curino, Hyun J. Moon, and Carlo Zaniolo. 2008b. Graceful database schema evolution: The prism workbench. Proceedings of the VLDB Endowment 1, 1 (2008), 761--772. Google ScholarDigital Library
- Carlo A. Curino, Hyun J. Moon, and Carlo Zaniolo. 2008c. Managing the history of metadata in support for db archiving and schema evolution. In Advances in Conceptual Modeling--Challenges and Opportunities. Lecture Notes in Computer Science, Vol. 5232. Springer, 78--88. Google ScholarDigital Library
- Carlo A. Curino, Letizia Tanca, Hyun J. Moon, and Carlo Zaniolo. 2008. Schema evolution in wikipedia: Toward a web information system benchmark. In Proceedings of the International Conference on Enterprise Information Systems (ICEIS’08). Citeseer, 323--332.Google Scholar
- Krzysztof Czarnecki, J. Nathan Foster, Zhenjiang Hu, Ralf Lämmel, Andy Schürr, and James F. Terwilliger. 2009. Bidirectional transformations: A cross-discipline perspective. In Theory and Practice of Model Transformations. Springer, 260--283. Google ScholarDigital Library
- Cristina De Castro, Fabio Grandi, and Maria Rita Scalas. 1997. Schema versioning for multitemporal relational databases. Information Systems 22, 5 (1997), 249--290. Google ScholarDigital Library
- Denise de Vries, Sally Rice, and John F. Roddick. 2004. In support of mesodata in database management systems. In Database and Expert Systems Applications. Springer, 663--674.Google Scholar
- Denise de Vries and John F. Roddick. 2004. Facilitating database attribute domain evolution using mesodata. In Evolution and Change in Data Management (ECDM’04) - ER 2004 Workshops, Vol. 3289.Google Scholar
- Denise de Vries and John F. Roddick. 2007. The case for mesodata: An empirical investigation of an evolving database system. Information and Software Technology 49, 9 (2007), 1061--1072. Google ScholarDigital Library
- Vincenzo Deufemia, Massimiliano Giordano, Giuseppe Polese, and Genoveffa Tortora. 2014. A visual language-based system for extraction--transformation--loading development. Software: Practice and Experience 44, 12 (2014), 1417--1440. Google ScholarDigital Library
- Alin Deutsch and Val Tannen. 2003. MARS: A system for publishing XML from mixed and redundant storage. In Proceedings of the 29th International Conference on Very Large Data Bases (VLDB’03), Vol. 29. VLDB Endowment, 201--212. Google ScholarDigital Library
- Ronald Fagin. 2006. Inverting schema mappings. In Principles of Database Systems (PODS’06), Vansummeren (Ed.). 50--59. Google ScholarDigital Library
- Ronald Fagin, Phokion G. Kolaitis, Lucian Popa, and Wang-Chiew Tan. 2005. Composing schema mappings: Second-order dependencies to the rescue. ACM Transactions on Database Systems (TODS) 30, 4 (2005), 994--1055. Google ScholarDigital Library
- Hao Fan and Alexandra Poulovassilis. 2003. Using AutoMed metadata in data warehousing environments. In Proceedings of the 6th ACM International Workshop on Data Warehousing and OLAP. ACM, 86--93. Google ScholarDigital Library
- Fabrizio Ferrandina, Thorsten Meyer, and Roberto Zicari. 1994. Implementing lazy database updates for an object database system. In Proceedings of the International Conference on Very Large Data Bases (VLDB’94). Citeseer, 261--261. Google ScholarDigital Library
- Enrico Franconi, Fabio Grandi, and Federica Mandreoli. 2000. A semantic approach for schema evolution and versioning in object-oriented databases. In Computational Logic (CL’00). Springer, 1048--1062. Google ScholarDigital Library
- Enrico Franconi, Fabio Grandi, and Federica Mandreoli. 2001. Schema evolution and versioning: A logical and computational characterisation. Database Schema Evolution and Meta-Modeling. Springer, 85--99. Google ScholarDigital Library
- Frédéric Gingras, Laks V. S. Lakshmanan, Iyer N. Subramanian, Despina Papoulis, and Nematollaah Shiri. 1997. Languages for multi-database interoperability. In ACM SIGMOD Record, Vol. 26. ACM, 536--538. Google ScholarDigital Library
- Fabio Grandi and Federica Mandreoli. 2003. A formal model for temporal schema versioning in object-oriented databases. Data & Knowledge Engineering 46, 2 (2003), 123--167. Google ScholarDigital Library
- Peter Haase and Boris Motik. 2005. A mapping system for the integration of owl-dl ontologies. In Proceedings of the 1st International Workshop on Interoperability of Heterogeneous Information Systems. ACM, 9--16. Google ScholarDigital Library
- Alon Y. Halevy, Zachary G. Ives, Peter Mork, and Igor Tatarinov. 2003. Piazza: Data management infrastructure for semantic web applications. In Proceedings of the 12th International Conference on World Wide Web. ACM, 556--567. Google ScholarDigital Library
- Mark Hansen, Stuart Madnick, and Michael Siegel. 2003. Data Integration Using Web Services. Springer.Google Scholar
- Jean-Marc Hick and Jean-Luc Hainaut. 2006. Database application evolution: A transformational approach. Data & Knowledge Engineering 59, 3 (2006), 534--558. Google ScholarDigital Library
- Jaakko Hintikka and James Bachman. 1991. What If-? Toward Excellence in Reasoning. Mayfield Publishing Company.Google Scholar
- Richard Hull. 1986. Relative information capacity of simple relational database schemata. SIAM Journal of Computing 15, 3 (1986), 856--886. Google ScholarDigital Library
- Akaichi Jalel. 2007. E-learning data warehouse maintenance system for collaborative learning availability resources optimization. International Journal of Education and Development Using ICT 3, 3 (2007), 16--29.Google Scholar
- Edgar Jasper. 2002. Global query processing in the AutoMed heterogeneous database environment. In Proceedings of the 19th British National Conference on Databases (BNCOD’02). Springer, 46--49. Google ScholarDigital Library
- Ole Guttorm Jensen and Michael Böhlen. 2002. Current, legacy, and invalid tuples in conditionally evolving databases. In Advances in Information Systems (ADVIS’02). Springer, 65--82. Google ScholarDigital Library
- Peter Sune Jørgensen and Michael Böhlen. 2007. Versioned relations: Support for conditional schema changes and schema versioning. In Advances in Databases: Concepts, Systems and Applications. Springer, 1058--1061. Google ScholarDigital Library
- Christian Kaas, Torben Bach Pedersen, and Bjørn Rasmussen. 2004. Schema evolution for stars and snowflakes. ICEIS (2004), 425--433.Google Scholar
- Zoubida Kedad and Mokrane Bouzeghoub. 1999. Discovering view expressions from a multi-source information system. In Proceedings of the International Conference on Cooperative Information Systems (IFCIS’99). IEEE, 57--68. Google ScholarDigital Library
- Andreas Koeller and Elke A. Rundensteiner. 2000. History-driven view synchronization. In Data Warehousing and Knowledge Discovery, Y. Kambayashi, M. K. Mohania, and A. M. Tjoia (Eds.). Lecture Notes in Computer Science, Vol. 1874. Springer, 168--177. Google ScholarDigital Library
- Andreas Koeller and Elke A. Rundensteiner. 2005. A history-driven approach at evolving views under meta data changes. Knowledge and Information Systems 8, 1 (2005), 34--67.Google ScholarDigital Library
- Andreas Koeller, Elke A. Rundensteiner, and Nabil Hachem. 1998. Integrating the rewriting and ranking phases of view synchronization. In Proceedings of the 1st ACM International Workshop on Data Warehousing and OLAP (DOLAP’98). ACM, 60--65. Google ScholarDigital Library
- Phokion G. Kolaitis. 2005. Schema mappings, data exchange, and metadata management. In Proceedings of the 24th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (PODS’05), C. Li (Ed.). ACM, 61--75. Google ScholarDigital Library
- Laks V. S. Lakshmanan, Fereidoon Sadri, and Iyer N. Subramanian. 1993. On the logical foundations of schema integration and evolution in heterogeneous database systems. In Deductive and Object-Oriented Databases (DOOD’93). Springer, 81--100.Google Scholar
- Laks V. S. Lakshmanan, Fereidoon Sadri, and Iyer N. Subramanian. 1997. Logic and algebraic languages for interoperability in multidatabase systems. Journal of Logic Programming 33, 2 (1997), 101--149.Google ScholarCross Ref
- Ralf Lämmel. 2004. Coupled software transformations. In Proceedings of the 1st International Workshop on Software Evolution Transformations. 31--35.Google Scholar
- Amy J. Lee, Andreas Koeller, Anisoara Nica, and Elke A. Rundensteiner. 1999a. Data warehouses evolution: Trade-offs between quality and cost of query rewritings. In Proceedings of 15th International Conference on Data Engineering (ICDE’99). IEEE, 255. Google ScholarDigital Library
- Amy J. Lee, Andreas Koeller, Anisoara Nica, and Elke A. Rundensteiner. 1999b. Non-equivalent query rewritings. In International Database Conference. Citeseer.Google Scholar
- Amy J. Lee, Anisoara Nica, and Elke A. Rundensteiner. 2002. The EVE approach: View synchronization in dynamic distributed environments. IEEE Transactions on Knowledge and Data Engineering 14, 5 (2002), 931--954. Google ScholarDigital Library
- Maurizio Lenzerini. 2002. Data integration: A theoretical perspective. In Proceedings of the 21st ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (PODS’02), L. Popa (Ed.). ACM, 233--246. Google ScholarDigital Library
- Barbara Staudt Lerner. 2000. A model for compound type changes encountered in schema evolution. ACM Transactions on Database Systems (TODS) 25, 1 (2000), 83--127. Google ScholarDigital Library
- Xue Li. 1999. A survey of schema evolution in object-oriented databases. In Proceedings of Technology of Object-Oriented Languages and Systems (TOOLS’99). IEEE, 362--371. Google ScholarDigital Library
- Yaozhong Liang, Harith Alani, and Nigel Shadbolt. 2006. Changing ontology breaks queries. In The Semantic Web (ISWC’06), I. F. Cruz, S. Decker, D. Allemang, C. Preist, D. Schwabe, P. Mika, M. Uschold, and L. Aroyo (Eds.). Lecture Notes on Computer Science, Vol. 4275. Springer, 982--985. Google ScholarDigital Library
- Bernadette Farias Lóscio and Ana Carolina Salgado. 2004. Evolution of XML-based mediation queries in a data integration system. In Conceptual Modeling for Advanced Application Domains, S. Wang, D. Yang, K. Tanaka, F. Grandi, S. Zhou, E. E. Mangina, T. W. Ling, I.-Y. Song, J. Guan, and H. C. Mayr (Eds.). Lecture Notes in Computer Science, Vol. 3289. Springer, 402--414.Google Scholar
- Jayant Madhavan, S. Jeffery, Shirley Cohen, X. Dong, David Ko, Cong Yu, and Alon Halevy. 2007. Web-scale data integration: You can only afford to pay as you go. In Proceedings of the 3rd Biennial Conference on Innovative Data Systems Research (CIDR'07). 342--350.Google Scholar
- Andy Maule, Wolfgang Emmerich, and David S. Rosenblum. 2008. Impact analysis of database schema changes. In Proceedings of the 30th International Conference on Software Engineering (ICSE’08). ACM, 451--460. Google ScholarDigital Library
- Peter McBrien and Alexandra Poulovassilis. 1998. A formalisation of semantic schema integration. Information Systems 23, 5 (1998), 307--334. Google ScholarDigital Library
- Peter McBrien and Alexandra Poulovassilis. 1999a. Automatic migration and wrapping of database applications - a schema transformation approach. In Proceedings of 18th International Conference on Conceptual Modeling. Springer, 96--113. Google ScholarDigital Library
- Peter McBrien and Alexandra Poulovassilis. 1999b. A uniform approach to inter-model transformations. In Advanced Information Systems Engineering. Springer, 333--348. Google ScholarDigital Library
- Peter McBrien and Alexandra Poulovassilis. 2002. Schema evolution in heterogeneous database architectures, a schema transformation approach. In Advanced Information Systems Engineering. Springer, 484--499. Google ScholarDigital Library
- Peter McBrien and Alexandra Poulovassilis. 2003. Data integration by bi-directional schema transformation rules. In Proceedings of 19th International Conference on Data Engineering. IEEE, 227--238.Google ScholarCross Ref
- Sergey Melnik. 2004. Generic Model Management: Concepts and Algorithms. Vol. 2967. Springer-Verlag New York Incorporated. Google ScholarDigital Library
- Sergey Melnik. 2005. Model management: First steps and beyond. BTW, LNI 65 (2005), 455--464.Google Scholar
- Sergey Melnik, Erhard Rahm, and Philip A. Bernstein. 2003a. Developing metadata-intensive applications with Rondo. Web Semantics: Science, Services and Agents on the World Wide Web 1, 1 (2003), 47--74.Google ScholarCross Ref
- Sergey Melnik, Erhard Rahm, and Philip A. Bernstein. 2003b. Rondo: A programming platform for generic model management. In Proceedings of the 2003 ACM SIGMOD International Conference on Management of Data, A. Y. Halevy, Z. G. Ives, and Doan A. (Eds.). ACM, 193--204. Google ScholarDigital Library
- Renée J. Miller, Mauricio A. Hernández, Laura M. Haas, Ling-Ling Yan, CT Howard Ho, Ronald Fagin, and Lucian Popa. 2001. The Clio project: Managing heterogeneity. SIgMOD Record 30, 1 (2001), 78--83. Google ScholarDigital Library
- Renée J. Miller, Yannis E. Ioannidis, and Raghu Ramakrishnan. 1993. The use of information capacity in schema integration and translation. In Proceedings of the 19th International Conference on Very Large Data Bases (VLDB'93), Vol. 93. Citeseer, 120--133. Google ScholarDigital Library
- Hyun J. Moon, Carlo A. Curino, Alin Deutsch, Chien-Yi Hou, and Carlo Zaniolo. 2008. Managing and querying transaction-time databases under schema evolution. Proceedings of the VLDB Endowment 1, 1 (2008), 882--895. Google ScholarDigital Library
- Mirella M. Moro, Susan Malaika, and Lipyeow Lim. 2007. Preserving XML queries during schema evolution. In Proceedings of the 16th International Conference on World Wide Web, C. L. Williamson, M. E. Zurko, P. F. Patel-Schneider, and P. J. Shenoy (Eds.). ACM, 1341--1342. Google ScholarDigital Library
- Ullas Nambiar and Subbarao Kambhampati. 2004. Mining approximate functional dependencies and concept similarities to answer imprecise queries. In Proceedings of the 7th International Workshop on the Web and Databases: Colocated with ACM SIGMOD/PODS 2004. ACM, 73--78. Google ScholarDigital Library
- Anisoara Nica, Amy J. Lee, and Elke A. Rundensteiner. 1998. The CVS algorithm for view synchronization in evolvable large-scale information systems. In Advances in Database Technology (EDBT), H.-J. Schek, F. Saltor, I. Ramos, and G. Alonso (Eds.). Lecture Notes in Computer Science, Vol. 1377. Springer, 357--373. Google ScholarDigital Library
- Anisoara Nica and Elke A. Rundensteiner. 1998. Using containment information for view evolution in dynamic distributed environments. In Proceedings of the 9th International Workshop on Database and Expert Systems Applications (DEXA’98). IEEE, 212--217. Google ScholarDigital Library
- Natalya F. Noy and Mark A. Musen. 2002. PROMPTDIFF: A fixed-point algorithm for comparing ontology versions. In Proceedings of the National Conference on Artificial Intelligence (AAAI/IAAI’02). 744--750. Google ScholarDigital Library
- George Papastefanatos, Fotini Anagnostou, Yannis Vassiliou, and Panos Vassiliadis. 2008. Hecataeus: A what-if analysis tool for database schema evolution. In Proceedings of the 12th European Conference on Software Maintenance and Reengineering (CSMR’08). IEEE, 326--328. Google ScholarDigital Library
- George Papastefanatos, Panos Vassiliadis, Alkis Simitsis, and Yannis Vassiliou. 2007. What-if analysis for data warehouse evolution. In Data Warehousing and Knowledge Discovery. Springer, 23--33. Google ScholarDigital Library
- George Papastefanatos, Panos Vassiliadis, Alkis Simitsis, and Yannis Vassiliou. 2009. Policy-regulated management of ETL evolution. Journal on Data Semantics XIII. Springer, 147--177. Google ScholarDigital Library
- George Papastefanatos, Panos Vassiliadis, Alkis Simitsis, and Yannis Vassiliou. 2010. HECATAEUS: Regulating schema evolution. In Proceedings of the IEEE 26th International Conference on Data Engineering (ICDE’10). IEEE, 1181--1184.Google ScholarCross Ref
- George Papastefanatos, Panos Vassiliadis, and Yannis Vassiliou. 2006. Adaptive query formulation to handle database evolution. In Proceedings of the 18th International Conference on Advanced Information Systems Engineering (CAiSE’06) (CEUR Workshop Prooceedings), N. Boudjilida, D. Cheng, and N. Guelfi (Eds.), Vol. 231.Google Scholar
- Despina Papoulis. 1994. Realizing SchemaLog. Technical Report. Department of Computer Science, Concordia University, Montreal, Canada.Google Scholar
- Dennis Pedersen and Torben Bach Pedersen. 2004a. Synchronizing XPath views. In International Database Engineering and Applications Symposium (IDEAS’04). IEEE, 149--160. Google ScholarDigital Library
- Dennis Pedersen and Torben Bach Pedersen. 2004b. Synchronizing XPath Views. Technical Report 7. DBTR.Google Scholar
- Torben Bach Pedersen and Christian S. Jensen. 2001. Multidimensional database technology. IEEE Computer 34, 12 (2001), 40--46. Google ScholarDigital Library
- Torben Bach Pedersen, Dennis Pedersen, and Jesper Pedersen. 2008. Integrating XML data in the TARGIT OLAP system. International Journal of Web Engineering and Technology (IJWET) 4, 4 (2008), 495--533. Google ScholarDigital Library
- Randel J. Peters and M. Tamer Özsu. 1997. An axiomatic model of dynamic schema evolution in objectbase systems. ACM Transactions on Database Systems (TODS) 22, 1 (1997), 75--114. Google ScholarDigital Library
- Giuseppe Polese and Mario Vacca. 2009a. A dialogue-based model for the query synchronization problem. In Proceedings of the IEEE 5th International Conference on Intelligent Computer Communication and Processing (ICCP’09).Google ScholarCross Ref
- Giuseppe Polese and Mario Vacca. 2009b. Notes on view synchronization using default logic. In Proceedings of 17th Italian Symposium on Advanced Database Systems (SEBD’09). 253--260.Google Scholar
- Alexandra Poulovassilis and Peter McBrien. 1998. A general formal framework for schema transformation. Data & Knowledge Engineering 28, 1 (1998), 47--71. Google ScholarDigital Library
- Erhard Rahm, Andreas Thor, David Aumueller, Hong-Hai Do, Nick Golovin, and Toralf Kirsten. 2005. iFuice-information fusion utilizing instance correspondences and peer mappings. In Proceedings of 8th WebDB. Citeseer, 7--12.Google Scholar
- Sudha Ram and G. Shankaranarayanan. 2003. Research issues in database schema evolution: The road not taken. Boston University School of Management, Department of Information Systems, Working Paper 2003-15 (2003).Google Scholar
- Raymond Reiter. 1980. A logic for default reasoning. Artificial Intelligence 13, 1 (1980), 81--132.Google ScholarDigital Library
- John F. Roddick, Noel G. Craske, and Thomas J. Richards. 1993. A taxonomy for schema versioning based on the relational and entity relationship models. In Entity-Relationship Approach (ER’93). Springer, 137--148. Google ScholarDigital Library
- Elke A. Rundensteiner, A. Koeller, A. Lee, Y. Li, A. Nica, and X Zhang. 1998. Evolvable view environment (EVE) project: Synchronizing views over dynamic distributed information sources. In Demo Session Proceedings of International Conference on Extending Database Technology (EDBT’98). Citeseer, 41--42.Google Scholar
- Elke A. Rundensteiner, Andreas Koeller, and Xin Zhang. 2000. Maintaining data warehouses over changing information sources. Communications of the ACM 43, 6 (2000), 57--62. Google ScholarDigital Library
- Elke A. Rundensteiner, Andreas Koeller, Xin Zhang, Amy J. Lee, Anisoara Nica, A. Van Wyk, and Y. Lee. 1999. Evolvable view environment (EVE): Non-equivalent view maintenance under schema changes. In Proceedings of the SIGMOD Conference, A. Delis, C. Faloutsos, and S. Ghandeharizadeh (Eds.), Vol. 28. ACM Press, 553--555. Google ScholarDigital Library
- Elke A. Rundensteiner, Amy J. Lee, and Anisoara Nica. 1997. On preserving views in evolving environments. In Knowledge Representation Meets DataBases (KRDB’97) (CEUR Workshop Proceedings), F. Baader, M. A. Jeusfeld, and W. Nutt (Eds.), Vol. 8. 13.11--13.11.Google Scholar
- Len Seligman, Peter Mork, Alon Halevy, Ken Smith, Michael J. Carey, Kuang Chen, Chris Wolf, Jayant Madhavan, Akshay Kannan, and Doug Burdick. 2010. OpenII: An open source information integration toolkit. In Proceedings of the 2010 ACM SIGMOD International Conference on Management of Data. ACM, 1057--1060. Google ScholarDigital Library
- Ben Shneiderman and Glenn Thomas. 1982a. An architecture for automatic relational database system conversion. ACM Transactions on Database Systems (TODS) 7, 2 (1982), 235--257. Google ScholarDigital Library
- Ben Shneiderman and Glenn Thomas. 1982b. Automatic database system conversion: Schema revision, data translation, and source-to-source program transformation. In Proceedings of the National Computer Conference. ACM, 579--587. Google ScholarDigital Library
- Balder Ten Cate and Phokion G. Kolaitis. 2009. Structural characterizations of schema-mapping languages. In Proceedings of the 12th International Conference on Database Theory (ICDT’09) (ACM International Conference Proceeding), R. Fagin (Ed.), Vol. 361. ACM, 63--72. Google ScholarDigital Library
- James F. Terwilliger, Anthony Cleve, and Carlo A. Curino. 2012. How clean is your sandbox? In Theory and Practice of Model Transformations. Springer, 1--23. Google ScholarDigital Library
- Andreas Thor, David Aumueller, and Erhard Rahm. 2007. Data integration support for mashups. In Workshops at the 22nd AAAI Conference on Artificial Intelligence.Google Scholar
- Yannis Velegrakis, Renée J. Miller, and Lucian Popa. 2003a. Adapting Mappings in Frequently Changing Environments. CSRG 468. University of Toronto, Department of Computer Science.Google Scholar
- Yannis Velegrakis, Renée J. Miller, and Lucian Popa. 2003b. Mapping adaptation under evolving schemas. In Proceedings of the 29th International Conference on Very Large Data Bases (VLDB’03), Vol. 29. VLDB Endowment, 584--595. Google ScholarDigital Library
- Yannis Velegrakis, Renée J. Miller, and Lucian Popa. 2004a. Preserving mapping consistency under schema changes. VLDB Journal 13, 3 (2004), 274--293. Google ScholarDigital Library
- Yannis Velegrakis, Renée J. Miller, Lucian Popa, and John Mylopoulos. 2004b. Tomas: A system for adapting mappings while schemas evolve. In Proceedings of the 20th International Conference on Data Engineering (ICDE’04). IEEE Computer Society, 862. Google ScholarDigital Library
- Joost Visser. 2008. Coupled transformation of schemas, documents, queries, and constraints. Electronic Notes in Theoretical Computer Science 200, 3 (2008), 3--23. Google ScholarDigital Library
- Michael Weiss and G. R. Gangadharan. 2010. Modeling the mashup ecosystem: Structure and growth. R&D Management 40, 1 (2010), 40--49.Google ScholarCross Ref
- Jin Yu, Boualem Benatallah, Fabio Casati, and Florian Daniel. 2008. Understanding mashup development. IEEE Internet Computing 12, 5 (2008), 44--52. Google ScholarDigital Library
- Roberto Zicari. 1991. A framework for schema updates in an object-oriented database system. In Proceedings of the 7th International Conference on Data Engineering (ICDE’91). IEEE Computer Society, 2--13. Google ScholarDigital Library
Index Terms
- Synchronization of Queries and Views Upon Schema Evolutions: A Survey
Recommendations
Dependency-Based Query/View Synchronization upon Schema Evolutions
Advances in Conceptual ModelingAbstractQuery/view synchronization upon the evolution of a database schema is a critical problem that has drawn the attention of many researchers in the database community. It entails rewriting queries and views to make them continue work on the new ...
XML materialized views and schema evolution in VIREX
Web-based databases are gaining increased popularity. This has positively influenced the availability of structured and semi-structured databases for access by a variety of users ranging from professionals to naive users. The number of users accessing ...
Reformulating XPath queries and XSLT queries on XSLT views
Applications using XML for data representation very often use different XML formats and thus require the transformation of XML data. The common approach transforms entire XML documents from one format into another, e.g. by using an XSLT stylesheet. ...
Comments