{"id":"https://openalex.org/W2099623679","doi":"https://doi.org/10.1002/spe.4380190505","title":"A practical algorithm for evaluating database queries","display_name":"A practical algorithm for evaluating database queries","publication_year":1989,"publication_date":"1989-05-01","ids":{"openalex":"https://openalex.org/W2099623679","doi":"https://doi.org/10.1002/spe.4380190505","mag":"2099623679"},"language":"en","primary_location":{"id":"doi:10.1002/spe.4380190505","is_oa":false,"landing_page_url":"https://doi.org/10.1002/spe.4380190505","pdf_url":null,"source":{"id":"https://openalex.org/S122199241","display_name":"Software Practice and Experience","issn_l":"0038-0644","issn":["0038-0644","1097-024X"],"is_oa":false,"is_in_doaj":false,"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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software: Practice and Experience","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/A5097668306","display_name":"John H. M. De Vet","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"John H. M. De Vet","raw_affiliation_strings":["Institute for Perception Research (IPO), P.O. Box 513, 5600 MB Eindhoven, The Netherlands","Institute for Perception Research, Eindhoven, The Netherlands#TAB#"],"affiliations":[{"raw_affiliation_string":"Institute for Perception Research (IPO), P.O. Box 513, 5600 MB Eindhoven, The Netherlands","institution_ids":[]},{"raw_affiliation_string":"Institute for Perception Research, Eindhoven, The Netherlands#TAB#","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5097668306"],"corresponding_institution_ids":[],"apc_list":{"value":4220,"currency":"USD","value_usd":4220},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.18186096,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"19","issue":"5","first_page":"491","last_page":"504"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9995999932289124,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9972000122070312,"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.7743446826934814},{"id":"https://openalex.org/keywords/variable","display_name":"Variable (mathematics)","score":0.620643138885498},{"id":"https://openalex.org/keywords/expression","display_name":"Expression (computer science)","score":0.5719998478889465},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.568997323513031},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.5117201805114746},{"id":"https://openalex.org/keywords/directed-acyclic-graph","display_name":"Directed acyclic graph","score":0.4859084188938141},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4784809947013855},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.47310948371887207},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4011394679546356},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.38494873046875},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3209341764450073},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3076398968696594},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.17487892508506775}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7743446826934814},{"id":"https://openalex.org/C182365436","wikidata":"https://www.wikidata.org/wiki/Q50701","display_name":"Variable (mathematics)","level":2,"score":0.620643138885498},{"id":"https://openalex.org/C90559484","wikidata":"https://www.wikidata.org/wiki/Q778379","display_name":"Expression (computer science)","level":2,"score":0.5719998478889465},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.568997323513031},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.5117201805114746},{"id":"https://openalex.org/C74197172","wikidata":"https://www.wikidata.org/wiki/Q1195339","display_name":"Directed acyclic graph","level":2,"score":0.4859084188938141},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4784809947013855},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.47310948371887207},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4011394679546356},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.38494873046875},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3209341764450073},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3076398968696594},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.17487892508506775},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1002/spe.4380190505","is_oa":false,"landing_page_url":"https://doi.org/10.1002/spe.4380190505","pdf_url":null,"source":{"id":"https://openalex.org/S122199241","display_name":"Software Practice and Experience","issn_l":"0038-0644","issn":["0038-0644","1097-024X"],"is_oa":false,"is_in_doaj":false,"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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software: Practice and Experience","raw_type":"journal-article"},{"id":"pmh:oai:pure.tue.nl:openaire_cris_publications/6359e288-011f-4545-bcba-4b2f5a4bf3f8","is_oa":false,"landing_page_url":"https://research.tue.nl/en/publications/6359e288-011f-4545-bcba-4b2f5a4bf3f8","pdf_url":null,"source":{"id":"https://openalex.org/S4406922641","display_name":"TU/e Research Portal","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":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"de Vet, J H M 1989, 'Practical algorithm for evaluating database queries', Software : Practice and Experience, vol. 19, no. 5, pp. 491-504. https://doi.org/10.1002/spe.4380190505","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:pure.tue.nl:publications/6359e288-011f-4545-bcba-4b2f5a4bf3f8","is_oa":false,"landing_page_url":"http://www.scopus.com/inward/record.url?scp=0024665272&partnerID=8YFLogxK","pdf_url":null,"source":{"id":"https://openalex.org/S4406922641","display_name":"TU/e Research Portal","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"de Vet, J H M 1989, 'Practical algorithm for evaluating database queries', Software : Practice and Experience, vol. 19, no. 5, pp. 491-504. https://doi.org/10.1002/spe.4380190505","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:tue:oai:pure.tue.nl:publications/6359e288-011f-4545-bcba-4b2f5a4bf3f8","is_oa":false,"landing_page_url":"https://research.tue.nl/nl/publications/6359e288-011f-4545-bcba-4b2f5a4bf3f8","pdf_url":null,"source":{"id":"https://openalex.org/S4306401843","display_name":"Data Archiving and Networked Services (DANS)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1322597698","host_organization_name":"Royal Netherlands Academy of Arts and Sciences","host_organization_lineage":["https://openalex.org/I1322597698"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Software : Practice and Experience, 19(5), 491 - 504. Wiley","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W147900504","https://openalex.org/W612375141","https://openalex.org/W1491178396","https://openalex.org/W1496815773","https://openalex.org/W1499457203","https://openalex.org/W1509104740","https://openalex.org/W1543641760","https://openalex.org/W1997320166","https://openalex.org/W2047658315","https://openalex.org/W2048001632","https://openalex.org/W2063650855","https://openalex.org/W2092842298","https://openalex.org/W2167679350","https://openalex.org/W3210025416","https://openalex.org/W4249360996","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W584886505","https://openalex.org/W1502610062","https://openalex.org/W1989645082","https://openalex.org/W2607324466","https://openalex.org/W2140379930","https://openalex.org/W2027162968","https://openalex.org/W3162115094","https://openalex.org/W2168681435","https://openalex.org/W2354016879","https://openalex.org/W2379294600"],"abstract_inverted_index":{"Abstract":[0],"This":[1],"paper":[2],"describes":[3],"an":[4],"algorithm":[5,33],"for":[6],"evaluating":[7],"database":[8,19,91],"queries":[9],"represented":[10],"as":[11,67],"expressions":[12],"in":[13,96],"a":[14,18,68],"logical":[15],"language.":[16],"Such":[17],"query":[20],"expression":[21,63,87],"can":[22],"be":[23],"evaluated":[24],"efficiently":[25],"by":[26,57],"focusing":[27],"on":[28],"the":[29,36,42,79,85,97],"variable":[30,59],"dependencies.":[31],"The":[32,61],"recursively":[34],"computes":[35],"values":[37,53],"of":[38,49,78,84],"subexpressions":[39,51],"to":[40,75],"evaluate":[41],"input":[43,62,86],"expression,":[44],"but":[45],"it":[46],"avoids":[47],"re\u2010evaluation":[48],"those":[50],"whose":[52],"are":[54,81],"not":[55],"affected":[56],"new":[58],"assignments.":[60],"is":[64,103],"internally":[65],"structured":[66],"directed":[69],"acyclic":[70],"graph.":[71],"Two":[72],"additional":[73],"techniques":[74],"improve":[76],"efficiency":[77],"evaluation":[80],"discussed:":[82],"transformations":[83],"and":[88],"special":[89],"primitive":[90],"operations.":[92],"Finally,":[93],"its":[94],"implementation":[95],"natural":[98],"language":[99],"question\u2010answering":[100],"system":[101],"SPICOS":[102],"described.":[104]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}