Bloc Basic DBMS in detailed information

parthbarach2005 5 views 19 slides Aug 29, 2024
Slide 1
Slide 1 of 19
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14
Slide 15
15
Slide 16
16
Slide 17
17
Slide 18
18
Slide 19
19

About This Presentation

you might know that but after reading this ppt your knowledge will more raise.


Slide Content

DatabaseManagementSystem
Block:I

Block:I-Agenda
-IntroductiontoDatabase
-TypesofDatabase
-DBMSvsRDBMS
-DBMSArchitecture
-DataModels
-DataModelschema

●Data:
○Dataisacollectionofadistinctsmallunitofinformation.Itcanbe
usedinavarietyofformsliketext,numbers,media,bytes,etc.itcan
bestoredinpiecesofpaperorelectronicmemory,etc.
●Database:
○Thedatabaseisacollectionofinterrelateddatawhichisusedto
retrieve,insertanddeletethedataefficiently.Itisalsousedto
organizethedataintheformofatable,schema,views,andreports,
etc.
○Forexample:ThecollegeDatabaseorganizesthedataaboutthe
admin,staff,studentsandfacultyetc.
○Usingthedatabase,youcaneasilyretrieve,insert,anddeletethe
information.
●DatabaseManagementSystem:
○ADatabaseManagementSystem(DBMS)isasoftwaresystemthatis
designedtomanageandorganizedatainastructuredmanner.
○Forexample:MySQL,Oracle,etcareaverypopularcommercial
databasewhichisusedindifferentapplications.
○DBMSprovidesaninterfacetoperformvariousoperationslike
databasecreation,storingdatainit,updatingdata,creatingatablein
thedatabaseandalotmore.
DBMS

TypesofDatabase

●CentralizedDatabase:
○Acentralizeddatabaseisbasicallyatypeofdatabasethatisstored,
locatedaswellasmaintainedatasinglelocationonly.
○Thistypeofdatabaseismodifiedandmanagedfromthatlocation
itself.
○Thislocationisthusmainlyanydatabasesystemoracentralized
computersystem.Thecentralizedlocationisaccessedviaaninternet
connection(LAN,WAN,etc).
○Thiscentralizeddatabaseismainlyusedbyinstitutionsor
organizations.
●DistributedDatabase:
○Adistributeddatabaseisbasicallyatypeofdatabasewhichconsistsof
multipledatabasesthatareconnectedwitheachotherandarespread
acrossdifferentphysicallocations.
○Thedatathatisstoredinvariousphysicallocationscanthusbe
managedindependentlyofotherphysicallocations.
○Thecommunicationbetweendatabasesatdifferentphysicallocations
isthusdonebyacomputernetwork.
TypesofDatabase

●RelationalDatabase:
○Consideredthemostmatureofalldatabases,thesedatabasesleadin
theproductionlinealongwiththeirmanagementsystems.
○Inthisdatabase,everypieceofinformationhasarelationshipwith
everyotherpieceofinformation.
○Thisisonaccountofeverydatavalueinthedatabasehavingaunique
identityintheformofarecord.
○ArelationaldatabaseusesSQLforstoring,manipulating,aswellas
maintainingthedata.
●NoSQLDatabase:
○ANoSQLoriginallyreferringtononSQLornon-relationalisadatabase
thatprovidesamechanismforstorageandretrievalofdata.
○Itisnotarelationaldatabaseasitstoresdatanotonlyintabularform
butinseveraldifferentways.
○MongoDBfallsinthecategoryofNoSQLdocument-baseddatabase.
TypesofDatabase

●CloudDatabase:
○Atypeofdatabasewheredataisstoredinavirtualenvironmentand
executesoverthecloudcomputingplatform.
○Itprovidesuserswithvariouscloudcomputingservices(SaaS,PaaS,
IaaS,etc.)foraccessingthedatabase.
○Therearenumerouscloudplatforms,butthebestoptionsare:AWS,
Azure,GoogleCloudSQLetc.
●ObjectOrientedDatabase:
○Thetypeofdatabasethatusestheobject-baseddatamodelapproach
forstoringdatainthedatabasesystem.
○The data isrepresented and stored asobjects which aresimilar to the
objectsusedintheobject-orientedprogramminglanguage.
TypesofDatabase

