{"id":"https://openalex.org/W2006761638","doi":"https://doi.org/10.1145/1451940.1451949","title":"Real-time data warehouse loading methodology","display_name":"Real-time data warehouse loading methodology","publication_year":2008,"publication_date":"2008-01-01","ids":{"openalex":"https://openalex.org/W2006761638","doi":"https://doi.org/10.1145/1451940.1451949","mag":"2006761638"},"language":"en","primary_location":{"id":"doi:10.1145/1451940.1451949","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1451940.1451949","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 international symposium on Database engineering & applications - IDEAS '08","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/A5107051979","display_name":"Ricardo Jorge Santos","orcid":null},"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":true,"raw_author_name":"Ricardo Jorge Santos","raw_affiliation_strings":["University of Coimbra, Coimbra, Portugal","university of coimbra, coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"University of Coimbra, Coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]},{"raw_affiliation_string":"university of coimbra, coimbra, Portugal","institution_ids":["https://openalex.org/I76903346"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007020545","display_name":"Jorge Bernardino","orcid":"https://orcid.org/0000-0001-9660-2011"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jorge Bernardino","raw_affiliation_strings":["Superior Institute of Engineering of Coimbra, Coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"Superior Institute of Engineering of Coimbra, Coimbra, Portugal","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5107051979"],"corresponding_institution_ids":["https://openalex.org/I76903346"],"apc_list":null,"apc_paid":null,"fwci":6.9657,"has_fulltext":false,"cited_by_count":85,"citation_normalized_percentile":{"value":0.969988,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"49","last_page":"49"},"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.9997000098228455,"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.9997000098228455,"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/T11106","display_name":"Data Management and Algorithms","score":0.9977999925613403,"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/T11719","display_name":"Data Quality and Management","score":0.9937000274658203,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.9065349102020264},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8254058361053467},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.745411217212677},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6153953075408936},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.5368367433547974},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.5263356566429138},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5225893259048462},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4883222281932831},{"id":"https://openalex.org/keywords/data-virtualization","display_name":"Data virtualization","score":0.4332560896873474},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.43135330080986023},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.41852283477783203},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.30607151985168457},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.20373228192329407},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.13935279846191406},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09711775183677673}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9065349102020264},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8254058361053467},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.745411217212677},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6153953075408936},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.5368367433547974},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.5263356566429138},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5225893259048462},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4883222281932831},{"id":"https://openalex.org/C80344994","wikidata":"https://www.wikidata.org/wiki/Q5227369","display_name":"Data virtualization","level":4,"score":0.4332560896873474},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.43135330080986023},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.41852283477783203},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.30607151985168457},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.20373228192329407},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.13935279846191406},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09711775183677673},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C513985346","wikidata":"https://www.wikidata.org/wiki/Q270471","display_name":"Virtualization","level":3,"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/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1451940.1451949","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1451940.1451949","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 international symposium on Database engineering & applications - IDEAS '08","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.5199999809265137,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W129057286","https://openalex.org/W173539262","https://openalex.org/W186994102","https://openalex.org/W640404332","https://openalex.org/W1519498445","https://openalex.org/W1523728030","https://openalex.org/W1523736481","https://openalex.org/W1596708276","https://openalex.org/W1604131870","https://openalex.org/W1648759563","https://openalex.org/W2052464302","https://openalex.org/W2053287658","https://openalex.org/W2065668182","https://openalex.org/W2072764742","https://openalex.org/W2100758984","https://openalex.org/W2107159615","https://openalex.org/W2115659114","https://openalex.org/W2118212266","https://openalex.org/W2123733721","https://openalex.org/W2126666814","https://openalex.org/W2132520482","https://openalex.org/W2149576945","https://openalex.org/W2149877754"],"related_works":["https://openalex.org/W16924853","https://openalex.org/W2549774162","https://openalex.org/W2783605540","https://openalex.org/W1021093982","https://openalex.org/W2382405670","https://openalex.org/W2535974884","https://openalex.org/W1582942928","https://openalex.org/W1490264602","https://openalex.org/W2383931363","https://openalex.org/W2488975489"],"abstract_inverted_index":{"A":[0],"data":[1,11,25,27,35,63,75,87,105,116,140,143,176],"warehouse":[2,36,106,144],"provides":[3],"information":[4],"for":[5,73,112,133],"analytical":[6],"processing,":[7],"decision":[8,83],"making":[9],"and":[10,26,44,48,60,108,129],"mining":[12],"tools.":[13],"As":[14],"the":[15,21,142,154,157],"concept":[16],"of":[17,41,156],"real-time":[18,78,86,115],"enterprise":[19],"evolves,":[20],"synchronism":[22],"between":[23,46],"transactional":[24],"warehouses,":[28],"statically":[29],"implemented,":[30],"has":[31],"been":[32],"redefined.":[33],"Traditional":[34],"systems":[37],"have":[38],"static":[39],"structures":[40],"their":[42,58],"schemas":[43,107],"relationships":[45],"data,":[47,135],"therefore":[49],"are":[50,70],"not":[51,71],"able":[52],"to":[53,90,103,136],"support":[54,84],"any":[55],"dynamics":[56],"in":[57,82,141,148,163],"structure":[59,127],"content.":[61],"Their":[62],"is":[64],"only":[65],"periodically":[66],"updated":[67],"because":[68],"they":[69],"prepared":[72],"continuous":[74,175],"integration.":[76,117],"For":[77],"enterprises":[79],"with":[80,145],"needs":[81],"purposes,":[85],"warehouses":[88],"seem":[89],"be":[91],"very":[92],"promising.":[93],"In":[94],"this":[95],"paper":[96],"we":[97,121],"present":[98],"a":[99],"methodology":[100],"on":[101],"how":[102],"adapt":[104],"user-end":[109],"OLAP":[110],"queries":[111],"efficiently":[113],"supporting":[114],"To":[118],"accomplish":[119],"this,":[120],"use":[122],"techniques":[123],"such":[124],"as":[125],"table":[126],"replication":[128],"query":[130,149,164,170],"predicate":[131],"restrictions":[132],"selecting":[134],"enable":[137],"continuously":[138],"loading":[139],"minimum":[146],"impact":[147,162],"execution":[150],"time.":[151],"We":[152],"demonstrate":[153],"efficiency":[155],"method":[158],"by":[159],"analyzing":[160],"its":[161],"performance":[165],"using":[166],"benchmark":[167],"TPC-H":[168],"executing":[169],"workloads":[171],"while":[172],"simultaneously":[173],"performing":[174],"integration":[177],"at":[178],"various":[179],"insertion":[180],"time":[181],"rates.":[182]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":8},{"year":2014,"cited_by_count":11},{"year":2013,"cited_by_count":12},{"year":2012,"cited_by_count":12}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}