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.
- Lossless Decomposition in DBMS
- Introduction of Relational Algebra in DBMS
- Need for DBMS
- Commonly asked DBMS interview questions | Set 1
- Normal Forms in DBMS
- View Serializability in DBMS Transactions
- Relational Model in DBMS
- Commonly asked DBMS interview questions | Set 2
- Concurrency Control in DBMS
- Conflict Serializability in DBMS
- Recoverability in DBMS
- Last Minute Notes - DBMS
- ACID Properties in DBMS
- DBMS Architecture 2-Level, 3-Level
- Introduction of DBMS (Database Management System) | Set 1
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.