{"id":"https://openalex.org/W2008943322","doi":"https://doi.org/10.1109/clei.2012.6427228","title":"Query processing over data warehouse using relational databases and NoSQL","display_name":"Query processing over data warehouse using relational databases and NoSQL","publication_year":2012,"publication_date":"2012-10-01","ids":{"openalex":"https://openalex.org/W2008943322","doi":"https://doi.org/10.1109/clei.2012.6427228","mag":"2008943322"},"language":"en","primary_location":{"id":"doi:10.1109/clei.2012.6427228","is_oa":false,"landing_page_url":"https://doi.org/10.1109/clei.2012.6427228","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 XXXVIII Conferencia Latinoamericana En Informatica (CLEI)","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/A5067908573","display_name":"Anderson Chaves Carniel","orcid":"https://orcid.org/0000-0002-8297-9894"},"institutions":[{"id":"https://openalex.org/I177909021","display_name":"Universidade Federal de S\u00e3o Carlos","ror":"https://ror.org/00qdc6m37","country_code":"BR","type":"education","lineage":["https://openalex.org/I177909021"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Anderson Chaves Carniel","raw_affiliation_strings":["Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I177909021"]},{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil","institution_ids":["https://openalex.org/I177909021"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021720230","display_name":"Aried de Aguiar","orcid":null},"institutions":[{"id":"https://openalex.org/I177909021","display_name":"Universidade Federal de S\u00e3o Carlos","ror":"https://ror.org/00qdc6m37","country_code":"BR","type":"education","lineage":["https://openalex.org/I177909021"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Aried de Aguiar Sa","raw_affiliation_strings":["Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I177909021"]},{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil","institution_ids":["https://openalex.org/I177909021"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026226645","display_name":"Vin\u00edcius Henrique Porto Brisighello","orcid":"https://orcid.org/0000-0002-8258-311X"},"institutions":[{"id":"https://openalex.org/I177909021","display_name":"Universidade Federal de S\u00e3o Carlos","ror":"https://ror.org/00qdc6m37","country_code":"BR","type":"education","lineage":["https://openalex.org/I177909021"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Vinicius Henrique Porto Brisighello","raw_affiliation_strings":["Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I177909021"]},{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil","institution_ids":["https://openalex.org/I177909021"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004343218","display_name":"Marcela Xavier Ribeiro","orcid":"https://orcid.org/0000-0002-2323-5326"},"institutions":[{"id":"https://openalex.org/I177909021","display_name":"Universidade Federal de S\u00e3o Carlos","ror":"https://ror.org/00qdc6m37","country_code":"BR","type":"education","lineage":["https://openalex.org/I177909021"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Marcela Xavier Ribeiro","raw_affiliation_strings":["Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I177909021"]},{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil","institution_ids":["https://openalex.org/I177909021"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087687401","display_name":"Renato Bueno","orcid":"https://orcid.org/0000-0002-5811-3847"},"institutions":[{"id":"https://openalex.org/I177909021","display_name":"Universidade Federal de S\u00e3o Carlos","ror":"https://ror.org/00qdc6m37","country_code":"BR","type":"education","lineage":["https://openalex.org/I177909021"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Renato Bueno","raw_affiliation_strings":["Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I177909021"]},{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil","institution_ids":["https://openalex.org/I177909021"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076042738","display_name":"Ricardo Rodrigues Ciferri","orcid":"https://orcid.org/0000-0001-5944-8246"},"institutions":[{"id":"https://openalex.org/I177909021","display_name":"Universidade Federal de S\u00e3o Carlos","ror":"https://ror.org/00qdc6m37","country_code":"BR","type":"education","lineage":["https://openalex.org/I177909021"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Ricardo Rodrigues Ciferri","raw_affiliation_strings":["Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I177909021"]},{"raw_affiliation_string":"Departamento de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, SP, Brasil","institution_ids":["https://openalex.org/I177909021"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036767529","display_name":"Cristina Dutra de Aguiar Ciferri","orcid":"https://orcid.org/0000-0002-7618-1405"},"institutions":[{"id":"https://openalex.org/I177909021","display_name":"Universidade Federal de S\u00e3o Carlos","ror":"https://ror.org/00qdc6m37","country_code":"BR","type":"education","lineage":["https://openalex.org/I177909021"]},{"id":"https://openalex.org/I17974374","display_name":"Universidade de S\u00e3o Paulo","ror":"https://ror.org/036rp1748","country_code":"BR","type":"education","lineage":["https://openalex.org/I17974374"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Cristina Dutra de Aguiar Ciferri","raw_affiliation_strings":["Departamento de Ci\u00eancias de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","Departamento de Ci\u00eancias de Computa\u00e7\u00e3o, Universidade de S\u00e3o Paulo S\u00e3o Carlos, Brasil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Ci\u00eancias de Computa\u00e7\u00e3o, Universidade Federal de S\u00e3o Carlos, Sao Carlos, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I177909021"]},{"raw_affiliation_string":"Departamento de Ci\u00eancias de Computa\u00e7\u00e3o, Universidade de S\u00e3o Paulo S\u00e3o Carlos, Brasil","institution_ids":["https://openalex.org/I17974374"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4954,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.65667489,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"5","issue":null,"first_page":"1","last_page":"9"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983999729156494,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9958000183105469,"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/nosql","display_name":"NoSQL","score":0.9562188386917114},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.810515284538269},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.791104257106781},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6883317232131958},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6478056311607361},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6201807260513306},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5049212574958801},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5004324913024902},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4906064569950104},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.43865910172462463},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.41541242599487305},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3956451117992401},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.37174850702285767},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.22843018174171448},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.10594552755355835}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.9562188386917114},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.810515284538269},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.791104257106781},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6883317232131958},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6478056311607361},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6201807260513306},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5049212574958801},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5004324913024902},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4906064569950104},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.43865910172462463},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.41541242599487305},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3956451117992401},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37174850702285767},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.22843018174171448},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.10594552755355835},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/clei.2012.6427228","is_oa":false,"landing_page_url":"https://doi.org/10.1109/clei.2012.6427228","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2012 XXXVIII Conferencia Latinoamericana En Informatica (CLEI)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1495859460","https://openalex.org/W1558235631","https://openalex.org/W1578512165","https://openalex.org/W1605756423","https://openalex.org/W2007217077","https://openalex.org/W2016071357","https://openalex.org/W2026205964","https://openalex.org/W2084568010","https://openalex.org/W2140646908","https://openalex.org/W2140980002","https://openalex.org/W2142318882","https://openalex.org/W2143401113","https://openalex.org/W2144201450","https://openalex.org/W2164326160","https://openalex.org/W2313418883","https://openalex.org/W2502241578","https://openalex.org/W4234246607","https://openalex.org/W4289258943","https://openalex.org/W6636156854","https://openalex.org/W6657084543","https://openalex.org/W6681555784"],"related_works":["https://openalex.org/W1988774479","https://openalex.org/W2123931473","https://openalex.org/W1799555191","https://openalex.org/W3012397820","https://openalex.org/W1525815534","https://openalex.org/W2382658894","https://openalex.org/W2391561131","https://openalex.org/W2791024100","https://openalex.org/W4312096174","https://openalex.org/W195952546"],"abstract_inverted_index":{"Data":[0],"warehouse":[1],"(DW)":[2],"is":[3,17,50,64],"an":[4,65,79],"important":[5],"component":[6],"of":[7,28,44,53,93,112,122,139],"Business":[8],"Intelligence":[9],"used":[10],"to":[11,81,124,128],"support":[12],"strategic":[13],"decision":[14],"making.":[15],"DW":[16,94],"a":[18,117],"subject-oriented,":[19],"nonvolatile,":[20],"historical":[21],"and":[22,58,75,78,89,98,132],"massive":[23],"database,":[24],"which":[25],"the":[26,41,51,62,91,101,109,113,133,137],"processing":[27,43,74,138],"analytical":[29],"queries,":[30],"results":[31,106],"in":[32,136],"high":[33],"response":[34],"times.":[35],"There":[36],"known":[37],"techniques":[38],"for":[39],"improving":[40],"performance":[42],"queries":[45,140],"on":[46,141],"DW.":[47,142],"Among":[48],"them":[49],"use":[52],"data":[54,76],"fragmentation,":[55],"materialized":[56],"views":[57],"indices.":[59],"In":[60,84],"addition,":[61],"NoSQL":[63,131],"emerging":[66],"technology":[67],"whose":[68],"main":[69],"characteristics":[70],"are":[71],"improved":[72],"query":[73],"storage,":[77],"alternative":[80],"relational":[82,96,134],"databases.":[83],"this":[85],"paper":[86],"we":[87],"investigate":[88],"compare":[90],"implementation":[92],"using":[95],"databases":[97],"NoSQL,":[99],"considering":[100],"Star":[102],"Schema":[103],"Benchmark.":[104],"The":[105],"showed":[107,116],"that":[108],"column-oriented":[110],"model":[111],"software":[114],"FastBit":[115],"better":[118],"performance,":[119],"with":[120],"gains":[121],"25.4%":[123],"99.4%":[125],"if":[126],"compared":[127],"other":[129],"models":[130],"model,":[135]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}