Advantages of Relational Databases

by Toan T
This article talks about the several key advantages that relational database has over other database models. Relational database is probably those most popular database models being used. It provides a declarative method for specification of data and queries. Information in  a relational database can be retrieved based on what the users want without having to deal with complicated data structures. A way of describing a relational database is that its a collection of relations or tables and there are rows within those tables which are known as tuples and each column of the table is called an attribute which was explained during the lecture. To explain it in another way is that relational database contains data which is related to each other as they share the same attributes. Some advantages that relational database has are: performance, flexibility, security, large capacity to meet all data needs, scalability, data normalization (relates to the structuring model used to ensure data consistency and duplication), dynamic viewing ( a term that describe how data are accessed within a relational database) and it uses SQL. It is obvious why relational

I chose this article because the lecture did talk and explain a little bit about relational database and I have also heard a bit about it but I never know why it is so widely use. This article gave me a better understand why relational database is “relational” and why it is so popular. However, I have heard that people are starting to move away from relational databases as more data are now being stored in the cloud.

Oak, Manali. “Advantages of Relational Databases.” Buzzle Web Portal. N.p., 21 Sept. 2011. Web. 15 Jan. 2012. <http://www.buzzle.com/articles/advantages-of-relational-databases.html>.

5 thoughts on “Advantages of Relational Databases”

  1. Very useful information, thx. I have also heard alot about cloud use. Relational databases sound very well organized and I can see many uses for them.

  2. Relational databases, however, are only good to use if they are used correctly. There’s many reasons why to use it and efficiency is a main part of it. For users to be able to find what they are looking for in a database with relational databases would be much more effective.

  3. Relational databases are wonderful, though can be frustrating to use. I remember in 305 how great it was able to use sql commands to pull up customer information based on products they have ordered. For example I want to find all customers who ordered a Hacksaw, relational databases would allow me to do this.

  4. I remember those days Stephen, good old days. I would add that SQL server was not too hard to use and was used alongside with Erwin. Both programs worked great together helping understand the way relational-databases work.

Comments are closed.