find and solve || findandsolve.com
Please wait.....

What is a Relational Database Management System-Database


A database can be defined as a collection of coherent,meaningful data. The phrase collection of coherent data needs to have a point reference to be understood. A Simple Point of reference would be the example of a postal address,this would generally contain:


  • A building name
  • A flat number in the building(if it is co-op housing society rather that a bungalow)
  • A road name
  • An area name
  • A state name
  • A pincode
  • A country name (This is optional, but necessary if the letter is destined to a foreign country)
         
   To project on this fuhrer,multiple address kept together in one place,such as an address book, could be termed as a coherent collection of data.Thus the address book is a database and the postal address in the book, is the data that fills the database.

What is database management system(DBMS)


To be able to successfully design and maintain database we have o do the following:

    1. Identify which part of the works's data is a interest to us
    2. Identify what specific objects in that part of the world's data are of interest.
    3. Identify a relationship between the objects

    Hence,the objects,their attributes and the relationship between them are stored in the database that is designed ,built and  populated with data for a specific purpose.

    Software houses took up the challenge of designing a system that would help in managing data in such a database. These systems were called Database Management System(DBMS).DBMS is a system that allows inserting,updating,deleting and processing of data. Some of the DBMS developed by software houses were Oracle,Ingress,Sybase, Dbse 3+,Foxbase, Foxpro,MS access,Database,Dataflex, Advanced Revelation and so on.

    Benefits of DBMS


    1. The amount of data redundancy in stored data can be reduced
    2. No more data inconsistencies
    3. Stored data can be shared by a single or multiple users
    4. Standard can be set and followed
    5. Data integrity can be maintained. Data integrity refers to the problem of ensuring that database contains only accurate data
    6. Security of data can be simply implemented
    7. Data independence can be achieved, i.e. data and programs that manipulate the data are two different entities


    WHAT IS A RELATIONSHIP DATABASE MANAGEMENT SYSTEM (RDBMS)

    A Relational Database Management System (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Dr. Edgar F. Cod. Strictly speaking it should also satisfy Cod's 12 rules, but in practice there is no DBMS that satisfies all these rules. In fact, most successful DBMS that are considered to be relational violate the relational model in several important ways, including the Structured Query Language (SQL). However, moats database practitioners and researchers use the term in a loose way such that most databases that support SQL are included.

    Relational Database Management Systems (RDBMS) stores data in the form of related tables. RDBMS are powerful because they require few assumption about how data is related or how it will be extracted from the database. As a result, the same database be viewed in many different ways.

    An important feature of relational systems is that a single database can be spread across several tables. This differs from flat-file databases, in which each database is self-contained in a single table.

    The first released RDBMS that was a relatively faithful implementation of the relational model was the Multics Relational Data Store first sold in 1978. Others have been Berkeley Ingres, QUEL and IBM BS12.

    Today, popular commercial RDBMS for large databases include Oracle, Microsoft SQL Server, Sybase SQL Server, and IBM's DB2. The most commonly used free RDBMS are MySQL, PostgreSQL.


    Sundar  Neupane

    Sundar Neupane

    I like working on projects with a team that cares about creating beautiful and usable interfaces.

    Comments



    Report Response