Everything but the kitchen sink: building a metadata repository for time series data at the Federal Reserve Board.

Cannon, San; Krug, Meredith

Abstract

In support of the Board's duty to conduct monetary policy for the United States, the research divisions at the Federal Reserve Board use a variety of time series data for both research and forecasting. The collection, maintenance and upkeep of more than 50,000 time series from more than sixty sources in a central location are daunting tasks; documenting the metadata for the compilation and use of these data is even more so. We are currently building a comprehensive metadata repository that links three kinds of metadata about our time series: structural metadata, reference metadata and operational metadata. Many of the pieces of this puzzle currently exist in an array of disparate formats: attributes in a proprietary database, HTML pages on a website, Word documents buried on a file server, etc. We are bringing these pieces of information together in a relational database setting to allow users to search and display relevant metadata for a particular series or economic concept. In addition, we are working to make the metadata entries in the repository time sensitive to accommodate the database of contemporaneous "real time" or "snapshot" time series that we are building for future research purposes. This paper will examine the different types of metadata gathered for time series data, and how this information is collected, stored and made available to staff at the Federal Reserve Board.

Citation

CANNON, S. and KRUG, M. 2006. Everything but the kitchen sink: building a metadata repository for time series data at the Federal Reserve Board. IASSIST quarterly [online], 30(1), pages 20-25. Available from: https://doi.org/10.29173/iq606

• Journal Article Type: Article
• Acceptance Date: Mar 31, 2006
• Online Publication Date: Jan 24, 2007
• Publication Date: Mar 31, 2006
• Deposit Date: Aug 22, 2023
• Publicly Available Date: Oct 27, 2023
• Journal: IASSIST quarterly
• Print ISSN: 0739-1137
• Electronic ISSN: 2331-4141
• Publisher: University of Alberta, Learning Services
• Peer Reviewed: Peer Reviewed
• Volume: 30
• Issue: 1
• Pages: 20-25
• DOI: https://doi.org/10.29173/iq606
• Keywords: Metadata repositories; Financial data; Time series data; Metadata application profiles; Repositories
• Public URL: https://rgu-repository.worktribe.com/output/2048692