Advantages and Disadvantages of using relational databases
4:05 AM
Advantages:
1. Ease of use: The revision of any information as tables consisting of rows and columns is much easier to understand .
2. Flexibility: Different tables from which information has to be linked and extracted can be easily manipulated by operators such as project and join to give information in the form in which it is desired.
3. Precision: The usage of relational algebra and relational calculus in the manipulation of he relations between the tables ensures that there is no ambiguity, which may otherwise arise in establishing the linkages in a complicated network type database.
4. Security: Security control and authorization can also be implemented more easily by moving sensitive attributes in a given table into a separate relation with its own authorization controls. If authorization requirement permits, a particular attribute could be joined back with others to enable full information retrieval.
5. Data Independence: Data independence is achieved more easily with normalization structure used in a relational database than in the more complicated tree or network structure.
6. Data Manipulation Language: The possibility of responding to query by means of a language based on relational algebra and relational calculus e.g SQL is easy in the relational database approach. For data organized in other structure the query language either becomes complex or extremely limited in its capabilities.
Disadvantages :
1. Performance: A major constraint and therefore disadvantage in the use of relational database system is machine performance. If the number of tables between which relationships to be established are large and the tables themselves effect the performance in responding to the sql queries.
2. Physical Storage Consumption:With an interactive system, for example an operation like join would depend upon the physical storage also. It is, therefore common in relational databases to tune the databases and in such a case the physical data layout would be chosen so as to give good performance in the most frequently run operations. It therefore would naturally result in the fact that the lays frequently run operations would tend to become even more shared.
3. Slow extraction of meaning from data: if the data is naturally organized in a hierarchical manner and stored as such, the hierarchical approach may give quick meaning for that data.
98-364 Database Fundamentals Prep is the primary certification which can be acquired to articulate the command in concepts of databases from Microsoft.
Techveze.com provides study matertial and practice tests which can not only help in enhancing knowledge and preparation for the certification but you can also get a basic certification in this database domain to excel further in your career. Currently Techveze have published 5 practice test which can be accessed by clicking the links below.
98-364 Database Fundamentals Prep is the primary certification which can be acquired to articulate the command in concepts of databases from Microsoft.
Techveze.com provides study matertial and practice tests which can not only help in enhancing knowledge and preparation for the certification but you can also get a basic certification in this database domain to excel further in your career. Currently Techveze have published 5 practice test which can be accessed by clicking the links below.
Labels:
Subscribe to:
Post Comments (Atom)
23 comments:
cool stuff
nice ;3 really helped with school work ;Pp
Good Stuff...To make it better though you should write about Referential Integrity
very helpfull data in did but i suspect the flexibility is a little lie it should be data integrity
nice thax
Ty
cheers maaaaate
cool
very helpful thanks
Really helped for College, don't worry no copying and pasting!
good stuff gangsta dope
helped me to complete a part of a task from my assignment.Thanks
good research
why spank you
good helped me with assignment :)
thnx u da og
Can't understand the precesion pls anyone discribe this point ?
It really helped for my assignment. Thanks...
Thanks rly helped me a lot
good stuff very helpful thankyou
its better to have a explanation by each.
Much obliged.
Thanks mate very helpful, makes databasing seem like a breeze.
Post a Comment