Overview of Database Management System (DBMS) – Part 3

Features of Database

The Database Management System (DBMS) tactic has a number of distinguishing features which are discussed in details as follows:-

1. Simultaneous Use

The database management system lets numerous end users to access the database simultaneously. Responding to dissimilar quires of the various end users with the identical information is a vital feature of a database management system. Such simultaneous usage of information surges the economy of a system. An instance for simultaneous use is the tourism database of a big tourism company. The staffs of dissimilar outlets can access the database simultaneously as well as reserve the trips for their customers. Every single staffs gets a detail on his or her system indicating if there are seats vacant for a particular trip or if it is by this time completely reserved.

2. Organized & Labeled Information

The important aspect of the Database Management System (DBMS) method is that the database systems do not only have the information however the whole demarcation as well as explanation of these information too. These explanations are mostly particulars about the amount, the organization, the category as well as the arrangement of the information in addition to, the association among the information. This type of deposited information is known as Metadata, which means “Data about Data”.

3. Parting of Information & Applications

As labeled in the aspect organized information the organization of a database is demarcated through Metadata which is kept in the database too. Application software does not require any information about the physical storing like encrypting, format, storing location etc. It solely connects with the Database Management System (DBMS) via a uniform interface by means of a standardized language like Structured Query Language (SQL). The access to the information as well as the Metadata is completely through by the Database Management System (DBMS). In this manner every application can be completely divided from the information. Hence, database inner restructurings otherwise developments of competence do not have any effect on the application software.

4. Information Reliability

Information reliability is a perfect example for the excellence as well as the consistency of the information of a Database Management System (DBMS). In extensive sense information reliability comprise of the safeguarding the database from illegal access as well as unlawful modifications. Information imitates details of the real world.

5. Transaction

The transactions are a package of activities which are completed in a database to fetch it from one reliable state to a different reliable state. The information may turn to be unavoidably unreliable. The transaction is ATOMIC in nature which means that, within a transaction either entire set of activities or none of the activities will be approved. Completing merely a portion of the activities would lead to an unreliable database state. One instance of a transaction is the transfer of an amount of fund from one bank account to another account or may be to another bank account. The withdrawal of the money from one account and the credit of it to another account make composed a reliable transaction. This transaction is ATOMIC too. The withdrawal or credit unaccompanied would both lead to an unreliable state. Concluding the transaction both the withdrawal as well as credit the modifications to both the accounts turns out to be persistent as well as the individual who’s account has been debited now has less fund on the account however the receiver of the fund now has a higher fund.

6. Information Perseverance

Information perseverance means that in a Database Management System (DBMS) the information is preserved as long as it is not removed obviously. The life time of the data should be determined straightly and ultimately by the end user as well as should not be reliant on the system aspects. Furthermore, information once deposited in a database should not be misplaced. Modifications of a database which are completed by means of a transaction are persistent. The minute a transaction is done even a system crash cannot put the information in threat.

Advantages & Disadvantages of Database Management System (DBMS)

By means of a Database Management System (DBMS), the data handling has numerous benefits, as stated below:

· Information individuality: Application programs must be as self-governing as likely from particulars of information illustration as well as storing. The Database Management System (DBMS) can offer an immaterial interpretation of the information to protect the application program coding from such particulars.

· Well-organized information access: A Database Management System (DBMS) uses a diversity of refined methods to stock as well as save information professionally. This aspect is specifically significant when the information is kept on external storage devices (SD).

· Information reliability & safety: When information is continuously retrieved over the Database Management System (DBMS), the Database Management System (DBMS) can apply reliability constrictions on the information. For an instance, earlier of adding the payroll data for a staff in Database Management System (DBMS), it can be examined whether the department budget is exceeding or not. In Database Management System (DBMS) access controls can be applied which will direct which information is observable to dissimilar classes of end users.

· Information management: At the time of sharing information by numerous end users, unifying the management of information can give important developments. Knowledgeable experts, who appreciate the environment of the information that get managed, as well as by what method dissimilar clusters of end users practice it, can be accountable for establishing the information illustration to diminish the repetition plus acceptable modification of the information storing to make recovery well-organized.

· Synchronized access as well as crash rescue: A Database Management System (DBMS) plans the synchronized right of entry to the information in such a method that end users could consider the information being opened by merely one (1) end user at a certain point time. Additional, the Database Management System (DBMS) safeguards end users from the special effects of system failures.

· Condensed system improvement time: Obviously, the Database Management System (DBMS) assists a lot of significant utilities which are common to numerous systems retrieving information kept in the Database Management System (DBMS). This, in combination with the high – level interface to the information, enables fast improvement of system too. Such system are probable to be extra vigorous than the system established from scratch for the reason that countless vital responsibilities are managed by means of the Database Management System (DBMS) as an alternative of applying by means of the system.

In the upcoming part we will be discussing a basic question “Assumed every advantages, now is there any reason for not using Database Management System (DBMS)?” and thereafter stating the Pitfall of Database Management System (DBMS) and Database Instances plus Schemas.