ETLUtils: Utility Functions to Execute Standard Extract/Transform/Load Operations (using Package 'ff') on Large Data
Version 1.3

Provides functions to facilitate the use of the 'ff' package in interaction with big data in 'SQL' databases (e.g. in 'Oracle', 'MySQL', 'PostgreSQL', 'Hive') by allowing easy importing directly into 'ffdf' objects using 'DBI', 'RODBC' and 'RJDBC'. Also contains some basic utility functions to do fast left outer join merging based on 'match', factorisation of data and a basic function for re-coding vectors.

Browse man pages Browse package API and functions Browse package files

AuthorJan Wijffels
Date of publication2015-05-18 17:55:19
MaintainerJan Wijffels <jwijffels@bnosac.be>
LicenseGPL-2
Version1.3
URL https://github.com/jwijffels/ETLUtils http://www.bnosac.be
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("ETLUtils")

Man pages

ETLUtils-package: Extra utility functions to execute standard ETL operations on...
factorise: Put character vectors, columns of a data.frame or list...
matchmerge: Merge two data frames (fast) by common columns by performing...
naLOCFPlusone: Performs NA replacement by last observation carried forward...
read.dbi.ffdf: Read data from a DBI connection into an ffdf.
read.jdbc.ffdf: Read data from a JDBC connection into an ffdf.
read.odbc.ffdf: Read data from a ODBC connection into an ffdf.
recoder: Recodes the values of a character vector
renameColumns: Renames variables in a data frame.
write.dbi.ffdf: Write ffdf data to a database table by using a DBI...
write.jdbc.ffdf: Write ffdf data to a database table by using a JDBC...
write.odbc.ffdf: Write ffdf data to a database table by using a ODBC...

Functions

ETLUtils Man page
ETLUtils-package Man page
colClass Source code
colClass.default Source code
colClass.ff Source code
convertCharacterToFactor Source code
factorise Man page Source code
factorise.character Man page Source code
factorise.data.frame Man page Source code
factorise.default Man page Source code
factorise.list Man page Source code
matchmerge Man page Source code
naLOCFPlusone Man page Source code
read.dbi.ffdf Man page Source code
read.jdbc.ffdf Man page Source code
read.odbc.ffdf Man page Source code
recoder Man page Source code
renameColumns Man page Source code
write.dbi.ffdf Man page Source code
write.jdbc.ffdf Man page Source code
write.odbc.ffdf Man page Source code

Files

inst
inst/smalldb.sqlite3
NAMESPACE
NEWS
R
R/utils.R
R/pkg.R
R/matchmerge.R
R/ffsql.R
R/All_Imports.R
README.md
MD5
DESCRIPTION
man
man/read.dbi.ffdf.Rd
man/ETLUtils-package.Rd
man/matchmerge.Rd
man/write.jdbc.ffdf.Rd
man/write.odbc.ffdf.Rd
man/write.dbi.ffdf.Rd
man/renameColumns.Rd
man/naLOCFPlusone.Rd
man/factorise.Rd
man/recoder.Rd
man/read.jdbc.ffdf.Rd
man/read.odbc.ffdf.Rd
ETLUtils documentation built on May 19, 2017, 12:09 p.m.