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

Share:

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.

Author
Jan Wijffels
Date of publication
2015-05-18 17:55:19
Maintainer
Jan Wijffels <jwijffels@bnosac.be>
License
GPL-2
Version
1.3
URLs

View on CRAN

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...

Files in this package

ETLUtils
ETLUtils/inst
ETLUtils/inst/smalldb.sqlite3
ETLUtils/NAMESPACE
ETLUtils/NEWS
ETLUtils/R
ETLUtils/R/utils.R
ETLUtils/R/pkg.R
ETLUtils/R/matchmerge.R
ETLUtils/R/ffsql.R
ETLUtils/R/All_Imports.R
ETLUtils/README.md
ETLUtils/MD5
ETLUtils/DESCRIPTION
ETLUtils/man
ETLUtils/man/read.dbi.ffdf.Rd
ETLUtils/man/ETLUtils-package.Rd
ETLUtils/man/matchmerge.Rd
ETLUtils/man/write.jdbc.ffdf.Rd
ETLUtils/man/write.odbc.ffdf.Rd
ETLUtils/man/write.dbi.ffdf.Rd
ETLUtils/man/renameColumns.Rd
ETLUtils/man/naLOCFPlusone.Rd
ETLUtils/man/factorise.Rd
ETLUtils/man/recoder.Rd
ETLUtils/man/read.jdbc.ffdf.Rd
ETLUtils/man/read.odbc.ffdf.Rd