SlideShare a Scribd company logo
Prepared By::-
Ghanshyam Patel
Defination
 A database is a collection of information that is
organized so that it can easily be accessed,
managed, and updated.
 A Program that provides access to databases is
known as a database management system(DBMS).
 For the use of DBMS data redundancy, data isolation
and data inconsistency are minimized and data can
be shared among users of data.
Types Of Databases:
 There are basic two types of databases:-
 Centralized Databases
 Distributed Databases
Centralized Databases
 where the database is physically in one location and
users typically use an Internet connection to access
it.
 Banks tend to use centralized databases.
Distributed Databases
 Where the database is in many locations often
where you have a national or international company
and customers tend to regularly interact with a local
branch.
 For example: Google uses Big-Table a distributed
DBMS as searching tends to be by users in a
particular region of the world.
Information About DBMS
 The DBMS permits an organization to centralize
data, manage them efficiently and provide access to
the stored data by application program.
 The DBMS acts as an interface between application
programs and physical data files. And also it
provides user with tools to add, delete, maintain,
display, print, search, select, short and update data.
Function Perform by DBMS
 Data Filtering and profiling
 Data quality
 Data Synchronization
 Data Enrichment
 Data maintenance
Advantages and capabilities of a DBMS
 Permanence
 Querying
 Concurrency
 Back up and replication
 Rule Enforcement
 Security
 Computation
 Change and access logging
 Automated optimization
View of the Data provide by DBMS
 A DBMS provides two views of data: A Physical
View and A logical View
 The physical view deals with the actual, physical
arrangement and location of data in the direct
access storage devices(DASDs).
 The logical view/user’s view, of a database program
represents data in a format that is meaningful to a
user and to the software programs that process
those data.
Thank You
Ad

More Related Content

What's hot (20)

Data base ppt
Data base pptData base ppt
Data base ppt
Hemanth Reddy
 
Database management system
Database management systemDatabase management system
Database management system
ashishkthakur94
 
Assign 1
Assign 1Assign 1
Assign 1
guestffcfdd
 
Database system environment ppt.
Database system environment ppt.Database system environment ppt.
Database system environment ppt.
yhen06
 
DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1
DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1
DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1
Raj vardhan
 
Bca3020 database management system
Bca3020   database management systemBca3020   database management system
Bca3020 database management system
smumbahelp
 
jose rizal
jose rizaljose rizal
jose rizal
Rio Hemelgo
 
Database Design and Implementation
Database Design and ImplementationDatabase Design and Implementation
Database Design and Implementation
Christian Reina
 
Database & dbms
Database & dbmsDatabase & dbms
Database & dbms
Diana Diana
 
Database System Architecture
Database System ArchitectureDatabase System Architecture
Database System Architecture
Vignesh Saravanan
 
Database design challenges conflicting goals
Database design challenges conflicting goalsDatabase design challenges conflicting goals
Database design challenges conflicting goals
markilyn
 
Database Development Process
Database Development ProcessDatabase Development Process
Database Development Process
Daniel Francisco Tamayo
 
Data and database administration(database)
Data and database administration(database)Data and database administration(database)
Data and database administration(database)
welcometofacebook
 
Distributed database
Distributed databaseDistributed database
Distributed database
sanjay joshi
 
Database
DatabaseDatabase
Database
sahil shinwari
 
Chapter 1
Chapter 1Chapter 1
Chapter 1
naidukalya
 
DATABASE FUNCTIONS
DATABASE FUNCTIONSDATABASE FUNCTIONS
DATABASE FUNCTIONS
ghazi103
 
02010 ppt ch01
02010 ppt ch0102010 ppt ch01
02010 ppt ch01
Rphelps2011
 
New Microsoft Office WordDatabase administration and automation Document (2)
New Microsoft Office WordDatabase administration and automation Document (2)New Microsoft Office WordDatabase administration and automation Document (2)
New Microsoft Office WordDatabase administration and automation Document (2)
naveen
 
Chapter 1
Chapter 1Chapter 1
Chapter 1
University Institute of Management sciences
 
Database management system
Database management systemDatabase management system
Database management system
ashishkthakur94
 
Database system environment ppt.
Database system environment ppt.Database system environment ppt.
Database system environment ppt.
yhen06
 
DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1
DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1
DATABASE MANAGEMENT SYSTEM UNIT-I Chapter-1
Raj vardhan
 
Bca3020 database management system
Bca3020   database management systemBca3020   database management system
Bca3020 database management system
smumbahelp
 
