EDIT I have just began skimming Codd's famous 1970 paper that began everything, that Oracle took it's origin from (A Relational Type of Data for big Shared Data Banks [pdf]), and was amazed to locate it appears it'll answer this SO question. It discusses databases within the market in those days ("hierarchical" and "network" - like NoSQL?), the requirement for independence from internal representation, along with a obvious explanation of methods to use mathematical "relations" to some database.


In the past, what feature of relational databases gave what benefit that triggered companies to consider it, which makes it massively effective?

Today, you will find a lot of reasons to utilize a RDB: it's standard, items are mature, debugged, full-featured, there's a range of suppliers, there's support, there is a trained labor force and so forth. Why made it happen become very popular?

I have heard "hierarchical databases" were popular before relational databases - they seem just like a key-value store, in which the value could be another group of key-values. If that's the case, that's like the object oriented databases which were promoted ten years or two ago also to XML/document databases and NoSQL.

Maybe Acidity transactions (atomicity etc)? But that does not appear specific to RDB.

Maybe because relational databases enabled you to definitely define a data schema which was purely concerning the data - separate from a specific programming language, version of the application (evolution), or reason for the applying (this will make "impedance mismatch" an unavoidable) But any database having a data schema has this feature.

Maybe since the relational model is mathematically seem? But this does not seem enjoy it would convince managers to consider it - and what will be the business benefit.

Maybe since the mathematical model provides you with a method to arrange the database into different normal forms to provide different performance qualities, that are mathematically certain to not alter the concept of the information? This appears plausible, and my uni books create a large deal from it, however it does not seem very compelling in my experience like a practical business benefit (maybe I am missing something)?

To summarise: in the past, what made the relational model win so decisively within the hierarchical model? I am also thinking about whether RDB have some kind of special quality that positively means they are a much better viable option for companies (apart from the advantages of as being a standard pointed out above).

Thank you if you're able to shed some light - I have lengthy been interested in this.

For the similar reason the script languages are popular.

You may make a question together with your favorite text editor and merely problem it, without disturbing concerning the bodily schema.

It isn't the quickest model, not probably the most reliable model — it is simply the most efficient model. You are able to write ten occasions as numerous queries within an hour.

You might want to look at this article during my blog which compares typically the most popular database models:

From the understanding, it's the normalization theory (the well-known Codd's Third Normal Form) to define relational data model that's simple and easy , efficient for storing and locating. This then the conventional Query Language (SQL) which enables so that it is used across all of the relational db system. Standardization was certainly missing in those days that also get this to attractive to many.