{"id":"https://openalex.org/W2130654008","doi":"https://doi.org/10.1109/tkde.2004.1277816","title":"Reconciling point-based and interval-based semantics in temporal relational databases: a treatment of the telic/atelic distinction","display_name":"Reconciling point-based and interval-based semantics in temporal relational databases: a treatment of the telic/atelic distinction","publication_year":2004,"publication_date":"2004-03-30","ids":{"openalex":"https://openalex.org/W2130654008","doi":"https://doi.org/10.1109/tkde.2004.1277816","mag":"2130654008"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2004.1277816","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2004.1277816","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5007745000","display_name":"Paolo Terenziani","orcid":"https://orcid.org/0000-0002-9014-7537"},"institutions":[{"id":"https://openalex.org/I123338534","display_name":"Universit\u00e0 degli Studi del Piemonte Orientale \u201cAmedeo Avogadro\u201d","ror":"https://ror.org/04387x656","country_code":"IT","type":"education","lineage":["https://openalex.org/I123338534"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"P. Terenziani","raw_affiliation_strings":["Dipartimento di Informatica, Universit\u00e1 del Piemonte Orientale Amedeo Avogadro, Alessandria, Italy","Dipt. di Informatica, Univ. del Piemonte Orientale, Alessandria, Italy#TAB#"],"affiliations":[{"raw_affiliation_string":"Dipartimento di Informatica, Universit\u00e1 del Piemonte Orientale Amedeo Avogadro, Alessandria, Italy","institution_ids":["https://openalex.org/I123338534"]},{"raw_affiliation_string":"Dipt. di Informatica, Univ. del Piemonte Orientale, Alessandria, Italy#TAB#","institution_ids":["https://openalex.org/I123338534"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5058823251","display_name":"Richard T. Snodgrass","orcid":"https://orcid.org/0000-0003-4703-7460"},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"R.T. Snodgrass","raw_affiliation_strings":["Department of Computer Science, University of Arizona Tucson, Tucson, AZ, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Arizona Tucson, Tucson, AZ, USA","institution_ids":["https://openalex.org/I138006243"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5007745000"],"corresponding_institution_ids":["https://openalex.org/I123338534"],"apc_list":null,"apc_paid":null,"fwci":2.7398,"has_fulltext":false,"cited_by_count":67,"citation_normalized_percentile":{"value":0.91727057,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"16","issue":"5","first_page":"540","last_page":"551"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9962999820709229,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7895463705062866},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6774027347564697},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.6417026519775391},{"id":"https://openalex.org/keywords/interval","display_name":"Interval (graph theory)","score":0.5789299607276917},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.5418217778205872},{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.5243145227432251},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.4526039659976959},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4010748565196991},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4008854031562805},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3942262530326843},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.37321925163269043},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11823207139968872}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7895463705062866},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6774027347564697},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.6417026519775391},{"id":"https://openalex.org/C2778067643","wikidata":"https://www.wikidata.org/wiki/Q166507","display_name":"Interval (graph theory)","level":2,"score":0.5789299607276917},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.5418217778205872},{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.5243145227432251},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.4526039659976959},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4010748565196991},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4008854031562805},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3942262530326843},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.37321925163269043},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11823207139968872},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/tkde.2004.1277816","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2004.1277816","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.113.6581","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.113.6581","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.arizona.edu/~rts/pubs/TKDEMay04.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7300000190734863,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":108,"referenced_works":["https://openalex.org/W118536976","https://openalex.org/W131127645","https://openalex.org/W135415881","https://openalex.org/W142323383","https://openalex.org/W166149685","https://openalex.org/W623773473","https://openalex.org/W648834565","https://openalex.org/W1494039273","https://openalex.org/W1499647402","https://openalex.org/W1501220540","https://openalex.org/W1504193486","https://openalex.org/W1505839237","https://openalex.org/W1526125566","https://openalex.org/W1526523172","https://openalex.org/W1529967551","https://openalex.org/W1532002274","https://openalex.org/W1549387132","https://openalex.org/W1549722407","https://openalex.org/W1550582582","https://openalex.org/W1557868286","https://openalex.org/W1561355444","https://openalex.org/W1563974525","https://openalex.org/W1566724751","https://openalex.org/W1573002516","https://openalex.org/W1577743175","https://openalex.org/W1589223644","https://openalex.org/W1594120206","https://openalex.org/W1599633142","https://openalex.org/W1605474854","https://openalex.org/W1607503739","https://openalex.org/W1621077771","https://openalex.org/W1707426366","https://openalex.org/W1871606727","https://openalex.org/W1965982021","https://openalex.org/W1967303829","https://openalex.org/W1977441255","https://openalex.org/W1978476354","https://openalex.org/W1978502433","https://openalex.org/W1979749124","https://openalex.org/W1983713291","https://openalex.org/W1986739594","https://openalex.org/W1987118521","https://openalex.org/W1988163600","https://openalex.org/W1991183254","https://openalex.org/W1992732065","https://openalex.org/W2000290232","https://openalex.org/W2005678616","https://openalex.org/W2015119740","https://openalex.org/W2018538688","https://openalex.org/W2018978908","https://openalex.org/W2023119183","https://openalex.org/W2024786853","https://openalex.org/W2025589690","https://openalex.org/W2028544887","https://openalex.org/W2040088125","https://openalex.org/W2048715330","https://openalex.org/W2050347474","https://openalex.org/W2054655669","https://openalex.org/W2060728891","https://openalex.org/W2067481201","https://openalex.org/W2068063357","https://openalex.org/W2076702356","https://openalex.org/W2078590814","https://openalex.org/W2080925799","https://openalex.org/W2081102106","https://openalex.org/W2083125010","https://openalex.org/W2083594369","https://openalex.org/W2096619464","https://openalex.org/W2096730617","https://openalex.org/W2097983280","https://openalex.org/W2099197152","https://openalex.org/W2110415540","https://openalex.org/W2110788116","https://openalex.org/W2113056857","https://openalex.org/W2119054414","https://openalex.org/W2119409989","https://openalex.org/W2119984902","https://openalex.org/W2122540544","https://openalex.org/W2123533420","https://openalex.org/W2124335333","https://openalex.org/W2134779891","https://openalex.org/W2139205714","https://openalex.org/W2158850947","https://openalex.org/W2159036867","https://openalex.org/W2159948956","https://openalex.org/W2161484642","https://openalex.org/W2166253827","https://openalex.org/W2169057819","https://openalex.org/W2170777093","https://openalex.org/W2323119546","https://openalex.org/W2326390422","https://openalex.org/W2396555304","https://openalex.org/W2407958425","https://openalex.org/W2883690628","https://openalex.org/W2899987233","https://openalex.org/W3000386367","https://openalex.org/W3028765791","https://openalex.org/W3107016489","https://openalex.org/W3121561501","https://openalex.org/W3123141741","https://openalex.org/W3125726144","https://openalex.org/W4211046312","https://openalex.org/W4242944310","https://openalex.org/W4243158342","https://openalex.org/W4250495829","https://openalex.org/W6630038781","https://openalex.org/W6684614746","https://openalex.org/W6713448417"],"related_works":["https://openalex.org/W124328752","https://openalex.org/W1665257821","https://openalex.org/W149237019","https://openalex.org/W2762065037","https://openalex.org/W1516563171","https://openalex.org/W2400945447","https://openalex.org/W2126493028","https://openalex.org/W1716383435","https://openalex.org/W1980245017","https://openalex.org/W2405416608"],"abstract_inverted_index":{"The":[0],"analysis":[1],"of":[2,5,17,31,49,62,81,122,127],"the":[3,15,43,47,60,79,100,128],"semantics":[4,39,84],"temporal":[6,18,112],"data":[7,101],"and":[8,24,52,104,114],"queries":[9],"plays":[10],"a":[11,36,66,82,110],"central":[12],"role":[13],"in":[14,46,78,99],"area":[16],"databases.":[19],"Although":[20],"many":[21],"different":[22],"algebrae":[23],"models":[25],"have":[26],"been":[27],"proposed,":[28],"almost":[29],"all":[30],"them":[32],"are":[33],"based":[34],"on":[35],"point-based":[37,67,83],"(snapshot)":[38],"for":[40,85,119],"data.":[41],"On":[42],"other":[44,129],"hand,":[45],"areas":[48],"linguistics,":[50],"philosophy,":[51],"recently,":[53],"artificial":[54],"intelligence,":[55],"an":[56,63],"oft-debated":[57],"issue":[58],"concerns":[59],"use":[61],"interval-based":[64],"versus":[65],"semantics.":[68],"In":[69],"this":[70],"paper,":[71],"we":[72],"first":[73],"show":[74],"some":[75],"problems":[76,91],"inherent":[77],"adoption":[80],"data,":[86],"then":[87,108],"argue":[88],"that":[89],"these":[90,137],"arise":[92],"because":[93],"there":[94],"is":[95],"no":[96],"distinction":[97],"drawn":[98],"between":[102],"telic":[103],"atelic":[105],"facts.":[106],"We":[107],"introduce":[109],"three-sorted":[111],"model":[113],"algebra":[115],"including":[116],"coercion":[117],"functions":[118],"transforming":[120],"relations":[121,126],"one":[123],"sort":[124],"into":[125],"at":[130],"query":[131],"time":[132],"which":[133],"properly":[134],"copes":[135],"with":[136],"issues.":[138]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":5}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}