{"id":"https://openalex.org/W4296713748","doi":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431","title":"Towards a new hybrid approach for building document-oriented data warehouses","display_name":"Towards a new hybrid approach for building document-oriented data warehouses","alternate_titles":[],"publication_year":2022,"publication_date":"2022-12-01","ids":{"openalex":"https://openalex.org/W4296713748","doi":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431"},"language":"en","primary_location":{"id":"doi:10.11591/ijece.v12i6.pp6423-6431","doi":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431","is_oa":true,"landing_page_url":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431","pdf_url":"https://ijece.iaescore.com/index.php/IJECE/article/download/28727/16154","source":{"id":"https://openalex.org/S4210235676","display_name":"International Journal of Power Electronics and Drive Systems/International Journal of Electrical and Computer Engineering","issn_l":"2722-256X","issn":["2722-256X","2722-2578"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1"],"host_organization":"https://openalex.org/P4310315009","host_organization_name":"Institute of Advanced Engineering and Science (IAES)","host_organization_lineage":["https://openalex.org/P4310315009"],"host_organization_lineage_names":["Institute of Advanced Engineering and Science (IAES)"],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Electrical and Computer Engineering (IJECE)","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4296713748"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://ijece.iaescore.com/index.php/IJECE/article/download/28727/16154","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5074340583","display_name":"Nawfal El Moukhi","orcid":"https://orcid.org/0000-0001-5357-9421","observed_orcids":["https://orcid.org/0000-0001-5357-9421"]},"institutions":[{"id":"https://openalex.org/I3121676899","display_name":"Universit\u00e9 Ibn-Tofail","ror":"https://ror.org/02wj89n04","country_code":"MA","type":"education","lineage":["https://openalex.org/I3121676899"]}],"countries":["MA"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Nawfal El Moukhi","raw_affiliation_strings":["Ibn Tofail University"],"raw_orcid":"https://orcid.org/0000-0001-5357-9421","affiliations":[{"raw_affiliation_string":"Ibn Tofail University","institution_ids":["https://openalex.org/I3121676899"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047126111","display_name":"Ikram El Azami","orcid":"https://orcid.org/0000-0002-9204-7759","observed_orcids":["https://orcid.org/0000-0002-9204-7759"]},"institutions":[{"id":"https://openalex.org/I3121676899","display_name":"Universit\u00e9 Ibn-Tofail","ror":"https://ror.org/02wj89n04","country_code":"MA","type":"education","lineage":["https://openalex.org/I3121676899"]}],"countries":["MA"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Ikram El Azami","raw_affiliation_strings":["Ibn Tofail University"],"raw_orcid":"https://orcid.org/0000-0002-9204-7759","affiliations":[{"raw_affiliation_string":"Ibn Tofail University","institution_ids":["https://openalex.org/I3121676899"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5072066115","display_name":"Soufiane Hajbi","orcid":"https://orcid.org/0000-0002-4504-5363","observed_orcids":["https://orcid.org/0000-0002-4504-5363"]},"institutions":[{"id":"https://openalex.org/I3121676899","display_name":"Universit\u00e9 Ibn-Tofail","ror":"https://ror.org/02wj89n04","country_code":"MA","type":"education","lineage":["https://openalex.org/I3121676899"]}],"countries":["MA"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Soufiane Hajbi","raw_affiliation_strings":["Ibn Tofail University"],"raw_orcid":"https://orcid.org/0000-0002-4504-5363","affiliations":[{"raw_affiliation_string":"Ibn Tofail University","institution_ids":["https://openalex.org/I3121676899"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5074340583"],"corresponding_institution_ids":["https://openalex.org/I3121676899"],"apc_list":null,"apc_paid":null,"fwci":0.3957,"has_fulltext":true,"cited_by_count":4,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.59025282,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":94},"biblio":{"volume":"12","issue":"6","first_page":"6423","last_page":"6423"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.6664999723434448,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.6664999723434448,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.3237000107765198,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.0012000000569969416,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/nosql-databases","display_name":"NoSQL databases","score":0.8370000123977661},{"id":"https://openalex.org/keywords/unstructured-data","display_name":"unstructured data","score":0.9509999752044678},{"id":"https://openalex.org/keywords/spark","display_name":"Spark","score":0.492000013589859},{"id":"https://openalex.org/keywords/decision-support","display_name":"decision support","score":0.4429999887943268},{"id":"https://openalex.org/keywords/json-schema","display_name":"JSON Schema","score":0.8410000205039978},{"id":"https://openalex.org/keywords/user-requirements","display_name":"user requirements","score":0.6200000047683716}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8278787136077881},{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.764066219329834},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.7222047448158264},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6845754384994507},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6552972197532654},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6082816123962402},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5220568180084229},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.4908676743507385},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.47907382249832153},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4429623782634735},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.39615803956985474},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3830448091030121},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.13001412153244019},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.11591/ijece.v12i6.pp6423-6431","doi":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431","is_oa":true,"landing_page_url":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431","pdf_url":"https://ijece.iaescore.com/index.php/IJECE/article/download/28727/16154","source":{"id":"https://openalex.org/S4210235676","display_name":"International Journal of Power Electronics and Drive Systems/International Journal of Electrical and Computer Engineering","issn_l":"2722-256X","issn":["2722-256X","2722-2578"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1"],"host_organization":"https://openalex.org/P4310315009","host_organization_name":"Institute of Advanced Engineering and Science (IAES)","host_organization_lineage":["https://openalex.org/P4310315009"],"host_organization_lineage_names":["Institute of Advanced Engineering and Science (IAES)"],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Electrical and Computer Engineering (IJECE)","raw_type":"journal-article"},{"id":"pmh:oai:zenodo.org:7303246","doi":null,"is_oa":true,"landing_page_url":"https://zenodo.org/records/7303246","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"International Journal of Electrical and Computer Engineering (IJECE), 12(6), 6423-6431, (2022-12-01)","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.11591/ijece.v12i6.pp6423-6431","doi":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431","is_oa":true,"landing_page_url":"https://doi.org/10.11591/ijece.v12i6.pp6423-6431","pdf_url":"https://ijece.iaescore.com/index.php/IJECE/article/download/28727/16154","source":{"id":"https://openalex.org/S4210235676","display_name":"International Journal of Power Electronics and Drive Systems/International Journal of Electrical and Computer Engineering","issn_l":"2722-256X","issn":["2722-256X","2722-2578"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1"],"host_organization":"https://openalex.org/P4310315009","host_organization_name":"Institute of Advanced Engineering and Science (IAES)","host_organization_lineage":["https://openalex.org/P4310315009"],"host_organization_lineage_names":["Institute of Advanced Engineering and Science (IAES)"],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Electrical and Computer Engineering (IJECE)","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4296713748.pdf","grobid_xml":"https://content.openalex.org/works/W4296713748.grobid-xml"},"referenced_works_count":22,"referenced_works":["https://openalex.org/W1564996880","https://openalex.org/W2122465391","https://openalex.org/W2190012392","https://openalex.org/W2294291481","https://openalex.org/W2396528261","https://openalex.org/W2556483642","https://openalex.org/W2584112163","https://openalex.org/W2603580523","https://openalex.org/W2741482120","https://openalex.org/W2810333995","https://openalex.org/W2844620057","https://openalex.org/W2913512110","https://openalex.org/W2980648625","https://openalex.org/W2981807200","https://openalex.org/W2982784959","https://openalex.org/W3024743437","https://openalex.org/W3039327773","https://openalex.org/W3093177083","https://openalex.org/W3097345360","https://openalex.org/W3112375919","https://openalex.org/W3158936693","https://openalex.org/W4229571662"],"related_works":["https://openalex.org/W2980648625","https://openalex.org/W3139743542","https://openalex.org/W2917247870","https://openalex.org/W2151407425","https://openalex.org/W2792069973","https://openalex.org/W4205711100","https://openalex.org/W2518094867","https://openalex.org/W1987015138","https://openalex.org/W2511992115"],"abstract_inverted_index":{"Schemaless":[0],"databases":[1,45],"offer":[2],"a":[3,35,70,81,108,149],"large":[4,27],"storage":[5],"capacity":[6],"while":[7],"guaranteeing":[8],"high":[9],"performance":[10],"in":[11,25,40,114,131,154],"data":[12,50,72,86,162],"processing.":[13],"Unlike":[14],"relational":[15],"databases,":[16],"which":[17],"are":[18],"rigid":[19],"and":[20,38,58,88,99,134,160],"have":[21],"shown":[22],"their":[23],"limitations":[24],"managing":[26],"amounts":[28],"of":[29,34,49,102,122,126,140,146],"data.":[30,76],"However,":[31],"the":[32,47,97,103,115,124,127,138,141,144,147,161,165],"absence":[33],"well-defined":[36],"schema":[37,110,151],"structure":[39],"not":[41],"only":[42],"SQL":[43],"(NoSQL)":[44],"makes":[46],"use":[48],"for":[51,111],"decision":[52],"analysis":[53,87],"purposes":[54],"even":[55],"more":[56],"complex":[57],"difficult.":[59],"In":[60],"this":[61],"paper,":[62],"we":[63],"propose":[64],"an":[65],"original":[66],"approach":[67,79],"to":[68,106,137],"build":[69],"document-oriented":[71],"warehouse":[73],"from":[74],"unstructured":[75],"The":[77,92,117],"new":[78],"follows":[80],"hybrid":[82],"paradigm":[83],"that":[84],"combines":[85],"user":[89],"requirements":[90,129],"analysis.":[91],"first":[93],"data-driven":[94],"step":[95,120],"exploits":[96],"fast":[98],"distributed":[100],"processing":[101],"spark":[104],"engine":[105],"generate":[107],"general":[109],"each":[112],"collection":[113],"database.":[116],"second":[118],"requirement-driven":[119],"consists":[121],"analyzing":[123],"semantics":[125],"decisional":[128,150],"expressed":[130],"natural":[132],"language":[133],"mapping":[135],"them":[136],"schemas":[139],"collections.":[142],"At":[143],"end":[145],"process,":[148],"is":[152,168],"generated":[153],"JavaScript":[155],"object":[156],"notation":[157],"(JSON)":[158],"format":[159],"loading":[163],"with":[164],"necessary":[166],"transformations":[167],"performed.":[169]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4296713748","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2022-09-23T00:00:00"}
