The benefits of RDBMS
Posted: Mon Aug 03, 2009 11:16 am
The benefits of RDBMS (Relational data base management systems) are:
Consistency: data is guarantees to be consistent. Irrespective of the number of Custom Web Design simultaneously accessing it. An RDBMS always implements suitable locking mechanisms to prevent data inconsistency. A transaction either goes through fully or not at all i.e. it is either “committed “or “rolled back”.
Recoverability: irrespective of the type of failure, it is always possible to recover the data base upto the most recent consistent state. This means that if recovery measures are correctly implemented you would not lose all days work. And thus no need to reenter.
Distributability: database can be distributed in more than one physical location. Irrespective of this, application’s view of the database remains same as though it is in a single location. Applications need not undergo any change if the distribution of the data changes.
Support for IV generation languages: (4GL): RDBMS support 4GL. Today, there is even a standard 4GL in the structured query Language (SQL) form. The main difference between 4GLs and 3GLs is that in the former the user needs to specify what is required and not how it has to be done.
Transaction rules: rules, processes and constraints can be integral part of the data bases. This ensures that all transactions must obey these rules if they are to be successful. This offers a single point control.
Consistency: data is guarantees to be consistent. Irrespective of the number of Custom Web Design simultaneously accessing it. An RDBMS always implements suitable locking mechanisms to prevent data inconsistency. A transaction either goes through fully or not at all i.e. it is either “committed “or “rolled back”.
Recoverability: irrespective of the type of failure, it is always possible to recover the data base upto the most recent consistent state. This means that if recovery measures are correctly implemented you would not lose all days work. And thus no need to reenter.
Distributability: database can be distributed in more than one physical location. Irrespective of this, application’s view of the database remains same as though it is in a single location. Applications need not undergo any change if the distribution of the data changes.
Support for IV generation languages: (4GL): RDBMS support 4GL. Today, there is even a standard 4GL in the structured query Language (SQL) form. The main difference between 4GLs and 3GLs is that in the former the user needs to specify what is required and not how it has to be done.
Transaction rules: rules, processes and constraints can be integral part of the data bases. This ensures that all transactions must obey these rules if they are to be successful. This offers a single point control.