{"id":"https://openalex.org/W2152541844","doi":"https://doi.org/10.1109/icdew.2007.4401030","title":"Towards Adaptive Costing of Database Access Methods","display_name":"Towards Adaptive Costing of Database Access Methods","publication_year":2007,"publication_date":"2007-04-01","ids":{"openalex":"https://openalex.org/W2152541844","doi":"https://doi.org/10.1109/icdew.2007.4401030","mag":"2152541844"},"language":"en","primary_location":{"id":"doi:10.1109/icdew.2007.4401030","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2007.4401030","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering Workshop","raw_type":"proceedings-article"},"type":"conference-paper","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/A5100654753","display_name":"Qin Ye","orcid":"https://orcid.org/0000-0001-7842-4397"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ye Qin","raw_affiliation_strings":["David R. Cheriton School of Computer Science, University of Waterloo, Waterloo, ONT, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"David R. Cheriton School of Computer Science, University of Waterloo, Waterloo, ONT, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035977189","display_name":"Kenneth Salem","orcid":"https://orcid.org/0000-0003-0409-9725"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Kenneth Salem","raw_affiliation_strings":["David R. Cheriton School of Computer Science, University of Waterloo, Waterloo, ONT, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"David R. Cheriton School of Computer Science, University of Waterloo, Waterloo, ONT, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103358763","display_name":"Anil K. Goel","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anil K Goel","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.8935,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.87316879,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"469","last_page":"477"},"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.9997000098228455,"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.9997000098228455,"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.9976999759674072,"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/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9768000245094299,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8416771292686462},{"id":"https://openalex.org/keywords/activity-based-costing","display_name":"Activity-based costing","score":0.7311041355133057},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6551720499992371},{"id":"https://openalex.org/keywords/cost-estimate","display_name":"Cost estimate","score":0.6395968794822693},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5400906205177307},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5370214581489563},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5048542618751526},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.46208593249320984},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4360671043395996},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.2578117847442627},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.21727964282035828},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.19854068756103516},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.18680128455162048},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.16159269213676453}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8416771292686462},{"id":"https://openalex.org/C164624739","wikidata":"https://www.wikidata.org/wiki/Q754331","display_name":"Activity-based costing","level":2,"score":0.7311041355133057},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6551720499992371},{"id":"https://openalex.org/C93983250","wikidata":"https://www.wikidata.org/wiki/Q795053","display_name":"Cost estimate","level":2,"score":0.6395968794822693},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5400906205177307},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5370214581489563},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5048542618751526},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.46208593249320984},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4360671043395996},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.2578117847442627},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21727964282035828},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.19854068756103516},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.18680128455162048},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.16159269213676453},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/icdew.2007.4401030","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2007.4401030","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering Workshop","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.419.1540","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.419.1540","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://ccs.njit.edu/inst/source/06SMDS10.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.541.9393","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.541.9393","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://cs.uwaterloo.ca/~kmsalem/pubs/QinSalemGoelSMDB07.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6600000262260437,"display_name":"No poverty","id":"https://metadata.un.org/sdg/1"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1596568456","https://openalex.org/W1606789201","https://openalex.org/W1964374591","https://openalex.org/W1968829657","https://openalex.org/W2007069074","https://openalex.org/W2035622347","https://openalex.org/W2040892657","https://openalex.org/W2113124441","https://openalex.org/W2118130633","https://openalex.org/W2122949840","https://openalex.org/W2151310484","https://openalex.org/W2171048836","https://openalex.org/W4245279681","https://openalex.org/W6635797705"],"related_works":["https://openalex.org/W2249768123","https://openalex.org/W4361194359","https://openalex.org/W3125756434","https://openalex.org/W1971797742","https://openalex.org/W2941854747","https://openalex.org/W2992414350","https://openalex.org/W1943557536","https://openalex.org/W2611817341","https://openalex.org/W2168708570","https://openalex.org/W2294818385"],"abstract_inverted_index":{"Most":[0],"database":[1,40],"query":[2,10,20,80],"optimizers":[3,21],"use":[4,92],"cost":[5,16,58,74,98],"models":[6,17,59],"to":[7,22,82,101],"identify":[8],"good":[9],"execution":[11],"plans.":[12,25],"Inaccuracies":[13],"in":[14,86],"the":[15,31,36,79,91],"can":[18,60,77],"cause":[19,78],"select":[23],"poor":[24],"In":[26],"this":[27],"paper,":[28],"we":[29],"consider":[30],"problem":[32],"of":[33,39,93],"accurately":[34],"estimating":[35],"I/O":[37,57],"costs":[38],"access":[41],"methods,":[42],"such":[43],"as":[44],"index":[45],"scans.":[46],"We":[47,64,89],"present":[48,66],"some":[49],"experimental":[50],"results":[51],"which":[52,70],"show":[53],"that":[54,72],"existing":[55],"analytical":[56],"be":[61],"very":[62],"inaccurate.":[63],"also":[65],"a":[67],"simple":[68],"analysis":[69],"shows":[71],"larger":[73,84],"estimation":[75,99],"errors":[76],"optimizer":[81],"make":[83],"mistakes":[85],"plan":[87],"selection.":[88],"propose":[90],"an":[94],"adaptive":[95],"black-box":[96],"statistical":[97],"methodology":[100],"achieve":[102],"better":[103],"estimates.":[104]},"counts_by_year":[{"year":2016,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}