0% found this document useful (0 votes)
18 views8 pages

DBMS Notes

All about unit 1

Uploaded by

junabalimjacse22
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
0% found this document useful (0 votes)
18 views8 pages

DBMS Notes

All about unit 1

Uploaded by

junabalimjacse22
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
Das Data: Raw, unprocessed facts thet neccl context to becme weful Data can be numbeu,, symbole , Chenactoy , Words, coc ox Graphs €g- Monks ¥ Hu student, Mans G the wuld] )rformatin> Data thet Rar been priotessed, Opgenised ere) ‘index preted -b add mean and value. Inflamach en 4 Chda pt inte comlext and Can be hbed by fhunard 40 mae deckias 4 rests . fo jr Report curd sheet Database? 1+ is an Orgenised collectin dere gtd in a com puter System and wy Crholld by a database Manesgement System, Des) Informbin, Pccourd ‘fermadien orgeige the deda abet faculty , admin, staff, etc. which helhs ™ Ho efficent — ratsiaal , inderton ond deletion of dab a from Me DBMS A Database Management Sptem is @ Seftond System thal is desjqred fo manage ano! Osgange dda in 9 shuchuedl manne . > 4 allows ion to crab, modify ond Yyeyy « dalabwe as ne a manage he Secusiy and acon crpls for Hat dcdabaye . DENS PRY ah environment ty she ond reinwo dala in Convenient and Of ficert manne Key feaheas * Dake_modeling> f DBMS pslovides -bols for oan Ord modifiing cere models, which define the Shuc ard Selahonbips of dale in a dedabue - ata Bbrage end Deberal = 1H Dams is respriible pr ab eal sebiovng oles fem the dodabue, and Gn pscovide vestions methods for Searching ond wong He dda - Concisgency Conrol> A DBMS xavier mechanisms fr conhpll ake acces ty the oe te ensure Ce mutible wea can acy He data h8ithont- Conf ching wo each other: Dal_inigowiiy ond Security? PH DOMS provide tools for Crfercing —dledex ny Ord Seeustily conshaints , Buch ay Qrsbants on the valug dato aol ated conols tet Fe bhict who Can aceon He ede. . Backup and) Secovewy- A DBMS byevider mechanlamy for backing up ome deevering the dole in the evenp 4 Apter fain Both fle Septem om) Dans oxe hoo Rindu dele mavegenent stony thol cet taed in diffead Capaci hes amd possea different chasrocteu tics A file system Is a weg d crgeniaing pie into grubs ond folden ox sor Shona thors Ina Bhnage device File &sptemy censist ffeeat ple which Oe Grewal tol dirockigg. Tre dircelorin futher cordevn ‘other forte amd files Bo Naps ( Neu Technology ple syslen). Ext C Extended fle Se) IxLylz > meater fle dint J To > wea fie disc 00 = file; d DBMs+ it is bassically sefhware that manages the colleen ¢ rolated dedq: tt iy wed fo» shng cla cx, and eke eVing the dada E ffechaely bohen it is needed 3 abo Pproiides — proper Sectaiky me aanes tr brclechog the dda fom wn auth orged accor £45 ¢ Stouchnt Baia, > |n DBMS, the data can be fetched rd Soe Quen amd Selakonaf algebra - mechanisms of data Tecovoty Oracle, Myssar, MS See File Splem The file Sptem ia a aopanging the fie in a sbraye medion within a Compider Pedundoat dale can be proxi ino fle systen provide in bait rechaniam for backup and Aecowey Y dada of it loss. There is no Cb bicient Mery Brocessng in He file Seplen ond dafa bachup 14 allo |aH oviol ey Server - DENS DAMS SPhore managing ddlabae ro tedundont dada preent u porovicls in howe tools fr back up Aid Secov ci dad c Cven if 4 ialost . Efficient ptr [eeeassipg 14 there In DBN¢ File Sytem DBs Gonaipteng ess contistende more Consistent became | the pretess ¢ jormalygetry, Seay less secured move secu y Shag Dede is clishrbuded Dae te erties ary Pro! matt, lof shari ag Fis not ayy to sha aes ded “a : ey (oy ee Onacle, sq. serwer Data mode! + A dala model in DBMS is the wncept @ hols Hat ane developed qo Summasige the descnplon g the database > Dala models provide ns with « lrarsbasent folehae H x which Belbs ns m creating on achal database Tape ca data mol? — Hiexanchical Moclee Ne hvorR Model - €R Noded - Relational Mocle? Hictachical Model In this the dada is cxparited ‘nko a Wee-liKe Shevche thet Cah ecard Consul of q one parent Secord and Trost Childun y> w> ai> Nebwrh Medel “Dis model ai the genta gab the hierarchical Medel: Ts model can cornish ae potent segues and these seqment belenging a ony levee Objed - owented Deda model): Volabonships is Hew, dala. and ten 90 contain! in a Alogle Bhuchie “nih ered fy a an ebject in His data model . In #8, Seal porod frroblens ane repuesen ted a3 Objed with different atmhdes. All the Objects fave. mulhple Telahouhips blw then. | nfl Relafen Model: Tre eR data model specifies Enterpyse schema thad Yopraents the over ave lene ae Bhrachut ff a dadabasze Graprically: Relakcnal Mod - The dela in this model is febe In form a table tab is tuo-dmensinal. nly of the data is Rept tm frm ef Toe al Mluvy Schema and Intlance Sa oe Schema— lt ig the gverall descnphon the dedabue > te basic ghuchae In the detabase ig Ray doda wil be Ashroo catted Achoma > PAschoma i a tomplade +that dicted Rows dala ttems in @ database Wil) be Bhoted, Amonge d ard accessed - = he gical Schona a Physical soa) ; a View Shon shemar HH dlescrbs te’ dafabaue degpend oA atygicall tevel fow the dala or 1 erm abe) 1s pled pally inthe storage Siptem in far files indices => Tre Detabawe administrabr chooses where Gr) Bow to Alvre the data im differed blocks ¢ Ahorage bogie Dedabue Schema = he logical gchema descnbes ow

You might also like