{"id":"https://openalex.org/W2336099042","doi":null,"title":"A Novel Approach of Query Optimization for Distributed Database Systems","display_name":"A Novel Approach of Query Optimization for Distributed Database Systems","alternate_titles":[],"publication_year":2011,"publication_date":"2011-01-01","ids":{"openalex":"https://openalex.org/W2336099042","mag":"2336099042"},"language":"en","primary_location":{"id":"mag:2336099042","doi":null,"is_oa":false,"landing_page_url":"https://www.ijcsi.org/papers/IJCSI-8-4-1-307-312.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2336099042"],"child_works_count":0,"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/A5046540041","display_name":"Deepak Sukheja","orcid":"https://orcid.org/0000-0001-8809-5830","observed_orcids":["https://orcid.org/0000-0001-8809-5830"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Deepak Sukheja","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0001-8809-5830","affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5072674054","display_name":"Umesh Kumar Singh","orcid":"https://orcid.org/0000-0001-9120-4428","observed_orcids":["https://orcid.org/0000-0001-9120-4428"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Umesh Kumar Singh","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0001-9120-4428","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.3006,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.89246052,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":95},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.000699999975040555,"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.9879999756813049},{"id":"https://openalex.org/keywords/distributed-databases","display_name":"distributed databases","score":0.8769999742507935},{"id":"https://openalex.org/keywords/cost-based-optimization","display_name":"cost-based optimization","score":0.9589999914169312},{"id":"https://openalex.org/keywords/communication-overhead","display_name":"communication overhead","score":0.8140000104904175},{"id":"https://openalex.org/keywords/two-phase-optimization","display_name":"two-phase optimization","score":0.7570000290870667},{"id":"https://openalex.org/keywords/physical-database-design","display_name":"physical database design","score":0.8130000233650208},{"id":"https://openalex.org/keywords/search-space","display_name":"search space","score":0.4909999966621399}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8952111005783081},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7969084978103638},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.6257242560386658},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6065892577171326},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.47744327783584595},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.44982969760894775},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.38814547657966614},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38549530506134033},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.3403412997722626},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.32075315713882446},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1935044825077057},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.15808749198913574},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.1139160692691803},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0780879557132721},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"mag:2336099042","doi":null,"is_oa":false,"landing_page_url":"https://www.ijcsi.org/papers/IJCSI-8-4-1-307-312.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.402.6731","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.402.6731","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.ijcsi.org/papers/IJCSI-8-4-1-307-312.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W63365308","https://openalex.org/W1556076816","https://openalex.org/W1602423797","https://openalex.org/W2010495072","https://openalex.org/W2023195086","https://openalex.org/W2089634871","https://openalex.org/W2201552871","https://openalex.org/W2218458026"],"related_works":["https://openalex.org/W2135991133","https://openalex.org/W2123323016","https://openalex.org/W2762829074","https://openalex.org/W2083658209","https://openalex.org/W78616836","https://openalex.org/W2072321697","https://openalex.org/W2385423149","https://openalex.org/W2347107296","https://openalex.org/W2920388404","https://openalex.org/W1963638780"],"abstract_inverted_index":{"Query":[0],"optimization":[1,12,48,56,89,133,140,153,172,186],"in":[2,7,46,54,91,123,135,159,162,174],"distributed":[3,124,176],"databases":[4],"explicitly":[5],"needed":[6],"many":[8],"aspects":[9,137],"of":[10,38,61,77,138,150],"the":[11,19,36,43,47,59,80,88,100,112,129,139,163,175,194,201],"process,":[13],"often":[14],"making":[15],"it":[16],"imperative":[17],"for":[18,118,131],"optimizer":[20,70,122],"to":[21,79,200],"consult":[22],"underlying":[23],"data":[24,83],"sources":[25,84],"while":[26],"doing":[27],"cost":[28,37,53,102,146,148],"based":[29],"optimization.":[30],"This":[31,142],"is":[32,58,198],"not":[33],"only":[34,72],"increases":[35],"optimization,":[39],"but":[40],"also":[41],"changes":[42],"trade-offs":[44],"involved":[45],"process":[49,57],"significantly.":[50],"The":[51,69],"leading":[52],"this":[55,92,108,132],"\u201ccost":[60],"costing\u201d":[62],"that":[63,182],"traditionally":[64],"has":[65],"been":[66],"considered":[67],"insignificant.":[68],"can":[71],"afford":[73],"a":[74,119,169,183],"few":[75],"rounds":[76],"messages":[78],"under-":[81],"lying":[82],"and":[85,114,126,155],"he":[86],"nce":[87],"techniques":[90],"environment":[93,125],"must":[94],"be":[95],"geared":[96],"toward":[97],"gathering":[98],"all":[99],"required":[101],"information":[103],"with":[104],"minimal":[105],"communication.":[106],"In":[107],"paper,":[109],"we":[110],"explore":[111],"design":[113,197],"s":[115],"earch":[116],"space":[117],"que":[120],"ry":[121],"de":[127],"monstrate":[128],"need":[130],"approach":[134,173],"various":[136,151],"process.":[141],"work":[143],"present":[144,164],"minimumcommunication":[145],"query":[147,152],"variants":[149],"techniques,":[154],"di":[156],"scuss":[157],"tradeoffs":[158],"their":[160],"performance":[161],"development.":[165],"We":[166],"have":[167],"implemented":[168],"nov":[170],"el":[171],"database":[177,196],"environment,":[178],"somewhat":[179],"unexpectedly,":[180],"indicate":[181],"simple":[184],"two-phase":[185],"scheme":[187],"performs":[188],"fairly":[189],"well":[190],"as":[191,193],"long":[192],"physical":[195],"known":[199],"optimizer,":[202],"though":[203],"more":[204],"determined":[205],"algorithms":[206],"are":[207],"required.":[208]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2336099042","counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
