DBMS which stands for Database Management base System is a software developed to manage and manipulate database. DBMS is basically a interface that helps user to interact with database. Some examples of DBMS are MYSQL which was developed by IBM, Oracle which was developed by LARRY Ellision and his team, SQL servers etc. Most DBMS comes with ODBC (Open Database Connectivity) driver that allows one database to coalescent or integrate with other database. ODBC helps to translate syntax of one database to syntax of another database.
Types of DBMS
Based in data model there are 4 types of DBMS which are:
- Relational database.
- Object oriented database.
- Hierarchical database.
- Network database.
Characteristic of DBMS( Database Management System)
- Reduce duplication.
- Retrieve information from database.
- Multiple view of data.
- Defines data.
- Allows parallel manipulation of data.
Advantage of DBMS are:
- More secure and efficient.
- Make development of application faster.
- Makes application user friendly by data abstraction.
- Reduce redundancy which makes database size small and manageable.
- Easy to access information.
- Supports multi-user access.
Disadvantages of DBMS are:
- Cost of implementation is high.
- Trained and skilled manpower is required.
- If no backup is kept destruction of database will cause full loos of information stored one database.
- Maintenance of DBMS cost both money and manpower as the technology is upgrading .
Scopes of DBMS
DBMS has scope in many sectors, for example :
- Bank- Bank have to keep huge data and information on its clients and employs where they use DBMS.
- School and college- School and college has to keep info on student and there result, fee etc and also have to keep track of there employs
- Finance- DBMS is widely used in finance sector to store information about stocks, bonds etc
- Airline- DBMS has many use in airlines like to keep track of reservation and there employee information.
Why is DBMS better than Flat File System?
- Because flat file system does not allow access to multiple user a same time but DBMS does.
- Because DBMS can be used for any scale of business unlike flat file system which is used mainly for small business.
- Because flat file system is outdate system.
- Because support for DBMS is widely available as it is widely used.
- Because DBMS causes less redundancy and has more integrity.
READ OUR OTHER ARTICALS