Overview Of DBMS

What is Data?

Data is nothing but facts stored over a network. For designing database data is a primary need. Basically, we can say that data is a building block of any database. Generally, it is raw and unprocessed.

when we processed the data it is called information. We apply some rules and regulations for transforming data into meaningful information.

What is Database?

The database is a collection of inter-related data which is used to retrieve, insert, update and delete the data efficiently. The database is also used to organized data into the form of tables, views and schema.

During earlier days data is stored on tapes on which once data is stored it can never be changed. This approach is slow and bulky. Due to this problem, the computer scientist realized that they need a better solution to this problem.

Then co-founder of oracle Larry-Ellison was amongst the first few who realized the need for software-based data management system.

DATABASE MANAGEMENT SYSTEM

DBMS is a software which is used to manage the database.DBMS provides an interface for performing various operations like the creation of data, storing of data, updating of data and retrieving of data. With the help of DBMS, data can be analyzed and processed easily.DBMS provides security and protection to the database.

some of the databases are as follows:

  • MySql
  • Oracle
  • Sql Server
  • IBM DB2 etc.

Task performed by DBMS:-

1.Data Definition:- It is used for creation, definition , modification and removal of definition of the data in the database.
2.Data Updation:- It is used for insertion, deletion, modification of data in the database when required.
3.Data Retrieval:- It is used for extract data from database which is used by various applications for performing various task.
4. User Administration:- It is used for monitoring users, maintain data integrity, security, dealing with concurrency control etc.

Characteristics of DBMS:-

  • DBMS stored data into the tables created inside the database.DBMS also established connection between tables which makes data more meaningful and connected.
  • DBMS  reduced duplication of data in the database with the help of normalization which divides the database in such a way that duplication and repitition is minimum.
  • In real-world data is being continuously updated and added, so maintaining the consistency of data is a challenge . But with the help of DBMS this problem can be solved easily.
  • DBMS allows multiple users to perform operations like insertion, updation, deletion at the same time without losing any data consistency.
  • DBMS also protects the data from unauthorized access , takes care of the security of the database from malicious attack. In DBMS we can also maintain security by means of username and password.
  • With the help of DBMS simple query language , data can be easily inserted, updated, deleted in the database.
Advantages of DBMS:-

  • Data Redundancy Reduced:- The file based management system contained multiple copies of the same file in more than one place which lead to data redundancy and it occupies more space. This is prevented  in database as there is single database and any change in it can reflected immediately so there is no chance of duplication of data.
  • Sharing of data:- With the help of DBMS data can be shared among multiple users very easily .There are various levels of authorization to access the data, and data can only be shared based on the correct authorization protocols being followed. 
  • Easily Maintainance:- DBMS can be maintained very easily as the whole data can be placed in a centralised manner.
  • Backup:-DBMS provide automatic  backup and recovery of data when hardware and software failure .
  • Easy Access:-Data can be easily accessible with fast response with the help of Database systems.
  • Improved Decision Making:- Data managed in efficient and improved way makes it possible to generate better quality information with the help of this meaningful information better decision can be taken.
Disadvantages of DBMS:-

  • Hardware and Software cost:- DBMS requires a high speed of data processor and large memory size to run DBMS software .
  • Higher impact of failure:- Failure is highly impacted in the database because in most of the organization, all the data stored in a single database and if the database is damaged due to electric failure or database corruption then the data may be lost forever.
  • Complexity:- As there is large amount of data stored in the database due to this  it is very complex to understand it.

Comments

Post a Comment

Popular posts from this blog

ASP.NET Overview

ASP.NET CORE:- The ASP.NET Core is a brand new cross-platform, high-performance, light-weight, open-source Framework which is used for developing modern, Internet-connected, cloud-based Web Applications, IoT, and Web APIs which can be developed and run on Windows, Linux, or Mac operating systems. ASP.NET Core Framework is completely rewritten of existing ASP.NET 4.x, with architectural changes which make it more modular, scalable, open-source, high-performance, light-weight, and a cross-platform web framework.    ASP.NET Core benefits and features: Nowadays, the ASP.NET Core the framework becomes more and more popular among the developers for several reasons. Let us discuss the benefits and features provided by this framework in detail. ·      Open Source:- The ASP.NET Core framework is Open Source. The Source Code of this Framework is available at   https://github.com/aspnet  and you are free to download the source code and even if you want ...
Read more

SQL AND ,OR, NOT Operators

Image
SQL AND, OR, NOT  OPERATOR:-  The WHERE clause can be combined with AND, OR, NOT Operators. These operators are used to filter records based on more than one condition. SQL AND OPERATOR:- The AND operator displays a record if all the conditions separated by AND are TRUE. SYNTAX:- SELECT column1 ,column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ... ; EXAMPLE:- Consider the CUSTOMERS table having the following records:- AND Example:- The following SQL statement selects all fields from "CUSTOMERS" where Address is "Delhi" AND Age is "23 ":-  SELECT CustomerID , Name ,Address , Age ,Salary   FROM CUSTOMERS  WHERE Address = 'Delhi' AND Age = 23 ; OUTPUT:- SQL OR OPERATOR:- The SQL OR Operator is used to create a SQL statement where records are returned when any one of the conditions met. Syntax:- SELECT column1 ,column2, ... FROM table_name WHERE condition1 OR condition2 OR condition3 ... ; EXAMPLE:- The followin...
Read more

SQL Joins

SQL JOINS:-  JOIN means to combine something. In case of SQL join clause is used to combine rows from two or more table, based on a related column between them. IMPORTANCE OF JOIN:- If you want to combine two or more table the SQL JOIN is used. If you want to access more than one table through a SELECT statement. The joining of two or more tables is based on common filed between them. TYPES OF JOIN:- INNER JOIN:- INNER JOIN returns records that have matching values in both the table. LEFT(OUTER) JOIN:- This join returns all records from the left table , and the matched record from the right table. RIGHT(OUTER) JOIN:- This join returns all records from the right table, and the matched records from the left table. FULL(OUTER) JOIN:- This join returns all records when there is s match in either left or the right table.
Read more