O'Neill, Liam (1994) Database rules and time: some proposed extensions to the SQL standard. Master of Science thesis, Dublin City University.
Abstract
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.
Metadata
Item Type: | Thesis (Master of Science) |
---|---|
Date of Award: | 1994 |
Refereed: | No |
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 10:20 by Celine Campbell . Last Modified 08 Oct 2013 10:10 |
Documents
Full text available as:
Preview |
PDF
- Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
2MB |
Downloads
Downloads
Downloads per month over past year
Archive Staff Only: edit this record