{"id":"https://openalex.org/W2085106021","doi":"https://doi.org/10.1109/snpd.2014.6888696","title":"New data warehouse designing approach based on principal component analysis","display_name":"New data warehouse designing approach based on principal component analysis","publication_year":2014,"publication_date":"2014-06-01","ids":{"openalex":"https://openalex.org/W2085106021","doi":"https://doi.org/10.1109/snpd.2014.6888696","mag":"2085106021"},"language":"en","primary_location":{"id":"doi:10.1109/snpd.2014.6888696","is_oa":false,"landing_page_url":"https://doi.org/10.1109/snpd.2014.6888696","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"15th IEEE/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel/Distributed Computing (SNPD)","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/A5005500453","display_name":"Wafa Tebourski","orcid":null},"institutions":[{"id":"https://openalex.org/I108714496","display_name":"Tunis University","ror":"https://ror.org/02q1spa57","country_code":"TN","type":"education","lineage":["https://openalex.org/I108714496"]},{"id":"https://openalex.org/I83259278","display_name":"Manouba University","ror":"https://ror.org/0503ejf32","country_code":"TN","type":"education","lineage":["https://openalex.org/I83259278"]}],"countries":["TN"],"is_corresponding":true,"raw_author_name":"Wafa Tebourski","raw_affiliation_strings":["ENSI, Manouba University","High Inst. of Manage. of Tunis, Univ. of Tunis, Tunis, Tunisia"],"affiliations":[{"raw_affiliation_string":"ENSI, Manouba University","institution_ids":["https://openalex.org/I83259278"]},{"raw_affiliation_string":"High Inst. of Manage. of Tunis, Univ. of Tunis, Tunis, Tunisia","institution_ids":["https://openalex.org/I108714496"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017566136","display_name":"Wahiba Ben Abdessalem Kar\u00e2a","orcid":"https://orcid.org/0000-0002-7444-5921"},"institutions":[{"id":"https://openalex.org/I108714496","display_name":"Tunis University","ror":"https://ror.org/02q1spa57","country_code":"TN","type":"education","lineage":["https://openalex.org/I108714496"]},{"id":"https://openalex.org/I83259278","display_name":"Manouba University","ror":"https://ror.org/0503ejf32","country_code":"TN","type":"education","lineage":["https://openalex.org/I83259278"]}],"countries":["TN"],"is_corresponding":false,"raw_author_name":"Wahiba Ben Abdessalem Kara","raw_affiliation_strings":["ENSI, Manouba University","High Inst. of Manage. of Tunis, Univ. of Tunis, Tunis, Tunisia"],"affiliations":[{"raw_affiliation_string":"ENSI, Manouba University","institution_ids":["https://openalex.org/I83259278"]},{"raw_affiliation_string":"High Inst. of Manage. of Tunis, Univ. of Tunis, Tunis, Tunisia","institution_ids":["https://openalex.org/I108714496"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045642024","display_name":"Henda Ben Gh\u00e9zela","orcid":null},"institutions":[{"id":"https://openalex.org/I83259278","display_name":"Manouba University","ror":"https://ror.org/0503ejf32","country_code":"TN","type":"education","lineage":["https://openalex.org/I83259278"]}],"countries":["TN"],"is_corresponding":false,"raw_author_name":"Henda Ben Ghezela","raw_affiliation_strings":["ENSI, Manouba University, Manouba","Nat. Sch. of Comput. Sci., Univ. of Manouba, Manouba, Tunisia"],"affiliations":[{"raw_affiliation_string":"ENSI, Manouba University, Manouba","institution_ids":["https://openalex.org/I83259278"]},{"raw_affiliation_string":"Nat. Sch. of Comput. Sci., Univ. of Manouba, Manouba, Tunisia","institution_ids":["https://openalex.org/I83259278"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5005500453"],"corresponding_institution_ids":["https://openalex.org/I108714496","https://openalex.org/I83259278"],"apc_list":null,"apc_paid":null,"fwci":0.6896,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.75469603,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"10","issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9925000071525574,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9925000071525574,"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"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9886000156402588,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9866999983787537,"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/data-warehouse","display_name":"Data warehouse","score":0.9296557903289795},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.8167577981948853},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.7436126470565796},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7216585278511047},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.6118413805961609},{"id":"https://openalex.org/keywords/principal-component-analysis","display_name":"Principal component analysis","score":0.5006246566772461},{"id":"https://openalex.org/keywords/multidimensional-analysis","display_name":"Multidimensional analysis","score":0.47699978947639465},{"id":"https://openalex.org/keywords/structuring","display_name":"Structuring","score":0.4745897948741913},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.47294092178344727},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4265926480293274},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.42423611879348755},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.40074411034584045},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3451443016529083},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13114160299301147},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.10640060901641846},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.09235811233520508}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9296557903289795},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8167577981948853},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.7436126470565796},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7216585278511047},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.6118413805961609},{"id":"https://openalex.org/C27438332","wikidata":"https://www.wikidata.org/wiki/Q2873","display_name":"Principal component analysis","level":2,"score":0.5006246566772461},{"id":"https://openalex.org/C169191187","wikidata":"https://www.wikidata.org/wiki/Q1418353","display_name":"Multidimensional analysis","level":2,"score":0.47699978947639465},{"id":"https://openalex.org/C2775945657","wikidata":"https://www.wikidata.org/wiki/Q381442","display_name":"Structuring","level":2,"score":0.4745897948741913},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.47294092178344727},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4265926480293274},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.42423611879348755},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.40074411034584045},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3451443016529083},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13114160299301147},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.10640060901641846},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.09235811233520508},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/snpd.2014.6888696","is_oa":false,"landing_page_url":"https://doi.org/10.1109/snpd.2014.6888696","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"15th IEEE/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel/Distributed Computing (SNPD)","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.6899999976158142}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1530537858","https://openalex.org/W1969722313","https://openalex.org/W1971323001","https://openalex.org/W1971518725","https://openalex.org/W2008120802","https://openalex.org/W2010453024","https://openalex.org/W2032999854","https://openalex.org/W2108971776","https://openalex.org/W2114887408","https://openalex.org/W2135203905","https://openalex.org/W2140473596","https://openalex.org/W2153696856","https://openalex.org/W4245642253","https://openalex.org/W6631809729"],"related_works":["https://openalex.org/W208715492","https://openalex.org/W23190051","https://openalex.org/W2160457037","https://openalex.org/W2343314637","https://openalex.org/W2377338394","https://openalex.org/W2357522326","https://openalex.org/W1971010447","https://openalex.org/W2980304303","https://openalex.org/W2111757262","https://openalex.org/W2148726436"],"abstract_inverted_index":{"Decision":[0],"making":[1],"has":[2,57],"become":[3,58],"a":[4,59,89,116],"strategic":[5],"need":[6],"for":[7,93,124],"any":[8],"business.":[9,18],"Indeed,":[10],"it":[11],"is":[12,134],"among":[13],"the":[14,26,36,44,52,64,94,100,125],"priorities":[15],"of":[16,21,39,48,54,66,96,107,127],"capital":[17],"The":[19,105],"establishment":[20],"decision":[22],"information":[23],"systems":[24],"facilitates":[25],"data":[27,33,55,71,85,98,119],"exploitation":[28],"and":[29,46,82,129],"analysis.":[30],"We":[31],"distinguish":[32],"warehouses":[34,56,86],"as":[35],"core":[37],"system":[38],"business":[40],"intelligence":[41],"to":[42,63,69,80,83,136],"ensure":[43],"structuring":[45],"analysis":[47,95],"multidimensional":[49,97],"data.":[50],"Consequently,":[51],"design":[53,81],"major":[60],"problem,":[61],"leading":[62],"development":[65],"appropriate":[67],"approaches":[68],"implement":[70],"warehouses.":[72],"In":[73],"this":[74,108],"paper,":[75],"we":[76],"propose":[77],"an":[78,122],"approach":[79],"construct":[84],"based":[87],"on":[88],"descriptive":[90],"statistics":[91],"technique":[92],"in":[99,111],"Principal":[101],"Components":[102],"Analysis":[103],"(PCA).":[104],"findings":[106],"article":[109],"appear":[110],"two":[112],"main":[113],"areas:":[114],"(i)":[115],"conceptual":[117],"model":[118],"warehouse,":[120],"(ii)":[121],"algorithm":[123],"determination":[126],"measures":[128],"dimensions.":[130],"A":[131],"case":[132],"study":[133],"used":[135],"validate":[137],"our":[138],"proposal.":[139]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"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"}