Para acceder a los documentos con el texto completo, por favor, siga el siguiente enlace: http://hdl.handle.net/2117/103757

Database integrated analytics using R : initial experiences with SQL-Server + R
Berral, Josep Ll.; Poggi, Nicolas
© 2016 IEEE. Personal use of this material is permitted. Permission from IEEE must be obtained for all other uses, in any current or future media, including reprinting/republishing this material for advertising or promotional purposes, creating new collective works, for resale or redistribution to servers or lists, or reuse of any copyrighted component of this work in other works.
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.
Peer Reviewed
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
Big data
SQL
Databases
Data-flow schemes
Big Data
Macrodades
info:eu-repo/semantics/submittedVersion
info:eu-repo/semantics/conferenceObject
         

Mostrar el registro completo del ítem

Documentos relacionados

Otros documentos del mismo autor/a

Berral, Josep Ll.; Gavaldà Mestre, Ricard; Torres Viñals, Jordi
Poggi, Nicolas; Berral García, Josep Lluís; Fenech, Thomas; Carrera Pérez, David; Blakeley, Jose; Minhas, Umar F.; Vujic, Nikola
Berral García, Josep Lluís; Poggi, Nicolas; Carrera Pérez, David; Call, Aaaron; Reinauer, Rob; Green, Daron
Poggi, Nicolas; Berral García, Josep Lluís; Carrera Pérez, David
 

Coordinación

 

Patrocinio