{"id":"https://openalex.org/W1978006057","doi":"https://doi.org/10.1007/s00778-005-0161-9","title":"SQL extension for spatio-temporal data","display_name":"SQL extension for spatio-temporal data","publication_year":2006,"publication_date":"2006-07-12","ids":{"openalex":"https://openalex.org/W1978006057","doi":"https://doi.org/10.1007/s00778-005-0161-9","mag":"1978006057"},"language":"en","primary_location":{"id":"doi:10.1007/s00778-005-0161-9","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s00778-005-0161-9","pdf_url":null,"source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","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/A5019103741","display_name":"Jos\u00e9 R. R. Viqueira","orcid":"https://orcid.org/0000-0002-1539-3746"},"institutions":[{"id":"https://openalex.org/I200284239","display_name":"Universidade de Santiago de Compostela","ror":"https://ror.org/030eybx10","country_code":"ES","type":"education","lineage":["https://openalex.org/I200284239"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Jose R. Rios Viqueira","raw_affiliation_strings":["Systems Laboratory, Department of Electronics and Computer Science, Instituto de Investigaciones Tecnol\u00f3gicas, University of Santiago de Compostela, Campus Sur, 15782, Santiago de Compostela, A Coru\u00f1a, Spain","Systems Laboratory, Department of Electronics and Computer Science, Instituto de Investigaciones Tecnol\u00f3gicas, University of Santiago de Compostela, Spain"],"affiliations":[{"raw_affiliation_string":"Systems Laboratory, Department of Electronics and Computer Science, Instituto de Investigaciones Tecnol\u00f3gicas, University of Santiago de Compostela, Campus Sur, 15782, Santiago de Compostela, A Coru\u00f1a, Spain","institution_ids":["https://openalex.org/I200284239"]},{"raw_affiliation_string":"Systems Laboratory, Department of Electronics and Computer Science, Instituto de Investigaciones Tecnol\u00f3gicas, University of Santiago de Compostela, Spain","institution_ids":["https://openalex.org/I200284239"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108493610","display_name":"Nikos A. Lorentzos","orcid":null},"institutions":[{"id":"https://openalex.org/I109954829","display_name":"Agricultural University of Athens","ror":"https://ror.org/03xawq568","country_code":"GR","type":"education","lineage":["https://openalex.org/I109954829"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Nikos A. Lorentzos","raw_affiliation_strings":["Informatics Laboratory, Agricultural University of Athens, Iera Odos 75, GR 11855, Athens, Greece","Informatics Laboratory, Agricultural University of Athens, Greece#TAB#"],"affiliations":[{"raw_affiliation_string":"Informatics Laboratory, Agricultural University of Athens, Iera Odos 75, GR 11855, Athens, Greece","institution_ids":["https://openalex.org/I109954829"]},{"raw_affiliation_string":"Informatics Laboratory, Agricultural University of Athens, Greece#TAB#","institution_ids":["https://openalex.org/I109954829"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5019103741"],"corresponding_institution_ids":["https://openalex.org/I200284239"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":null,"fwci":2.2709,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.87102214,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"16","issue":"2","first_page":"179","last_page":"200"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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.9993000030517578,"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/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/T10757","display_name":"Geographic Information Systems Studies","score":0.9927999973297119,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7788952589035034},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7260805368423462},{"id":"https://openalex.org/keywords/extension","display_name":"Extension (predicate logic)","score":0.694553017616272},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.6478922367095947},{"id":"https://openalex.org/keywords/temporal-database","display_name":"Temporal database","score":0.5510047078132629},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5293912291526794},{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.45994043350219727},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.4441315233707428},{"id":"https://openalex.org/keywords/kernel","display_name":"Kernel (algebra)","score":0.41464677453041077},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41209617257118225},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.410513699054718},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3601694405078888},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.2284671664237976},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.16802912950515747},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.15993711352348328},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.14672639966011047},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.09581363201141357}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7788952589035034},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7260805368423462},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.694553017616272},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6478922367095947},{"id":"https://openalex.org/C77277458","wikidata":"https://www.wikidata.org/wiki/Q1969246","display_name":"Temporal database","level":2,"score":0.5510047078132629},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5293912291526794},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.45994043350219727},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.4441315233707428},{"id":"https://openalex.org/C74193536","wikidata":"https://www.wikidata.org/wiki/Q574844","display_name":"Kernel (algebra)","level":2,"score":0.41464677453041077},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41209617257118225},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.410513699054718},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3601694405078888},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2284671664237976},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.16802912950515747},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.15993711352348328},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.14672639966011047},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.09581363201141357},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s00778-005-0161-9","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s00778-005-0161-9","pdf_url":null,"source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":60,"referenced_works":["https://openalex.org/W19423796","https://openalex.org/W27949121","https://openalex.org/W131259011","https://openalex.org/W161989083","https://openalex.org/W1486187394","https://openalex.org/W1494315059","https://openalex.org/W1507944889","https://openalex.org/W1518766736","https://openalex.org/W1524409986","https://openalex.org/W1525406938","https://openalex.org/W1528103959","https://openalex.org/W1544752055","https://openalex.org/W1547485590","https://openalex.org/W1559231632","https://openalex.org/W1562735428","https://openalex.org/W1584754980","https://openalex.org/W1589223644","https://openalex.org/W1603321032","https://openalex.org/W1608357613","https://openalex.org/W1655554306","https://openalex.org/W1764866287","https://openalex.org/W1766171436","https://openalex.org/W1844476468","https://openalex.org/W1854128032","https://openalex.org/W1861141368","https://openalex.org/W1977662461","https://openalex.org/W2000654499","https://openalex.org/W2013277984","https://openalex.org/W2014590262","https://openalex.org/W2014765212","https://openalex.org/W2015612071","https://openalex.org/W2016125828","https://openalex.org/W2026180971","https://openalex.org/W2029243045","https://openalex.org/W2032521898","https://openalex.org/W2036351221","https://openalex.org/W2038230692","https://openalex.org/W2039734966","https://openalex.org/W2051666449","https://openalex.org/W2057520401","https://openalex.org/W2057807152","https://openalex.org/W2085827136","https://openalex.org/W2086916990","https://openalex.org/W2087022699","https://openalex.org/W2099397891","https://openalex.org/W2109464129","https://openalex.org/W2110788116","https://openalex.org/W2147270837","https://openalex.org/W2161109697","https://openalex.org/W2163571731","https://openalex.org/W2167679446","https://openalex.org/W2254374855","https://openalex.org/W2532754970","https://openalex.org/W3001482777","https://openalex.org/W4210602482","https://openalex.org/W4235053306","https://openalex.org/W4250336784","https://openalex.org/W6614357680","https://openalex.org/W6731711574","https://openalex.org/W6820072941"],"related_works":["https://openalex.org/W1980548249","https://openalex.org/W650213220","https://openalex.org/W1554917839","https://openalex.org/W4386768611","https://openalex.org/W2382973082","https://openalex.org/W7869049","https://openalex.org/W2340883001","https://openalex.org/W4312388085","https://openalex.org/W2884764431","https://openalex.org/W2086783690"],"abstract_inverted_index":null,"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":6}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}