Time Series Database Management
For Microsoft Windows.
In terms of specific the hardware requirements for the implementation of this approach, a desktop standard, consisting of a 400 Mhz (or faster) Pentium processor, 64 MB RAM, and 6GB hard disks, is sufficient. It is also necessary to designate one high-end Intel-based server to host the shared database. The hardware should be a Pentium Pro/III, dual processor with at least 256 MB RAM and a 40 GB RAID drive or higher. This server should run under Windows NT with service pack 6 or higher (including Windows 2000), however Windows 95/98 is also acceptable (but not recommended).
For the software environment, the adoption of a simplified client/file-server model is recommended, so that Excel and the time-series data manager are installed and run on client desktops, but Dbank databases are stored on a shared networked file server. In cases where specific components of the database may need to be restricted to users in particular departments, e.g., for purposes of confidentiality or accountability, it is recommended that the database to be segmented into separate physical compartments or files, but combined logical databases (in the sense that they reside in the same directory). In this way, selected databases may be assigned security or restricted access limits that are imposed and controlled by the operating system itself. In this case, an Administrator of the system would retain the ability to set security and restrict file access to the selected but limited set of users. If this kind of secure access is imposed, the client software (both Excel and Dbank for Windows) will be unable to access that component e.g., the secure set of data, in the absence of specific user rights being assigned by the Administrator.
As a summary:
Workstations: Pentium class for each end user with minimum of 64 MB RAM
File Server: Pentium Pro/III, dual processor, 256+ MB RAM, 40 GB RAID drive
Network: Standard LAN for file server and workstations.
Server operating system: Windows NT version 4.0, Service pack 6 or higher, or
Workstation operating system: Windows 9X, NT, or 2000
Spreadsheet for reports and analysis: Excel 97 or higher
Data access/analysis: Dbank for Windows (email@example.com)
Standard report/screen systems: Excel and VBA
Security/Access Control: NT/2000 file-level.
Recommended Project Team Recommendations
At least one IT staff: Needed to support infrastructure requirements, assist in the design of the coding system, and facilitate data transfers between systems
Two Economic Department Staff: To coordinate the identification, learn Dbank for Windows, develop Excel templates, and assist other statistical staff.
(Optional) One outside expert: On an as needed part-time basis to assist with implementation, including initial installation of hardware and software, training of staff, spreadsheet development, etc.
| Copyright © 1994-2011 | TSDM Pte Ltd | Time Series Data Management for Windows | Contact TSDM |