{"id":"https://openalex.org/W26359298","doi":null,"title":"Local and global query optimization mechanisms for relational databases","display_name":"Local and global query optimization mechanisms for relational databases","alternate_titles":[],"publication_year":1985,"publication_date":"1985-08-21","ids":{"openalex":"https://openalex.org/W26359298","mag":"26359298"},"language":"en","primary_location":{"id":"mag:26359298","doi":null,"is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb85.html#SatohTNO85","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W26359298"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":[],"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/A5108626567","display_name":"Kazuhiro Satoh","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Kazuhiro Satoh","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112217836","display_name":"Masashi Tsuchida","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Masashi Tsuchida","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Fumio Nakamura","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Fumio Nakamura","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5077040200","display_name":"\u4e00\u5f66 \u5927\u753a","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Kazuhiko Oomachi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2339,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.73743017,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"405","last_page":"417"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9961000084877014,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9961000084877014,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0013000000035390258,"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"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.00019999999494757503,"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/query-optimization","display_name":"query optimization","score":0.9940000176429749},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.8759999871253967},{"id":"https://openalex.org/keywords/cascade-method","display_name":"cascade method","score":0.8209999799728394},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.47099998593330383}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8738111257553101},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8275459408760071},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.7588378190994263},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6746044158935547},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.6098321080207825},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5831252336502075},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5662103891372681},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5464020371437073},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.49004805088043213},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.4555540978908539},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4255882203578949},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.42360052466392517},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3926863670349121},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2554280161857605},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2200830578804016},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.20961645245552063},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.07084843516349792},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.06585237383842468},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:26359298","doi":null,"is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb85.html#SatohTNO85","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G1484555822","display_name":"Core Grant for Vision Research","funder_award_id":"P30EY010608","funder_id":"https://openalex.org/F4320337350","funder_display_name":"National Eye Institute"},{"id":"https://openalex.org/G9000911930","display_name":"Regulation of Retinal Gap Junctions","funder_award_id":"R01EY012857","funder_id":"https://openalex.org/F4320337350","funder_display_name":"National Eye Institute"}],"funders":[{"id":"https://openalex.org/F4320337350","display_name":"National Eye Institute","ror":"https://ror.org/03wkg3b53"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W1485785467","https://openalex.org/W1976607278","https://openalex.org/W2012802704","https://openalex.org/W2020601345","https://openalex.org/W2026896584","https://openalex.org/W2039187793","https://openalex.org/W2047658315","https://openalex.org/W2073987830","https://openalex.org/W2091589574","https://openalex.org/W2111607006","https://openalex.org/W2116436709","https://openalex.org/W2133384222","https://openalex.org/W2147059765","https://openalex.org/W2153329411","https://openalex.org/W2167679350","https://openalex.org/W2412384313"],"related_works":["https://openalex.org/W7095345021","https://openalex.org/W1599681770","https://openalex.org/W136900661","https://openalex.org/W2026832881","https://openalex.org/W2277406869","https://openalex.org/W1499820067","https://openalex.org/W2904970222","https://openalex.org/W1485785467","https://openalex.org/W1528066211","https://openalex.org/W1562229368"],"abstract_inverted_index":{"In":[0],"a":[1,21,34,64,88,103],"relational":[2,65],"database":[3,112],"management":[4],"system":[5],"(DBMS),":[6],"query":[7,24],"optimization":[8,36,53,59,96,105,109],"is":[9],"essential":[10],"since":[11],"the":[12,27,42,52,92],"DBMS":[13,66],"must":[14],"produce":[15],"candidate":[16],"internal":[17],"access":[18,46,83],"strategies":[19,47],"from":[20],"high":[22],"level":[23],"and":[25,48,86],"select":[26],"optimal":[28,82],"one.":[29],"The":[30,70],"goals":[31],"of":[32,44,77],"inplementing":[33],"good":[35],"mechanism":[37,71],"are:":[38],"(a)":[39],"to":[40,50],"maximize":[41],"performance":[43],"selected":[45],"(b)":[49],"minimize":[51],"overhead.":[54],"We":[55],"have":[56],"developed":[57],"an":[58],"mechanisin,":[60],"built":[61],"it":[62],"in":[63,79],"product":[67],"at":[68],"Hitachi.":[69],"can":[72],"estimate":[73],"precise":[74],"tuple":[75],"selectivity":[76],"predicates":[78],"queries":[80],"for":[81,95],"strategy":[84],"selection,":[85],"employs":[87],"new":[89],"method,":[90,94],"called":[91],"cascade":[93],"overhead":[97],"reduction.":[98],"This":[99],"paper":[100],"also":[101],"proposes":[102],"global":[104],"mechanisn":[106],"which":[107],"executes":[108],"over":[110],"multiple":[111],"queries.":[113]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W26359298","counts_by_year":[{"year":2016,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