Database Design and Implementation
Database Design and ImplementationDatabase Design and Implementation
Database Design and Implementation
Christian Reina
 
Database System Architecture
Database System ArchitectureDatabase System Architecture
Database System Architecture
Vignesh Saravanan
 
Database design challenges conflicting goals
Database design challenges conflicting goalsDatabase design challenges conflicting goals
Database design challenges conflicting goals
markilyn
 
Data and database administration(database)
Data and database administration(database)Data and database administration(database)
Data and database administration(database)
welcometofacebook
 
Distributed database
Distributed databaseDistributed database
Distributed database
sanjay joshi
 
DATABASE FUNCTIONS
DATABASE FUNCTIONSDATABASE FUNCTIONS
DATABASE FUNCTIONS
ghazi103
 
New Microsoft Office WordDatabase administration and automation Document (2)
New Microsoft Office WordDatabase administration and automation Document (2)New Microsoft Office WordDatabase administration and automation Document (2)
New Microsoft Office WordDatabase administration and automation Document (2)
naveen
 

Viewers also liked (9)

Distributed computing
Distributed computingDistributed computing
Distributed computing
Alokeparna Choudhury
 
Distributed & parallel system
Distributed & parallel systemDistributed & parallel system
Distributed & parallel system
Manish Singh
 
Database Management System
Database Management SystemDatabase Management System
Database Management System
NILESH UCHCHASARE
 
Distributed system notes unit I
Distributed system notes unit IDistributed system notes unit I
Distributed system notes unit I
NANDINI SHARMA
 
Software Architecture: Styles
Software Architecture: StylesSoftware Architecture: Styles
Software Architecture: Styles
Henry Muccini
 
Fault tolerance in distributed systems
Fault tolerance in distributed systemsFault tolerance in distributed systems
Fault tolerance in distributed systems
sumitjain2013
 
System Development Life Cycle & Implementation of MIS
System Development Life Cycle & Implementation of MISSystem Development Life Cycle & Implementation of MIS
System Development Life Cycle & Implementation of MIS
George V James
 
Computer based information system
Computer based information systemComputer based information system
Computer based information system
shoaibzaheer1
 
Introduction to the Computer-Based Information System
Introduction to the Computer-Based Information SystemIntroduction to the Computer-Based Information System
Introduction to the Computer-Based Information System
Fathur Rohman
 
Distributed & parallel system
Distributed & parallel systemDistributed & parallel system
Distributed & parallel system
Manish Singh
 
Distributed system notes unit I
Distributed system notes unit IDistributed system notes unit I
Distributed system notes unit I
NANDINI SHARMA
 
Software Architecture: Styles
Software Architecture: StylesSoftware Architecture: Styles
Software Architecture: Styles
Henry Muccini
 
Fault tolerance in distributed systems
Fault tolerance in distributed systemsFault tolerance in distributed systems
Fault tolerance in distributed systems
sumitjain2013
 
System Development Life Cycle & Implementation of MIS
System Development Life Cycle & Implementation of MISSystem Development Life Cycle & Implementation of MIS
System Development Life Cycle & Implementation of MIS
George V James
 
Computer based information system
Computer based information systemComputer based information system
Computer based information system
shoaibzaheer1
 
Introduction to the Computer-Based Information System
Introduction to the Computer-Based Information SystemIntroduction to the Computer-Based Information System
Introduction to the Computer-Based Information System
Fathur Rohman
 
Ad

Similar to Databases And Database Management System (20)

Database_Mgt_Accounting_Students_Ghana11
Database_Mgt_Accounting_Students_Ghana11Database_Mgt_Accounting_Students_Ghana11
Database_Mgt_Accounting_Students_Ghana11
AlexanderAsmah1
 
Introductionaaaaaaaaaaaaaaaaaaaaaaa.pptx
Introductionaaaaaaaaaaaaaaaaaaaaaaa.pptxIntroductionaaaaaaaaaaaaaaaaaaaaaaa.pptx
Introductionaaaaaaaaaaaaaaaaaaaaaaa.pptx
AlexanderAsmah1
 
Unit 2 rdbms study_material
Unit 2  rdbms study_materialUnit 2  rdbms study_material
Unit 2 rdbms study_material
gayaramesh
 
Database System Concepts
Database System ConceptsDatabase System Concepts
Database System Concepts
Ranilesh Raveendran
 
DataMgt - UNIT-I .PPT
DataMgt - UNIT-I .PPTDataMgt - UNIT-I .PPT
DataMgt - UNIT-I .PPT
BhaskarPatil24
 
