{"id":"https://openalex.org/W1920644729","doi":null,"title":"Query Optimization in a Heterogeneous DBMS","display_name":"Query Optimization in a Heterogeneous DBMS","publication_year":1992,"publication_date":"1992-08-23","ids":{"openalex":"https://openalex.org/W1920644729","mag":"1920644729"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.178.6747","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.178.6747","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb.org/conf/1992/P277.PDF","raw_type":"text"},"volume":null,"type":"article","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/A5008630611","display_name":"Weimin Du","orcid":"https://orcid.org/0000-0003-3125-9122","observed_orcids":["https://orcid.org/0000-0003-3125-9122"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Weimin Du","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0003-3125-9122","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114073194","display_name":"Ravi Krishnamurthy","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ravi Krishnamurthy","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5114256308","display_name":"Ming-Chien Shan","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ming-Chien Shan","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":10.8033,"has_fulltext":false,"cited_by_count":148,"citation_normalized_percentile":{"value":0.97999183,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"277","last_page":"291"},"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.9970999956130981,"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.9970999956130981,"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.0006000000284984708,"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":9.999999747378752e-05,"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/heterogeneous-databases","display_name":"heterogeneous databases","score":0.8259999752044678},{"id":"https://openalex.org/keywords/ibm-db2","display_name":"DB2","score":0.9700000286102295},{"id":"https://openalex.org/keywords/informix","display_name":"Informix","score":0.7940000295639038}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8056984543800354},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7368699908256531},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6239997744560242},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4764987826347351},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43100547790527344},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.425326406955719},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3864371180534363},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33721208572387695},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1349853277206421}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.178.6747","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.178.6747","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb.org/conf/1992/P277.PDF","raw_type":"text"},{"id":"mag:1920644729","doi":null,"is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb92.html#DuKS92","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":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W166430344","https://openalex.org/W1489192275","https://openalex.org/W1545406293","https://openalex.org/W1552081212","https://openalex.org/W1945005351","https://openalex.org/W1979648938","https://openalex.org/W1995407428","https://openalex.org/W2112668678","https://openalex.org/W2153329411"],"related_works":["https://openalex.org/W1972387024","https://openalex.org/W4255174863","https://openalex.org/W2120080137","https://openalex.org/W2109118818","https://openalex.org/W2156647424","https://openalex.org/W2576841874","https://openalex.org/W7096510696","https://openalex.org/W2545191987","https://openalex.org/W1499820067","https://openalex.org/W70022965"],"abstract_inverted_index":{"We":[0,48],"propose":[1,128],"a":[2,82,93,97,129,200],"query":[3],"optimization":[4],"strategy":[5,14,73],"for":[6,233],"heterogeneous":[7],"DBMSs":[8,19,30,34,52],"that":[9,35,50,169],"extends":[10],"the":[11,43,65,72,77,86,107,112,116,140,144,151,174,176,203,217,231],"traditional":[12],"optimizer":[13],"widely":[15],"used":[16,110],"in":[17,170,216],"commercial":[18,160],"to":[20,37,63,75,89,138,237],"allow":[21],"execution":[22],"of":[23,71,115,122,142,150,173,186,202,205,226,230],"queries":[24],"over":[25],"both":[26],"known":[27],"(i.e.,":[28],"proprietary)":[29],"and":[31,55,119,165,167,188],"foreign":[32],"vendor":[33],"conform":[36],"some":[38],"standard":[39],"such":[40,104],"as":[41,92,96,105,137,199],"providing":[42],"usual":[44],"relational":[45],"database":[46,131,189,235],"statistics.":[47],"assume":[49],"participating":[51],"are":[53,228],"autonomous":[54],"may":[56,211],"not":[57,95],"be":[58,90],"able,":[59],"even":[60],"if":[61],"willing,":[62],"provide":[64],"cost":[66,145],"model":[67,146],"parameters.":[68],"The":[69],"novelty":[70],"is":[74,133,178],"deduce":[76],"necessary":[78],"information":[79],"by":[80,111],"calibrating":[81,130],"given":[83],"DBMS.":[84],"As":[85],"calibration":[87],"has":[88],"done":[91],"user,":[94],"system":[98],"administrator,":[99],"it":[100],"poses":[101],"unpredictability":[102,152],"problems":[103],"inferring":[106],"access":[108],"methods":[109],"DBMS,":[113],"idiosyncrasies":[114],"storage":[117],"subsystem":[118],"coincidental":[120],"clustering":[121],"data.":[123],"In":[124],"this":[125,155,209],"paper":[126],"we":[127,157],"which":[132],"synthetically":[134],"created":[135],"so":[136],"make":[139],"process":[141],"deducing":[143],"coefficients":[147],"reasonably":[148],"devoid":[149],"problems.":[153],"Using":[154],"procedure,":[156],"calibrate":[158],"three":[159],"DBMSs,":[161],"namely":[162],"Allbase,":[163],"DB2,":[164],"Informix,":[166],"observe":[168],"80":[171],"%":[172],"cases":[175],"estimate":[177],"quite":[179],"accurate.":[180],"1":[181],"Mot":[182],"ivat":[183],"ion":[184],"Heterogeneity":[185],"databases":[187],"management":[190],"systems":[191,236],"(DBMSs)":[192],"h":[193],"ave":[194],"gained":[195],"its":[196],"due":[197],"recognition":[198],"result":[201,212],"advent":[204],"open":[206],"systems.":[207],"Typically":[208],"heterogeneity":[210],"from":[213],"semantic":[214],"discrepancies":[215],"data,":[218],"multiple":[219],"data":[220],"models,":[221],"different":[222],"systems,":[223],"etc.":[224],"All":[225],"these":[227],"consequences":[229],"need":[232],"independent":[234],"interoperate":[238],"while":[239]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":3}],"updated_date":"2026-10-30T12:39:25.321706","created_date":"2016-06-24T00:00:00"}