{"id":"https://openalex.org/W2400883540","doi":"https://doi.org/10.3233/978-1-61499-161-8-71","title":"Combining Data Mining Technique and Query Frequencies for Automatic Selection of Indexes in Data Warehouses","display_name":"Combining Data Mining Technique and Query Frequencies for Automatic Selection of Indexes in Data Warehouses","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W2400883540","doi":"https://doi.org/10.3233/978-1-61499-161-8-71","mag":"2400883540"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-161-8-71","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-161-8-71","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"},"type":"book-chapter","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/A5073785860","display_name":"Benameur Ziani","orcid":"https://orcid.org/0000-0003-1176-4631"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ziani Benameur","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5085494766","display_name":"Youcef Ouinten","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ouinten Youcef","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":1.1538,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.81746214,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"71","last_page":"83"},"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.9901000261306763,"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.9901000261306763,"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.9211999773979187,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7224797606468201},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6745564937591553},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6355653405189514},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.586259126663208},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4359167814254761},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36041343212127686},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.16665342450141907}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7224797606468201},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6745564937591553},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6355653405189514},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.586259126663208},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4359167814254761},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36041343212127686},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.16665342450141907}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3233/978-1-61499-161-8-71","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-161-8-71","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"},{"id":"mag:2400883540","is_oa":false,"landing_page_url":"http://dblp.uni-trier.de/db/conf/balt/dbis2012.html#ZianiO12","pdf_url":null,"source":{"id":"https://openalex.org/S4306507590","display_name":"DB&IS","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"DB&IS","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2099525665","https://openalex.org/W2373884155","https://openalex.org/W4200307027","https://openalex.org/W2531755459","https://openalex.org/W6138692","https://openalex.org/W3167309973","https://openalex.org/W2359411520","https://openalex.org/W2543282246","https://openalex.org/W1980959743","https://openalex.org/W1535822977"],"abstract_inverted_index":{"Index":[0],"selection":[1,78,119,245],"is":[2,12,38,142],"an":[3,15,239],"important":[4],"part":[5],"of":[6,18,36,65,86,93,133,138,153,171,192,212,233,258,274],"physical":[7],"database":[8],"design.":[9],"Its":[10],"goal":[11],"to":[13,20,42,112,145,148,207,221,229],"select":[14],"appropriate":[16],"set":[17,257],"indexes":[19,37,50,77,134],"minimize":[21],"the":[22,63,74,87,91,102,114,118,149,164,184,190,197,200,209,231,243,251,267,272,275],"cost":[23],"for":[24,49,117,167,180,254],"a":[25,33,39,66,130,136,193,203],"given":[26,194],"workload":[27,185,204],"under":[28],"storage":[29,157,268],"constraint.":[30],"However,":[31],"selecting":[32],"suitable":[34],"configuration":[35],"difficult":[40,144],"problem":[41,45,79],"solve.":[43],"The":[44],"becomes":[46],"more":[47,68],"complex":[48],"defined":[51],"on":[52,82],"multiple":[53],"tables":[54],"such":[55],"as":[56],"bitmap":[57,75],"join":[58,76],"indexes,":[59],"since":[60],"it":[61,141],"requires":[62],"exploration":[64],"much":[67],"search":[69,88,115],"space.":[70],"Studies":[71],"dealing":[72],"with":[73,135],"mainly":[80],"focused":[81],"proposing":[83],"pruning":[84],"solutions":[85],"space":[89,116,158,269],"by":[90],"means":[92],"data":[94,103],"mining":[95,104,168,255],"techniques":[96],"or":[97],"heuristic":[98],"approaches.":[99],"So":[100],"far,":[101],"based":[105],"approaches":[106,122],"have":[107,123,174,208],"used":[108,175],"closed":[109],"frequent":[110,169,224,256],"itemsets":[111,225],"reduce":[113],"process.":[120],"These":[121],"two":[124],"notable":[125],"shortcomings.":[126],"Firstly,":[127],"they":[128,162,173],"generate":[129],"huge":[131],"number":[132],"lot":[137],"redundancy":[139],"that":[140,241,263],"very":[143],"manage":[146],"according":[147],"system":[150],"limitation":[151],"(number":[152],"Indexes":[154],"per":[155],"table,":[156],"constraint).":[159],"Secondly,":[160],"when":[161],"construct":[163],"extraction":[165,252],"context":[166,253],"sets":[170],"attributes,":[172],"indexable":[176],"attributes":[177],"only":[178],"once":[179],"each":[181],"query":[182,195,227,248],"in":[183,196,202,250],"which":[186],"does":[187],"not":[188],"reflect":[189],"importance":[191],"workload.":[198],"Indeed,":[199],"queries":[201],"are":[205],"unlikely":[206],"same":[210],"probability":[211],"being":[213],"requested.":[214],"To":[215],"overcome":[216],"these":[217],"imitations,":[218],"we":[219],"propose":[220],"combine":[222],"maximal":[223],"and":[226,270],"frequencies":[228,249],"improve":[230],"quality":[232,273],"generated":[234],"indexes.":[235,277],"This":[236],"paper":[237],"describes":[238],"approach":[240,265],"refines":[242],"index":[244],"process,":[246],"incorporating":[247],"attributes.":[259],"We":[260],"experimentally":[261],"prove":[262],"our":[264],"reduces":[266],"improves":[271],"recommended":[276]},"counts_by_year":[{"year":2013,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}