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

dc.affiliation.dptoUC3M. Departamento de Informáticaes
dc.affiliation.grupoinvUC3M. Grupo de Investigación: Human Language and Accessibility Technologies (HULAT)es
dc.contributor.authorAljumaily, Harith
dc.contributor.authorCuadra Fernández, María Dolores
dc.contributor.authorMartínez Fernández, Paloma
dc.date.accessioned2010-05-07T13:01:20Z
dc.date.available2010-05-07T13:01:20Z
dc.date.issued2008-12
dc.description16 pages, 10 figures.-- Issue title: "Best papers from the 2007 Australian Software Engineering Conference (ASWEC 2007), Melbourne, Australia, April 10-13, 2007, Australian Software Engineering Conference 2007".
dc.description.abstractTransforming integrity constraints into active rules or triggers for verifying database consistency produces a serious and complex problem related to real time behaviour that must be considered for any implementation. Our main contribution to this work is to provide a complete approach for deriving the active mechanisms for Relational Databases from the specification of the integrity constraints by using OCL. This approach is designed in accordance with the MDA approach which consists of transforming the specified OCL clauses into a class diagram into SQL:2003 standard triggers, then transforming the standard triggers into target DBMS triggers. We believe that developing triggers and plugging them into a given model is insufficient because the behaviour of such triggers is invisible to the developers, and therefore not controllable. For this reason, a DBMS trigger verification model is used in our approach, in order to ensure the termination of trigger execution. Our approach is implemented as an add-in tool in Rational Rose called OCL2Trigger.
dc.description.sponsorshipThis work is part of the "Software Process Management Platform: Modelling, reuse and measurement" TIN2004/07083 project.
dc.description.statusPublicado
dc.format.mimetypeapplication/pdf
dc.identifier.bibliographicCitationJournal of Systems and Software, 2008, vol. 81, n. 12, p. 2299-2314
dc.identifier.doi10.1016/j.jss.2008.04.027
dc.identifier.issn0164-1212
dc.identifier.publicationfirstpage2299
dc.identifier.publicationissue12
dc.identifier.publicationlastpage2314
dc.identifier.publicationtitleJournal of Systems and Software
dc.identifier.publicationvolume81
dc.identifier.urihttp://hdl.handle.net/10016/8221
dc.language.isoeng
dc.publisherElsevier
dc.relation.publisherversionhttp://dx.doi.org/10.1016/j.jss.2008.04.027
dc.rights© Elsevier
dc.rights.accessRightsopen access
dc.subject.ecienciaMatemáticas
dc.subject.otherIntegrity constraints
dc.subject.otherModel-Driven Architecture
dc.subject.otherCASE tools
dc.subject.otherActive database systems
dc.subject.otherOCL
dc.subject.otherSequence diagrams
dc.titleOCL2Trigger: Deriving active mechanisms for relational databases using Model-Driven Architecture
dc.typeresearch article*
dc.type.reviewPeerReviewed
dspace.entity.typePublication
Files
Original bundle
Now showing 1 - 1 of 1
Loading...
Thumbnail Image
Name:
al_jumaily_Ocl2Trigger_jss_2008_ps.pdf
Size:
1.57 MB
Format:
Adobe Portable Document Format