Exploring DBMS and RDBMS: Unveiling the Pros and Cons

DBMS-

      
                A database is a collection of related data. personal computer store the database using different kind of software. for example microsoft access,excel. It can be any size and of varying complexity. dbms stands for database management system.
      
                  Various collection of program which are useful to generate and maintains the user define database known as database management system. we can also define dbms as a software that allows access to data contained in a database. since dbms is general purpose software systems that facilitates the processes of defining, constructing and manipulating database for various application. 
       we can see all above facilities one by one- 

• Defining a database involves specifying the data type structure and constraints for data to be stored in the database.                          
• Constructing a database is the process of storing the data itself in some storage medium that is monitored by dbms.                          
• Manipulating a database includes such function as querying database to retrieve information. modify that and view the changes in real world and produce various kind of result.             

ADVANTAGES-

• Data redundancy- this is the major problem with file system. if similar information is stored in more than one place afterwards the updation of minute changes may happen only with one file.            
• Security- file processing system can not assure any kind of security mechanism with its data.database system can hide the stored information from the unauthorised person.                           
• Data isolation- the data  is stored in the file according to different purpose in different manner.                                                      
• Accessing data- file system contain huge amount of data. to access such huge data file system uses special  application programs.                                                                                           
• concurrency control- if one user of file is engaged with its file operation other user cannot access same file for using data from respective file.                                                                                      

DISADVANTAGES-

• Costly software - paid software which are save and maintained the database are too much costly.                                                        
• Costly hardware - for the data processing processor required which having high speed which is again costly.                                     
• Data loss - when the power failure or other damage with dbms whole data is to be loss.                                                                        
• Difficult in recovery - due to problem like power failure it is difficult to recover and backup also not available.                                 
• high memory - it is required huge memory to store data. 

       
                Data redundancy is solved by the database problems. database system provides the best security mechanism by hiding the information from unauthorized person or using username and password. data isolation is possible. data access take less time compare to file system. multiple users access database at the same time that means control is possible. difficult to learn. expensive comparative to file system. better of any size of the data. database saves on the fixed permanent location.

Properties of database-

• A database represents some aspect of real world.                             
• Database is designed for specific purpose according to need.             
• A database is logically coherent collection of the data with some inherent purpose.                                                                        
• Database stored in system by applying some principles used by applying some principle.                                                                         
• For example- college consist student data like his roll number,name,address,phone no,marks etc.