Abstract
This paper completes our proposal for automatic development of Object-Relational (OR) DataBase (DB) schemas. By means of a case study, this work focuses on presenting the tooling developed to support the whole process. As usual, the proposal starts from a conceptual data model (Platform Independent Model) depicted in a UML class diagram. Then, the conceptual data model is mapped into an OR DB model (Platform Specific Model) that represents the OR DB schema. To that end, we have implemented a set of formalized mapping rules using the ATL language. Finally, the SQL code that implements the modeled schema in Oracle 10g is automatically generated from the OR model by means of a MOFScript model to text transformation. Moreover, since the OR model could be refined along the design process, we have developed a graphical editor for OR DB models.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Atzeni, P., Cappellari, P., Gianforme, G.: MIDST: model independent schema and data translation. In: Proceedings of the 2007 ACM SIGMOD international Conference on Management of Data. SIGMOD 2007, Beijing, China, June 11-14, pp. 1134–1136. ACM, New York (2007)
Baresi, L., Heckel, R.: Tutorial Introduction to Graph Transformation: A Software Engineering Perspective. In: Corradini, A., Ehrig, H., Kreowski, H.-J., Rozenberg, G. (eds.) ICGT 2002. LNCS, vol. 2505, pp. 402–429. Springer, Heidelberg (2002)
Bernstein, P.A.: Applying Model Management to Classical Meta Data Problems. In: First Biennial Conference on Innovative Data Systems Research, Asilomar, CA, USA (2003)
Bertino, E., Marcos, E.: Object Oriented Database Systems. In: Díaz, O., Piattini, M. (eds.) Advanced Databases: Technology and Design. Artech House, Norwood (2000)
Bézivin, J.: Some Lessons Learnt in the Building of a Model Engineering Platform. In: 4th Workshop in Software Model Engineering (WISME), Montego Bay, Jamaica (2005)
Bézivin, J., et al.: Model Transformations in Practice Workshop. In: Bruel, J.-M. (ed.) MoDELS 2005. LNCS, vol. 3844, pp. 120–127. Springer, Heidelberg (2006)
Cáceres, P., De Castro, V., Vara, J.M., Marcos, E.: Model Transformations for Hypertext Modeling on Web Information Systems. In: SAC 2006. Proc. of the 2006 ACM Symposium on Applied Computing, pp. 1232–1239. ACM Press, New York (2006)
Chen, P.P.: The Entity-Relationship Model – Toward a Unified View of Data. ACM Transactions on Database Systems 1(1), 9–36 (1976)
Fernández-Medina, E., Trujillo, J., Villarroel, R., Piattini, M.: Developing secure data warehouses with a UML extension. Information Systems 32, 826–856 (2007)
ISO / IEC 9075-14:2008 Standard, Information Technology – Database Languages – SQL 2008, International Organization for Standardization (2008)
Jouault, F., Kurtev, I.: Transforming Models with ATL. In: Bruel, J.-M. (ed.) MoDELS 2005. LNCS, vol. 3844, pp. 128–138. Springer, Heidelberg (2006)
Marcos, E., Vela, B., Cavero, J.M.: Extending UML for Object-Relational Database Design. In: Gogolla, M., Kobryn, C. (eds.) UML 2001. LNCS, vol. 2185, pp. 225–239. Springer, Heidelberg (2001)
Marcos, E., Vela, B., Cáceres, P., Cavero, J.M.: MIDAS/DB: a Methodological Framework for Web Database Design. In: Arisawa, H., Kambayashi, Y., Kumar, V., Mayr, H.C., Hunt, I. (eds.) ER Workshops 2001. LNCS, vol. 2465, pp. 227–238. Springer, Heidelberg (2002)
Marjan, M., Jan, H., Anthony, M.S.: When and how to develop domain-specific languages. ACM Comput. Surv. 37, 316–344 (2005)
Mazon, J.-N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: Proceedings of the 8th ACM international workshop on Datawarehousing and OLAP. ACM, Bremen (2005)
Muller, R.: Database Design for Smarties. Morgan Kaufmann, San Francisco (1999)
Naiburg, E.J., Maksimchuk, R.A.: UML for Database Design. Addison-Wesley, Reading (2001)
Oldevik, J., Neple, T., Grønmo, R., Aagedal, J., Berre, A.-J.: Toward Standardised Model to Text Transformations. In: Model-driven Architecture – Foundations and Applications, pp. 239–253 (2005)
Miller, J., Mukerji, J. (eds.): OMG. MDA Guide Version 1.0. Document number omg/2003-05-01 (retrieved 2003), http://www.omg.com/mda
Oracle Corporation. Oracle Database 10g. Release 2 (10.2), www.oracle.com
Selic, B.: The pragmatics of Model-Driven development. IEEE Software 20(5), 19–25 (2003)
Stonebraker, M., Brown, P.: Object-Relational DBMSs. In: Tracking the Next Great Wave. Morgan Kauffman, San Francisco (1999)
Tonkunaite, J., Nemuraite, L., Paradauskas, B.: Model driven development of data warehouses. In: 7th International Baltic Conference on Databases and Information Systems, July 3-6, pp. 106–113 (2006)
Vara, J.M., De Castro, V., Marcos, E.: WSDL automatic generation from UML models in a MDA framework. International Journal of Web Services Practices 1(1,2), 1–12 (2005)
Voelter, M. MD* Best Practices (12/2008), http://voelter.de (retrieved January 10, 2009)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vara, J.M., Vela, B., Bollati, V.A., Marcos, E. (2009). Supporting Model–Driven Development of Object–Relational Database Schemas: A Case Study. In: Paige, R.F. (eds) Theory and Practice of Model Transformations. ICMT 2009. Lecture Notes in Computer Science, vol 5563. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02408-5_13
Download citation
DOI: https://doi.org/10.1007/978-3-642-02408-5_13
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-02407-8
Online ISBN: 978-3-642-02408-5
eBook Packages: Computer ScienceComputer Science (R0)