timeseriesdb: Manage Time Series with R and PostgreSQL
Version 0.2.1

Store and organize a large amount of low frequency time series data. The package was designed to manage a large catalog of official statistics which are typically published on monthly, quarterly or yearly basis. Thus timeseriesdb is optimized to handle a large number of lower frequency time series as opposed to a smaller amount of high frequency time series such as real time data from measuring devices. Hence timeseriesdb provides the opportunity to store extensive multi-lingual meta information. The package also provides a web GUI to explore the underlying PostgreSQL database interactively.

Author"Matthias Bannert <bannert@kof.ethz.ch> [aut, cre]"
Date of publication2015-04-04 07:46:09
Maintainer'Matthias Bannert' <bannert@kof.ethz.ch>
LicenseGPL-2
Version0.2.1
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("timeseriesdb")

Getting started

README.md

Popular man pages

activateTsSet: Activate a Set of Time Series
deactivateTsSet: Deactivate a Set of Time Series
loadTsSet: Load a Time Series Set
readTimeSeries: Read Time Series From PostgreSQL database
resolveOverlap: Concatenate Time Series and Resolve Overlap Automatically
storeTimeSeries: Write an R Time Series to a PostgreSQL database
transactionUtils: Convenience Wrapper to SQL classics for BEGIN,COMMIT,...
See all...

All man pages Function index File listing

Man pages

activateTsSet: Activate a Set of Time Series
addMetaInformation: Add Meta Information to R Environments
createChoices: Create Choices Boxes Dynamically
createConObj: Conveniently Create Connection Object to PostgreSQL based...
createHstore: Create Hstore
createUI: Polymorphic Helpers for the Shiny Based GUI
dbIsValid-methods: Check Validity of a PostgreSQL connection
deactivateTsSet: Deactivate a Set of Time Series
deleteTimeSeries: Delete Time Series from the database
exploreDb: Start a GUI to Explore Data
exportTsList: Export A List of Time Series to CSV
getListDepth: Determine depth of a list
getMeta: Quickly Handle Meta Information
importTsList: Import A Long Format CSV File Into a List of Time Series
listTsSets: List All Time Series Sets for a Particular User
loadTsSet: Load a Time Series Set
plotMethods: Plot a list of Time Series Directly plot time series of mixed...
quickHandleOps: Search the Database by Keys
readMetaInformation: Read Meta Information from a Time Series Database
readTimeSeries: Read Time Series From PostgreSQL database
resolveOverlap: Concatenate Time Series and Resolve Overlap Automatically
searchHstore: Search Key-Value Pairs, look for existing keys in an Hstore
searchKeys: Search Keys From Pre-Defined Or Key Based Queries
setAttrListWise: Set Attributes to Each Element of List According to a Given...
storeMetaInformation: Store Meta Information to the Database
storeTimeSeries: Write an R Time Series to a PostgreSQL database
storeTsSet: Store a New Set of Time Series
transactionUtils: Convenience Wrapper to SQL classics for BEGIN,COMMIT,...
zooLikeDateConvert: Zoo like Date Conversion

Functions

\%k\% Man page
activateTsSet Man page Source code
addMetaInformation Man page Source code
beginTransaction Man page Source code
commitTransaction Man page Source code
createChoices Man page Source code
createChoices.key Man page Source code
createChoices.md Man page Source code
createChoices.set Man page Source code
createConObj Man page Source code
createHstore Man page Source code
createHstore.data.frame Man page Source code
createHstore.list Man page Source code
createHstore.ts Man page Source code
createMetaDataHandle Man page Source code
createUI Man page Source code
createUI.key Man page Source code
createUI.md Man page Source code
createUI.set Man page Source code
dbIsValid Man page
dbIsValid,PostgreSQLConnection-method Man page
deactivateTsSet Man page Source code
deleteTimeSeries Man page Source code
exploreDb Man page Source code
exportTsList Man page Source code
getListDepth Man page Source code
getMeta Man page Source code
importTsList Man page Source code
listTsSets Man page Source code
loadTsSet Man page Source code
lookForKey Man page Source code
plot.tslist Man page Source code
print.meta_env Source code
readMetaInformation Man page Source code
readTimeSeries Man page Source code
resolveOverlap Man page Source code
rollbackTransaction Man page Source code
searchKVP Man page Source code
searchKeys Man page Source code
searchKeys.key Man page Source code
searchKeys.md Man page Source code
searchKeys.set Man page Source code
setAttrListWise Man page Source code
storeMetaInformation Man page Source code
storeTimeSeries Man page Source code
storeTsSet Man page Source code
zooLikeDateConvert Man page Source code
zooLikeDateconvert Man page

Files

inst
inst/sql
inst/sql/setup.sql
inst/sql/createTable.sql
NAMESPACE
NEWS
R
R/utils.R
R/readTimeseries.R
R/createConObj.R
R/tsSetFunctions.R
R/addMetaInformation.R
R/createHstore.R
R/storeTimeseries.R
R/plotMethod.R
R/resolveOverlap.R
R/transactionUtils.R
R/setAttrListWise.R
R/importTsList.R
R/storeMetaInformation.R
R/deleteTimeSeries.R
R/dbExplorerUtils.R
R/getMeta.R
R/zooLikeDataConvert.R
R/readMetaInformation.R
R/print_methods.R
R/searchHstore.R
R/quickHandleOps.R
R/exportTsList.R
R/exploreDb.R
README.md
MD5
DESCRIPTION
man
man/searchHstore.Rd
man/exportTsList.Rd
man/addMetaInformation.Rd
man/searchKeys.Rd
man/plotMethods.Rd
man/storeTsSet.Rd
man/readMetaInformation.Rd
man/createUI.Rd
man/storeMetaInformation.Rd
man/quickHandleOps.Rd
man/setAttrListWise.Rd
man/resolveOverlap.Rd
man/storeTimeSeries.Rd
man/getListDepth.Rd
man/transactionUtils.Rd
man/readTimeSeries.Rd
man/createChoices.Rd
man/createConObj.Rd
man/deleteTimeSeries.Rd
man/loadTsSet.Rd
man/zooLikeDateConvert.Rd
man/dbIsValid-methods.Rd
man/deactivateTsSet.Rd
man/listTsSets.Rd
man/getMeta.Rd
man/createHstore.Rd
man/importTsList.Rd
man/exploreDb.Rd
man/activateTsSet.Rd
timeseriesdb documentation built on May 19, 2017, 2:31 p.m.

Questions? Problems? Suggestions? Tweet to @rdrrHQ or email at ian@mutexlabs.com.

Please suggest features or report bugs in the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.