{"id":"https://openalex.org/W2000290232","doi":"https://doi.org/10.1145/288086.288087","title":"Supporting valid-time indeterminacy","display_name":"Supporting valid-time indeterminacy","publication_year":1998,"publication_date":"1998-03-01","ids":{"openalex":"https://openalex.org/W2000290232","doi":"https://doi.org/10.1145/288086.288087","mag":"2000290232"},"language":"en","primary_location":{"id":"doi:10.1145/288086.288087","doi":"https://doi.org/10.1145/288086.288087","is_oa":true,"landing_page_url":"https://doi.org/10.1145/288086.288087","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/288086.288087","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2000290232"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/288086.288087","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005123859","display_name":"Curtis Dyreson","orcid":"https://orcid.org/0000-0003-0236-1515","observed_orcids":["https://orcid.org/0000-0003-0236-1515"]},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Curtis E. Dyreson","raw_affiliation_strings":["Aalborg Univ., Aalborg, Denmark","Aalborg University, Aalborg, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg Univ., Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]},{"raw_affiliation_string":"Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5058823251","display_name":"Richard Thomas Snodgrass","orcid":"https://orcid.org/0000-0003-4703-7460","observed_orcids":["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":"Richard Thomas Snodgrass","raw_affiliation_strings":["Univ. of Arizona, Tuscon","University of Arizona, Tuscon"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Univ. of Arizona, Tuscon","institution_ids":["https://openalex.org/I138006243"]},{"raw_affiliation_string":"University of Arizona, Tuscon","institution_ids":["https://openalex.org/I138006243"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":18.2757,"has_fulltext":true,"cited_by_count":166,"citation_normalized_percentile":{"value":0.9929764,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":99},"biblio":{"volume":"23","issue":"1","first_page":"1","last_page":"57"},"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.95169997215271,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.95169997215271,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.04259999841451645,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.002099999925121665,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/uncertain-events","display_name":"uncertain events","score":0.4790000021457672},{"id":"https://openalex.org/keywords/sql-extension","display_name":"SQL extension","score":0.6179999709129333},{"id":"https://openalex.org/keywords/temporal-databases","display_name":"temporal databases","score":0.49799999594688416},{"id":"https://openalex.org/keywords/denotational-semantics","display_name":"denotational semantics","score":0.9520000219345093},{"id":"https://openalex.org/keywords/query-processing","display_name":"query processing","score":0.5220000147819519},{"id":"https://openalex.org/keywords/temporal-query-languages","display_name":"temporal query languages","score":0.6349999904632568},{"id":"https://openalex.org/keywords/sql3","display_name":"SQL3","score":0.7210000157356262}],"concepts":[{"id":"https://openalex.org/C2777366796","wikidata":"https://www.wikidata.org/wiki/Q6017758","display_name":"Indeterminacy (philosophy)","level":2,"score":0.8717039823532104},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8549711108207703},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.6062997579574585},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5657315254211426},{"id":"https://openalex.org/C2779662365","wikidata":"https://www.wikidata.org/wiki/Q5416694","display_name":"Event (particle physics)","level":2,"score":0.5544115304946899},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.506693422794342},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5057742595672607},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.43347764015197754},{"id":"https://openalex.org/C2780224610","wikidata":"https://www.wikidata.org/wiki/Q1530061","display_name":"Credibility","level":2,"score":0.42406466603279114},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4156700074672699},{"id":"https://openalex.org/C2777026412","wikidata":"https://www.wikidata.org/wiki/Q2684591","display_name":"Statement (logic)","level":2,"score":0.4114401638507843},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4001135230064392},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37894129753112793},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.35421818494796753},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3328849673271179},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.08076754212379456},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":7,"locations":[{"id":"doi:10.1145/288086.288087","doi":"https://doi.org/10.1145/288086.288087","is_oa":true,"landing_page_url":"https://doi.org/10.1145/288086.288087","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/288086.288087","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.111.4857","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.111.4857","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/TODS98.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.130.8466","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.130.8466","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/ICDE93p335.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.39.1219","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.39.1219","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.it.bond.edu.au/cdyreson/pub/temporal/papers/tods.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.46.2366","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.46.2366","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.auc.dk/research/DP/tdb/TimeCenter/TimeCenterPublications/TR-7.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.51.9776","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.51.9776","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ftp://coral.cs.jcu.edu.au/pub/techreports/96-20.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.68.9532","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.68.9532","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://oldwww.cs.aau.dk/research/DP/tdb/TimeCenter/TimeCenterPublications/TR-7.pdf","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/288086.288087","doi":"https://doi.org/10.1145/288086.288087","is_oa":true,"landing_page_url":"https://doi.org/10.1145/288086.288087","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/288086.288087","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-a","cwts-core","dongbi-a","jufo-3","norway-1","poland-100","russia-white-list-2"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2000290232.pdf","grobid_xml":"https://content.openalex.org/works/W2000290232.grobid-xml"},"referenced_works_count":64,"referenced_works":["https://openalex.org/W71027922","https://openalex.org/W80630407","https://openalex.org/W104337258","https://openalex.org/W621585018","https://openalex.org/W1487409515","https://openalex.org/W1489843519","https://openalex.org/W1496691805","https://openalex.org/W1499815887","https://openalex.org/W1500547548","https://openalex.org/W1500821679","https://openalex.org/W1501284393","https://openalex.org/W1504193486","https://openalex.org/W1517386541","https://openalex.org/W1524941137","https://openalex.org/W1526145227","https://openalex.org/W1526523172","https://openalex.org/W1526814147","https://openalex.org/W1529967551","https://openalex.org/W1546227028","https://openalex.org/W1554917839","https://openalex.org/W1565143444","https://openalex.org/W1579448688","https://openalex.org/W1584590635","https://openalex.org/W1589223644","https://openalex.org/W1592371320","https://openalex.org/W1716383435","https://openalex.org/W1784626293","https://openalex.org/W1951450271","https://openalex.org/W1968915456","https://openalex.org/W1970065917","https://openalex.org/W1971864291","https://openalex.org/W1992609556","https://openalex.org/W1993849034","https://openalex.org/W2000616942","https://openalex.org/W2003017562","https://openalex.org/W2004851292","https://openalex.org/W2010377999","https://openalex.org/W2013277984","https://openalex.org/W2024400846","https://openalex.org/W2032352315","https://openalex.org/W2046005538","https://openalex.org/W2047226031","https://openalex.org/W2056147406","https://openalex.org/W2066837227","https://openalex.org/W2083820144","https://openalex.org/W2085988990","https://openalex.org/W2086784214","https://openalex.org/W2089797906","https://openalex.org/W2095303876","https://openalex.org/W2097518550","https://openalex.org/W2103343882","https://openalex.org/W2119984902","https://openalex.org/W2125791539","https://openalex.org/W2130214058","https://openalex.org/W2130949492","https://openalex.org/W2139722852","https://openalex.org/W2146256141","https://openalex.org/W2148454664","https://openalex.org/W2159948956","https://openalex.org/W2161484642","https://openalex.org/W2660900262","https://openalex.org/W2914144260","https://openalex.org/W3022688068","https://openalex.org/W3121801367"],"related_works":["https://openalex.org/W2095303876","https://openalex.org/W2032513332","https://openalex.org/W7099347161","https://openalex.org/W2386009699","https://openalex.org/W793196884","https://openalex.org/W7098747583","https://openalex.org/W2091953868","https://openalex.org/W52441815","https://openalex.org/W1592149428"],"abstract_inverted_index":{"In":[0,25],"valid-time":[1,39,203],"indeterminacy":[2,204,217],"it":[3,18,128,138,237],"is":[4,19,117,124,133,159,189,195,218,222,233],"known":[5,21],"that":[6,67,102,121,127,136,192,230],"an":[7,47],"event":[8,48,58],"stored":[9],"in":[10,14,78,91,98,126,135],"a":[11,50,63,180],"database":[12],"did":[13],"fact":[15],"occur,":[16],"but":[17],"not":[20,148],"exactly":[22],"when":[23,56,157],".":[24],"this":[26,122,187],"paper":[27,188],"we":[28,228],"extend":[29],"the":[30,43,57,79,92,99,145,154,163,231,239],"SQL":[31],"data":[32,94,165],"model":[33,166],"and":[34,62,95,114,151,167,197,205,221],"query":[35,72,168,207,241],"language":[36,73,169,242],"to":[37,75,87,141,153,178,190,224,238],"support":[38,215],"indeterminacy.":[40,82,161],"We":[41,69,119],"represent":[42],"occurrence":[44],"time":[45],"of":[46,52,81,186,202,214],"with":[49,111],"set":[51],"possible":[53],"instants,":[54],"delimiting":[55],"might":[59],"have":[60],"occurred,":[61],"probability":[64],"distribution":[65],"over":[66],"set.":[68],"also":[70],"describe":[71],"constructs":[74,84,116,243],"retrieve":[76],"information":[77],"presence":[80],"These":[83],"enable":[85],"users":[86],"specify":[88],"their":[89,96],"credibility":[90,113],"underlying":[93],"plausibility":[97,115],"relationships":[100],"among":[101],"data.":[103],"A":[104,184],"denotational":[105],"semantics":[106,123,156],"for":[107,216,246],"SQL's":[108],"select":[109],"statement":[110],"optional":[112],"given.":[118],"show":[120,229],"reliable,":[125,150],"never":[129],"produces":[130],"incorrect":[131],"information,":[132],"maximal,":[134],"if":[137],"were":[139],"extended":[140,164],"be":[142,149,225],"more":[143],"informative,":[144],"results":[146],"may":[147],"reduces":[152],"previous":[155],"there":[158],"no":[160],"Although":[162],"provide":[170],"needed":[171],"modeling":[172],"capabilities,":[173],"these":[174],"extensions":[175],"appear":[176],"initially":[177],"carry":[179],"significant":[181],"execution":[182],"cost.":[183],"contribution":[185],"demonstrate":[191],"our":[193],"approach":[194,232],"useful":[196],"practical.":[198],"An":[199],"efficient":[200,206],"representation":[201],"processing":[208],"algorithms":[209],"are":[210],"provided.":[211],"The":[212],"cost":[213],"empirically":[219],"measured,":[220],"shown":[223],"modest.":[226],"Finally,":[227],"general,":[234],"by":[235],"applying":[236],"temporal":[240],"being":[244],"proposed":[245],"SQL3.":[247]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":8},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
