A Time Series Database for Official Statistics with R and PostgreSQL
Convert a List into a Metadata Object
Convert a List into a Metadata Object
Change the Access Level of a Time Series
Create Meta Data Objects
Meta in
Convert date-likes to time index
Create a New Role (Access Level)
Delete a role in access levels table
Get All Access Levels and Their Description
Set the Default Access Level
Helper to construct SQL function calls
Bundles Keys into an Existing Collection or Adds a New Collection
Remove an Entire Time Series Key Collection
Get All Keys in a User Collection
Get the last update of a collection for a specific User
List All Available Collections for a Specific User
Read Metadata for a Collection
Read all Time Series in a User Collection
Remove Keys From a User's Collection
Close an Existing Database Connection
Create Database Connection
Create a New Dataset
Irrevocably Delete All Time Series in a Set and the Set Itself
Get All Time Series Keys in a Given Set
Get the dataset last update
Get the latest Release for Given Datasets
Get Next Release Date for Given Datasets
Get the latest Release for Given Datasets
Get All Available Datasets and Their Description
Read Dataset Meta Information
Read all Time Series in a Dataset
Remove Vintages from the Beginning of Dataset
Update Description and/or Metadata of a Dataset
Get the Currently Installed Version of Timeseriesdb
GRANT all rights on a (temp) table to schema admin
Get Latest Validity for Metadata of a Given Time Series
Read Time Series Metadata
Store Time Series Metadata to PostgreSQL
Cancel a Scheduled Release
Create an Entry in the Release Calendar
List Data on Registered Releases
Update an Existing Release Record
Assign Time Series Identifiers to a Dataset
Remove Time Series from the Database
Delete the Latest Vintage of a Time Series
Get All keys that follow a pattern
Find Out About the Access Level of a Vintage
Find Datasets Given a Set
Get the times series last update
Read Time Series From PostgreSQL into R
Read the Entire History of a Time Series
Rename Time Series by Assigning a New Key
Store a Time Series to the Database
Remove Vintages from the Beginning
Helper to Create and Populate a Temporary Table for Fast Reading
Test if a list has exactly depth 2
Helper Function for Date Operations
Install timeseriesdb
Convert JSON Representation of a Time Series into R Time Series Object...
Common parameters
Print Method for meta Object
Install PostgreSQL Schemas and Extensions
Install timeseriesdb System Functions
Grant execute on timeseriesdb functions
Create Roles needed for operation of timeseriesdb
Install timeseriesdb System Tables
Install timeseriesdb Triggers
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.
Useful links