OCL2Trigger: Deriving active mechanisms for relational databases using Model-Driven Architecture

Journal of Systems and Software

Volumn 81, Issue 12, 2008, Pages 2299-2314

  Al Jumaily, Harith T ^a   Cuadra, Dolores ^a   Martínez, Paloma ^a  

^a UNIVERSIDAD CARLOS III DE MADRID   (Spain)

Author keywords

Active database systems; CASE tools; Integrity constraints; Model Driven Architecture; OCL; Sequence diagrams

Indexed keywords

MECHANISMS;

ACTIVE DATABASE SYSTEMS; CASE TOOLS; INTEGRITY CONSTRAINTS; MODEL-DRIVEN ARCHITECTURE; OCL; SEQUENCE DIAGRAMS;

DATABASE SYSTEMS;

EID: 53949093489     PISSN: 01641212     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.jss.2008.04.027     Document Type: Article

References (35)

1. Al-Jumaily, H.T., 2006. Active technology application to control constraints in database development. Ph.D. Thesis, Carlos III University of Madrid, Spain.
2. ArgoUML, 2007. .
3. Baralis E., and Widom J. An algebraic approach to static analysis of active database rules. ACM Transactions on Database Systems 25 3 (2000) 269-332
4. Baralis, E., Ceri, S., Widom, J., 1993. Better termination analysis for active databases. In: Proceedings of the First International Workshop on Rules in Database Systems, Edinburgh, Scotland, pp. 163-179.
5. Birgit, D., Heinrich, H., 1999. Using OCL constraints for relational database design - The unified modeling language. In: Proceedings of the Second International Conference, LNCS 1723. Springer, pp. 598-613.
6. Budgen D., and Thomson M. CASE tool evaluation: experiences from an empirical study. Journal of systems and software 67 2 (2003) 55-75
7. Cabot, J., Teniente, E., 2006. Constraint Support in MDA Tools: A Survey, Model Driven Architecture - Foundations and Applications, LNCS, pp. 256-267.
8. Ceri S., and Fraternalli P. Designing Database Applications With Objects and Rules: The IDEA Methodology (1997), Addison-Wesley
9. Ceri, S., Widom, J., 1990. Deriving production rules for constraint maintenance. In: Proceedings of VLDB Conference IBM Almaden Research Center.
10. Ceri S., Fraternali P., Paraboschi S., and Tanca L. Automatic generation of production rules for integrity maintenance. ACM Transaction on Database Systems 19 3 (1994)
11. Chen P. The entity-relationship model - toward a unified view of data. ACM Transactions on Database Systems 1 1 (1976)
12. Cuadra D., Nieto C., Castro E., Martinez P., and Velasco M. Preserving relationship cardinality constraints in relational schemata. Database Integrity: Challenges and Solutions (2003), Ed: Idea Group Publishing
13. Decker, H., Martinenghi, D., Christiansen, H., 2006. Integrity checking and maintenance in relational and deductive databases and beyond. In: Intelligent Databases: Technologies and Applications, Idea Group, pp. 238-285.
14. Domínguez, E., Lloret, J., Zapata, M.A., 2002. Integrity constraint enforcement by means of trigger templates. In: Second International Conference, Advances in Information Systems, ADVIIS, 2002.
15. Elmasri R., and Navathe S. Fundamentals of Database Systems. Third ed. (2000), Addison-Wesley
16. EmPowerTec, 2006. .
17. Gogolla, M., Richters, M., 1998. Transformation rules for UML class diagrams. The Unified Modeling Language, UML'98 - Beyond the Notation. In: First International Workshop, Mulhouse, France.
18. Hickey, T., 2000. Constraint-based termination analysis for cyclic active database rules. In: Proceedings of the Sixth International Conference on Rules and Objects in Databases, LNAI, vol. 1861. Springer, pp. 1121-1136.
19. IBM Rational, 2007. XDE Developer. .
20. ISO/IEC 9075 Standard, 2003. Information Technology - Database Languages - SQL:2003 International Organization for Standardization.
21. Kulkarni K., Mattos N., and Cochrane R. Active Database Features in SQL3, Active Rules in Database Systems (1998), Springer-Verlag, New York pp. 197-218
22. MetaEdit+, 2007. .
23. Objecteering/UML, 2007. Objecteering/SQL Designer User Guide Version 5.2.2. .
24. OCL22SQL, 2007. Dresden OCL Toolkit. .
25. Olivé, A., 2003. Integrity constraints definition in object-oriented conceptual modeling languages. In: Conceptual Modeling - ER 2003, 22nd International Conference on Conceptual Modeling, Chicago, IL, USA.
26. OMG, 2007. Object Management Group, Inc. .
27. ® Database SQL Developer User's Guide .
28. Paton N., and Díaz O. Active Database Systems. ACM Computing Surveys 31 1 (1999)
29. Rational Enterprise Edition, 2003. .
30. Rational Software, 2000. Mapping Object to Data Models with the UML Mapping Objects to Relational Databases. .
31. Teorey T.J. Database Modeling and Design. third ed. (1999), Morgan Kaufmann Series in data management systems
32. Türker, C., Gertz, M., 2000. Semantic Integrity Support in SQL-99 and Commercial (Object) Relational Database Management Systems. UC Davis Computer Science Technical Report CSE-2000-11, University of California.
33. Verheecke, B., Straeten, R., 2003. Specifying and implementing the operational use of constraints in object-oriented applications. In: Proceedings of TOOLS PACIFIC 2002, vol. 10, p. 23.
34. Visual Case Tool, 2007. .
35. Wahler, M., Koehler, J., Brucker, A., 2006. Model-Driven Constraint Engineering, Workshop on OCL for (Meta-)Models in Multiple Application Domains (OCLApps), Models 2006.