{"id":"https://openalex.org/W2761892930","doi":"https://doi.org/10.1504/ijbis.2017.10008186","title":"Performance optimisation of the decision-support queries by the horizontal fragmentation of the data warehouse","display_name":"Performance optimisation of the decision-support queries by the horizontal fragmentation of the data warehouse","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W2761892930","doi":"https://doi.org/10.1504/ijbis.2017.10008186","mag":"2761892930"},"language":"en","primary_location":{"id":"doi:10.1504/ijbis.2017.10008186","is_oa":false,"landing_page_url":"https://doi.org/10.1504/ijbis.2017.10008186","pdf_url":null,"source":{"id":"https://openalex.org/S146555279","display_name":"International Journal of Business Information Systems","issn_l":"1746-0972","issn":["1746-0972","1746-0980"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310317825","host_organization_name":"Inderscience Publishers","host_organization_lineage":["https://openalex.org/P4310317825"],"host_organization_lineage_names":["Inderscience Publishers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Business Information Systems","raw_type":"journal-article"},"type":"article","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/A5038443663","display_name":"Safia Nait Bahloul","orcid":"https://orcid.org/0009-0009-5695-4923"},"institutions":[{"id":"https://openalex.org/I137407579","display_name":"Universit\u00e9 Oran 1 Ahmed Ben Bella","ror":"https://ror.org/059et2b68","country_code":"DZ","type":"education","lineage":["https://openalex.org/I137407579"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Safia Nait Bahloul","raw_affiliation_strings":["Lab. LITIO, University of Oran1, Ahmed Ben Bella, Algeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lab. LITIO, University of Oran1, Ahmed Ben Bella, Algeria","institution_ids":["https://openalex.org/I137407579"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5075537686","display_name":"Mohamed Kechar","orcid":"https://orcid.org/0000-0002-5350-8516"},"institutions":[{"id":"https://openalex.org/I137407579","display_name":"Universit\u00e9 Oran 1 Ahmed Ben Bella","ror":"https://ror.org/059et2b68","country_code":"DZ","type":"education","lineage":["https://openalex.org/I137407579"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Mohamed Kechar","raw_affiliation_strings":["Lab. LITIO, University of Oran1, Ahmed Ben Bella, Algeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lab. LITIO, University of Oran1, Ahmed Ben Bella, Algeria","institution_ids":["https://openalex.org/I137407579"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I137407579"],"apc_list":null,"apc_paid":null,"fwci":0.496,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.75149183,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"26","issue":"4","first_page":"506","last_page":"506"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9958000183105469,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9958000183105469,"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/T11719","display_name":"Data Quality and Management","score":0.9955000281333923,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9932000041007996,"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/fragmentation","display_name":"Fragmentation (computing)","score":0.7469021677970886},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.7333192825317383},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6852431297302246},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5703771114349365},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5100115537643433},{"id":"https://openalex.org/keywords/binary-decision-diagram","display_name":"Binary decision diagram","score":0.4831685423851013},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4483286142349243},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.44379132986068726},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.44242170453071594},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.43613535165786743},{"id":"https://openalex.org/keywords/decision-table","display_name":"Decision table","score":0.429193377494812},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.24897438287734985},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14839118719100952},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.07286256551742554}],"concepts":[{"id":"https://openalex.org/C191015642","wikidata":"https://www.wikidata.org/wiki/Q1132459","display_name":"Fragmentation (computing)","level":2,"score":0.7469021677970886},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.7333192825317383},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6852431297302246},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5703771114349365},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5100115537643433},{"id":"https://openalex.org/C3309909","wikidata":"https://www.wikidata.org/wiki/Q864155","display_name":"Binary decision diagram","level":2,"score":0.4831685423851013},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4483286142349243},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.44379132986068726},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.44242170453071594},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.43613535165786743},{"id":"https://openalex.org/C172967692","wikidata":"https://www.wikidata.org/wiki/Q747762","display_name":"Decision table","level":3,"score":0.429193377494812},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.24897438287734985},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14839118719100952},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.07286256551742554},{"id":"https://openalex.org/C111012933","wikidata":"https://www.wikidata.org/wiki/Q3137210","display_name":"Rough set","level":2,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1504/ijbis.2017.10008186","is_oa":false,"landing_page_url":"https://doi.org/10.1504/ijbis.2017.10008186","pdf_url":null,"source":{"id":"https://openalex.org/S146555279","display_name":"International Journal of Business Information Systems","issn_l":"1746-0972","issn":["1746-0972","1746-0980"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310317825","host_organization_name":"Inderscience Publishers","host_organization_lineage":["https://openalex.org/P4310317825"],"host_organization_lineage_names":["Inderscience Publishers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Business Information Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.800000011920929,"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2073713056","https://openalex.org/W3110702597","https://openalex.org/W2125620709","https://openalex.org/W2110441383","https://openalex.org/W4233149903","https://openalex.org/W2326878701","https://openalex.org/W4293864700","https://openalex.org/W2045932760","https://openalex.org/W2359230757","https://openalex.org/W2535242978"],"abstract_inverted_index":{"The":[0],"horizontal":[1],"fragmentation":[2,123],"of":[3,11,17,31,42,52,60,81,106,121,132],"the":[4,12,18,27,32,40,43,50,53,62,79,82,88,98,104,107,119,128,140],"data":[5,29],"warehouse":[6],"is":[7,23,35],"considered":[8],"as":[9],"one":[10],"important":[13],"performance":[14],"optimisation":[15,22],"techniques":[16],"decision-support":[19,89],"queries.":[20],"This":[21],"reached":[24],"only":[25,97],"if":[26],"large":[28],"volume":[30],"fact":[33,44,99],"table":[34,45,100],"horizontally":[36,96],"fragmented.":[37],"For":[38],"that,":[39],"fragments":[41,51,63,83],"are":[46],"always":[47],"derived":[48],"from":[49],"dimension":[54],"tables.":[55],"Unfortunately,":[56],"in":[57],"this":[58],"type":[59],"fragmentation,":[61],"number":[64,80],"can":[65],"dramatically":[66],"increase,":[67],"and":[68,74,84,113],"their":[69,110,114],"maintenance":[70],"becomes":[71],"quite":[72],"hard":[73],"costly.":[75],"Thus,":[76],"to":[77,85,94],"reduce":[78],"further":[86],"optimise":[87],"queries":[90],"performances,":[91],"we":[92,125],"propose":[93],"fragment":[95],"by":[101],"exploiting":[102],"jointly:":[103],"selectivities":[105],"selection":[108],"predicates,":[109],"occurrence":[111],"numbers,":[112],"access":[115],"frequencies.":[116],"To":[117],"prove":[118],"effectiveness":[120],"our":[122],"technique,":[124],"present":[126],"at":[127],"end,":[129],"a":[130],"set":[131],"experimental":[133],"results":[134],"conducted":[135],"under":[136],"Oracle":[137],"10g":[138],"on":[139],"APB-1":[141],"benchmark.":[142]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}