●HierarchicalDatabase:
○Itisthetypeofdatabasethatstoresdataintheformof
parent-childrenrelationshipnodes.Here,itorganizesdataina
tree-likestructure.
○Datagetstoredintheformofrecordsthatareconnectedvialinks.
Eachchildrecordinthetreewillcontainonlyoneparent.Ontheother
hand,eachparentrecordcanhavemultiplechildrecords.
●PersonalDatabase:
○Collectingandstoringdataontheuser'ssystemdefinesaPersonal
Database.Thisdatabaseisbasicallydesignedforasingleuser.
TypesofDatabase

DBMSvsRDBMS

DatabaseArchitecture

DatabaseArchitecture:1Tier

DatabaseArchitecture:2Tier

DatabaseArchitecture:3Tier

DataModels
●ADataModelinDatabaseManagement System(DBMS) istheconceptoftoolsthataredevelopedto
summarizethedescriptionofthedatabase.
●DataModelsprovideuswithatransparentpictureofdatawhichhelpsusincreatinganactualdatabase.
●Itshowsusfromthedesignofthedatatoitsproperimplementationofdata.

DataModels:Conceptual
●Theconceptualdatamodeldescribesthedatabaseataveryhighlevelandisusefultounderstandtheneeds
orrequirementsofthedatabase.Itisthismodel,thatisusedintherequirement-gatheringprocessi.e.
beforetheDatabaseDesignersstartmakingaparticulardatabase.
●Onesuchpopularmodelistheentity/relationshipmodel(ERmodel).TheE/Rmodelspecializesinentities,
relationships,andevenattributesthatareusedbydatabasedesigners.
●Intermsofthisconcept,adiscussioncanbemadeevenwithnon-computerscience(non-technical)users
andstakeholders,andtheirrequirementscanbeunderstood.

DataModels:Representational
●Thistypeofdatamodelisusedtorepresentonlythelogicalpartofthedatabaseanddoesnotrepresentthe
physicalstructureofthedatabase.
●Therepresentationaldatamodelallowsustofocusprimarily,onthedesignpartofthedatabase.Apopular
representationalmodelisaRelationalmodel.
●TherelationalModelconsistsofRelationalAlgebraandRelationalCalculus.IntheRelationalModel,we
basicallyusetablestorepresentourdataandtherelationshipsbetweenthem.
●ItisatheoreticalconceptwhosepracticalimplementationisdoneinPhysicalDataModel.

DataModels:Physical
●ThephysicalDataModelisusedtopracticallyimplementRelationalDataModel.
●Webasicallysavetablesinmemorysotheycanbeaccessedefficiently.
●Inordertocomeupwithagoodphysicalmodel,wehavetoworkontherelationalmodelinabetterway.
●StructuredQueryLanguage(SQL)isusedtopracticallyimplementRelationalAlgebra.
●ThisDataModeldescribesHOWthesystemwillbeimplementedusingaspecificDBMSsystem.
●ThismodelistypicallycreatedbyDBAanddevelopers.
●Thepurposeisactualimplementationofthedatabase.

18
DatamodelSchema
●ADataModelSchemadefineshowdatapointsareorganizedand
connectedwithinaRelationalDatabase,includinglogicalconstraintslike
tablenames,fields,datatypes,andtherelationshipsbetweenthese
entities.
●Inotherwords,aDataModelSchemaisthe“blueprint”ofadatabase
thatdescribeshowdatacanberelatedtootherTablesorDataModels.
●Adatabaseschemaistheskeletonstructureofthedatabase.It
representsthelogicalviewoftheentiredatabase.Aschemacontains
schemaobjectsliketable,foreignkey,primarykey,views,columns,data
types,storedprocedure,etc.
●Adatabaseschemacanberepresentedbyusingthevisualdiagram.That
diagramshowsthedatabaseobjectsandrelationshipwitheachother.
●Adatabaseschemaisdesignedbythedatabasedesignerstohelp
programmerswhosesoftwarewillinteractwiththedatabase.Theprocess
ofdatabasecreationiscalleddatamodeling.

GoodLuck!
Tags