SQL Server Mentalist

Hi Folks,

This post is part of Series Database Management Systems

Currently running topic for this series is listed as below :

Series of Database Management Systems

>>Chapter 1 : DBMS [Database Management Systems]<You are Here>

Continuing from my previous post on this series, If you have missed any link please visit link below

We are going to Cover the Following Points in this article

• Types of Database Users
• Advantages of using DBMS
• Applications of traditional Database

Types of Database Users

Different persons who are involved in the design, use and maintenance of a large database having many users are:
1. Database Administrator [DBA]
2. Database Designers [DBD]
3. End Users
4. System Analysts and Application Programmers
5. DBMS System Designers and Implementers
6. Tool Developers
Database Administrator [DBA]

Database is one of the many Primary resources that are used by many  people in an Organization. 

DBMS and related software are the secondary resources.
Administering this secondary resource is the responsibility of the Database Administrator.   
He usually has the complete authority to access and monitor the database.  
He is responsible for creating, modifying, and maintaining the Database.
He grants permission to the users of the database.
He stores the profile of each user in the database.
He defines procedures to recover the database resulting from failures due to human, natural or hardware causes.
Database Designers [DBD]
 A Database Designer should design the database in such a manner that it should meet the requirements of the clients.   
End Users

People, who access the database, query and update the database and generate the various reports: the database primarily exists for their use.

End users are of two types: 
Casual users – are the users accessing the DBMS with SQL queries.
Naïve users – are the users accessing the DBMS through menus.   

System analysts and Application Programmers
 System analysts collect the information regarding requirements of the end users and develop specifications for caned transactions (Standardized queries and updates with carefully programmed data validity checking) that meet their requirements.  
 Application programmers implement specifications developed by the System Analysts in the form of programs, they are also responsible to test, debug, document and maintain these programs.   These are the programmers who write menus applications.

DBMS system designers and implementers
Implementers – implement the DBMS modules and interfaces as a software package.  

Tool Developers
 Tools are the third party optional software packages which are not available with the DBMS.  They include packages for DB design, performance, monitoring, graphical interacts.  In many cases independent software vendors develop and market these tools.  They are called Tool Developers. 
Operators and Maintenance Personnel
These are the system administration personnel that are responsible for the actual running and maintenance of the hardware and software environment for the DB system.

Advantages of using DBMS

1. Redundancy is reduced
2. Data located on a server can be shared by clients
3. Integrity (accuracy) can be maintained
4. Security features protect the Data from unauthorized access
5. Modern DBMS support internet based application.
6. In DBMS the application program and structure of data are independent.
7. Consistency of Data is maintained
8. DBMS supports multiple views. As DBMS  has many users, and each one of them might use it for different purposes, and may  require to view and manipulate only on a portion of the database, depending on requirement. 

Applications of traditional Database

Many large organizations like corporation, universities, hospitals and banks use database to store and maintain large number of records. 
The high level query language provided an alternative to programming language interfaces. Therefore new queries were much quicker to write than programming.

Due to the growth in object oriented programming languages the complex databases were used mainly in technological applications like engineering design, multimedia publishing and manufacturing system. 
Database is used for storing the documents created using web publishing languages such as HTML and interchange the data on the web for E-commerce. 
Further the new applications of database are scientific, storing and retrieval of images and videos, data mining, geographical information systems etc.

Hope you will like Series of Database Management Systems series !

If you have not yet subscribe this Blog , Please subscribe it from “follow me” tab !

So that you will be updated @ real time and all updated knowledge in your mail daily for free without any RSS subscription OR news reading !!

Happy Learning and Sharing !!

For More information related to BI World visit our all Mentalist networks Blog

SQL Server Mentalist … SQL Learning Blog

Business Intelligence Mentalist … Business Intelligence World

Microsoft Mentalist … MVC,ASP.NET, WCF & LinQ

MSBI Mentalist … MS BI and SQL Server

NMUG Bloggers …Navi Mumbai User Group Blog

Architectural Shack … Architectural implementation and design patterns

DBA Mentalist …Advance SQL Server Blog

MVC Mentalist … MVC Learning Blog

Link Mentalist … Daily Best link @ your email

Infographics Mentalist … Image worth explaining thousand Words

Hadoop Mentalist … Blog on Big Data

BI Tools Analysis … BI Tools

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS | About Me |