Matches in SemOpenAlex for { <https://semopenalex.org/work/W69767005> ?p ?o ?g. }
Showing items 1 to 71 of
71
with 100 items per page.
- W69767005 endingPage "448" @default.
- W69767005 startingPage "403" @default.
- W69767005 abstract "Temporal database support was added to the SQL standard in 2011. This lengthy chapter explains that support in detail and compares and contrasts it with the ideas introduced in previous chapters. It discusses “periods” (SQL’s analog of intervals, represented by explicit from/to pairs); an SQL base table can have at most one application time period (corresponding to valid time) and at most one system time period (corresponding to transaction time). SQL supports analogs of certain of the interval operators discussed in previous chapters; unfortunately, however, it has nothing analogous to PACK and UNPACK. The chapter discusses all of these operators, also database design considerations, queries, and updates in the SQL context. In particular, it explains how queries and updates work on “tables with system time” (especially system-versioned tables) and on “bitemporal tables” (tables with both application time and system time). The chapter concludes with a detailed analysis and assessment of the SQL temporal features." @default.
- W69767005 created "2016-06-24" @default.
- W69767005 creator A5010700946 @default.
- W69767005 creator A5010789574 @default.
- W69767005 creator A5015281988 @default.
- W69767005 creator A5048797744 @default.
- W69767005 creator A5055220781 @default.
- W69767005 creator A5077918637 @default.
- W69767005 date "2014-01-01" @default.
- W69767005 modified "2023-09-27" @default.
- W69767005 title "The SQL Standard" @default.
- W69767005 doi "https://doi.org/10.1016/b978-0-12-800631-3.50019-8" @default.
- W69767005 hasPublicationYear "2014" @default.
- W69767005 type Work @default.
- W69767005 sameAs 69767005 @default.
- W69767005 citedByCount "11" @default.
- W69767005 countsByYear W697670052013 @default.
- W69767005 crossrefType "book-chapter" @default.
- W69767005 hasAuthorship W69767005A5010700946 @default.
- W69767005 hasAuthorship W69767005A5010789574 @default.
- W69767005 hasAuthorship W69767005A5015281988 @default.
- W69767005 hasAuthorship W69767005A5048797744 @default.
- W69767005 hasAuthorship W69767005A5055220781 @default.
- W69767005 hasAuthorship W69767005A5077918637 @default.
- W69767005 hasConcept C154420247 @default.
- W69767005 hasConcept C164120249 @default.
- W69767005 hasConcept C167544706 @default.
- W69767005 hasConcept C194222762 @default.
- W69767005 hasConcept C199360897 @default.
- W69767005 hasConcept C23123220 @default.
- W69767005 hasConcept C33882796 @default.
- W69767005 hasConcept C41008148 @default.
- W69767005 hasConcept C45235069 @default.
- W69767005 hasConcept C510870499 @default.
- W69767005 hasConcept C55596503 @default.
- W69767005 hasConcept C75949130 @default.
- W69767005 hasConcept C77088390 @default.
- W69767005 hasConcept C97854310 @default.
- W69767005 hasConceptScore W69767005C154420247 @default.
- W69767005 hasConceptScore W69767005C164120249 @default.
- W69767005 hasConceptScore W69767005C167544706 @default.
- W69767005 hasConceptScore W69767005C194222762 @default.
- W69767005 hasConceptScore W69767005C199360897 @default.
- W69767005 hasConceptScore W69767005C23123220 @default.
- W69767005 hasConceptScore W69767005C33882796 @default.
- W69767005 hasConceptScore W69767005C41008148 @default.
- W69767005 hasConceptScore W69767005C45235069 @default.
- W69767005 hasConceptScore W69767005C510870499 @default.
- W69767005 hasConceptScore W69767005C55596503 @default.
- W69767005 hasConceptScore W69767005C75949130 @default.
- W69767005 hasConceptScore W69767005C77088390 @default.
- W69767005 hasConceptScore W69767005C97854310 @default.
- W69767005 hasLocation W697670051 @default.
- W69767005 hasOpenAccess W69767005 @default.
- W69767005 hasPrimaryLocation W697670051 @default.
- W69767005 hasRelatedWork W1157955462 @default.
- W69767005 hasRelatedWork W1505413869 @default.
- W69767005 hasRelatedWork W1725587203 @default.
- W69767005 hasRelatedWork W1998518960 @default.
- W69767005 hasRelatedWork W2282389522 @default.
- W69767005 hasRelatedWork W2356451189 @default.
- W69767005 hasRelatedWork W2463360381 @default.
- W69767005 hasRelatedWork W2738342198 @default.
- W69767005 hasRelatedWork W2756130066 @default.
- W69767005 hasRelatedWork W99652509 @default.
- W69767005 isParatext "false" @default.
- W69767005 isRetracted "false" @default.
- W69767005 magId "69767005" @default.
- W69767005 workType "book-chapter" @default.