The Library
Efficient multiple assignment to database tables
Tools
Tools
Tools
Hudnott, Elizabeth, Sinclair, Jane and Darwen, Hugh (2010) Efficient multiple assignment to database tables. In: 9th WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases, Univ Cambridge, Cambridge, England, February 20-22, 2010. Published in: Proceedings of the 9th WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases pp. 286-291.
Full text not available from this repository.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) |
|---|---|
| Subjects: | Q Science > QA Mathematics > QA76 Electronic computers. Computer science. Computer software T Technology > TK Electrical engineering. Electronics Nuclear engineering |
| Divisions: | Faculty of Science > Computer Science |
| Series Name: | Artificial Intelligence Series-WSEAS |
| Journal or Publication Title: | Proceedings of the 9th WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases |
| Publisher: | World Scientific and Engineering Academy and Society |
| ISBN: | 978-960-474-154-0 |
| Editor: | Zadeh, LA and Kacprzyk, J and Mastorakis, N and KuriMorales, A and Borne, P and Kazovsky, L |
| Date: | 2010 |
| Number of Pages: | 6 |
| 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 WSEAS International Conference on Artificial Intelligence, Knowledge Engineering and Data Bases |
| Type of Event: | Conference |
| Location of Event: | Univ Cambridge, Cambridge, England |
| Date(s) of Event: | February 20-22, 2010 |
| URI: | http://wrap.warwick.ac.uk/id/eprint/6043 |
Data sourced from Thomson Reuters' Web of Knowledge
Actions (login required)
 |
View Item |
