Basically, the choice of a DBMS is governed by a number of factors such as:
- Politics of Organization
Here we will basically discuss Non-technical factors which include the financial status and the support organization of the vendor. In this article, we will concentrate on discussing the economic and organizational factors that the effect the choice of DBMS. Following cost are considered while choosing a DBMS these are as follows:
- Software acquisition cost –
This is basically the up-front cost of software or buying cost of software including language options, different types of interfaces. The correct DBMS version for a specific OS must be selected. Basically, the Development tools, design tools, and additional language support are not included in basic pricing.
- Maintenance cost –
This is basically the recurring cost of receiving standard maintenance service from the vendor and to keep the DBMS version up-to-date.
- Hardware acquisition cost –
We may need hardware components such as memory, disk drives, controllers, archival storage etc cost of all these also we need to consider while choosing a DBMS.
- Personal cost –
Acquisition of DBMS software for the first time by an organization is often accompanied by a reorganization of the data processing department. The position of DBA and staff exist in most companies and that have adopted DBMS.
- Training cost –
DBMS are often complex systems personal must often be trained to use and program for DBMS. Training is required at all levels which include programming, application development and database administration.
- Operating cost –
Cost of operating database also needs to be considered while choosing DBMS.
- DBMS | Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
- Need for DBMS
- Commonly asked DBMS interview questions | Set 1
- DBMS | How to test if two schedules are View Equal or not ?
- Commonly asked DBMS interview questions | Set 2
- DBMS | How to find the highest normal form of a relation
- DBMS | How to solve Relational Algebra problems for GATE
- DBMS | Concurrency Control -Introduction
- DBMS | Conflict Serializability
- DBMS | Nested Queries in SQL
- DBMS | Recoverability of Schedules
- Last Minute Notes - DBMS
- ACID Properties in DBMS
- DBMS Architecture 2-Level, 3-Level
- DBMS | Relational Model Introduction and Codd Rules
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.