{"id":"https://openalex.org/W1979481445","doi":"https://doi.org/10.1016/s1383-7621(02)00056-5","title":"A novel three-level architecture for large data warehouses","display_name":"A novel three-level architecture for large data warehouses","publication_year":2002,"publication_date":"2002-05-01","ids":{"openalex":"https://openalex.org/W1979481445","doi":"https://doi.org/10.1016/s1383-7621(02)00056-5","mag":"1979481445"},"language":"en","primary_location":{"id":"doi:10.1016/s1383-7621(02)00056-5","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s1383-7621(02)00056-5","pdf_url":null,"source":{"id":"https://openalex.org/S127660348","display_name":"Journal of Systems Architecture","issn_l":"1383-7621","issn":["1383-7621","1873-6165"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Systems Architecture","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/A5055479421","display_name":"Luigi Palopoli","orcid":"https://orcid.org/0000-0003-4915-5137"},"institutions":[{"id":"https://openalex.org/I59725666","display_name":"University of Reggio Calabria","ror":"https://ror.org/041sz8d87","country_code":"IT","type":"education","lineage":["https://openalex.org/I59725666"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"L. Palopoli","raw_affiliation_strings":["DIMET, Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy","DIMET Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy#TAB#"],"affiliations":[{"raw_affiliation_string":"DIMET, Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy","institution_ids":["https://openalex.org/I59725666"]},{"raw_affiliation_string":"DIMET Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy#TAB#","institution_ids":["https://openalex.org/I59725666"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051833173","display_name":"Luigi Pontieri","orcid":"https://orcid.org/0000-0003-4513-0362"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"L. Pontieri","raw_affiliation_strings":["ISI, Consiglio Nazionale delle Ricerche, Via Pietro Bucci, 87036 Rende, Italy","ISI, Consiglio Nazionale delle Ricerche, Via Pietro Bucci, 87036 Rende, Italy#TAB#"],"affiliations":[{"raw_affiliation_string":"ISI, Consiglio Nazionale delle Ricerche, Via Pietro Bucci, 87036 Rende, Italy","institution_ids":[]},{"raw_affiliation_string":"ISI, Consiglio Nazionale delle Ricerche, Via Pietro Bucci, 87036 Rende, Italy#TAB#","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084620092","display_name":"Giorgio Terracina","orcid":"https://orcid.org/0000-0002-3090-7223"},"institutions":[{"id":"https://openalex.org/I59725666","display_name":"University of Reggio Calabria","ror":"https://ror.org/041sz8d87","country_code":"IT","type":"education","lineage":["https://openalex.org/I59725666"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"G. Terracina","raw_affiliation_strings":["DIMET, Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy","DIMET Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy#TAB#"],"affiliations":[{"raw_affiliation_string":"DIMET, Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy","institution_ids":["https://openalex.org/I59725666"]},{"raw_affiliation_string":"DIMET Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy#TAB#","institution_ids":["https://openalex.org/I59725666"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5032253415","display_name":"Domenico Ursino","orcid":"https://orcid.org/0000-0003-1360-8499"},"institutions":[{"id":"https://openalex.org/I59725666","display_name":"University of Reggio Calabria","ror":"https://ror.org/041sz8d87","country_code":"IT","type":"education","lineage":["https://openalex.org/I59725666"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"D. Ursino","raw_affiliation_strings":["DIMET, Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy","DIMET Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy#TAB#"],"affiliations":[{"raw_affiliation_string":"DIMET, Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy","institution_ids":["https://openalex.org/I59725666"]},{"raw_affiliation_string":"DIMET Universit\u00e0 Mediterranea di Reggio Calabria, Via Graziella, Localit\u00e0 Feo di Vito, 89060 Reggio Calabria, Italy#TAB#","institution_ids":["https://openalex.org/I59725666"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5055479421"],"corresponding_institution_ids":["https://openalex.org/I59725666"],"apc_list":{"value":2800,"currency":"USD","value_usd":2800},"apc_paid":null,"fwci":0.6941,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.73694017,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"47","issue":"11","first_page":"937","last_page":"958"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9973999857902527,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9973999857902527,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9972000122070312,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9948999881744385,"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/computer-science","display_name":"Computer science","score":0.8985683917999268},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.833199143409729},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.7343381643295288},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5890202522277832},{"id":"https://openalex.org/keywords/data-architecture","display_name":"Data architecture","score":0.4324905276298523},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.382149338722229},{"id":"https://openalex.org/keywords/reference-architecture","display_name":"Reference architecture","score":0.3683779835700989},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3613986670970917},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.32916152477264404},{"id":"https://openalex.org/keywords/software-architecture","display_name":"Software architecture","score":0.20904168486595154},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09496644139289856}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8985683917999268},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.833199143409729},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.7343381643295288},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5890202522277832},{"id":"https://openalex.org/C94070970","wikidata":"https://www.wikidata.org/wiki/Q638422","display_name":"Data architecture","level":5,"score":0.4324905276298523},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.382149338722229},{"id":"https://openalex.org/C55356503","wikidata":"https://www.wikidata.org/wiki/Q2136675","display_name":"Reference architecture","level":4,"score":0.3683779835700989},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3613986670970917},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.32916152477264404},{"id":"https://openalex.org/C35869016","wikidata":"https://www.wikidata.org/wiki/Q846636","display_name":"Software architecture","level":3,"score":0.20904168486595154},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09496644139289856},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/s1383-7621(02)00056-5","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s1383-7621(02)00056-5","pdf_url":null,"source":{"id":"https://openalex.org/S127660348","display_name":"Journal of Systems Architecture","issn_l":"1383-7621","issn":["1383-7621","1873-6165"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Systems Architecture","raw_type":"journal-article"},{"id":"pmh:oai:iris.univpm.it:11566/253338","is_oa":false,"landing_page_url":"http://hdl.handle.net/11566/253338","pdf_url":null,"source":{"id":"https://openalex.org/S4306402571","display_name":"Universit\u00e0 Politecnica delle Marche (Universit\u00e0 Politecnica delle Marche)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I122534668","host_organization_name":"Marche Polytechnic University","host_organization_lineage":["https://openalex.org/I122534668"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Sustainable cities and communities","id":"https://metadata.un.org/sdg/11","score":0.6700000166893005}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1971784203","https://openalex.org/W1973632517","https://openalex.org/W1985059939","https://openalex.org/W1995999642","https://openalex.org/W2072764742","https://openalex.org/W2076898857","https://openalex.org/W2080090262","https://openalex.org/W2093775596","https://openalex.org/W2132610455","https://openalex.org/W2147931420","https://openalex.org/W2158494365","https://openalex.org/W2163494375","https://openalex.org/W2164240433","https://openalex.org/W2170235279","https://openalex.org/W2319660501","https://openalex.org/W2999729612","https://openalex.org/W4246575857","https://openalex.org/W4285719527","https://openalex.org/W6639106640","https://openalex.org/W6643416587","https://openalex.org/W6646773878","https://openalex.org/W6649511929","https://openalex.org/W6681908343","https://openalex.org/W6683949723"],"related_works":["https://openalex.org/W2356280685","https://openalex.org/W4211040133","https://openalex.org/W2611496792","https://openalex.org/W2181647270","https://openalex.org/W2905071167","https://openalex.org/W3082688266","https://openalex.org/W2753650998","https://openalex.org/W4238407057","https://openalex.org/W2377470023","https://openalex.org/W2380240402"],"abstract_inverted_index":null,"counts_by_year":[{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}