Browse DORAS
Browse Theses
Latest Additions
Creative Commons License
Except where otherwise noted, content on this site is licensed for use under a:

Database rules and time: some proposed extensions to the SQL standard

O'Neill, Liam (1994) Database rules and time: some proposed extensions to the SQL standard. Master of Science thesis, Dublin City University.

Full text available as:

[img]PDF - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader


The subject of this thesis is the incorporation of temporal semantics into database rules and how the resultant syntax might be reconciled with the evolving SQL standard. In particular, it explores time-driven rules and the time-relationship between triggering events and associated actions. A review of the key research results in the area of database rules and the syntax developed for the major prototype implementations is conducted, and a working syntax , free of any limitations within the SQL standard, developed. Next, an operational definition is evolved through the application of this working syntax to two sample domains rich in 'temporal rules'. In each case a graphical representation of the domain is presented using an adapted object-oriented modelling technique followed by a mapping into the working temporal syntax. Attention is then turned to the SQL-92 standard and its future successor SQL3. An assessment is made of their implications for the working syntax developed in the earlier chapters - with particular reference to the specification of time and the use of database triggers. When an attempt was made to re-cast the working syntax into SQL, a satisfactory mapping, which succeeded in preserving the semantics of the original, could not be achieved. Support for time-based triggers; cyclic operations; delayed actions and rule lifetimes necessitated the development of appropriate modifications to the basic SQL3 draft syntax. The proposed extensions capture all of the semantics required for the specification of time-based rules. The example applications indicated that an extended SQLcompliant language approach allied to a sound objectoriented modelling formalism had a broad applicability. Furthermore, it was apparent that the addition of a temporal dimension to rule actions was a key enabling factor in increasing their semantic power.

Item Type:Thesis (Master of Science)
Date of Award:1994
Supervisor(s):Smeaton, Alan F.
Uncontrolled Keywords:Databases systems; SQL; Temporal semantics
Subjects:Computer Science > Computer software
Computer Science > Information storage and retrieval systems
DCU Faculties and Centres:DCU Faculties and Schools > Faculty of Engineering and Computing > School of Computing
Use License:This item is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 3.0 License. View License
ID Code:19248
Deposited On:16 Sep 2013 11:20 by Celine Campbell. Last Modified 08 Oct 2013 11:10

Download statistics

Archive Staff Only: edit this record