Abstract
We discuss a proposal for the implementation of the model management operator ModelGen, which translates schemas from one model to another, for example from object-oriented to SQL or from SQL to XML schema descriptions. The operator can be used to generate database wrappers (e.g., object-oriented or XML to relational), default user interfaces (e.g., relational to forms), or default database schemas from other representations. The approach translates schemas from a model to another, within a predefined, but large and extensible, set of models: given a source schema S expressed in a source model, and a target model TM, it generates a schema S′ expressed in TM that is “equivalent” to S. A wide family of models is handled by using a metamodel in which models can be succinctly and precisely described. The approach expresses the translation as Datalog rules and exposes the source and target of the translation in a generic relational dictionary. This makes the translation transparent, easy to customize and model-independent. The proposal includes automatic generation of translations as composition of basic steps.
Article PDF
Similar content being viewed by others
Avoid common mistakes on your manuscript.
References
Atzeni, P., Cappellari, P., Bernstein, P.A.: Model-independent schema and data translation. In: EDBT Conference, LNCS, vol. 3896, pp. 368–385. Springer, Berlin (2006)
Atzeni, P., Cappellari, P., Gianforme, G.: MIDST: model independent schema and data translation. In: SIGMOD Conference, pp. 1134–1136. ACM, New York (2007)
Atzeni, P., Del Nostro, P.: Management of heterogeneity in the Semantic Web. In: ICDE Workshops, p. 60. IEEE Computer Society (2006)
Atzeni, P., Gianforme, G., Cappellari, P.: Reasoning on data models in schema translation. In: FOIKS Symposium, LNCS, vol. 4932, pp. 158–177. Springer, Berlin (2008)
Atzeni P., Torlone R.: A metamodel approach for the management of multiple models and translation of schemes. Inf. Syst. 18(6), 349–362 (1993)
Atzeni, P., Torlone, R.: Management of multiple models in an extensible database design tool. In: EDBT Conference, LNCS, vol. 1057, pp. 79–95. Springer, Berlin (1996)
Barbosa, D., Freire, J., Mendelzon, A.O.: Information preservation in XML-to-relational mappings. In: XSym Workshop, LNCS, vol. 3186, pp. 66–81. Springer (2004)
Barbosa, D., Freire, J., Mendelzon, A.O.: Designing information-preserving mapping schemes for XML. In: VLDB, pp. 109–120 (2005)
Batini C., Ceri S., Navathe S.: Database Design with the Entity-Relationship Model. Benjamin and Cummings Publ. Co., Menlo Park, CA (1992)
Batini C., Lenzerini M.: A methodology for data schema integration in the entity relationship model. IEEE Trans. Software Eng. 10(6), 650–664 (1984)
Bernstein, P.A.: Applying model management to classical meta data problems. In: CIDR Conference, pp. 209–220 (2003)
Bernstein P.A., Halevy A.Y., Pottinger R.: A vision of management of complex models. SIGMOD Record 29(4), 55–63 (2000)
Bernstein, P.A., Melnik, S., Mork, P.: Interactive schema translation with instance-level mappings. In: VLDB, pp. 1283–1286 (2005)
Bézivin, J., Breton, E., Dupé, G., Valduriez, P.: The ATL transformation-based model management framework. Research Report 03.08, IRIN, Université de Nantes (2003)
Bohannon, P., Fan, W., Flaster, M., Narayan, P.P.S.: Information preserving XML schema embedding. In: VLDB, pp. 85–96 (2005)
Bowers, S., Delcambre, L.M.L.: The Uni-level description: a uniform framework for representing information in multiple data models. In: ER Conference, LNCS, vol. 2813, pp. 45–58. Springer, Berlin (2003)
Boyd, M., McBrien, P.: Comparing and transforming between data models via an intermediate hypergraph data model. J. Data Semantics IV pp. 69–109 (2005)
Claypool, K.T., Rundensteiner, E.A.: Sangam: A transformation modeling framework. In: DASFAA Conference, pp. 47–54 (2003)
Claypool, K.T., Rundensteiner, E.A., Zhang, X., Su, H., Kuno, H.A., Lee, W.C., Mitchell, G.: Sangam—a solution to support multiple data models, their mappings and maintenance. In: SIGMOD Conference, p. 606 (2001)
Cluet, S., Delobel, C., Siméon, J., Smaga, K.: Your mediators need data conversion! In: SIGMOD Conference, pp. 177–188 (1998)
De Virgilio, R., Torlone, R.: Modeling heterogeneous context information in adaptive Web based applications. In: ICWE Conference, pp. 56–63. ACM, New York (2006)
Hainaut J.L.: Specification preservation in schema transformations—application to semantics and statistics. Data Knowl. Eng. 19(2), 99–134 (1996)
Hainaut, J.L.: The transformational approach to database engineering. In: GTTSE, LNCS. vol. 4143, pp. 95–143. Springer, Berlin (2006)
Hull R.: Relative information capacity of simple relational schemata. SIAM J. Comput. 15(3), 856–886 (1986)
Hull, R.: Managing semantic heterogeneity in databases: a theoretical perspective. In: PODS Symposium, pp. 51–61. ACM, New York (1997)
Hull R., King R.: Semantic database modelling: survey, applications and research issues. ACM Comput. Surv. 19(3), 201–260 (1987)
McBrien, P., Poulovassilis, A.: A uniform approach to inter-model transformations. In: CAiSE Conference, LNCS, vol. 1626, pp. 333–348 (1999)
Miller, R.J., Ioannidis, Y.E., Ramakrishnan, R.: The use of information capacity in schema integration and translation. In: VLDB, pp. 120–133 (1993)
Miller R.J., Ioannidis Y.E., Ramakrishnan R.: Schema equivalence in heterogeneous systems: bridging theory and practice. Inf. Syst. 19(1), 3–31 (1994)
Milo, T., Zohar, S.: Using schema matching to simplify heterogeneous data translation. In: VLDB, pp. 122–133 (1998)
Mork, P., Bernstein, P.A., Melnik, S.: Teaching a schema translator to produce O/R views. In: ER Conference, LNCS, vol. 4801, pp. 102–119. Springer, Berlin (2007)
Paolozzi, S., Atzeni, P.: Interoperability for semantic annotations. In: DEXA Workshops, pp. 445–449. IEEE Computer Society (2007)
Papotti P., Torlone R.: Heterogeneous data translation through XML conversion. J. Web Eng. 4(3), 189–204 (2005)
Popa, L., Velegrakis, Y., Miller, R.J., Hernández, M.A., Fagin, R.: Translating Web data. In: VLDB, pp. 598–609 (2002)
Poulovassilis A., McBrien P.: A general formal framework for schema transformation. Data Knowl. Eng. 28(1), 47–71 (1998)
Shu N.C., Housel B.C., Taylor R.W., Ghosh S.P., Lum V.Y.: Express: a data extraction, processing, amd restructuring system. ACM Trans. Database Syst. 2(2), 134–174 (1977)
Song, G., Zhang, K., Wong, R.: Model management though graph transformations. In: IEEE Symposium on Visual Languages and Human Centric Computing, pp. 75–82 (2004)
Ullman J.D., Widom J.: A First Course in Database Systems. Prentice-Hall, Englewood Cliffs, NJ (1997)
Author information
Authors and Affiliations
Corresponding author
Additional information
P. Atzeni and R. Torlone partially supported by MIUR, Università Roma Tre and an IBM Faculty Award, and G. Gianforme by a Microsoft Research Fellowship.
Rights and permissions
About this article
Cite this article
Atzeni, P., Cappellari, P., Torlone, R. et al. Model-independent schema translation. The VLDB Journal 17, 1347–1370 (2008). https://doi.org/10.1007/s00778-008-0105-2
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s00778-008-0105-2