Intro to dbms
Intro to dbmsIntro to dbms
Intro to dbms
Surkhab Shelly
 
ansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhf
ansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhfansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhf
ansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhf
neverinstall77
 
database chap 1 and 2.pptx
database chap 1 and 2.pptxdatabase chap 1 and 2.pptx
database chap 1 and 2.pptx
Eliasasefa
 
mayankszwshqwehydgfrgyhsdehybedfbedjednhedrik
mayankszwshqwehydgfrgyhsdehybedfbedjednhedrikmayankszwshqwehydgfrgyhsdehybedfbedjednhedrik
mayankszwshqwehydgfrgyhsdehybedfbedjednhedrik
neverinstall77
 
Introduction to Database Management System.pptx
Introduction to Database Management System.pptxIntroduction to Database Management System.pptx
Introduction to Database Management System.pptx
yashodamb
 
A database management system
A database management systemA database management system
A database management system
ghulam120
 
Basic of Database Management System(DBMS)
Basic of Database Management System(DBMS)Basic of Database Management System(DBMS)
Basic of Database Management System(DBMS)
anjanasharma77573
 
Role of Database susytem AICT (lec# 4).pptx
Role of Database susytem AICT (lec# 4).pptxRole of Database susytem AICT (lec# 4).pptx
Role of Database susytem AICT (lec# 4).pptx
hinasattar5
 
mayank file tt 6 (1).do989loioli9lo9ioocx
mayank file tt 6 (1).do989loioli9lo9ioocxmayank file tt 6 (1).do989loioli9lo9ioocx
mayank file tt 6 (1).do989loioli9lo9ioocx
neverinstall77
 
mayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuef
mayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuefmayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuef
mayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuef
neverinstall77
 
data base management report
data base management report data base management report
data base management report
shivam tripathi
 
DB Lecture_04.pptx data base sql mongodb
DB Lecture_04.pptx data base sql mongodbDB Lecture_04.pptx data base sql mongodb
DB Lecture_04.pptx data base sql mongodb
Islamicgharchanel
 
Data base management system
Data base management systemData base management system
Data base management system
ashirafzal1
 
Cp 121 lecture 01
Cp 121 lecture 01Cp 121 lecture 01
Cp 121 lecture 01
ITNet
 
Database Management System.pptx
Database Management System.pptxDatabase Management System.pptx
Database Management System.pptx
AaravSharma743156
 
Database_Mgt_Accounting_Students_Ghana11
Database_Mgt_Accounting_Students_Ghana11Database_Mgt_Accounting_Students_Ghana11
Database_Mgt_Accounting_Students_Ghana11
AlexanderAsmah1
 
Introductionaaaaaaaaaaaaaaaaaaaaaaa.pptx
Introductionaaaaaaaaaaaaaaaaaaaaaaa.pptxIntroductionaaaaaaaaaaaaaaaaaaaaaaa.pptx
Introductionaaaaaaaaaaaaaaaaaaaaaaa.pptx
AlexanderAsmah1
 
Unit 2 rdbms study_material
Unit 2  rdbms study_materialUnit 2  rdbms study_material
Unit 2 rdbms study_material
gayaramesh
 
ansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhf
ansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhfansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhf
ansh24.docxdegevfeghvehydfyebgdfhbgdfhbgefhf
neverinstall77
 
database chap 1 and 2.pptx
database chap 1 and 2.pptxdatabase chap 1 and 2.pptx
database chap 1 and 2.pptx
Eliasasefa
 
mayankszwshqwehydgfrgyhsdehybedfbedjednhedrik
mayankszwshqwehydgfrgyhsdehybedfbedjednhedrikmayankszwshqwehydgfrgyhsdehybedfbedjednhedrik
mayankszwshqwehydgfrgyhsdehybedfbedjednhedrik
neverinstall77
 
Introduction to Database Management System.pptx
Introduction to Database Management System.pptxIntroduction to Database Management System.pptx
Introduction to Database Management System.pptx
yashodamb
 
A database management system
A database management systemA database management system
A database management system
ghulam120
 
Basic of Database Management System(DBMS)
Basic of Database Management System(DBMS)Basic of Database Management System(DBMS)
Basic of Database Management System(DBMS)
anjanasharma77573
 
Role of Database susytem AICT (lec# 4).pptx
Role of Database susytem AICT (lec# 4).pptxRole of Database susytem AICT (lec# 4).pptx
Role of Database susytem AICT (lec# 4).pptx
hinasattar5
 
mayank file tt 6 (1).do989loioli9lo9ioocx
mayank file tt 6 (1).do989loioli9lo9ioocxmayank file tt 6 (1).do989loioli9lo9ioocx
mayank file tt 6 (1).do989loioli9lo9ioocx
neverinstall77
 
mayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuef
mayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuefmayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuef
mayank duehduiehdfeudfheufdhufujfufujdfujdfhuhdfuijdhuidfhuef
neverinstall77
 
data base management report
data base management report data base management report
data base management report
shivam tripathi
 
DB Lecture_04.pptx data base sql mongodb
DB Lecture_04.pptx data base sql mongodbDB Lecture_04.pptx data base sql mongodb
DB Lecture_04.pptx data base sql mongodb
Islamicgharchanel
 
Data base management system
Data base management systemData base management system
Data base management system
ashirafzal1
 
Cp 121 lecture 01
Cp 121 lecture 01Cp 121 lecture 01
Cp 121 lecture 01
ITNet
 
Database Management System.pptx
Database Management System.pptxDatabase Management System.pptx
Database Management System.pptx
AaravSharma743156
 
Ad

Recently uploaded (13)

DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...
DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...
DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...
werhkr1
 
Presentation Mehdi Monitorama 2022 Cancer and Monitoring
Presentation Mehdi Monitorama 2022 Cancer and MonitoringPresentation Mehdi Monitorama 2022 Cancer and Monitoring
Presentation Mehdi Monitorama 2022 Cancer and Monitoring
mdaoudi
 
ProjectArtificial Intelligence Good or Evil.pptx
ProjectArtificial Intelligence Good or Evil.pptxProjectArtificial Intelligence Good or Evil.pptx
ProjectArtificial Intelligence Good or Evil.pptx
OlenaKotovska
 
Breaking Down the Latest Spectrum Internet Plans.pdf
Breaking Down the Latest Spectrum Internet Plans.pdfBreaking Down the Latest Spectrum Internet Plans.pdf
Breaking Down the Latest Spectrum Internet Plans.pdf
Internet Bundle Now
 
Java developer-friendly frontends: Build UIs without the JavaScript hassle- JCON
Java developer-friendly frontends: Build UIs without the JavaScript hassle- JCONJava developer-friendly frontends: Build UIs without the JavaScript hassle- JCON
Java developer-friendly frontends: Build UIs without the JavaScript hassle- JCON
Jago de Vreede
 
GiacomoVacca - WebRTC - troubleshooting media negotiation.pdf
GiacomoVacca - WebRTC - troubleshooting media negotiation.pdfGiacomoVacca - WebRTC - troubleshooting media negotiation.pdf
GiacomoVacca - WebRTC - troubleshooting media negotiation.pdf
Giacomo Vacca
 
introduction to html and cssIntroHTML.ppt
introduction to html and cssIntroHTML.pptintroduction to html and cssIntroHTML.ppt
introduction to html and cssIntroHTML.ppt
SherifElGohary7
 
Cloud-to-cloud Migration presentation.pptx
Cloud-to-cloud Migration presentation.pptxCloud-to-cloud Migration presentation.pptx
Cloud-to-cloud Migration presentation.pptx
marketing140789
 
Paper: World Game (s) Great Redesign.pdf
Paper: World Game (s) Great Redesign.pdfPaper: World Game (s) Great Redesign.pdf
Paper: World Game (s) Great Redesign.pdf
Steven McGee
 
plataforma virtual E learning y sus características.pdf
plataforma virtual E learning y sus características.pdfplataforma virtual E learning y sus características.pdf
plataforma virtual E learning y sus características.pdf
valdiviesovaleriamis
 
IoT PPT introduction to internet of things
IoT PPT introduction to internet of thingsIoT PPT introduction to internet of things
IoT PPT introduction to internet of things
VaishnaviPatil3995
 
The Hidden Risks of Hiring Hackers to Change Grades: An Awareness Guide
The Hidden Risks of Hiring Hackers to Change Grades: An Awareness GuideThe Hidden Risks of Hiring Hackers to Change Grades: An Awareness Guide
The Hidden Risks of Hiring Hackers to Change Grades: An Awareness Guide
russellpeter1995
 
How to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabberHow to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabber
eGrabber
 
DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...
DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...
DEF CON 25 - Whitney-Merrill-and-Terrell-McSweeny-Tick-Tick-Boom-Tech-and-the...
werhkr1
 
Presentation Mehdi Monitorama 2022 Cancer and Monitoring
Presentation Mehdi Monitorama 2022 Cancer and MonitoringPresentation Mehdi Monitorama 2022 Cancer and Monitoring
Presentation Mehdi Monitorama 2022 Cancer and Monitoring
mdaoudi
 
ProjectArtificial Intelligence Good or Evil.pptx
ProjectArtificial Intelligence Good or Evil.pptxProjectArtificial Intelligence Good or Evil.pptx
ProjectArtificial Intelligence Good or Evil.pptx
OlenaKotovska
 
Breaking Down the Latest Spectrum Internet Plans.pdf
Breaking Down the Latest Spectrum Internet Plans.pdfBreaking Down the Latest Spectrum Internet Plans.pdf
Breaking Down the Latest Spectrum Internet Plans.pdf
Internet Bundle Now
 
Java developer-friendly frontends: Build UIs without the JavaScript hassle- JCON
Java developer-friendly frontends: Build UIs without the JavaScript hassle- JCONJava developer-friendly frontends: Build UIs without the JavaScript hassle- JCON
Java developer-friendly frontends: Build UIs without the JavaScript hassle- JCON
Jago de Vreede
 
GiacomoVacca - WebRTC - troubleshooting media negotiation.pdf
GiacomoVacca - WebRTC - troubleshooting media negotiation.pdfGiacomoVacca - WebRTC - troubleshooting media negotiation.pdf
GiacomoVacca - WebRTC - troubleshooting media negotiation.pdf
Giacomo Vacca
 
introduction to html and cssIntroHTML.ppt
introduction to html and cssIntroHTML.pptintroduction to html and cssIntroHTML.ppt
introduction to html and cssIntroHTML.ppt
SherifElGohary7
 
Cloud-to-cloud Migration presentation.pptx
Cloud-to-cloud Migration presentation.pptxCloud-to-cloud Migration presentation.pptx
Cloud-to-cloud Migration presentation.pptx
marketing140789
 
Paper: World Game (s) Great Redesign.pdf
Paper: World Game (s) Great Redesign.pdfPaper: World Game (s) Great Redesign.pdf
Paper: World Game (s) Great Redesign.pdf
Steven McGee
 
plataforma virtual E learning y sus características.pdf
plataforma virtual E learning y sus características.pdfplataforma virtual E learning y sus características.pdf
plataforma virtual E learning y sus características.pdf
valdiviesovaleriamis
 
IoT PPT introduction to internet of things
IoT PPT introduction to internet of thingsIoT PPT introduction to internet of things
IoT PPT introduction to internet of things
VaishnaviPatil3995
 
The Hidden Risks of Hiring Hackers to Change Grades: An Awareness Guide
The Hidden Risks of Hiring Hackers to Change Grades: An Awareness GuideThe Hidden Risks of Hiring Hackers to Change Grades: An Awareness Guide
The Hidden Risks of Hiring Hackers to Change Grades: An Awareness Guide
russellpeter1995
 
How to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabberHow to Install & Activate ListGrabber - eGrabber
How to Install & Activate ListGrabber - eGrabber
eGrabber
 

Databases And Database Management System

  • 2. Defination  A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.  A Program that provides access to databases is known as a database management system(DBMS).  For the use of DBMS data redundancy, data isolation and data inconsistency are minimized and data can be shared among users of data.
  • 3. Types Of Databases:  There are basic two types of databases:-  Centralized Databases  Distributed Databases
  • 4. Centralized Databases  where the database is physically in one location and users typically use an Internet connection to access it.  Banks tend to use centralized databases.
  • 5. Distributed Databases  Where the database is in many locations often where you have a national or international company and customers tend to regularly interact with a local branch.  For example: Google uses Big-Table a distributed DBMS as searching tends to be by users in a particular region of the world.
  • 6. Information About DBMS  The DBMS permits an organization to centralize data, manage them efficiently and provide access to the stored data by application program.  The DBMS acts as an interface between application programs and physical data files. And also it provides user with tools to add, delete, maintain, display, print, search, select, short and update data.
  • 7. Function Perform by DBMS  Data Filtering and profiling  Data quality  Data Synchronization  Data Enrichment  Data maintenance
  • 8. Advantages and capabilities of a DBMS  Permanence  Querying  Concurrency  Back up and replication  Rule Enforcement  Security  Computation  Change and access logging  Automated optimization
  • 9. View of the Data provide by DBMS  A DBMS provides two views of data: A Physical View and A logical View  The physical view deals with the actual, physical arrangement and location of data in the direct access storage devices(DASDs).  The logical view/user’s view, of a database program represents data in a format that is meaningful to a user and to the software programs that process those data.
  翻译: