Computer software repository systems

An important item to be addressed during the implementation of every computer system is the long-term archiving of data and any associated metadata. The hardware and software supporting the repository must be robust, but also flexible enough to withstand the regulatory electronic records retention requirements. 

Microsoft, Oracle, and Linux are software platforms that provide scalable environments. Microsoft Access is a widely used data entry platform where tables with pull-down entries can be created. The data storage element at the back-end requires Microsoft SQL or a comparable system to provide reliable and secure back-up and data storage. The systems should allow for dynamic error detection notification at data entry, construction of computer forms that mimic hardcopy forms, and data lookup capabilities for subject information. A web-based data entry format allows for integration of geographically separate sites. An inventory system for the repository should be incorporated into the electronic database. A data dictionary should be part of the protocol (7). 

---