My First Post      My Facebook Profile      My MeOnShow Profile      W3LC Facebook Page      Learners Consortium Group      Job Portal      Shopping

Thursday, February 17, 2011

An Introductory lesson on Emergence of Relational Database Management Systems

From the older days of Data backup in notebooks and registers we graduated to Computer Systems having File based data storage systems. A major advent was seen when DBMS were pooping up. And now we live in ages of RDBMS ie. Relational Database management Systems. I have chosen three RDMS for my introductory lesson, typically because they are widely used in Enterprises.
Apart from what outlined below, you have MySQL, Sqllite3, Excel, Acces, and many more.

Let me start with the Oracle. Refer Oracle.comThis database has many features that makes it well suited to data warehousing, including support for very large databases, automated summary management, and an embedded multidimensional OLAP engine. It was 1970, when Dr E F Codd published a paper entitled A Relational Model of Data for Large Shared Data Banks. This relational model, sponsored by IBM, then came to be accepted as the definitive model for relational database management systems – RDBMS. IBM developed a language to manipulate the data stored within Codd's model, which was originally called Structured English Query Language, or SEQUEL, with the word 'English' later being dropped in favor Structured Query Language – SQL. In 1979 a company called Relational Software, Inc. released the first commercially available implementation of SQL. Relational Software later came to be known as Oracle Corporation.

Second in my list is about PostgreSQL. You can see details Go Here For PostGre Official Website, which is Unix-based freeware Object-Relational Database Management System supporting almost all SQL constructs. It includes sub-selects, transactions, and user-defined types and functions. It supports everything from basic table structures, to extremely large datasets. This flexibility allows PostgreSQL to compete with MySQL, SQL Server, Oracle, and Sybase etc.
The name PostgreSQL, was chosen to reflect the relationship between original Postgres and the more recent versions with SQL capability. With the version 6.x series of PostgreSQL, the emphasis has shifted from identifying and understanding existing problems in the backend to augmenting features and capabilities. The overall backend code speed has been increased by approximately 30%, and the backend startup time has decreased 50%, though some people say it go as low as by 83%( I don’t know from where has this figure emerged!!!)
Third is about SQL Server that is a relational database management by BigB Microsoft (Possibly the diverse areas MS is into has made it to remain the king even today. All kudos to Bill Gates). SQLServer supports more than SQL. It is easy to manage and provides a separate OLAP engine. It is the ideal database on web applications constructed in ASP.Net. It links possibly best with ADO.Net (All from Microsft!!. That does not means it does not suits to others. Actually it is what is called a cure to all remedies. This also tells me that it is well suited in Remedy Tool too. On this, some other time though.) One important point is that the SQL Server currently runs only on the Windows operating systems, and MS has no plans for porting it to other platforms (After all BigB has all choices to make. Ahem Ahem!!) has been disclosed.

The Microsoft SQL Server originated in Sybase SQL Server, and it was Microsoft's pleasant entry to the enterprise-level database market. It was first launched in the onset of 1992 ( Though I am poor in dates. But I remember this because I learned this for my theory paper of Engineering. How I managed to have time for studying with my Girlfriend Sadiyah sitting in same class is a different story. Some other time, on some other blog…) I would conclude with my last sentence tht Oracle and SQLServer still remain the biggest of all RDBMS systems currently used in enterprises, but slowly the paradigm is changing. We all seem to be much happier with open sources softwares. (Hey but I heard Oracle keen to buy MySQL!!!)

No comments:

Post a Comment