> Code Storage: parent

Code Storage

A Technical blog for those who want to gain knowledge about SQL,MySQL,Data Science and real time query

Responsive Ads Here

Advertisement

Showing posts with label parent. Show all posts
Showing posts with label parent. Show all posts

Friday, January 10, 2020

What is DBMS.Advantage of DBMS.Types of DBMS.

DBMS,SQL,type if dbms,
                                            
                                                                    1.What is DBMS,Advantage,Type of DBMS


What is DBMS


  • A database management system is a software designed to assist in maintaining and utilizing large collection of data.
            Example:- Oracle,MySql,SQL.
  •  The alternative to use a DBMS is to store the data in files and write application specific to manage it.
  • DBMS allows users to create their own databases as per requirement.
  •  It provides an interface between the data and the software application.

Advantage of DBMS

  • Data independence. 
  • Efficient data access
  • Data integrity and security
  • Data Administration 
  • Concurrent access and data recovery
  • Reduce application development time

Types of DBMS 

  1. Hierarchical DBMS
  2. Network DBMS
  3. Relational DBMS
  4. Object Oriented

1.Hierarchical DBMS

  • In Hierarchical database, model data is organized in a tree like structure.
  • Data is stored hierarchically (top down or bottom down ) format .
  • Data is represented using a parent child relationship.
  • In hierarchical DBMS parent may have many children,but children have only one parent.

2.Network DBMS

  • The network database model allow each child to have multiple parents.
  • It helps you to address the need to model more complex relationship like many to many relationship.
  • In this model,entities are organized in a graph which can accessed through several paths.

3.Relational DBMS 

  • Relational DBMS is the widely used DBMS model in the industries because it is one of the easiest.
  • Relational DBMS based on the normalization data in the row and column of the tables.
  • It is stored in a fixed structures and manipulated using SQL.

4.Object Oriented 

  • In object oriented model data data stored in a form of objects. 
  • The structure we called is class we stored data within the class.
  • It define a database as a collection of objects which store both data members values and operations.

SEVER TYPE IN SSMS ( Sql Server Managment studio)

When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers ...