What is SQL Server 2008/RDBMS?

As you most likely know, SQL Server 2008 is primarily thought of as a Relational Database Management System (RDBMS). It is certainly that, but it is also much more.

SQL Server 2008 can be more accurately described as an Enterprise Data Platform. It offers many new features and even more enhanced or improved features from previous editions of the product. In addition to traditional RDBMS duty, SQL Server 2008 also provides rich reporting capabilities, powerful data analysis, and data mining, as well as features that support asynchronous data applications, data-driven event notification, and more.

What is SQL Server 2008/RDBMS?

Fundamentals of RDBMS

Data is the most important component in any work that we do. Data means collection of information or collection of raw facts.

Data base Management system is the management system or maintenance system on database.

or

It is a suit of software program for creating,maintaining & manipulating the data in database.

or

It allows the users to insert the data,to retrieve the data,to modify the data and to delete the data.

The first databases of kind existed in the form of files.
A file is nothing but collection of records.
A record is nothing but collection of information or data.

But the file system was not very efficient,it was crippled by slow data search speed. It includes the following Drawbacks.

1.Security
2.Data Redundancy
3.Data Integrity
4.Concurrency Control
5.Slow in Process

1.Security: No Login name No Password.
2.Data Redundancy: Data reputation or data duplication is very high.
3.Data Integrity: No Data Validation process.
4.Concurrency Control: No control in files system when concurrency exists.
5.Slow in Process: File System follows Sequential-searching process

Fundamentals of RDBMS