Big Data tools and relational BI analysis tools used in different stage of data analysis

I was thinking about the relationship between traditional BI platforms and Big Data analytic tools. I think they should coexist and service for different stage of data analyzing. That is, with the Data first approach, people use Big Data analytic tools to explore data and find out right question. Then, with right and interesting question, people drill data and try to give out answers in relational database based BI platform.

I happened to watch a presentation given by Facebook. It looks they are use both Big data tools and relational DB tools for different stages of data analysis. Below is cited from the presentation and video on youtube.

setup ODBC access in R or RStudio

1. make sure unixODBC development lib is installed.
   

   [root@localhost yiyujia]# yum list | grep unixODBC
   unixODBC.x86_64                         2.2.14-12.el6_3                @updates 
   freeradius-unixODBC.x86_64              2.1.12-4.el6_3                 base     
   unixODBC.i686                           2.2.14-12.el6_3                base     
   unixODBC-devel.i686                     2.2.14-12.el6_3                base     
   unixODBC-devel.x86_64                   2.2.14-12.el6_3                base     
   unixODBC-kde.i686                       2.2.14-12.el6_3                base     
   unixODBC-kde.x86_64                     2.2.14-12.el6_3                base 
   
   [root@localhost yiyujia]# yum install unixODBC-devel.x86_64
   
   

2. Inside R or Rstudio, run the following command to install RODBC package.
   

   install.packages("RODBC", dependencies = TRUE)