Database Integrated Analytics Using R: Initial Experiences with SQL-Server + R
Visualitza/Obre
Cita com:
hdl:2117/102772
Tipus de documentComunicació de congrés
Data publicació2017-02-02
EditorInstitute of Electrical and Electronics Engineers (IEEE)
Condicions d'accésAccés obert
Tots els drets reservats. Aquesta obra està protegida pels drets de propietat intel·lectual i
industrial corresponents. Sense perjudici de les exempcions legals existents, queda prohibida la seva
reproducció, distribució, comunicació pública o transformació sense l'autorització del titular dels drets
Abstract
Most data scientists use nowadays functional or semi-functional languages like SQL, Scala or R to treat data, obtained directly from databases. Such process requires to fetch data, process it, then store again, and such process tends to be done outside the DB, in often complex data-flows. Recently, database service providers have decided to integrate "R-as-a-Service" in their DB solutions. The analytics engine is called directly from the SQL query tree, and results are returned as part of the same query. Here we show a first taste of such technology by testing the portability of our ALOJA-ML analytics framework, coded in R, to Microsoft SQL-Server 2016, one of the SQL+R solutions released recently. In this work we discuss some data-flow schemes for porting a local DB + analytics engine architecture towards Big Data, focusing specially on the new DB Integrated Analytics approach, and commenting the first experiences in usability and performance obtained from such new services and capabilities.
CitacióBerrall, J. L.; Poggi, N. Database Integrated Analytics Using R: Initial Experiences with SQL-Server + R. A: 2016 IEEE 16th International Conference on Data Mining Workshops (ICDMW), 12-15 Dec. 2016. "Data Mining Workshops (ICDMW), 2016 IEEE 16th International Conference on". Institute of Electrical and Electronics Engineers (IEEE), 2017, p. 1-7.
ISBN978-1-5090-5910-2
Versió de l'editorhttp://ieeexplore.ieee.org/document/7836640/
Col·leccions
Fitxers | Descripció | Mida | Format | Visualitza |
---|---|---|---|---|
Database Integrated Analytics using R.pdf | 303,0Kb | Visualitza/Obre |