Related Experiment Videos
A microcomputer-based relational database for an academic department of human genetics
Summary
Academic departments can now create independent databases using microcomputers. A human genetics database successfully moved from a mainframe to a microcomputer system offers faster data capture and improved confidentiality.
Area of Science:
- Biomedical Informatics
- Computer Science Applications
- Genetics Research Data Management
Background:
- Centralized mainframe systems present limitations for departmental data management.
- The trend towards distributed processing favors smaller, localized systems.
- Academic departments require efficient and secure data handling solutions.
Purpose of the Study:
- To demonstrate the successful migration of a departmental database from a mainframe to a microcomputer system.
- To redesign the database into a relational system optimized for microcomputer architecture.
- To evaluate the advantages of a microcomputer-based database for academic departments.
Main Methods:
- Transferring an existing database from a mainframe environment to a microcomputer.
- Redesigning the database structure to a relational model suitable for microcomputers.
- Implementing the new system within the Department of Human Genetics.
Main Results:
- Achieved faster data capture rates compared to the mainframe system.
- Enhanced data consistency and integrity through the redesigned relational system.
- Improved confidentiality and economy of data management.
- Increased overall computer awareness within the department.
Conclusions:
- Microcomputer technology enables the creation of effective, discrete databases for academic departments.
- Migrating from mainframes to microcomputers offers significant operational advantages.
- Distributed processing on smaller systems is a viable and beneficial approach for specialized departmental needs.