Bloc Basic DBMS in detailed information

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

1. DatabaseManagementSystem
Block:I

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

3. ●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

4. TypesofDatabase

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

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

7. ●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

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

9. DBMSvsRDBMS

10. DatabaseArchitecture

11. DatabaseArchitecture:1Tier

12. DatabaseArchitecture:2Tier

13. DatabaseArchitecture:3Tier

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

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

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

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

18. 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.

19. GoodLuck!