{"id":"https://openalex.org/W2928775409","doi":"https://doi.org/10.1109/acit.2018.8672584","title":"Optimizing Database Query Performance Using Table Partitioning Techniques","display_name":"Optimizing Database Query Performance Using Table Partitioning Techniques","alternate_titles":[],"publication_year":2018,"publication_date":"2018-11-01","ids":{"openalex":"https://openalex.org/W2928775409","doi":"https://doi.org/10.1109/acit.2018.8672584","mag":"2928775409"},"language":"en","primary_location":{"id":"doi:10.1109/acit.2018.8672584","doi":"https://doi.org/10.1109/acit.2018.8672584","is_oa":false,"landing_page_url":"https://doi.org/10.1109/acit.2018.8672584","pdf_url":null,"source":{"id":"https://openalex.org/S4363608405","display_name":"International Arab Conference on Information Technology (ACIT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 International Arab Conference on Information Technology (ACIT)","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W2928775409"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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/A5000141500","display_name":"Khaled Saleh Maabreh","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I153687341","display_name":"Zarqa University","ror":"https://ror.org/01wf1es90","country_code":"JO","type":"education","lineage":["https://openalex.org/I153687341"]}],"countries":["JO"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Khaled Saleh Maabreh","raw_affiliation_strings":["Faculty of Information Technology, Zarqa University, Zarqa, Jordan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Information Technology, Zarqa University, Zarqa, Jordan","institution_ids":["https://openalex.org/I153687341"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5000141500"],"corresponding_institution_ids":["https://openalex.org/I153687341"],"apc_list":null,"apc_paid":null,"fwci":0.3005,"has_fulltext":false,"cited_by_count":9,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.45964145,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"4"},"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.9965999722480774,"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.9965999722480774,"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.0017999999690800905,"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/T10101","display_name":"Cloud Computing and Resource Management","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/table-partitioning","display_name":"table partitioning","score":0.9570000171661377},{"id":"https://openalex.org/keywords/database-query-performance","display_name":"database query performance","score":0.8059999942779541},{"id":"https://openalex.org/keywords/performance-optimization","display_name":"performance optimization","score":0.8019999861717224},{"id":"https://openalex.org/keywords/large-databases","display_name":"large databases","score":0.7820000052452087},{"id":"https://openalex.org/keywords/query-execution-time","display_name":"query execution time","score":0.9909999966621399},{"id":"https://openalex.org/keywords/data-management","display_name":"data management","score":0.5649999976158142}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8588382005691528},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.8174074292182922},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.6487941145896912},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.633089542388916},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5751476287841797},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.5553127527236938},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49611935019493103},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4835965037345886},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.46443280577659607},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4590548276901245},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4301915168762207},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.41210055351257324},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3318353295326233},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.26552528142929077},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.25500166416168213},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.16052404046058655},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.1569846272468567},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.1368149220943451}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/acit.2018.8672584","doi":"https://doi.org/10.1109/acit.2018.8672584","is_oa":false,"landing_page_url":"https://doi.org/10.1109/acit.2018.8672584","pdf_url":null,"source":{"id":"https://openalex.org/S4363608405","display_name":"International Arab Conference on Information Technology (ACIT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 International Arab Conference on Information Technology (ACIT)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W123776386","https://openalex.org/W1997375126","https://openalex.org/W2040428289","https://openalex.org/W2201003025","https://openalex.org/W2234423489","https://openalex.org/W2402749458","https://openalex.org/W2574177527","https://openalex.org/W2766459655"],"related_works":["https://openalex.org/W2574177527","https://openalex.org/W7166856796","https://openalex.org/W2016571757","https://openalex.org/W3090554509","https://openalex.org/W2871250688","https://openalex.org/W3102850653","https://openalex.org/W7004834276","https://openalex.org/W4413394287","https://openalex.org/W2795276609","https://openalex.org/W4254156409"],"abstract_inverted_index":{"Database":[0],"performance":[1,81,98],"is":[2,25,71],"a":[3,44,112],"primary":[4,19],"branch":[5],"of":[6,15,21,58,68,82,99],"information":[7],"technology":[8],"which":[9,101,123],"deals":[10],"with":[11,32],"the":[12,16,22,28,49,55,74,80,97,116],"proper":[13],"management":[14,24],"database.":[17,134],"The":[18,65,88,105],"goal":[20],"data":[23,59,75,93,109],"to":[26,37,72,85,127],"provide":[27],"organizations":[29],"daily":[30,61],"routines":[31],"powerful":[33],"applications":[34],"that":[35,92,108],"have":[36],"be":[38],"run":[39],"efficiently.":[40],"Performance":[41],"optimization":[42],"has":[43,111],"critical":[45],"role":[46],"in":[47,78,120],"improving":[48],"database":[50,129],"usage.":[51],"In":[52],"particular,":[53],"managing":[54],"massive":[56,103],"amount":[57],"generated":[60],"by":[62],"various":[63],"users.":[64],"main":[66],"target":[67],"this":[69],"research":[70],"evaluate":[73],"partitioning":[76,94,110],"technique":[77],"enhancing":[79],"quires":[83],"submitted":[84],"large":[86],"databases.":[87,104],"encouraging":[89],"results":[90],"show":[91],"could":[95],"improve":[96],"DBMS":[100],"manages":[102],"experiments":[106],"reveal":[107],"remarkable":[113],"impact":[114],"on":[115],"query":[117],"execution":[118],"time":[119],"big":[121],"databases,":[122],"exceeds":[124],"35%":[125],"compared":[126],"small":[128],"size":[130],"or":[131],"not":[132],"partitioned":[133]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2928775409","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":2}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2019-04-11T00:00:00"}
