{"id":"https://openalex.org/W2090850279","doi":"https://doi.org/10.1145/2213836.2213874","title":"Towards a unified architecture for in-RDBMS analytics","display_name":"Towards a unified architecture for in-RDBMS analytics","publication_year":2012,"publication_date":"2012-05-20","ids":{"openalex":"https://openalex.org/W2090850279","doi":"https://doi.org/10.1145/2213836.2213874","mag":"2090850279"},"language":"en","primary_location":{"id":"doi:10.1145/2213836.2213874","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2213836.2213874","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data","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/A5070588519","display_name":"Xixuan Feng","orcid":null},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xixuan Feng","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103749365","display_name":"Arun Kumar","orcid":null},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Arun Kumar","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012870568","display_name":"Benjamin Recht","orcid":"https://orcid.org/0000-0002-0293-593X"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Benjamin Recht","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103852640","display_name":"Christopher R\u00e9","orcid":null},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Christopher R\u00e9","raw_affiliation_strings":["University of Wisconsin-Madison, Madison, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison, Madison, WI, USA","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":179,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"325","last_page":"336"},"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.9991000294685364,"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.9991000294685364,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9944999814033508,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9944999814033508,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8645505309104919},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.8056005239486694},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.7679669857025146},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.5057296752929688},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4901800751686096},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.46498531103134155},{"id":"https://openalex.org/keywords/data-analysis","display_name":"Data analysis","score":0.42105403542518616},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.412830650806427},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.34586089849472046},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.29218095541000366},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.19756704568862915},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.139413982629776}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8645505309104919},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.8056005239486694},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.7679669857025146},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5057296752929688},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4901800751686096},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.46498531103134155},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.42105403542518616},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.412830650806427},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.34586089849472046},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.29218095541000366},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.19756704568862915},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.139413982629776},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"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":4,"locations":[{"id":"doi:10.1145/2213836.2213874","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2213836.2213874","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.229.2618","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.229.2618","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.wisc.edu/%7Ebrecht/papers/12.FengEtAl.SIGMOD.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.366.2377","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.366.2377","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://hazy.cs.wisc.edu/hazy/papers/bismarck-full.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.755.2052","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.755.2052","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://arxiv.org/pdf/1203.2574.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.5799999833106995}],"awards":[],"funders":[{"id":"https://openalex.org/F4320337345","display_name":"Office of Naval Research","ror":"https://ror.org/00rk2pe57"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":56,"referenced_works":["https://openalex.org/W189514790","https://openalex.org/W1480376833","https://openalex.org/W1487813067","https://openalex.org/W1506285740","https://openalex.org/W1554944419","https://openalex.org/W1558832481","https://openalex.org/W1962705364","https://openalex.org/W1970997001","https://openalex.org/W1980147176","https://openalex.org/W1992208280","https://openalex.org/W1994616650","https://openalex.org/W2038497950","https://openalex.org/W2058494157","https://openalex.org/W2060591526","https://openalex.org/W2061863621","https://openalex.org/W2063046368","https://openalex.org/W2070986426","https://openalex.org/W2076503082","https://openalex.org/W2090850279","https://openalex.org/W2092819480","https://openalex.org/W2095531095","https://openalex.org/W2102486516","https://openalex.org/W2110871651","https://openalex.org/W2113651538","https://openalex.org/W2114157818","https://openalex.org/W2114242687","https://openalex.org/W2116832440","https://openalex.org/W2117151961","https://openalex.org/W2119273405","https://openalex.org/W2119885577","https://openalex.org/W2120293976","https://openalex.org/W2134130436","https://openalex.org/W2134414349","https://openalex.org/W2135046866","https://openalex.org/W2136360692","https://openalex.org/W2138243089","https://openalex.org/W2139224857","https://openalex.org/W2144810465","https://openalex.org/W2146635036","https://openalex.org/W2166706236","https://openalex.org/W2296319761","https://openalex.org/W2616657226","https://openalex.org/W2798766386","https://openalex.org/W2951781666","https://openalex.org/W3007702476","https://openalex.org/W4206031975","https://openalex.org/W4230348051","https://openalex.org/W4254313632","https://openalex.org/W6607642809","https://openalex.org/W6633513001","https://openalex.org/W6675672627","https://openalex.org/W6677106874","https://openalex.org/W6679720444","https://openalex.org/W6680165598","https://openalex.org/W6684249991","https://openalex.org/W6750230808"],"related_works":["https://openalex.org/W4226266853","https://openalex.org/W4210252074","https://openalex.org/W2949223857","https://openalex.org/W3092201768","https://openalex.org/W2090850279","https://openalex.org/W2796632413","https://openalex.org/W2740083192","https://openalex.org/W2794907032","https://openalex.org/W4255802207","https://openalex.org/W4299701476"],"abstract_inverted_index":{"The":[0],"increasing":[1],"use":[2],"of":[3,65,91,107,123,139,150,176],"statistical":[4,34,182],"data":[5,134],"analysis":[6],"in":[7,27,41,75],"enterprise":[8],"applications":[9],"has":[10],"created":[11],"an":[12,108],"arms":[13],"race":[14,29],"among":[15],"database":[16],"vendors":[17],"to":[18,46,79,170,178],"offer":[19],"ever":[20],"more":[21],"sophisticated":[22],"in-database":[23,70],"analytics.":[24,71],"One":[25],"challenge":[26],"this":[28,60,76],"is":[30,62,78,95,135],"that":[31,55,96,127,205],"each":[32],"new":[33,181],"technique":[35],"must":[36],"be":[37,103],"implemented":[38],"from":[39],"scratch":[40],"the":[42,56,63,132,148,190,196,216],"RDBMS,":[43],"which":[44],"leads":[45],"a":[47,66,81,85,142,172,180],"lengthy":[48],"and":[49,120,137,162,203],"complex":[50],"development":[51],"process.":[52],"We":[53,146,184],"argue":[54],"root":[57],"cause":[58],"for":[59,69,99],"overhead":[61],"lack":[64],"unified":[67,86,93],"architecture":[68,94,152,167],"Our":[72,166],"main":[73],"contribution":[74],"work":[77],"take":[80],"step":[82],"towards":[83],"such":[84],"architecture.":[87],"A":[88],"key":[89,125],"benefit":[90],"our":[92,115,151,187,206],"performance":[97],"optimizations":[98],"analytics":[100,157,192,201],"techniques":[101,158],"can":[102],"studied":[104],"generically":[105],"instead":[106],"ad":[109],"hoc,":[110],"per-technique":[111],"fashion.":[112],"In":[113],"particular,":[114],"technical":[116],"contributions":[117],"are":[118],"theoretical":[119],"empirical":[121],"studies":[122],"two":[124,160],"factors":[126],"we":[128],"found":[129],"impact":[130],"performance:":[131],"order":[133],"stored,":[136],"parallelization":[138],"computations":[140],"on":[141,199],"single-node":[143],"multicore":[144],"RDBMS.":[145,165],"demonstrate":[147],"feasibility":[149],"by":[153,195],"integrating":[154],"several":[155],"popular":[156],"into":[159],"commercial":[161,197],"one":[163],"open-source":[164],"requires":[168],"changes":[169],"only":[171],"few":[173],"dozen":[174],"lines":[175],"code":[177],"integrate":[179],"technique.":[183],"then":[185],"compare":[186],"approach":[188,207],"with":[189],"native":[191],"tools":[193],"offered":[194],"RDBMSes":[198],"various":[200],"tasks,":[202],"validate":[204],"achieves":[208],"competitive":[209],"or":[210],"higher":[211],"performance,":[212],"while":[213],"still":[214],"achieving":[215],"same":[217],"quality.":[218]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":8},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":12},{"year":2021,"cited_by_count":13},{"year":2020,"cited_by_count":12},{"year":2019,"cited_by_count":21},{"year":2018,"cited_by_count":19},{"year":2017,"cited_by_count":22},{"year":2016,"cited_by_count":24},{"year":2015,"cited_by_count":7},{"year":2014,"cited_by_count":8},{"year":2013,"cited_by_count":18},{"year":2012,"cited_by_count":9}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}