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.
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- Need for DBMS
- Recoverability in DBMS
- Deadlock in DBMS
- Starvation in DBMS
- History of DBMS
- Interfaces in DBMS
- The CAP Theorem in DBMS
- Difference between DDL and DML in DBMS
- Disadvantages of DBMS
- Cascadeless in DBMS
- Difference between 2NF and 3NF in DBMS
- Difference between 1NF and 2NF in DBMS
- Disadvantages of Distributed DBMS
- Difference between BCNF and 4NF in DBMS
- Interesting Facts about DBMS
- Normalization Process in DBMS
- Result Serializability in DBMS
- Multivalued Dependency (MVD) in DBMS
- Data Models in DBMS
- Spurious Tuples in DBMS
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.