Matches in SemOpenAlex for { <https://semopenalex.org/work/W3044194791> ?p ?o ?g. }
Showing items 1 to 92 of
92
with 100 items per page.
- W3044194791 abstract "Current database practitioners cannot easily store information about transient phenomena using existing commercial off-the-shelf tools, because vendors do not support temporal database characteristics. This paper describes a practical problem where a relational database must record a series of events that occur over a given time span, without any modification to the underlying database management system. The database must be able to perform queries on the temporal information of an event occurrence. However, the database must also manage overriding events which take precedence over previously scheduled events, while maintaining knowledge of the overridden event. A basic approach to the problem is discussed, which is conceptually simple but cannot efficiently record the required information, nor can it cope with complex overriding event scenarios. We propose a second approach that models the events using time spans. The time span approach is then refined to create a third scheme that can efficiently handle complex overriding event scenarios. The two time span approaches result in significant storage gains compared to the first approach. However, the storage gains come with a trade-off in efficiency for data manipulation queries. The proposed approach is implementable with current relational standards (and SQL), and does not have the overhead and complexity of a full-scale temporal database." @default.
- W3044194791 created "2020-07-29" @default.
- W3044194791 creator A5058019927 @default.
- W3044194791 creator A5063220268 @default.
- W3044194791 date "2015-01-01" @default.
- W3044194791 modified "2023-09-24" @default.
- W3044194791 title "Maintaining Time Span Information in a Relational Database" @default.
- W3044194791 cites W115993962 @default.
- W3044194791 cites W1531918044 @default.
- W3044194791 cites W1597031764 @default.
- W3044194791 cites W1988843321 @default.
- W3044194791 cites W2044019389 @default.
- W3044194791 cites W2054655669 @default.
- W3044194791 cites W2055385473 @default.
- W3044194791 cites W2103465290 @default.
- W3044194791 cites W2126413127 @default.
- W3044194791 cites W2135960837 @default.
- W3044194791 cites W2149833616 @default.
- W3044194791 cites W2161484642 @default.
- W3044194791 cites W2165467455 @default.
- W3044194791 cites W2167350691 @default.
- W3044194791 cites W2169057819 @default.
- W3044194791 cites W2172207436 @default.
- W3044194791 cites W84440064 @default.
- W3044194791 hasPublicationYear "2015" @default.
- W3044194791 type Work @default.
- W3044194791 sameAs 3044194791 @default.
- W3044194791 citedByCount "0" @default.
- W3044194791 crossrefType "journal-article" @default.
- W3044194791 hasAuthorship W3044194791A5058019927 @default.
- W3044194791 hasAuthorship W3044194791A5063220268 @default.
- W3044194791 hasConcept C111919701 @default.
- W3044194791 hasConcept C121332964 @default.
- W3044194791 hasConcept C124101348 @default.
- W3044194791 hasConcept C127413603 @default.
- W3044194791 hasConcept C147176958 @default.
- W3044194791 hasConcept C148840519 @default.
- W3044194791 hasConcept C24394798 @default.
- W3044194791 hasConcept C2778753569 @default.
- W3044194791 hasConcept C2779662365 @default.
- W3044194791 hasConcept C2779960059 @default.
- W3044194791 hasConcept C40207289 @default.
- W3044194791 hasConcept C41008148 @default.
- W3044194791 hasConcept C510870499 @default.
- W3044194791 hasConcept C5655090 @default.
- W3044194791 hasConcept C62520636 @default.
- W3044194791 hasConcept C77088390 @default.
- W3044194791 hasConceptScore W3044194791C111919701 @default.
- W3044194791 hasConceptScore W3044194791C121332964 @default.
- W3044194791 hasConceptScore W3044194791C124101348 @default.
- W3044194791 hasConceptScore W3044194791C127413603 @default.
- W3044194791 hasConceptScore W3044194791C147176958 @default.
- W3044194791 hasConceptScore W3044194791C148840519 @default.
- W3044194791 hasConceptScore W3044194791C24394798 @default.
- W3044194791 hasConceptScore W3044194791C2778753569 @default.
- W3044194791 hasConceptScore W3044194791C2779662365 @default.
- W3044194791 hasConceptScore W3044194791C2779960059 @default.
- W3044194791 hasConceptScore W3044194791C40207289 @default.
- W3044194791 hasConceptScore W3044194791C41008148 @default.
- W3044194791 hasConceptScore W3044194791C510870499 @default.
- W3044194791 hasConceptScore W3044194791C5655090 @default.
- W3044194791 hasConceptScore W3044194791C62520636 @default.
- W3044194791 hasConceptScore W3044194791C77088390 @default.
- W3044194791 hasIssue "2" @default.
- W3044194791 hasLocation W30441947911 @default.
- W3044194791 hasOpenAccess W3044194791 @default.
- W3044194791 hasPrimaryLocation W30441947911 @default.
- W3044194791 hasRelatedWork W102036635 @default.
- W3044194791 hasRelatedWork W1035740170 @default.
- W3044194791 hasRelatedWork W130479384 @default.
- W3044194791 hasRelatedWork W1484842096 @default.
- W3044194791 hasRelatedWork W148687919 @default.
- W3044194791 hasRelatedWork W1592936309 @default.
- W3044194791 hasRelatedWork W1952857177 @default.
- W3044194791 hasRelatedWork W2010150096 @default.
- W3044194791 hasRelatedWork W2053508739 @default.
- W3044194791 hasRelatedWork W2059826150 @default.
- W3044194791 hasRelatedWork W2070560901 @default.
- W3044194791 hasRelatedWork W2077377680 @default.
- W3044194791 hasRelatedWork W2144319429 @default.
- W3044194791 hasRelatedWork W2151650592 @default.
- W3044194791 hasRelatedWork W2540212288 @default.
- W3044194791 hasRelatedWork W2740396472 @default.
- W3044194791 hasRelatedWork W2912093648 @default.
- W3044194791 hasRelatedWork W299334769 @default.
- W3044194791 hasRelatedWork W3046525496 @default.
- W3044194791 hasRelatedWork W939747119 @default.
- W3044194791 hasVolume "21" @default.
- W3044194791 isParatext "false" @default.
- W3044194791 isRetracted "false" @default.
- W3044194791 magId "3044194791" @default.
- W3044194791 workType "article" @default.