{"id":"https://openalex.org/W2160393829","doi":"https://doi.org/10.1145/2452376.2452444","title":"Near real-time analytics with IBM DB2 analytics accelerator","display_name":"Near real-time analytics with IBM DB2 analytics accelerator","publication_year":2013,"publication_date":"2013-03-18","ids":{"openalex":"https://openalex.org/W2160393829","doi":"https://doi.org/10.1145/2452376.2452444","mag":"2160393829"},"language":"en","primary_location":{"id":"doi:10.1145/2452376.2452444","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452444","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-article"},"type":"conference-paper","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/A5078835583","display_name":"Daniel Mart\u00edn","orcid":"https://orcid.org/0000-0003-3378-7551"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Daniel Martin","raw_affiliation_strings":["IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050296437","display_name":"Oliver Koeth","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Oliver Koeth","raw_affiliation_strings":["IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031438072","display_name":"Johannes Kern","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Johannes Kern","raw_affiliation_strings":["IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061628358","display_name":"Iliyana Ivanova","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Iliyana Ivanova","raw_affiliation_strings":["IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM DB2 Analytics Accelerator Development, IBM Deutschland Research & Development GmbH, Boeblingen, Germany","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2517,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.53312909,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"579","last_page":"588"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9995999932289124,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9990000128746033,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9986000061035156,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.882607102394104},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.764130175113678},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.6914733648300171},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5744842886924744},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.5607904195785522},{"id":"https://openalex.org/keywords/ibm","display_name":"IBM","score":0.5387957692146301},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5267690420150757},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.4936855733394623},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.4923611879348755},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.48784661293029785},{"id":"https://openalex.org/keywords/replication","display_name":"Replication (statistics)","score":0.4224146008491516},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.41754886507987976},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.41581499576568604},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.41507595777511597},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.39999040961265564},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.25292086601257324},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.24190384149551392},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.20218431949615479}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.882607102394104},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.764130175113678},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6914733648300171},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5744842886924744},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.5607904195785522},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.5387957692146301},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5267690420150757},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.4936855733394623},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4923611879348755},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.48784661293029785},{"id":"https://openalex.org/C12590798","wikidata":"https://www.wikidata.org/wiki/Q3933199","display_name":"Replication (statistics)","level":2,"score":0.4224146008491516},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.41754886507987976},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.41581499576568604},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.41507595777511597},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.39999040961265564},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.25292086601257324},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.24190384149551392},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.20218431949615479},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2452376.2452444","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452444","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.308.8740","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.308.8740","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.edbt.org/Proceedings/2013-Genova/papers/edbt/a52-martin.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W175906072","https://openalex.org/W1484420901","https://openalex.org/W1507724384","https://openalex.org/W1560510652","https://openalex.org/W1969877208","https://openalex.org/W1977330283","https://openalex.org/W2016829627","https://openalex.org/W2039910065","https://openalex.org/W2100542992","https://openalex.org/W2113831242","https://openalex.org/W2125775320","https://openalex.org/W2125834523","https://openalex.org/W2406267662","https://openalex.org/W2596218679"],"related_works":["https://openalex.org/W2804682780","https://openalex.org/W2084383859","https://openalex.org/W3166336118","https://openalex.org/W2188262136","https://openalex.org/W834810655","https://openalex.org/W2188975716","https://openalex.org/W171602259","https://openalex.org/W2102729946","https://openalex.org/W2240092424","https://openalex.org/W2963350265"],"abstract_inverted_index":{"The":[0,180],"IBM":[1,62],"DB2":[2,35,39,50,63,72,99,216],"Analytics":[3,64],"Accelerator":[4,65,214],"(IDAA)":[5],"implements":[6],"the":[7,38,60,71,79,98,105,156,160,195,200,213,220,228,232,244,247,262,271],"vision":[8],"of":[9,70,83,207,246,251,270],"a":[10,21,43,146,208],"universal":[11],"relational":[12],"DBMS":[13],"that":[14,66,85,96,133,142,257],"processes":[15],"OLTP":[16,121],"and":[17,102,122,158,205,231,253],"analytical-type":[18],"queries":[19,129],"in":[20,34,90,137,239],"single":[22],"system,":[23],"but":[24],"on":[25,32,68,145],"two":[26],"fundamentally":[27],"different":[28,263],"query":[29,44,182],"engines.":[30],"Based":[31],"heuristics":[33],"for":[36,175,202,217],"z/OS,":[37],"optimizer":[40],"decides":[41],"if":[42,52],"should":[45],"be":[46,173],"executed":[47],"by":[48,92,185,227],"\"mainline\"":[49],"or":[51,148],"it":[53,58,188],"is":[54,134],"beneficial":[55],"to":[56,59,107,139,155,162,190],"offload":[57],"attached":[61],"operates":[67],"copies":[69],"tables.":[73],"In":[74],"this":[75],"paper,":[76],"we":[77,258],"introduce":[78,163],"\"incremental":[80],"update\"":[81],"functionality":[82],"IDAA":[84,186,252],"keeps":[86],"these":[87],"copy":[88],"tables":[89],"sync":[91],"employing":[93],"replication":[94,233,249],"technology":[95],"monitors":[97],"transaction":[100],"log":[101],"asynchronously":[103],"applies":[104],"changes":[106,154,238],"IDAA.":[108],"This":[109],"enables":[110],"near":[111,240],"real-time":[112],"analytics":[113],"over":[114],"online":[115],"data,":[116],"effectively":[117],"marrying":[118],"traditionally":[119],"separated":[120],"data":[123,132,170,176,237],"warehouse":[124],"environments.":[125],"With":[126],"IDAA,":[127],"analytic":[128,181],"can":[130,172],"access":[131],"constantly":[135],"refreshed":[136],"contrast":[138],"traditional":[140],"warehouses":[141],"are":[143],"updated":[144],"daily":[147],"even":[149],"weekly":[150],"basis.":[151],"Without":[152],"any":[153],"applications":[157],"without":[159],"need":[161,201],"cross-system":[164],"ETL":[165],"flows,":[166],"an":[167],"existing":[168],"operational":[169],"store":[171],"used":[174],"warehousing":[177],"as":[178,219,265,267],"well.":[179],"performance":[183,224,268],"provided":[184],"makes":[187],"possible":[189],"execute":[191],"reports":[192],"directly":[193],"against":[194],"transactional":[196,221],"schema,":[197],"thus":[198],"avoiding":[199],"costly":[203],"design":[204,255],"maintenance":[206],"separate":[209],"reporting":[210],"schema.":[211],"Additionally,":[212],"shields":[215],"z/OS":[218],"system":[222],"from":[223],"degradation":[225],"caused":[226],"analytical":[229],"workload":[230],"component":[234,250],"synchronizes":[235],"all":[236],"real-time.":[241],"We":[242],"present":[243],"architecture":[245],"integrated":[248],"discuss":[254],"decisions":[256],"made":[259],"when":[260],"combining":[261],"technologies":[264],"well":[266],"characteristics":[269],"resulting":[272],"system.":[273]},"counts_by_year":[{"year":2015,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}