A Transparent Approach for Database Schema Evolution Using View Mechanism

详细信息    查看全文

• 作者：Jianxin Xue (21)
  Derong Shen (21)
  Tiezheng Nie (21)
  Yue Kou (21)
  Ge Yu (21)
  
• 关键词：schema evolution ; schema mapping ; backward compatibility ; schema composition
• 刊名：Lecture Notes in Computer Science
• 出版年：2012
• 出版时间：2012
• 年：2012
• 卷：7418
• 期：1
• 全文大小：309KB
• 参考文献：1. Roddick, J.F.: A Survey of Schema Versioning Issues for Database Systems. J. Information and Software Technology聽37(7), 383鈥?93 (1995) CrossRef
  2. Roddick, J.F.: Schema Evolution in Database System鈥揂n Annotated Bibliography. SIGMOD RECORD聽21(4) (1992)
  3. Banerjee, J., Kim, W.: Semantics and Implementation of Schema Evolution in Object-Oriented Databases. SIGMOD RECORD聽21, 311鈥?22 (1987) CrossRef
  4. McKenzie, L.E., Snodgrass, R.T.: Schema Evolution and the Relational Algebra. J. Information System聽15, 195鈥?97 (1990)
  5. Liu, C.T., Chrysanthis, P.K., Chang, S.K.: Database schema evolution through the specification and maintenance of the changes on entities and relationships. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol.聽881, pp. 13鈥?6. Springer, Heidelberg (1994)
  6. Ferrandina, F., Meyer, T., Zicari, R., Ferran, G.: Schema and database Evolution in the O2 Object Dabase System. In: VLDB 1995, pp. 170鈥?81. ACM, New York (1995)
  7. Kim, W., Chou, H.-T.: Versions of Schema for Object Oriented Databases. In: VLDB 1988, pp. 148鈥?59. Morgan Kaufmann, San Francisco (1988)
  8. Munch, B.P.: Versioning in a software Engineering Database鈥搕he Changes Oriented Way. Division of Computer Systems and Telematics. Norwegian Institute of Technology (1995)
  9. Andany, J., Leonard, M., Palisser, C.: Management of schema evolution in databases. In: VLDB 1991, pp. 161鈥?70. Morgan Kaufmann, San Francisco (1991)
  10. Bellahs猫ne, Z.: View mechanism for schema evolution. In: Morrison, R., Kennedy, J. (eds.) BNCOD 1996. LNCS, vol.聽1094, pp. 18鈥?5. Springer, Heidelberg (1996) CrossRef
  11. Bellahsene, Z.: Schema evolution in data warehouses. J. Knowledge and Information System, 283鈥?04 (2002)
  12. Nica, A., Lee, A.J., Rundensteiner, E.A.: The CVS Algorithm for View Synchronization in Evolvable Large-Scale Information Systems. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol.聽1377, pp. 359鈥?73. Springer, Heidelberg (1998)
  13. Rundensteiner, E.A., Lee, A.J., Nica, N.: On preserving views in evolving environments. In: KRDB 1997, pp. 13.1鈥?3.11 (1997)
  14. Karahasanovic, A., Sj酶berg, D.I.K.: Visualizing Impacts of Database schema changes-A Controlled Experiment. In: HCC 2001, p. 358. IEEE, Washington, DC (2001)
  15. Favre, C., Bentayeb, F., Boussaid, O.: Evolution of Data Warehouses鈥?Optimization: A Workload Perspective. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2007. LNCS, vol.聽4654, pp. 13鈥?2. Springer, Heidelberg (2007) CrossRef
  16. Papastefanatos,G. Vassiliadis, P., Vassiliou, Y.: Adaptive Query Formulation to Handle Database Evolution (Extended Version), In: CAiSE 2006, pp.5-9, Springer, Heidelberg (2006)
  17. Curino, C.A., Moon, H.J., Zaniolo, C.: Graceful database schema evolution: the prism work-bench. In: Proc. VLDB Conf., pp. 761鈥?72. ACM, USA (2008)
  
• 作者单位：Jianxin Xue (21)
  Derong Shen (21)
  Tiezheng Nie (21)
  Yue Kou (21)
  Ge Yu (21)
  
  21. College of Information Science and Engineering, Northeastern Unicersity, China
  

文摘

Designing databases that evolve over time is still a major problem today. The database schema is assumed to be stable enough to remain valid even as the modeled environment changes. However, the database administrators are faced with the necessity of changing something in the overall configuration of the database schema. Even though some approaches proposed are provided in current database systems, schema evolution remains an error-prone and time-consuming undertaking. We propose an on-demand transparent solution to overcome the schema evolution, which usually impacts existing applications/queries that have been written against the schema. In order to improve the performance of our approach, we optimize our approach with mapping composition. To this end, we show that our approach has a better potential than traditional schema evolution technique. Our approach, as suggested by experimental evaluation, is much more efficient than the other schema evolution techniques.