RDBMS

RDBMS or Relational Database Management System provides a very advanced and strong data storing capability. By using a RDBMS data can be queried from the database more easily. Complex reports can be generated from the stored data by executing different kinds of queries against a RDBMS.

These kinds of Databases make it possible to store large and complex data. These databases enable the database designer to make meaningful relationship with each table. There are many RDBMS available in the market, the most popular being SQL Server, Oracle etc.

DATABASE AND SOFTWARE APPLICATIONS

Databases work in conjunction with a software application. The data from the front-end (a software interface) goes to the back-end (database). Once a user from a system requests data, it is passed to the database in the form of a query. This query executed at the backend will fetch the data from the database. SQL queries are commands to the database to Insert, Delete, Update or Extract data. For example if a database contains a table called customers and you want to extract all the customer names from this table. All you have to do is execute a query against the database in the following manner. SELECT CUST_NAME FROM CUSTOMERS This query gets executed and provides results from the customer table in the database. Here CUST_NAME is the field name containing the customer names. Stored procedure is used in RDBMS to execute queries which returns large amount of data or involves complex data processing. It gets executed on the server side and returns data to the client side. Since only the parameters to the query are only passed from client side, the network traffic generated is quite small compared to using a normal query at the client side.