{"id":"https://openalex.org/W1974724178","doi":"https://doi.org/10.1109/aiccsa.2013.6616465","title":"Normed principal components analysis: A new approach to data warehouse fragmentation","display_name":"Normed principal components analysis: A new approach to data warehouse fragmentation","publication_year":2013,"publication_date":"2013-05-01","ids":{"openalex":"https://openalex.org/W1974724178","doi":"https://doi.org/10.1109/aiccsa.2013.6616465","mag":"1974724178"},"language":"en","primary_location":{"id":"doi:10.1109/aiccsa.2013.6616465","is_oa":false,"landing_page_url":"https://doi.org/10.1109/aiccsa.2013.6616465","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 ACS International Conference on Computer Systems and Applications (AICCSA)","raw_type":"proceedings-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/A5046898540","display_name":"Rachid Elmansouri","orcid":null},"institutions":[{"id":"https://openalex.org/I81605866","display_name":"Sidi Mohamed Ben Abdellah University","ror":"https://ror.org/04efg9a07","country_code":"MA","type":"education","lineage":["https://openalex.org/I81605866"]}],"countries":["MA"],"is_corresponding":true,"raw_author_name":"Rachid Elmansouri","raw_affiliation_strings":["LIIAN, GRMS2I, FSDM, Sidi Mohamed Ben Abdellah University, Fes, Morocco","FSDM, Sidi Mohamed Ben Abdellah Univ., Fes, Morocco"],"affiliations":[{"raw_affiliation_string":"LIIAN, GRMS2I, FSDM, Sidi Mohamed Ben Abdellah University, Fes, Morocco","institution_ids":["https://openalex.org/I81605866"]},{"raw_affiliation_string":"FSDM, Sidi Mohamed Ben Abdellah Univ., Fes, Morocco","institution_ids":["https://openalex.org/I81605866"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048317087","display_name":"Omar El Beqqali","orcid":"https://orcid.org/0000-0003-0269-3819"},"institutions":[{"id":"https://openalex.org/I81605866","display_name":"Sidi Mohamed Ben Abdellah University","ror":"https://ror.org/04efg9a07","country_code":"MA","type":"education","lineage":["https://openalex.org/I81605866"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Omar Elbeqqali","raw_affiliation_strings":["LIIAN, GRMS2I, FSDM, Sidi Mohamed Ben Abdellah University, Fes, Morocco","FSDM, Sidi Mohamed Ben Abdellah Univ., Fes, Morocco"],"affiliations":[{"raw_affiliation_string":"LIIAN, GRMS2I, FSDM, Sidi Mohamed Ben Abdellah University, Fes, Morocco","institution_ids":["https://openalex.org/I81605866"]},{"raw_affiliation_string":"FSDM, Sidi Mohamed Ben Abdellah Univ., Fes, Morocco","institution_ids":["https://openalex.org/I81605866"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5083127619","display_name":"Ziyati Elhoussaine","orcid":"https://orcid.org/0000-0003-0195-8459"},"institutions":[{"id":"https://openalex.org/I99297268","display_name":"University of Hassan II Casablanca","ror":"https://ror.org/001q4kn48","country_code":"MA","type":"education","lineage":["https://openalex.org/I99297268"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"Elhoussaine Ziyati","raw_affiliation_strings":["RITM, ESTC, ENSEM, Hassan II University, Casablanca, Morocco","ENSEM, Hassan II Univ., Casablanca, Morocco"],"affiliations":[{"raw_affiliation_string":"RITM, ESTC, ENSEM, Hassan II University, Casablanca, Morocco","institution_ids":["https://openalex.org/I99297268"]},{"raw_affiliation_string":"ENSEM, Hassan II Univ., Casablanca, Morocco","institution_ids":["https://openalex.org/I99297268"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5046898540"],"corresponding_institution_ids":["https://openalex.org/I81605866"],"apc_list":null,"apc_paid":null,"fwci":0.4738,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.71854419,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"4"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12114","display_name":"Sensory Analysis and Statistical Methods","score":0.9697999954223633,"subfield":{"id":"https://openalex.org/subfields/1106","display_name":"Food Science"},"field":{"id":"https://openalex.org/fields/11","display_name":"Agricultural and Biological Sciences"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T12114","display_name":"Sensory Analysis and Statistical Methods","score":0.9697999954223633,"subfield":{"id":"https://openalex.org/subfields/1106","display_name":"Food Science"},"field":{"id":"https://openalex.org/fields/11","display_name":"Agricultural and Biological Sciences"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9253000020980835,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10064","display_name":"Complex Network Analysis Techniques","score":0.911899983882904,"subfield":{"id":"https://openalex.org/subfields/3109","display_name":"Statistical and Nonlinear Physics"},"field":{"id":"https://openalex.org/fields/31","display_name":"Physics and Astronomy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/principal-component-analysis","display_name":"Principal component analysis","score":0.7420129776000977},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6682729125022888},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6120384335517883},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5439595580101013},{"id":"https://openalex.org/keywords/canonical-correlation","display_name":"Canonical correlation","score":0.4864663779735565},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.47763434052467346},{"id":"https://openalex.org/keywords/multiple-correspondence-analysis","display_name":"Multiple correspondence analysis","score":0.4575880765914917},{"id":"https://openalex.org/keywords/biplot","display_name":"Biplot","score":0.44574394822120667},{"id":"https://openalex.org/keywords/projection","display_name":"Projection (relational algebra)","score":0.4453688859939575},{"id":"https://openalex.org/keywords/fragmentation","display_name":"Fragmentation (computing)","score":0.44274425506591797},{"id":"https://openalex.org/keywords/thematic-map","display_name":"Thematic map","score":0.44183340668678284},{"id":"https://openalex.org/keywords/dimensionality-reduction","display_name":"Dimensionality reduction","score":0.423300176858902},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3462802469730377},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.26735079288482666},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.25793954730033875},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21267643570899963},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.10708695650100708}],"concepts":[{"id":"https://openalex.org/C27438332","wikidata":"https://www.wikidata.org/wiki/Q2873","display_name":"Principal component analysis","level":2,"score":0.7420129776000977},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6682729125022888},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6120384335517883},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5439595580101013},{"id":"https://openalex.org/C153874254","wikidata":"https://www.wikidata.org/wiki/Q115542","display_name":"Canonical correlation","level":2,"score":0.4864663779735565},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.47763434052467346},{"id":"https://openalex.org/C97448799","wikidata":"https://www.wikidata.org/wiki/Q2845212","display_name":"Multiple correspondence analysis","level":2,"score":0.4575880765914917},{"id":"https://openalex.org/C118483189","wikidata":"https://www.wikidata.org/wiki/Q4915468","display_name":"Biplot","level":4,"score":0.44574394822120667},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.4453688859939575},{"id":"https://openalex.org/C191015642","wikidata":"https://www.wikidata.org/wiki/Q1132459","display_name":"Fragmentation (computing)","level":2,"score":0.44274425506591797},{"id":"https://openalex.org/C93692415","wikidata":"https://www.wikidata.org/wiki/Q1502030","display_name":"Thematic map","level":2,"score":0.44183340668678284},{"id":"https://openalex.org/C70518039","wikidata":"https://www.wikidata.org/wiki/Q16000077","display_name":"Dimensionality reduction","level":2,"score":0.423300176858902},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3462802469730377},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.26735079288482666},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.25793954730033875},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21267643570899963},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.10708695650100708},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C135763542","wikidata":"https://www.wikidata.org/wiki/Q106016","display_name":"Genotype","level":3,"score":0.0},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/aiccsa.2013.6616465","is_oa":false,"landing_page_url":"https://doi.org/10.1109/aiccsa.2013.6616465","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 ACS International Conference on Computer Systems and Applications (AICCSA)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.7799999713897705}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W145170424","https://openalex.org/W2051441204","https://openalex.org/W2088477804","https://openalex.org/W2108971776","https://openalex.org/W2133097426","https://openalex.org/W2160172778","https://openalex.org/W2172240482","https://openalex.org/W2344467193","https://openalex.org/W4400699007","https://openalex.org/W6652444700","https://openalex.org/W6685408718"],"related_works":["https://openalex.org/W608264481","https://openalex.org/W2087187255","https://openalex.org/W2043084652","https://openalex.org/W183995451","https://openalex.org/W2074435153","https://openalex.org/W2003363096","https://openalex.org/W2017653426","https://openalex.org/W2619357646","https://openalex.org/W2132703645","https://openalex.org/W2413099090"],"abstract_inverted_index":{"In":[0],"this":[1],"paper,":[2],"we":[3,74],"present":[4],"a":[5,65,109,154,188],"state":[6],"of":[7,19,27,37,45,50,57,67,79,105,120,136,156,167,198],"the":[8,11,17,35,43,48,51,55,62,77,82,87,93,114,123,127,134,173,178,193,196],"art":[9],"on":[10,42,54,81,187],"principal":[12,71,84,96,128],"components":[13,129],"analysis":[14],"(PCA)":[15],"and":[16,24,64,86,107,126,138,169,195],"possibility":[18],"its":[20],"use":[21],"for":[22,69,113],"horizontal":[23,110],"vertical":[25,150],"fragmentation":[26,111],"data":[28,116,189],"warehouses":[29],"(DW),":[30],"in":[31,149],"order":[32],"to":[33,60,76,100,132,146,171],"reduce":[34],"time":[36],"query":[38],"execution.":[39],"We":[40,98,180],"focus":[41],"study":[44,66,119,183],"correlation":[46],"matrices,":[47],"impact":[49],"eigenvalues":[52],"evolution":[53],"determination":[56],"suitable":[58],"situations":[59],"achieve":[61],"PCA,":[63],"criteria":[68],"extracting":[70],"components.":[72,97],"Then,":[73],"proceed":[75],"projection":[78],"individuals":[80,106],"first":[83,94],"plane,":[85],"3D":[88],"vector":[89],"space":[90],"generated":[91],"by":[92,177,184],"three":[95],"try":[99],"determine":[101],"graphically":[102],"homogeneous":[103],"groups":[104],"therefore,":[108],"schema":[112],"studied":[115],"table.":[117],"The":[118],"correlations":[121,137],"between":[122],"original":[124],"variables":[125,145],"allow":[130],"us":[131],"draw":[133],"circle":[135],"define":[139],"graphically,":[140],"under":[141],"some":[142],"conditions,":[143],"candidate":[144],"be":[147],"collected":[148],"fragments.":[151],"To":[152],"satisfy":[153],"maximum":[155],"decision":[157],"queries":[158],"OLAP,":[159],"our":[160,182,199],"approach":[161],"is":[162],"independent":[163],"from":[164],"any":[165],"set":[166],"queries,":[168],"seeks":[170],"exploit":[172],"graphical":[174],"representations":[175],"provided":[176],"PCA.":[179],"conclude":[181],"an":[185],"experiment":[186],"warehouse":[190],"which":[191],"shows":[192],"interest":[194],"originality":[197],"approach.":[200]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}
