Evaluating A Suitable Database Management System (DBMS)

In order to effectively evaluate suitable database management system (DBMS) products at the highest level for data warehousing, the following factors must be taken into account:

  1. Budget – the over-riding decision, are their sufficient financial resources in place not only to licence the DMBS but also to purchase all of the required hardware, networking and human resources required to ensure the ongoing success of the system over its estimated useful life span.
  2. Business Continuity – the following factors are essential for the success of any system:
    • Reliability: the system must remain stable over its intended period of daily use, especially as many database installations are now expected to be available twenty-four hours a day and three hundred and sixty-five days a year.
    • Manageability: are tools and procedures available to examine the system and gain decision abling reports for system tuning and future development.
    • Backup: the data, in part or whole, and structure of the system must be able to be backed up and restored in a reasonable time in the event of a system failure without unreasonably affecting real-time system performance.
    • Support: for the expected life of the project, if a third party solution is chosen, can we reasonably expect that vendor support and product development will be available or if an in-house development, can we reasonably expect to be able to access the affordable experience and technologies we will need. Is support available in the open market?
  3. Operational Integrity: the system must perform well from an operational perspective allowing designed features to be user effectively.
  4. Capacity – in terms of industry proven capacity, are there any capacity limitations and if so, do these limitations represent a threat to the future cost or usability of the system.
  5. Performance – the DBMS must produce acceptable performance results in terms of loading, indexing and query processing. Test should be carried out to ensure that, under intended use conditions, such performance is acceptable.
  6. Connectivity – is the DBMS in question limited by the unavailability of middleware interfaces or API language limitations?