A runtime approach to model-independent schema and data translation

ABSTRACT

A runtime approach to model-generic translation of schema and data is proposed.

It is based on our previous work on MIDST, a platform conceived to perform translations in an off-line fashion. In the original approach, the source database is imported into a dictionary, where it is stored according to a universal model. Then, the translation is applied within the tool as a composition of elementary transformation steps, specified as Datalog programs. Finally, the result is exported into the operational system.

Here we illustrate a new, lightweight approach where the database is not imported. The tool needs only to know the model and the schema of the source database and generates views on the operational system that transform the underlying data (stored in the source schema) according to the corresponding schema in the target model. Views are generated in an almost automatic way, on the basis of the Datalog rules for schema translation.

REFERENCES

• 1: Paolo Atzeni , Luigi Bellomarini , Francesca Bugiotti , Giorgio Gianforme, From Schema and Model Translation to a Model Management System, Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge, July 07-10, 2008, Cardiff, Wales, UK [doi>10.1007/978-3-540-70504-8_24]
• 2: P. Atzeni, L. Bellomarini, F. Bugiotti, and G. Gianforme. A platform for model-independent solutions to model management problems (extended abstract). In SEBD, pages 310--317, 2008.
• 3: P. Atzeni, P. Cappellari, and P. A. Bernstein. Model-independent schema and data translation. In EDBT Conference, LNCS 3896, pages 368--385. Springer, 2006.
• 4: Paolo Atzeni , Paolo Cappellari , Giorgio Gianforme, MIDST: model independent schema and data translation, Proceedings of the 2007 ACM SIGMOD international conference on Management of data, June 11-14, 2007, Beijing, China [doi>10.1145/1247480.1247632]
• 5: Paolo Atzeni , Paolo Cappellari , Riccardo Torlone , Philip A. Bernstein , Giorgio Gianforme, Model-independent schema translation, The VLDB Journal — The International Journal on Very Large Data Bases, v.17 n.6, p.1347-1370, November 2008 [doi>10.1007/s00778-008-0105-2]
• 6: P. Atzeni, G. Gianforme, and P. Cappellari. Reasoning on data models in schema translation. In FOIKS Symposium, LNCS 4932, pages 158--177. Springer, 2008.
• 7: Paolo Atzeni , Riccardo Torlone, Management of Multiple Models in an Extensible Database Design Tool, Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology, p.79-95, March 25-29, 1996
• 8: Philip A. Bernstein , Sergey Melnik, Model management 2.0: manipulating richer mappings, Proceedings of the 2007 ACM SIGMOD international conference on Management of data, June 11-14, 2007, Beijing, China [doi>10.1145/1247480.1247482]
• 9: P. A. Bernstein, S. Melnik, and J. F. Terwilliger. Language-integrated querying of xml data in sql server. In VLDB, pages 1396--1399, 2008.
• 10: Ronald Fagin , Phokion G. Kolaitis , Renée J. Miller , Lucian Popa, Data Exchange: Semantics and Query Answering, Proceedings of the 9th International Conference on Database Theory, p.207-224, January 08-10, 2003
• 11: Ronald Fagin , Phokion G. Kolaitis , Lucian Popa, Data exchange: getting to the core, ACM Transactions on Database Systems (TODS), v.30 n.1, p.174-210, March 2005 [doi>10.1145/1061318.1061323]
• 12: Laura M. Haas , Mauricio A. Hernández , Howard Ho , Lucian Popa , Mary Roth, Clio grows up: from research prototype to industrial tool, Proceedings of the 2005 ACM SIGMOD international conference on Management of data, June 14-16, 2005, Baltimore, Maryland [doi>10.1145/1066157.1066252]
• 13: J.-L. Hainaut. The transformational approach to database engineering. In GTTSE, LNCS 4143, pages 95--143. Springer, 2006.
• 14: Hibernate. http://www.hibernate.org/.
• 15: Peter McBrien , Alexandra Poulovassilis, A Uniform Approach to Inter-model Transformations, Proceedings of the 11th International Conference on Advanced Information Systems Engineering, p.333-348, June 14-18, 1999
• 16: Renée J. Miller , Laura M. Haas , Mauricio A. Hernández, Schema Mapping as Query Discovery, Proceedings of the 26th International Conference on Very Large Data Bases, p.77-88, September 10-14, 2000
• 17: P. Mork, P. A. Bernstein, and S. Melnik. Teaching a schema translator to produce O/R views. In ER Conference, LNCS 4801, pages 102--119. Springer, 2007.
• 18: P. Papotti and R. Torlone. Heterogeneous data translation through XML conversion. J. Web Eng., 4(3):189--204, 2005.
• 19: Yannis Velegrakis , Renée J. Miller , Lucian Popa, Mapping adaptation under evolving schemas, Proceedings of the 29th international conference on Very large data bases, p.584-595, September 09-12, 2003, Berlin, Germany