Database & Big data

sqldf: a package for running SQL statements on data frames.

data.table: enhanced data.frame with fast indexing, ordered joins, assignment, and grouping.

RMongo & rmongodb: interface with MongoDB.

Improve the efficiency in joining data with index and application in sqldf and data.table

SQL interface

Advertisements