{"id":"https://openalex.org/W2014533148","doi":"https://doi.org/10.1007/s00236-007-0046-z","title":"View selection for real conjunctive queries","display_name":"View selection for real conjunctive queries","publication_year":2007,"publication_date":"2007-05-25","ids":{"openalex":"https://openalex.org/W2014533148","doi":"https://doi.org/10.1007/s00236-007-0046-z","mag":"2014533148"},"language":"en","primary_location":{"id":"doi:10.1007/s00236-007-0046-z","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s00236-007-0046-z","pdf_url":null,"source":{"id":"https://openalex.org/S84409463","display_name":"Acta Informatica","issn_l":"0001-5903","issn":["0001-5903","1432-0525"],"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":"Acta Informatica","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://doi.org/10.1007/s00236-007-0046-z","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5088568415","display_name":"Foto Afrati","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Foto Afrati","raw_affiliation_strings":["Department of Electrical and Computing Engineering, National Technical University of Athens (NTUA), 15773, Athens, Greece","National Technical University of Athens (NTUA), Department of Electrical and Computing Engineering, 15773, Athens, Greece#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical and Computing Engineering, National Technical University of Athens (NTUA), 15773, Athens, Greece","institution_ids":["https://openalex.org/I174458059"]},{"raw_affiliation_string":"National Technical University of Athens (NTUA), Department of Electrical and Computing Engineering, 15773, Athens, Greece#TAB#","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078910758","display_name":"Rada Chirkova","orcid":"https://orcid.org/0000-0003-4249-9690"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rada Chirkova","raw_affiliation_strings":["Computer Science Department, North Carolina State University, Campus Box 8206, Raleigh, NC, 27695-8206, USA","North Carolina State University, Computer Science Department, Campus Box 8206, 27695-8206, Raleigh, NC, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Science Department, North Carolina State University, Campus Box 8206, Raleigh, NC, 27695-8206, USA","institution_ids":["https://openalex.org/I137902535"]},{"raw_affiliation_string":"North Carolina State University, Computer Science Department, Campus Box 8206, 27695-8206, Raleigh, NC, USA","institution_ids":["https://openalex.org/I137902535"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061141406","display_name":"Manolis Gergatsoulis","orcid":"https://orcid.org/0000-0001-9744-5839"},"institutions":[{"id":"https://openalex.org/I187792471","display_name":"Ionian University","ror":"https://ror.org/01xm4n520","country_code":"GR","type":"education","lineage":["https://openalex.org/I187792471"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Manolis Gergatsoulis","raw_affiliation_strings":["Department of Archive and Library Sciences, Ionian University, Palea Anaktora, Plateia Eleftherias, 49100, Corfu, Greece","Ionian University, Department of Archive and Library Sciences, Campus Box 8206, Palea Anaktora, Plateia Eleftherias, 49100, Corfu, NC, Greece#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Archive and Library Sciences, Ionian University, Palea Anaktora, Plateia Eleftherias, 49100, Corfu, Greece","institution_ids":["https://openalex.org/I187792471"]},{"raw_affiliation_string":"Ionian University, Department of Archive and Library Sciences, Campus Box 8206, Palea Anaktora, Plateia Eleftherias, 49100, Corfu, NC, Greece#TAB#","institution_ids":["https://openalex.org/I187792471"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042065986","display_name":"Vassia Pavlaki","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Vassia Pavlaki","raw_affiliation_strings":["Department of Electrical and Computing Engineering, National Technical University of Athens (NTUA), 15773, Athens, Greece","National Technical University of Athens (NTUA), Department of Electrical and Computing Engineering, 15773, Athens, Greece#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical and Computing Engineering, National Technical University of Athens (NTUA), 15773, Athens, Greece","institution_ids":["https://openalex.org/I174458059"]},{"raw_affiliation_string":"National Technical University of Athens (NTUA), Department of Electrical and Computing Engineering, 15773, Athens, Greece#TAB#","institution_ids":["https://openalex.org/I174458059"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5061141406"],"corresponding_institution_ids":["https://openalex.org/I187792471"],"apc_list":{"value":2390,"currency":"EUR","value_usd":2990},"apc_paid":null,"fwci":1.0106,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.78824966,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"44","issue":"5","first_page":"289","last_page":"321"},"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.9998000264167786,"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.9998000264167786,"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.9995999932289124,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9951000213623047,"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/computer-science","display_name":"Computer science","score":0.7016469836235046},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5812311172485352},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.552136242389679},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.54893559217453},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5045393705368042},{"id":"https://openalex.org/keywords/result-set","display_name":"Result set","score":0.5014164447784424},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4945165812969208},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4553641676902771},{"id":"https://openalex.org/keywords/operational-semantics","display_name":"Operational semantics","score":0.4402173161506653},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.43661877512931824},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.43211230635643005},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4293321669101715},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4266253113746643},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.423772394657135},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.41221240162849426},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.3189541697502136},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2406717836856842},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.21586284041404724},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.20076021552085876},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.18062689900398254},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1431570053100586},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10452783107757568},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.0778246521949768},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.0773012638092041}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7016469836235046},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5812311172485352},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.552136242389679},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.54893559217453},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5045393705368042},{"id":"https://openalex.org/C4969071","wikidata":"https://www.wikidata.org/wiki/Q7316353","display_name":"Result set","level":3,"score":0.5014164447784424},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4945165812969208},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4553641676902771},{"id":"https://openalex.org/C156325763","wikidata":"https://www.wikidata.org/wiki/Q1930895","display_name":"Operational semantics","level":3,"score":0.4402173161506653},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.43661877512931824},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43211230635643005},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4293321669101715},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4266253113746643},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.423772394657135},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.41221240162849426},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.3189541697502136},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2406717836856842},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21586284041404724},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.20076021552085876},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.18062689900398254},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1431570053100586},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10452783107757568},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0778246521949768},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0773012638092041}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/s00236-007-0046-z","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s00236-007-0046-z","pdf_url":null,"source":{"id":"https://openalex.org/S84409463","display_name":"Acta Informatica","issn_l":"0001-5903","issn":["0001-5903","1432-0525"],"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":"Acta Informatica","raw_type":"journal-article"},{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/18505","is_oa":true,"landing_page_url":"http://doi.org/10.1007/s00236-007-0046-z","pdf_url":null,"source":{"id":"https://openalex.org/S4377196837","display_name":"DSpace - NTUA (National Technical University of Athens)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I174458059","host_organization_name":"National Technical University of Athens","host_organization_lineage":["https://openalex.org/I174458059"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Acta Informatica","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/18505","is_oa":true,"landing_page_url":"http://doi.org/10.1007/s00236-007-0046-z","pdf_url":null,"source":{"id":"https://openalex.org/S4377196837","display_name":"DSpace - NTUA (National Technical University of Athens)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I174458059","host_organization_name":"National Technical University of Athens","host_organization_lineage":["https://openalex.org/I174458059"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Acta Informatica","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W187851124","https://openalex.org/W201476034","https://openalex.org/W1482520531","https://openalex.org/W1483874328","https://openalex.org/W1520432709","https://openalex.org/W1538267625","https://openalex.org/W1562988957","https://openalex.org/W1569403765","https://openalex.org/W1581805425","https://openalex.org/W1605549034","https://openalex.org/W1977786400","https://openalex.org/W1979514837","https://openalex.org/W2027763082","https://openalex.org/W2048531653","https://openalex.org/W2049233281","https://openalex.org/W2097989803","https://openalex.org/W2111845378","https://openalex.org/W2112101330","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2122816893","https://openalex.org/W2143401113","https://openalex.org/W2160770337","https://openalex.org/W2163491591","https://openalex.org/W2251484078","https://openalex.org/W3215090778"],"related_works":["https://openalex.org/W2400172210","https://openalex.org/W175663584","https://openalex.org/W1593965959","https://openalex.org/W1592442835","https://openalex.org/W2128834514","https://openalex.org/W2179956029","https://openalex.org/W2903968032","https://openalex.org/W1973430024","https://openalex.org/W1973282744","https://openalex.org/W2099797738"],"abstract_inverted_index":null,"counts_by_year":[{"year":2014,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-19T15:47:20.252518","created_date":"2025-10-10T00:00:00"}