{"id":"https://openalex.org/W4284964210","doi":"https://doi.org/10.1007/s10619-022-07417-7","title":"Recursive SQL and GPU-support for in-database machine learning","display_name":"Recursive SQL and GPU-support for in-database machine learning","alternate_titles":[],"publication_year":2022,"publication_date":"2022-07-09","ids":{"openalex":"https://openalex.org/W4284964210","doi":"https://doi.org/10.1007/s10619-022-07417-7"},"language":"en","primary_location":{"id":"doi:10.1007/s10619-022-07417-7","doi":"https://doi.org/10.1007/s10619-022-07417-7","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10619-022-07417-7","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10619-022-07417-7.pdf","source":{"id":"https://openalex.org/S35927321","display_name":"Distributed and Parallel Databases","issn_l":"0926-8782","issn":["0926-8782","1573-7578"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-c","cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-3"],"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Distributed and Parallel Databases","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4284964210"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s10619-022-07417-7.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5051889128","display_name":"Maximilian Emanuel Sch\u00fcle","orcid":"https://orcid.org/0000-0003-1546-269X","observed_orcids":["https://orcid.org/0000-0003-1546-269X"]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Maximilian E. Sch\u00fcle","raw_affiliation_strings":["TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany"],"raw_orcid":"https://orcid.org/0000-0003-1546-269X","affiliations":[{"raw_affiliation_string":"TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Harald Lang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Harald Lang","raw_affiliation_strings":["TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111859470","display_name":"Maximilian Springer","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Maximilian Springer","raw_affiliation_strings":["TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105817801","display_name":"Alfons Kemper","orcid":"https://orcid.org/0009-0003-9066-271X","observed_orcids":["https://orcid.org/0009-0003-9066-271X"]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Alfons Kemper","raw_affiliation_strings":["TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101880157","display_name":"Thomas Neumann","orcid":"https://orcid.org/0000-0001-5787-142X","observed_orcids":["https://orcid.org/0000-0001-5787-142X"]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Thomas Neumann","raw_affiliation_strings":["TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074504351","display_name":"Stephan G\u00fcnnemann","orcid":"https://orcid.org/0000-0001-7772-5059","observed_orcids":["https://orcid.org/0000-0001-7772-5059"]},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Stephan G\u00fcnnemann","raw_affiliation_strings":["TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TUM, Boltzmannstr. 3, 85748, Garching, Bavaria, Germany","institution_ids":["https://openalex.org/I62916508"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5051889128"],"corresponding_institution_ids":["https://openalex.org/I62916508"],"apc_list":{"value":2890,"currency":"USD","value_usd":2890},"apc_paid":{"value":2890,"currency":"USD","value_usd":2890},"fwci":1.2403,"has_fulltext":true,"cited_by_count":15,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.80157341,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":98},"biblio":{"volume":"40","issue":"2-3","first_page":"205","last_page":"259"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9907000064849854,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9907000064849854,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.004900000058114529,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/in-database-machine-learning","display_name":"in-database machine learning","score":0.9559999704360962},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4580000042915344},{"id":"https://openalex.org/keywords/automatic-differentiation","display_name":"automatic differentiation","score":0.9120000004768372},{"id":"https://openalex.org/keywords/gradient-descent","display_name":"gradient descent","score":0.8209999799728394},{"id":"https://openalex.org/keywords/gpu-acceleration","display_name":"GPU acceleration","score":0.5659999847412109},{"id":"https://openalex.org/keywords/loss-functions","display_name":"loss functions","score":0.5950000286102295},{"id":"https://openalex.org/keywords/code-generation","display_name":"code generation","score":0.7070000171661377},{"id":"https://openalex.org/keywords/llvm","display_name":"LLVM","score":0.5929999947547913},{"id":"https://openalex.org/keywords/umbra","display_name":"umbra","score":0.492000013589859},{"id":"https://openalex.org/keywords/machine-learning-pipelines","display_name":"machine learning pipelines","score":0.5220000147819519}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8622684478759766},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.581160306930542},{"id":"https://openalex.org/C133512626","wikidata":"https://www.wikidata.org/wiki/Q787371","display_name":"Automatic differentiation","level":3,"score":0.5708335041999817},{"id":"https://openalex.org/C2778119891","wikidata":"https://www.wikidata.org/wiki/Q477690","display_name":"CUDA","level":2,"score":0.5191161632537842},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.4690568745136261},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.43433594703674316},{"id":"https://openalex.org/C74193536","wikidata":"https://www.wikidata.org/wiki/Q574844","display_name":"Kernel (algebra)","level":2,"score":0.41995877027511597},{"id":"https://openalex.org/C34736171","wikidata":"https://www.wikidata.org/wiki/Q918333","display_name":"Preprocessor","level":2,"score":0.4164867401123047},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.39217835664749146},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3828417658805847},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3268807530403137},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.3218232989311218},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.12365639209747314},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","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":4,"locations":[{"id":"doi:10.1007/s10619-022-07417-7","doi":"https://doi.org/10.1007/s10619-022-07417-7","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10619-022-07417-7","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10619-022-07417-7.pdf","source":{"id":"https://openalex.org/S35927321","display_name":"Distributed and Parallel Databases","issn_l":"0926-8782","issn":["0926-8782","1573-7578"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-c","cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-3"],"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Distributed and Parallel Databases","raw_type":"journal-article"},{"id":"pmh:oai:mediatum.ub.tum.de:node/1763871","doi":null,"is_oa":true,"landing_page_url":"https://mediatum.ub.tum.de/1763871","pdf_url":null,"source":{"id":"https://openalex.org/S4306400453","display_name":"mediaTUM (Technical University of Munich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I62916508","host_organization_name":"Technical University of Munich","host_organization_lineage":["https://openalex.org/I62916508"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"pmh:oai:mediatum.ub.tum.de:node/1795484","doi":null,"is_oa":true,"landing_page_url":"https://mediatum.ub.tum.de/1795484","pdf_url":null,"source":{"id":"https://openalex.org/S4306400453","display_name":"mediaTUM (Technical University of Munich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I62916508","host_organization_name":"Technical University of Munich","host_organization_lineage":["https://openalex.org/I62916508"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"doi:10.18420/btw2023-62","doi":"https://doi.org/10.18420/btw2023-62","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2023-62","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4210134436","host_organization_name":"German Informatics Society","host_organization_lineage":["https://openalex.org/I4210134436"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.1007/s10619-022-07417-7","doi":"https://doi.org/10.1007/s10619-022-07417-7","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10619-022-07417-7","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10619-022-07417-7.pdf","source":{"id":"https://openalex.org/S35927321","display_name":"Distributed and Parallel Databases","issn_l":"0926-8782","issn":["0926-8782","1573-7578"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-c","cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-3"],"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Distributed and Parallel Databases","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320323383","display_name":"Technische Universit\u00e4t M\u00fcnchen","ror":"https://ror.org/02kkvpp62"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4284964210.pdf","grobid_xml":"https://content.openalex.org/works/W4284964210.grobid-xml"},"referenced_works_count":66,"referenced_works":["https://openalex.org/W1979107684","https://openalex.org/W2001619934","https://openalex.org/W2007759057","https://openalex.org/W2020199039","https://openalex.org/W2035476608","https://openalex.org/W2093402788","https://openalex.org/W2097983418","https://openalex.org/W2102729946","https://openalex.org/W2106771621","https://openalex.org/W2124730187","https://openalex.org/W2148251931","https://openalex.org/W2152377671","https://openalex.org/W2266577992","https://openalex.org/W2278803301","https://openalex.org/W2290782711","https://openalex.org/W2571969736","https://openalex.org/W2591728388","https://openalex.org/W2604157164","https://openalex.org/W2604523703","https://openalex.org/W2695879227","https://openalex.org/W2752488889","https://openalex.org/W2753588408","https://openalex.org/W2767081117","https://openalex.org/W2767766062","https://openalex.org/W2803349759","https://openalex.org/W2805214778","https://openalex.org/W2911546574","https://openalex.org/W2928069584","https://openalex.org/W2934209801","https://openalex.org/W2935389012","https://openalex.org/W2937822179","https://openalex.org/W2948062280","https://openalex.org/W2948085204","https://openalex.org/W2948802729","https://openalex.org/W2966095869","https://openalex.org/W2966314645","https://openalex.org/W2966673242","https://openalex.org/W2970139027","https://openalex.org/W2971290973","https://openalex.org/W2971428651","https://openalex.org/W2971874466","https://openalex.org/W2987401328","https://openalex.org/W2989078842","https://openalex.org/W2999347085","https://openalex.org/W3008396642","https://openalex.org/W3012502136","https://openalex.org/W3013316555","https://openalex.org/W3014535178","https://openalex.org/W3016180335","https://openalex.org/W3029713723","https://openalex.org/W3029775758","https://openalex.org/W3030879513","https://openalex.org/W3034860472","https://openalex.org/W3046301602","https://openalex.org/W3085075268","https://openalex.org/W3086916597","https://openalex.org/W3094116934","https://openalex.org/W3112994350","https://openalex.org/W3148122658","https://openalex.org/W3152420077","https://openalex.org/W3173442755","https://openalex.org/W3193781380","https://openalex.org/W3194052658","https://openalex.org/W4212869709","https://openalex.org/W4246166885","https://openalex.org/W4288365054"],"related_works":["https://openalex.org/W3194052658","https://openalex.org/W3015253292","https://openalex.org/W3126670173","https://openalex.org/W4400909497","https://openalex.org/W7039188723","https://openalex.org/W2965445919","https://openalex.org/W4288365054","https://openalex.org/W4413360540","https://openalex.org/W2971169561","https://openalex.org/W3174677704"],"abstract_inverted_index":{"In":[0,47,161],"machine":[1,64,114,196],"learning,":[2],"continuously":[3],"retraining":[4],"a":[5,25,62,109,126,137,151],"model":[6,71,139],"guarantees":[7],"accurate":[8],"predictions":[9],"based":[10],"on":[11,140],"the":[12,21,78,85,102,167,170],"latest":[13,22],"data":[14,23,69],"as":[15,31,41,108],"training":[16,72],"input.":[17],"But":[18],"to":[19,60,135,149,176],"retrieve":[20],"from":[24],"database,":[26],"time-consuming":[27],"extraction":[28],"is":[29],"necessary":[30],"database":[32,87],"systems":[33],"have":[34],"rarely":[35],"been":[36],"used":[37],"for":[38,93,96,116,125,191],"operations":[39],"such":[40],"matrix":[42],"algebra":[43],"and":[44,73,154],"gradient":[45,128],"descent.":[46],"this":[48],"work,":[49],"we":[50,83],"demonstrate":[51],"that":[52],"SQL":[53,107,200],"with":[54,184],"recursive":[55,99],"tables":[56],"makes":[57],"it":[58],"possible":[59],"express":[61],"complete":[63],"learning":[65,197],"pipeline":[66],"out":[67],"of":[68,80,158,172],"preprocessing,":[70],"its":[74],"validation.":[75],"To":[76],"facilitate":[77],"specification":[79],"loss":[81,103],"functions,":[82],"extend":[84],"code-generating":[86],"system":[88],"Umbra":[89,112],"by":[90,169],"an":[91],"operator":[92],"automatic":[94,123,164],"differentiation":[95,124,165],"use":[97,122],"within":[98,199],"tables:":[100],"With":[101],"function":[104],"expressed":[105],"in":[106],"lambda":[110],"function,":[111],"generates":[113,132],"code":[115,134],"each":[117,178],"partial":[118],"derivative.":[119],"We":[120,142],"further":[121],"dedicated":[127],"descent":[129],"operator,":[130],"which":[131],"LLVM":[133],"train":[136],"user-specified":[138],"GPUs.":[141],"fine-tune":[143],"GPU":[144,182],"kernels":[145,183],"at":[146],"hardware":[147],"level":[148],"allow":[150],"higher":[152],"throughput":[153,189],"propose":[155],"non-blocking":[156],"synchronisation":[157],"multiple":[159],"units.":[160],"our":[162],"evaluation,":[163],"accelerated":[166],"runtime":[168],"number":[171],"cached":[173],"subexpressions":[174],"compared":[175],"compiling":[177],"derivative":[179],"separately.":[180],"Our":[181],"independent":[185],"models":[186],"allowed":[187],"maximal":[188],"even":[190],"small":[192],"batch":[193],"sizes,":[194],"making":[195],"pipelines":[198],"more":[201],"competitive.":[202]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4284964210","counts_by_year":[{"year":2026,"cited_by_count":5},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":3}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2022-07-10T00:00:00"}
