{"id":"https://openalex.org/W2021282951","doi":"https://doi.org/10.1504/ijbidm.2013.059046","title":"Real-time data warehouse: a solution and evaluation","display_name":"Real-time data warehouse: a solution and evaluation","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W2021282951","doi":"https://doi.org/10.1504/ijbidm.2013.059046","mag":"2021282951"},"language":"en","primary_location":{"id":"doi:10.1504/ijbidm.2013.059046","doi":"https://doi.org/10.1504/ijbidm.2013.059046","is_oa":false,"landing_page_url":"https://doi.org/10.1504/ijbidm.2013.059046","pdf_url":null,"source":{"id":"https://openalex.org/S47982532","display_name":"International Journal of Business Intelligence and Data Mining","issn_l":"1743-8187","issn":["1743-8187","1743-8195"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core","poland-40","russia-white-list-3","vabb-shw"],"host_organization":"https://openalex.org/P4310317825","host_organization_name":"Inderscience Publishers","host_organization_lineage":["https://openalex.org/P4310317825"],"host_organization_lineage_names":["Inderscience Publishers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Business Intelligence and Data Mining","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"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/A5007170696","display_name":"Nickerson Ferreira","orcid":"https://orcid.org/0000-0003-2857-5626","observed_orcids":["https://orcid.org/0000-0003-2857-5626"]},"institutions":[{"id":"https://openalex.org/I76903346","display_name":"University of Coimbra","ror":"https://ror.org/04z8k9a98","country_code":"PT","type":"education","lineage":["https://openalex.org/I76903346"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Nickerson Ferreira","raw_affiliation_strings":["Departamento de Engenharia Inform\u00e1tica, Faculdade de Ci\u00eancias e Tecnologia, Universidade de Coimbra, P\u00f3lo II \u2013 Pinhal de Marrocos, 3030-290 Coimbra, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Engenharia Inform\u00e1tica, Faculdade de Ci\u00eancias e Tecnologia, Universidade de Coimbra, P\u00f3lo II \u2013 Pinhal de Marrocos, 3030-290 Coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049382757","display_name":"Pedro Furtado","orcid":"https://orcid.org/0000-0001-6054-637X","observed_orcids":["https://orcid.org/0000-0001-6054-637X"]},"institutions":[{"id":"https://openalex.org/I76903346","display_name":"University of Coimbra","ror":"https://ror.org/04z8k9a98","country_code":"PT","type":"education","lineage":["https://openalex.org/I76903346"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Pedro Furtado","raw_affiliation_strings":["Departamento de Engenharia Inform\u00e1tica, Faculdade de Ci\u00eancias e Tecnologia, Universidade de Coimbra, P\u00f3lo II \u2013 Pinhal de Marrocos, 3030-290 Coimbra, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departamento de Engenharia Inform\u00e1tica, Faculdade de Ci\u00eancias e Tecnologia, Universidade de Coimbra, P\u00f3lo II \u2013 Pinhal de Marrocos, 3030-290 Coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I76903346"],"apc_list":null,"apc_paid":null,"fwci":2.183,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.9016719,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":"8","issue":"3","first_page":"244","last_page":"244"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.5098000168800354,"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.5098000168800354,"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.48489999771118164,"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/T11106","display_name":"Data Management and Algorithms","score":0.0003000000142492354,"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/real-time-data-warehouse","display_name":"real-time data warehouse","score":0.9909999966621399},{"id":"https://openalex.org/keywords/data-warehouse-architecture","display_name":"data warehouse architecture","score":0.9580000042915344},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.6209999918937683},{"id":"https://openalex.org/keywords/query-performance","display_name":"query performance","score":0.7110000252723694}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8848766088485718},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8485913872718811},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.6915496587753296},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.611871063709259},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5925291180610657},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5824615955352783},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.5310481190681458},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5065203905105591},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.48487982153892517},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4544811546802521},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.44405028223991394},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4398641288280487},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.42624717950820923},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.17853030562400818},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1552324891090393},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.15133634209632874},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1292281150817871},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.09266325831413269},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"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},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","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},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1504/ijbidm.2013.059046","doi":"https://doi.org/10.1504/ijbidm.2013.059046","is_oa":false,"landing_page_url":"https://doi.org/10.1504/ijbidm.2013.059046","pdf_url":null,"source":{"id":"https://openalex.org/S47982532","display_name":"International Journal of Business Intelligence and Data Mining","issn_l":"1743-8187","issn":["1743-8187","1743-8195"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core","poland-40","russia-white-list-3","vabb-shw"],"host_organization":"https://openalex.org/P4310317825","host_organization_name":"Inderscience Publishers","host_organization_lineage":["https://openalex.org/P4310317825"],"host_organization_lineage_names":["Inderscience Publishers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Business Intelligence and Data Mining","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W94964754","https://openalex.org/W197630086","https://openalex.org/W1762755661","https://openalex.org/W2000876233","https://openalex.org/W2006761638","https://openalex.org/W2033464728","https://openalex.org/W2121068295","https://openalex.org/W2129134929","https://openalex.org/W2158560981"],"related_works":["https://openalex.org/W340880505","https://openalex.org/W2006761638","https://openalex.org/W2363691477","https://openalex.org/W7100627105","https://openalex.org/W2905044464","https://openalex.org/W289492882","https://openalex.org/W2041815647","https://openalex.org/W2388861080","https://openalex.org/W849935344","https://openalex.org/W4240615369"],"abstract_inverted_index":{"Real-time":[0],"warehousing":[1],"has":[2],"been":[3],"researched":[4],"and":[5,21,31,49,69,80,104,150],"tried":[6],"in":[7,154],"practice":[8],"by":[9],"several":[10,167],"companies,":[11],"but":[12],"there":[13],"should":[14],"be":[15],"a":[16,36,65,70,127],"definition":[17],"of":[18,24,43,83,116,144],"an":[19,22],"architecture":[20,39,123],"evaluation":[23],"its":[25,52,152],"merits.":[26],"Based":[27],"on":[28],"both":[29],"industry":[30],"theoretical":[32],"insights,":[33],"we":[34,50,63],"define":[35,64],"data":[37,44,60,79,121],"warehouse":[38,61,67,72,122],"for":[40],"constant":[41,156],"integration":[42,157],"without":[45],"compromising":[46],"query":[47,101,137],"performance,":[48],"evaluate":[51,105],"capacity":[53],"to":[54,74,108],"provide":[55],"realtime.":[56],"For":[57],"this":[58],"real-time":[59],"(RTDW)":[62],"dynamic":[66],"component":[68,73],"static":[71],"represent":[75],"the":[76,81,84,92,106,112,142,145,155],"recently":[77],"integrated":[78],"rest":[82],"data,":[85],"respectively,":[86],"with":[87,126,135],"relevant":[88],"choices":[89,99],"concerning":[90,100],"how":[91],"components":[93],"merge":[94],"together.":[95],"We":[96],"propose":[97],"design":[98],"computation":[102],"mechanisms":[103,149],"alternatives":[107],"conclude":[109],"which":[110],"is":[111,124,161],"most":[113],"efficient":[114],"implementation":[115],"those":[117],"mechanisms.":[118],"The":[119,159],"realtime":[120,128],"evaluated":[125],"benchmark":[129],"setup":[130],"that":[131],"considers":[132],"online":[133],"loading":[134],"simultaneous":[136],"workload":[138],"processing.":[139],"Results":[140],"prove":[141],"validity":[143],"architecture,":[146],"compare":[147],"different":[148],"quantify":[151],"efficiency":[153],"context.":[158],"performance":[160],"carefully":[162],"analysed":[163],"taking":[164],"into":[165],"account":[166],"important":[168],"factors.":[169]},"counts_by_year":[{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2016-06-24T00:00:00"}