{"id":"https://openalex.org/W1945920115","doi":"https://doi.org/10.1007/978-0-387-39940-9_1525","title":"SQL-Based Temporal Query Languages","display_name":"SQL-Based Temporal Query Languages","publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W1945920115","doi":"https://doi.org/10.1007/978-0-387-39940-9_1525","mag":"1945920115"},"language":"en","primary_location":{"id":"doi:10.1007/978-0-387-39940-9_1525","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-0-387-39940-9_1525","pdf_url":null,"source":{"id":"https://openalex.org/S4306509343","display_name":"Encyclopedia of Database Systems","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Encyclopedia of Database Systems","raw_type":"book-chapter"},"type":"book-chapter","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/A5017018305","display_name":"Michael H. B\u00f6hlen","orcid":"https://orcid.org/0000-0003-3694-9026"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Michael B\u00f6hlen","raw_affiliation_strings":["Free University of Bozen-Bolzano, Bolzano, Italy"],"affiliations":[{"raw_affiliation_string":"Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043864804","display_name":"Johann Gamper","orcid":"https://orcid.org/0000-0002-7128-507X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Johann Gamper","raw_affiliation_strings":["Free University of Bozen-Bolzano, Bolzano, Italy"],"affiliations":[{"raw_affiliation_string":"Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029380368","display_name":"Christian S. Jensen","orcid":"https://orcid.org/0000-0002-9697-7670"},"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":"Christian S. Jensen","raw_affiliation_strings":["Aalborg University, Aalborg, Denmark"],"affiliations":[{"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 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":"Richard T. Snodgrass","raw_affiliation_strings":["University of Arizona, Tucson, AZ, USA, \u00a0,"],"affiliations":[{"raw_affiliation_string":"University of Arizona, Tucson, AZ, USA, \u00a0,","institution_ids":["https://openalex.org/I138006243"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5017018305"],"corresponding_institution_ids":["https://openalex.org/I171543936"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.17546296,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"2762","last_page":"2768"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"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"}},{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9991000294685364,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965000152587891,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7106465101242065},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.542614758014679},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5377203822135925},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4944489002227783},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.48067745566368103},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.41373389959335327},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1903921663761139},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.16327416896820068},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.038135915994644165}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7106465101242065},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.542614758014679},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5377203822135925},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4944489002227783},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.48067745566368103},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.41373389959335327},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1903921663761139},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.16327416896820068},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.038135915994644165}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1007/978-0-387-39940-9_1525","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-0-387-39940-9_1525","pdf_url":null,"source":{"id":"https://openalex.org/S4306509343","display_name":"Encyclopedia of Database Systems","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Encyclopedia of Database Systems","raw_type":"book-chapter"},{"id":"pmh:oai:alma.39UBZ_INST:11235054260001241","is_oa":false,"landing_page_url":"https://link.springer.com/referenceworkentry/10.1007/978-0-387-39940-9_1525","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"pmh:oai:pure.atira.dk:publications/d123e2b0-ed9a-11de-b63d-000ea68e967b","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/d123e2b0-ed9a-11de-b63d-000ea68e967b","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"B\u00f6hlen , M , Gamper , J , Jensen , C S & Snodgrass , R T 2009 , SQL-Based Temporal Query Languages . in Encyclopedia of Database Systems . 2009 edn , Springer , Berlin/Heidelberg , pp. 2762-2768 . https://doi.org/10.1007/978-1-4899-7993-3_1525-2","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:unibz.it:11235054260001241","is_oa":false,"landing_page_url":"https://bia.unibz.it/esploro/outputs/encyclopediaEntry/SQL-based-temporal-query-languages/991005772417901241","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"pmh:oai:www.zora.uzh.ch:56379","is_oa":false,"landing_page_url":"https://www.zora.uzh.ch/56379","pdf_url":null,"source":{"id":"https://openalex.org/S4306401281","display_name":"Zurich Open Repository and Archive (University of Zurich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I202697423","host_organization_name":"University of Zurich","host_organization_lineage":["https://openalex.org/I202697423"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"B\u00f6hlen, Michael Hanspeter; Gamper, Johann; Jensen, Christian; Snodgrass, Richard  (2009). SQL-Based Temporal Query Languages. In: Liu, Ling; Oezsu, M Tamer. Encyclopedia of Database Systems. Berlin / Heidelberg: Springer, 2762-2768.","raw_type":"Book Section"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W131127645","https://openalex.org/W1531918044","https://openalex.org/W1550582582","https://openalex.org/W1986739594","https://openalex.org/W2071578511","https://openalex.org/W2119984902","https://openalex.org/W2134779891","https://openalex.org/W2161484642"],"related_works":["https://openalex.org/W1980548249","https://openalex.org/W2614112517","https://openalex.org/W2340883001","https://openalex.org/W4318225407","https://openalex.org/W2348171219","https://openalex.org/W4366683866","https://openalex.org/W2361335440","https://openalex.org/W650213220","https://openalex.org/W20807724","https://openalex.org/W2184401408"],"abstract_inverted_index":null,"counts_by_year":[{"year":2019,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}