Learn R Programming
⚠️There's a newer version (1.0.0-1.1.2) of this package.Take me there.

timeseriesdb (version 0.4.1)

Manage Time Series for Official Statistics with R and PostgreSQL

Description

Archive and manage times series data from official statistics. The 'timeseriesdb' package was designed to manage a large catalog of time series from official statistics which are typically published on a monthly, quarterly or yearly basis. Thus timeseriesdb is optimized to handle updates caused by data revision as well as elaborate, multi-lingual meta information.

Copy Link

Version

Install

install.packages('timeseriesdb')

Monthly Downloads

270

Version

0.4.1

License

GPL-2

Issues

24

Pull Requests

6

Stars

24

Forks

3

Maintainer

Matthias Bannert

Last Published

August 6th, 2018

Functions in timeseriesdb (0.4.1)

deleteTsSet

Permanently delete a Set of Time Series Keys
createHstore

Create Hstore
createTimeseriesMain

Create Statements for PostgreSQL tables
dbIsValid,PostgreSQLConnection-method

Check Validity of a PostgreSQL connection
getListDepth

Determine depth of a list
writeLogFile

Simple Log File Writer
updateMetaInformation

Update Meta Information Records
readTimeSeries

Read Time Series From PostgreSQL database
getMeta

Quickly Handle Meta Information
removeKeysFromTsSet

Remove keys from a Time Series set (if present)
loadTsSet

Load a Time Series Set
joinTsSets

Join two Time Series sets together
setAttrListWise

Set Attributes to Each Element of List According to a Given Vector
listTsSets

List All Time Series Sets for a Particular User
rmAllBut

Delete all objects except for specific objects
overwriteTsSet

Overwrite a Time Series set with a new one
storeListChunkWise

Store a List of Time Series Chunk Wise to Avoid Memory Problem
storeMetaChunkWise

Store Meta Information Chunk Wise to Avoid Memory Problem
pgCopyDf

Copy data.frame to postgres using bulk copy
readMetaInformation

Read Meta Information from a Time Series Database
zooLikeDateconvert

Zoo like Date Conversion
storeMetaInformation

Store Meta Information to the Database
activateTsSet

Activate a Set of Time Series
runCreateTables

Run Setup: Create all mandatory tables
addKeysToTsSet

Add keys to an existing Time Series set
storeTsSet

Store a New Set of Time Series
storeTimeSeries

Write an R time series to a PostgreSQL database
beginTransaction

Convenience Wrapper to SQL classics for BEGIN,COMMIT, ROLLBACK
getTimeSeriesVintages

Get all available vintages for the time series identified by series
indexToDate

Convert ts style time index Date representation
runDbQuery

Run SELECT query
runUpgradeTables

Add Release Date Column to Tables
addMetaInformation

Add Meta Information to R Environments
createConObj

Conveniently Create Connection Object to PostgreSQL based timeseriesdb
deactivateTsSet

Deactivate a Set of Time Series
deleteTimeSeries

Delete Time Series from the database
changeTsSetOwner

Change the owner of a Time Series set
searchKVP

Search Key-Value Pairs, look for existing keys in an Hstore
exportMetaEnv

Export Content of Meta Information Environment to Various File Formats