{"id":"https://openalex.org/W2044849727","doi":"https://doi.org/10.14778/2367502.2367510","title":"The MADlib analytics library","display_name":"The MADlib analytics library","publication_year":2012,"publication_date":"2012-08-01","ids":{"openalex":"https://openalex.org/W2044849727","doi":"https://doi.org/10.14778/2367502.2367510","mag":"2044849727"},"language":"en","primary_location":{"id":"doi:10.14778/2367502.2367510","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2367502.2367510","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5043626252","display_name":"Joseph M. Hellerstein","orcid":"https://orcid.org/0000-0002-7712-4306"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joseph M. Hellerstein","raw_affiliation_strings":["U.C. Berkeley","U.C. BERKELEY"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"U.C. Berkeley","institution_ids":["https://openalex.org/I95457486"]},{"raw_affiliation_string":"U.C. BERKELEY","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083143788","display_name":"Christoper R\u00e9","orcid":null},"institutions":[{"id":"https://openalex.org/I1304256225","display_name":"University of Wisconsin System","ror":"https://ror.org/03ydkyb10","country_code":"US","type":"education","lineage":["https://openalex.org/I1304256225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Christoper R\u00e9","raw_affiliation_strings":["U. Wisconsin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"U. Wisconsin","institution_ids":["https://openalex.org/I1304256225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067160468","display_name":"Florian Schoppmann","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Florian Schoppmann","raw_affiliation_strings":["Greenplum"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Greenplum","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003464266","display_name":"Daisy Zhe Wang","orcid":"https://orcid.org/0009-0003-8234-5482"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Daisy Zhe Wang","raw_affiliation_strings":["U. Florida"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"U. Florida","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057152887","display_name":"Eugene Fratkin","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Eugene Fratkin","raw_affiliation_strings":["Greenplum"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Greenplum","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041032168","display_name":"Aleksander Gorajek","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Aleksander Gorajek","raw_affiliation_strings":["Greenplum"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Greenplum","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048997284","display_name":"Kee Siong Ng","orcid":"https://orcid.org/0000-0003-0701-8783"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kee Siong Ng","raw_affiliation_strings":["Greenplum"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Greenplum","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061740717","display_name":"Caleb Welton","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Caleb Welton","raw_affiliation_strings":["Greenplum"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Greenplum","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070588519","display_name":"Xixuan Feng","orcid":null},"institutions":[{"id":"https://openalex.org/I1304256225","display_name":"University of Wisconsin System","ror":"https://ror.org/03ydkyb10","country_code":"US","type":"education","lineage":["https://openalex.org/I1304256225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xixuan Feng","raw_affiliation_strings":["U. Wisconsin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"U. Wisconsin","institution_ids":["https://openalex.org/I1304256225"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100377520","display_name":"Kun Li","orcid":"https://orcid.org/0000-0001-9164-7691"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kun Li","raw_affiliation_strings":["U. Florida"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"U. Florida","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103749365","display_name":"Arun Kumar","orcid":null},"institutions":[{"id":"https://openalex.org/I1304256225","display_name":"University of Wisconsin System","ror":"https://ror.org/03ydkyb10","country_code":"US","type":"education","lineage":["https://openalex.org/I1304256225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Arun Kumar","raw_affiliation_strings":["U. Wisconsin"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"U. Wisconsin","institution_ids":["https://openalex.org/I1304256225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":11,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":33.1646,"has_fulltext":false,"cited_by_count":369,"citation_normalized_percentile":{"value":0.99831431,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":"5","issue":"12","first_page":"1700","last_page":"1711"},"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.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"}},"topics":[{"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9965000152587891,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9908999800682068,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/computer-science","display_name":"Computer science","score":0.834770917892456},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6453425884246826},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.640275239944458},{"id":"https://openalex.org/keywords/suite","display_name":"Suite","score":0.6343307495117188},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.5694418549537659},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5400598049163818},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5208638310432434},{"id":"https://openalex.org/keywords/open-source","display_name":"Open source","score":0.479771226644516},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.46421507000923157},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.42143484950065613},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.367931604385376},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.31574547290802},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15007343888282776},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12479367852210999}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.834770917892456},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6453425884246826},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.640275239944458},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.6343307495117188},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.5694418549537659},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5400598049163818},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5208638310432434},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.479771226644516},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.46421507000923157},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.42143484950065613},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.367931604385376},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.31574547290802},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15007343888282776},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12479367852210999},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","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/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/2367502.2367510","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2367502.2367510","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:alma.61RMIT_INST:11247000310001341","is_oa":false,"landing_page_url":"http://doi.org/10.14778/2367502.2367510","pdf_url":null,"source":{"id":"https://openalex.org/S4306402074","display_name":"RMIT Research Repository (RMIT University Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I82951845","host_organization_name":"RMIT University","host_organization_lineage":["https://openalex.org/I82951845"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","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.5400000214576721}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W31634058","https://openalex.org/W47292847","https://openalex.org/W182831726","https://openalex.org/W189514790","https://openalex.org/W398759745","https://openalex.org/W650854417","https://openalex.org/W1480928214","https://openalex.org/W1568668329","https://openalex.org/W1896160955","https://openalex.org/W1966901553","https://openalex.org/W1994616650","https://openalex.org/W2001496424","https://openalex.org/W2024228866","https://openalex.org/W2039950257","https://openalex.org/W2073459066","https://openalex.org/W2083541728","https://openalex.org/W2086959852","https://openalex.org/W2090850279","https://openalex.org/W2102458936","https://openalex.org/W2103718624","https://openalex.org/W2109722477","https://openalex.org/W2114303224","https://openalex.org/W2117293168","https://openalex.org/W2121737596","https://openalex.org/W2131975293","https://openalex.org/W2134414349","https://openalex.org/W2135046866","https://openalex.org/W2142384583","https://openalex.org/W2146635036","https://openalex.org/W2147880316","https://openalex.org/W2150593711","https://openalex.org/W2151234409","https://openalex.org/W2156858199","https://openalex.org/W2160039585","https://openalex.org/W2166706236","https://openalex.org/W2170616854","https://openalex.org/W2170648111","https://openalex.org/W2206925937","https://openalex.org/W2296319761","https://openalex.org/W2318935314","https://openalex.org/W2798766386","https://openalex.org/W3119603699","https://openalex.org/W4229666556","https://openalex.org/W4236558082","https://openalex.org/W4239025233","https://openalex.org/W4248008732","https://openalex.org/W4250589301","https://openalex.org/W6607642809","https://openalex.org/W6679720444","https://openalex.org/W6684249991","https://openalex.org/W6750230808"],"related_works":["https://openalex.org/W2058965144","https://openalex.org/W2164382479","https://openalex.org/W2146343568","https://openalex.org/W98480971","https://openalex.org/W2150291671","https://openalex.org/W2013643406","https://openalex.org/W2027972911","https://openalex.org/W2157978810","https://openalex.org/W3005935371","https://openalex.org/W2093907010"],"abstract_inverted_index":{"MADlib":[0,46,86,171],"is":[1,44,57,165,172,180],"a":[2,30,50,65,116,132,147],"free,":[3],"open-source":[4,101],"library":[5,62],"of":[6,15,68,107,118,131,138,167,184],"in-database":[7],"analytic":[8],"methods.":[9],"It":[10],"provides":[11],"an":[12,105],"evolving":[13],"suite":[14],"SQL-based":[16],"algorithms":[17],"for":[18,36,45,52,63,99,182],"machine":[19],"learning,":[20],"data":[21,37],"mining":[22],"and":[23,76,96,111,114,128,177,188],"statistics":[24],"that":[25,56,91,123],"run":[26],"at":[27,158,175],"scale":[28,75],"within":[29],"database":[31,54,192],"engine,":[32],"with":[33,74],"no":[34],"need":[35],"import/export":[38],"to":[39,47,59,93,190],"other":[40],"tools.":[41],"The":[42],"goal":[43],"eventually":[48],"serve":[49],"role":[51],"scalable":[53],"systems":[55],"similar":[58],"the":[60,85,89,97,108,142,168,178],"CRAN":[61],"R:":[64],"community":[66],"repository":[67],"statistical":[69,120],"methods,":[70,187],"this":[71,81],"time":[72],"written":[73],"parallelism":[77],"in":[78,122],"mind.":[79],"In":[80],"paper":[82],"we":[83],"introduce":[84],"project,":[87],"including":[88],"background":[90],"led":[92],"its":[94,100],"beginnings,":[95],"motivation":[98],"nature.":[102],"We":[103,125,151],"provide":[104,115],"overview":[106],"library's":[109],"architecture":[110],"design":[112,134],"patterns,":[113],"description":[117],"various":[119],"methods":[121,140],"context.":[124],"include":[126],"performance":[127],"speedup":[129],"results":[130],"core":[133],"pattern":[135],"from":[136],"one":[137,166],"those":[139],"over":[141],"Greenplum":[143],"parallel":[144],"DBMS":[145],"on":[146,154],"modest-sized":[148],"test":[149],"cluster.":[150],"then":[152],"report":[153],"two":[155],"initial":[156],"efforts":[157],"incorporating":[159],"academic":[160],"research":[161],"into":[162],"MADlib,":[163],"which":[164],"project's":[169],"goals.":[170],"freely":[173],"available":[174],"http://madlib.net,":[176],"project":[179],"open":[181],"contributions":[183],"both":[185],"new":[186],"ports":[189],"additional":[191],"platforms.":[193]},"counts_by_year":[{"year":2026,"cited_by_count":6},{"year":2025,"cited_by_count":14},{"year":2024,"cited_by_count":11},{"year":2023,"cited_by_count":8},{"year":2022,"cited_by_count":19},{"year":2021,"cited_by_count":36},{"year":2020,"cited_by_count":38},{"year":2019,"cited_by_count":34},{"year":2018,"cited_by_count":39},{"year":2017,"cited_by_count":42},{"year":2016,"cited_by_count":35},{"year":2015,"cited_by_count":27},{"year":2014,"cited_by_count":32},{"year":2013,"cited_by_count":26},{"year":2012,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}