Matches in SemOpenAlex for { <https://semopenalex.org/work/W146174752> ?p ?o ?g. }
- W146174752 endingPage "405" @default.
- W146174752 startingPage "392" @default.
- W146174752 abstract "We investigate the problems involved in efficient implementation of multiple assignment to database tables, as suggested by Date and Darwen in their Third Manifesto proposal for future database systems [10]. We explain the connection between assignment and the INSERT, DELETE and UPDATE operations and why multiple assignments executed simultaneously are preferable to deferred constraint checking. Our contributions are twofold. Firstly, we enable the user to specify updates either in terms of the changes needed to the existing state or as the final table contents directly, with no degradation in performance. Secondly, when multiple tables are updated SQL places the 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 present methods for a proposed implementation that can potentially exceed the performance of SQL DBMSs by employing parallelism and multi-query optimization." @default.
- W146174752 created "2016-06-24" @default.
- W146174752 creator A5032832343 @default.
- W146174752 creator A5045495475 @default.
- W146174752 creator A5077918637 @default.
- W146174752 date "2010-04-01" @default.
- W146174752 modified "2023-09-27" @default.
- W146174752 title "Rethinking database updates using a multiple assignment-based approach" @default.
- W146174752 cites W128387175 @default.
- W146174752 cites W1483819513 @default.
- W146174752 cites W1489273657 @default.
- W146174752 cites W1499412441 @default.
- W146174752 cites W1565494300 @default.
- W146174752 cites W1572571126 @default.
- W146174752 cites W1580074955 @default.
- W146174752 cites W163363913 @default.
- W146174752 cites W1979514837 @default.
- W146174752 cites W1980481456 @default.
- W146174752 cites W2008459584 @default.
- W146174752 cites W2011432210 @default.
- W146174752 cites W2028864278 @default.
- W146174752 cites W2030083229 @default.
- W146174752 cites W2043283603 @default.
- W146174752 cites W2076126314 @default.
- W146174752 cites W2093490165 @default.
- W146174752 cites W2098416578 @default.
- W146174752 cites W2103953153 @default.
- W146174752 cites W2104954161 @default.
- W146174752 cites W2106105896 @default.
- W146174752 cites W2109913494 @default.
- W146174752 cites W2141591281 @default.
- W146174752 cites W2153752008 @default.
- W146174752 cites W2462092264 @default.
- W146174752 cites W364699295 @default.
- W146174752 cites W409921457 @default.
- W146174752 cites W598883365 @default.
- W146174752 hasPublicationYear "2010" @default.
- W146174752 type Work @default.
- W146174752 sameAs 146174752 @default.
- W146174752 citedByCount "0" @default.
- W146174752 crossrefType "journal-article" @default.
- W146174752 hasAuthorship W146174752A5032832343 @default.
- W146174752 hasAuthorship W146174752A5045495475 @default.
- W146174752 hasAuthorship W146174752A5077918637 @default.
- W146174752 hasConcept C154420247 @default.
- W146174752 hasConcept C162324750 @default.
- W146174752 hasConcept C164120249 @default.
- W146174752 hasConcept C194222762 @default.
- W146174752 hasConcept C199360897 @default.
- W146174752 hasConcept C206729178 @default.
- W146174752 hasConcept C21547014 @default.
- W146174752 hasConcept C23123220 @default.
- W146174752 hasConcept C41008148 @default.
- W146174752 hasConcept C45235069 @default.
- W146174752 hasConcept C510870499 @default.
- W146174752 hasConcept C77088390 @default.
- W146174752 hasConcept C97854310 @default.
- W146174752 hasConceptScore W146174752C154420247 @default.
- W146174752 hasConceptScore W146174752C162324750 @default.
- W146174752 hasConceptScore W146174752C164120249 @default.
- W146174752 hasConceptScore W146174752C194222762 @default.
- W146174752 hasConceptScore W146174752C199360897 @default.
- W146174752 hasConceptScore W146174752C206729178 @default.
- W146174752 hasConceptScore W146174752C21547014 @default.
- W146174752 hasConceptScore W146174752C23123220 @default.
- W146174752 hasConceptScore W146174752C41008148 @default.
- W146174752 hasConceptScore W146174752C45235069 @default.
- W146174752 hasConceptScore W146174752C510870499 @default.
- W146174752 hasConceptScore W146174752C77088390 @default.
- W146174752 hasConceptScore W146174752C97854310 @default.
- W146174752 hasIssue "4" @default.
- W146174752 hasLocation W1461747521 @default.
- W146174752 hasOpenAccess W146174752 @default.
- W146174752 hasPrimaryLocation W1461747521 @default.
- W146174752 hasRelatedWork W1590029787 @default.
- W146174752 hasRelatedWork W1969931494 @default.
- W146174752 hasRelatedWork W1972348463 @default.
- W146174752 hasRelatedWork W2011795509 @default.
- W146174752 hasRelatedWork W2026843124 @default.
- W146174752 hasRelatedWork W2045031439 @default.
- W146174752 hasRelatedWork W2093823810 @default.
- W146174752 hasRelatedWork W2105252819 @default.
- W146174752 hasRelatedWork W2113329933 @default.
- W146174752 hasRelatedWork W2121523964 @default.
- W146174752 hasRelatedWork W2141575847 @default.
- W146174752 hasRelatedWork W2170515491 @default.
- W146174752 hasRelatedWork W2201552871 @default.
- W146174752 hasRelatedWork W2210960677 @default.
- W146174752 hasRelatedWork W2418571785 @default.
- W146174752 hasRelatedWork W2539113162 @default.
- W146174752 hasRelatedWork W2584032287 @default.
- W146174752 hasRelatedWork W3033409273 @default.
- W146174752 hasRelatedWork W3104705081 @default.
- W146174752 hasRelatedWork W1833502664 @default.
- W146174752 hasVolume "9" @default.
- W146174752 isParatext "false" @default.
- W146174752 isRetracted "false" @default.
- W146174752 magId "146174752" @default.