{"id":"https://openalex.org/W2087927750","doi":"https://doi.org/10.1145/1282480.1282531","title":"Query execution and index selection for relational data bases","display_name":"Query execution and index selection for relational data bases","publication_year":1975,"publication_date":"1975-01-01","ids":{"openalex":"https://openalex.org/W2087927750","doi":"https://doi.org/10.1145/1282480.1282531","mag":"2087927750"},"language":"en","primary_location":{"id":"doi:10.1145/1282480.1282531","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1282480.1282531","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st International Conference on Very Large Data Bases - VLDB '75","raw_type":"proceedings-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/A5032385370","display_name":"Gilles Farley","orcid":null},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Gilles Farley","raw_affiliation_strings":["University of Toronto, Toronto, Ontario, Canada","* University of Toronto, Toronto, Ontario, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto, Toronto, Ontario, Canada","institution_ids":["https://openalex.org/I185261750"]},{"raw_affiliation_string":"* University of Toronto, Toronto, Ontario, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002830624","display_name":"S. A. Schuster","orcid":null},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Stewart A. Schuster","raw_affiliation_strings":["University of Toronto, Toronto, Ontario, Canada","* University of Toronto, Toronto, Ontario, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto, Toronto, Ontario, Canada","institution_ids":["https://openalex.org/I185261750"]},{"raw_affiliation_string":"* University of Toronto, Toronto, Ontario, Canada","institution_ids":["https://openalex.org/I185261750"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I185261750"],"apc_list":null,"apc_paid":null,"fwci":5.7412,"has_fulltext":false,"cited_by_count":18,"citation_normalized_percentile":{"value":0.96049005,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"519","last_page":"519"},"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.9987999796867371,"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.9987999796867371,"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.9891999959945679,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9836999773979187,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/inverted-index","display_name":"Inverted index","score":0.766423225402832},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7380353212356567},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6597073078155518},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6396949291229248},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.6007983088493347},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.5347615480422974},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.46019247174263},{"id":"https://openalex.org/keywords/sample","display_name":"Sample (material)","score":0.45337435603141785},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4461195468902588},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.428719162940979},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.42299988865852356},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.4185994267463684},{"id":"https://openalex.org/keywords/selection-algorithm","display_name":"Selection algorithm","score":0.4157770276069641},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.41256505250930786},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.18524819612503052},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1444176435470581},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.1051064133644104}],"concepts":[{"id":"https://openalex.org/C130590232","wikidata":"https://www.wikidata.org/wiki/Q1671754","display_name":"Inverted index","level":3,"score":0.766423225402832},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7380353212356567},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6597073078155518},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6396949291229248},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.6007983088493347},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.5347615480422974},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.46019247174263},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.45337435603141785},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4461195468902588},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.428719162940979},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.42299988865852356},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4185994267463684},{"id":"https://openalex.org/C2775973920","wikidata":"https://www.wikidata.org/wiki/Q3252726","display_name":"Selection algorithm","level":3,"score":0.4157770276069641},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.41256505250930786},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.18524819612503052},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1444176435470581},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.1051064133644104},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","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/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1282480.1282531","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1282480.1282531","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1st International Conference on Very Large Data Bases - VLDB '75","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2124379162","https://openalex.org/W4234874385","https://openalex.org/W1585007175","https://openalex.org/W2805651586","https://openalex.org/W1604458106","https://openalex.org/W2382521049","https://openalex.org/W2970215257","https://openalex.org/W2104956440","https://openalex.org/W2323648130","https://openalex.org/W2154613491"],"abstract_inverted_index":{"An":[0],"algorithm":[1,18,61,152],"to":[2,23,32,58,75,88,95,100,109],"evaluate":[3],"primitive":[4],"Boolean":[5],"selections":[6,47],"over":[7,48],"single":[8],"relations":[9],"is":[10,19,42,56,148],"presented.":[11],"It":[12],"will":[13],"be":[14,73,96,101],"argued":[15],"that":[16],"the":[17,24,33,60,63,83,90,93,134,139,151],"efficient":[20,65],"with":[21,30,107,121],"respect":[22,31,108],"number":[25],"of":[26,35,85,92,114,124,141,145],"relational":[27],"accesses":[28],"and":[29,131],"merging":[34],"inverted":[36,50,102,146],"lists.":[37,156],"The":[38,68,98],"algorithm's":[39],"unique":[40],"quality":[41],"its":[43,77],"efficiency":[44],"in":[45,133],"evaluating":[46],"partially":[49],"relations.":[51],"A":[52],"simple":[53],"cost":[54,69],"function":[55,70],"used":[57,74],"drive":[59],"along":[62],"most":[64],"access":[66],"paths.":[67],"can":[71],"also":[72],"predict":[76],"response":[78],"time":[79],"which":[80,153],"then":[81],"forms":[82],"basis":[84],"a":[86,112,117,142],"procedure":[87],"suboptimize":[89],"selection":[91,140],"domains":[94,99],"inverted.":[97],"are":[103],"selected":[104],"by":[105],"analyzing,":[106],"their":[110],"costs,":[111],"sample":[113],"queries.":[115],"Such":[116],"method":[118],"does":[119],"away":[120],"usual":[122],"methods":[123],"updating":[125],"usage":[126],"counters":[127],"for":[128],"every":[129],"domain":[130],"relation":[132],"system.":[135],"In":[136],"this":[137],"approach,":[138],"good":[143],"set":[144],"lists":[147],"based":[149],"on":[150],"uses":[154],"those":[155]},"counts_by_year":[{"year":2020,"cited_by_count":1}],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}