Show simple item record

dc.contributor.authorAtaullah, Ahmed
dc.date.accessioned2014-05-12 17:53:22 (GMT)
dc.date.available2014-05-12 17:53:22 (GMT)
dc.date.issued2014-05-12
dc.date.submitted2014
dc.identifier.urihttp://hdl.handle.net/10012/8435
dc.description.abstractDatabase systems maintain integrity of the stored information by ensuring that modifications to the database comply with constraints designed by the administrators. As the number of users and applications sharing a common database increases, so does the complexity of the set of constraints that originate from higher level business processes. The lack of a systematic mechanism for integrating and reasoning about a diverse set of evolving and potentially interfering policies manifested as database level constraints makes corporate policy management within relational systems a chaotic process. In this thesis we present a systematic method of mapping a broad set of process centric business policies onto database level constraints. We exploit the observation that the state of a database represents the union of all the states of every ongoing business process and thus establish a bijective relationship between progression in individual business processes and changes in the database state space. We propose graphical notations that are equivalent to integrity constraints specified in linear temporal logic of the past. Furthermore we demonstrate how this notation can accommodate a wide array of workflow patterns, can allow for multiple policy makers to implement their own process centric constraints independently using their own logical policy models, and can model check these constraints within the database system to detect potential conflicting constraints across several different business processes. A major contribution of this thesis is that it bridges several different areas of research including database systems, temporal logics, model checking, and business workflow/policy management to propose an accessible method of integrating, enforcing, and reasoning about the consequences of process-centric constraints embedded in database systems. As a result, the task of ensuring that a database continuously complies with evolving business rules governed by hundreds of processes, which is traditionally handled by an army of database programmers regularly updating triggers and batch procedures, is made easier, more manageable, and more predictable.en
dc.language.isoenen
dc.publisherUniversity of Waterlooen
dc.subjectrecords managementen
dc.subjectretentionen
dc.subjectworkflowsen
dc.subjectrelational databasesen
dc.subjectbusiness processesen
dc.subjecttemporal databasesen
dc.titleBusiness Policy Modeling and Enforcement in Relational Database Systemsen
dc.typeDoctoral Thesisen
dc.comment.hiddenSupervisor has submitted the thesis acceptance form and I have made the requested changes that were suggested in the first review.en
dc.pendingfalse
dc.subject.programComputer Scienceen
uws-etd.degree.departmentSchool of Computer Scienceen
uws-etd.degreeDoctor of Philosophyen
uws.typeOfResourceTexten
uws.peerReviewStatusUnrevieweden
uws.scholarLevelGraduateen


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record


UWSpace

University of Waterloo Library
200 University Avenue West
Waterloo, Ontario, Canada N2L 3G1
519 888 4883

All items in UWSpace are protected by copyright, with all rights reserved.

DSpace software

Service outages