There are many advantages of SQL in DBMS. 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 a co-op housing society rather than 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 addresses 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 a database management system(DBMS)
To be able to successfully design and maintain a database we have o do the following:
- Identify which part of the works' data is of interest to us
- Identify what specific objects in that part of the world's data are of interest.
- 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 the 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.
Explain the advantages of database management system
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 assumptions 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.