Time Series Database Management
For Microsoft Windows.

Dbank Time Series Warehousing

I. Introduction

II. Common Data Managment Problems

III. Technology Overview

IV. Loading Data

V. Implementation Requirements

VI. Development of Dynamic Spreadsheets

VII. Economic Information Sharing and Internet publication

VIII. Automated Internet publication

IX. Summary


II. Common Data Management Problems

There is a high demand for efficient time-series data management systems. Corporations typically collect data from various sources, and in a variety of formats, ranging from ASCII "flat" files to proprietary spreadsheets, including hardcopy printouts that eventually need to be managed electronically. For example, central banks collect data from the treasury, accounting, and foreign exchange offices (internal sources), as well as from customs and national statistical bureaus (external sources).

It is not unusual for each staff member in a central bank to maintain his or her own data set and to rely heavily on spreadsheets in managing time-series data. While some existing databases and storage mechanisms exist in most central banks for storing historical economic and financial information, most of these systems are housed in mainframe computers that have relatively weak interface capabilities with Intel processor platforms running Microsoft Windows applications. As a result, data often has to be printed out in hard copy, distributed, and re-entered in spreadsheets for statistical reports. This gives rise to common concerns, including how to improve data sharing, consistency, and integrity and how to increase the productivity and efficiency of statistical staff in producing tables and reports.

There are several market solutions for these time-series problems, most of which are very expensive relative to the approach that uses Dbank's time-series object model..

Some commercially available time-series database software packages, such as SAS, AREMOS, and FAME, are indeed powerful in terms of their ability to provide integrated solutions for data storage, data manipulation and management, and statistical and econometric analyses, forecasting, and data presentation. However, each of these time-series data package has specific features and characteristics with different advantages and disadvantages, depending on the financial and information technology resources of the institutions concerned.

What makes Dbank for Windows unique and powerful is its full and natural use of Excel spreadsheet technology, which is already widely used. This is made possible by a simple Excel Add-In, written using Visual Basic for Applications and Dbank’s time series object, which allows users to build Excel tables that easily retrieve macroeconomic and financial information.


| Copyright © 1994-2011 | TSDM Pte Ltd | Time Series Data Management for Windows | Contact TSDM |