Hudnott, Elizabeth, Sinclair, Jane and Darwen, Hugh (2010) Efficient multiple simultaneous assignment of database tables. In: 9th International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases (AIKED 2010), Cambridge, UK, 20-22 Feb 2010. Published in: Proceeding AIKED'10 Proceedings of the 9th WSEAS international conference on Artificial intelligence, knowledge engineering and data bases pp. 286-291. ISBN 9789604741540.
![[thumbnail of AIKED-45.pdf]](https://wrap.warwick.ac.uk/style/images/fileicons/text.png) |
Text
AIKED-45.pdf - Published Version Embargoed item. Restricted access to Repository staff only Download (279kB) |
Abstract
We investigate the problems involved in efficient implementation of the multiple assignment construct in Date and Darwen's Third Manifesto [5] and we explain the connection between assignment and insert, delete and update. Updating multiple tables using SQL places responsibility on the user to order the update statements correctly. Integrity constraints must either be preserved in the unnecessary intermediate states or else deferred. Multiple assignment accepts updates across the entire database simultaneously and makes the system responsible for scheduling them correctly. We outline implementation techniques that potentially permit multiple assignment to outperform SQL deferred constraint checking by employing parallelism and multi-query optimization.
| Item Type: | Conference Item (Paper) |
|---|---|
| Divisions: | Faculty of Science, Engineering and Medicine > Science > Computer Science |
| Journal or Publication Title: | Proceeding AIKED'10 Proceedings of the 9th WSEAS international conference on Artificial intelligence, knowledge engineering and data bases |
| Publisher: | World Scientific and Engineering Academy and Society (WSEAS) |
| ISBN: | 9789604741540 |
| Official Date: | 2010 |
| Page Range: | pp. 286-291 |
| Status: | Peer Reviewed |
| Publication Status: | Published |
| Access rights to Published version: | Restricted or Subscription Access |
| Conference Paper Type: | Paper |
| Title of Event: | 9th International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases (AIKED 2010) |
| Type of Event: | Conference |
| Location of Event: | Cambridge, UK |
| Date(s) of Event: | 20-22 Feb 2010 |
| Related URLs: | |
| URI: | https://wrap.warwick.ac.uk/59651/ |
Request changes or add full text files to a record
Repository staff actions (login required)
 |
View Item |