DBMS/Repository Evaluation and Selection
DBMS/repository evaluation and selection is an activity by which the client determines the most appropriate set of DBMS(s) to employ on a project or repository to select for the enterprise. Some projects require more than one DBMS, as one may be especially suitable for data collection, batch updating and production reports while another is more suitable for ad hoc reports and research processing. Choosing the correct DBMS is critical. ANSI/SQL DBMSs, operating the same database application can have processing times for the same query ranging from a low of 2 minutes to a high of 60 hours.
Repositories can range from one that merely assists in database design and schema generation to those that dramatically reduce costs, accelerate development, and make evolution and maintenance a mere fraction of the original costs rather than a multiplier.
The DBMS evaluation and selection opportunity involves the following steps:
- Conduct Database Technology Course
- Identify DBMS requirements,
- Refine the DBMS evaluation and selection,
- Obtain DBMS reference manuals from vendors
- Fill out the DBMS questionnaire and score.
- Perform analysis and make recommendation.
The effort requires about six months time, for a staff of about 5 persons, 4 staff and one manager. Thus, the effort is about 2.5 staff years. The Whitemarsh consultant serves as one of the staff members to accomplish training, product development, and coaching.
The repository evaluation and selection effort consists of both training and consulting. It involves the following steps:
- Conduct the Repository-based Development course
- Conduct the Repository Requirements Specification course
- Identify repository requirements,
- Refine the repository evaluation and selection document
- Obtain repository reference manuals from vendors
- Fill out the repository questionnaire and score.
- Perform analysis and make recommendations.
The effort requires about six months time, for a staff of about 4 persons, 3 staff and one task leader, the effort is about 1.5 staff years. The Whitemarsh consultant serves as one of the staff members to accomplish training, product development, and coaching.