Effective Database Design for Geoscience Professionals

THE DATABASE MANAGEMENT SYSTEM (DBMS)

The database management system software (DBMS) is the fundamental "heart" of the data management system. In some cases, it may not be possible to select the DBMS before the initiation of a data management project, as there may already be a system installed. The guidelines presented in this section should be considered regardless of the stage at which the DBMS is selected.

Selection criteria

The selection of a DBMS is made easier to a certain extent because there are a relatively small number of mature, proven DBMS applications available on the market. On a corporate scale, the most frequent choice is Oracle . In the desktop world of PCs, Microsoft's Access product is the most common application. That being said, these are not the only products available, and both products have their limitations and disadvantages. This section discusses the issues that must be addressed when assessing a DBMS product. Additional resources can be found in Appendix A.

Suitability to project objectives. Once the project objectives have been defined (see the preceding section), the functionality of the DBMS can be compared with those objectives. If the primary focus of the project is to develop a large, cross-platform corporate DBMS, a product like MS-Access is not suitable. For a small, nonnetworked, individual database, an expensive, powerful, enterprise-scale product like Oracle would be overkill.


Figure 4-4: Stand-alone Database-Application System. An independent solution like this may be practical for an independent or small company, but may not be suitable for...

UNLIMITED FREE
ACCESS
TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Category: Data Warehousing Software
Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.