KEMBAR78
DBMS Unit-1 | PDF
Scribd
Upload
37 views40 pages

DBMS Unit-1

The document discusses Database Management Systems (DBMS), focusing on their structure, functionality, and benefits. It covers topics such as data organization, types of databases, data redundancy, and the importance of data integrity and security. Additionally, it highlights the advantages of using DBMS for efficient data management and access across multiple applications.

Uploaded by

Divya Gurram
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
37 views40 pages

DBMS Unit-1

The document discusses Database Management Systems (DBMS), focusing on their structure, functionality, and benefits. It covers topics such as data organization, types of databases, data redundancy, and the importance of data integrity and security. Additionally, it highlights the advantages of using DBMS for efficient data management and access across multiple applications.

Uploaded by

Divya Gurram
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
You are on page 1/ 40
- = Be igernent yor si: | Cf Datla Baye Moragerner Sysiemy Ouesview > Inlwoduction 10 dota, GaPoxmation, dotabose., and — datokaye monogenend Sted, > fie. bated sem, Dxesads Pile based Syter., > databoye appscach, _5 classificatisn oF DEMS, —> fidvordoges F datobaye 4 —> Yarius Data Mockls , > Canpcnen}s & oans, —> thee Schema axchilecbse F dodo bate, _s cost and isks F gatokoye oppecoth: pptcach, ‘Dota’ nothing ut a collection of Raw fact, (Pow fats) deese't hae of HRY bds, - EX padi, video, ye X Numbers --elc- pholos, chotatlers , 4 Tahesmation :- ele ee called © Zofeamation - “the peacessed dota 75 RY casa? we intoemation. | ) 2." Compoxs'sen g Coto. ond nfosreation Exomple :- “the histosy & “tempest ese scodings all noe ate oxld Rs We pest ico sfo¥S “4 dato and oralysed to Ged ‘ap aris dela fa OF eed : “nat alckal Aempexa wwe gp dising » ken apa Yip * Ragaswortion To fexmalion fs cxesled —Froen dala [Dota | ‘Dato | Joa ) NX —— sb, Note = ‘) peed the Monupulation & deta. iv”) Monigiation '- Chopra, Ape dala —Hromn one esrat 40 another Sand Databose 25 a calkction oF xeloted dale ospentecd ino 0H Ahat he dota can be é dated. Cos’) cosily accessed, managed and up 4) dolonse %3 0 oxgpniaed collection of Stsudlured Snfoxmaton, o8 dato, ~aypically Stosed electsenically my ao Comprier’ Sypiem- (os) A datoloye %@ Stauchwel, omaaiael sel & dato Cin Some Sequence of oxdex’). — a0 Comping Aesenindlog, datobaye think & Wos a Fle cobinate hex YU Stose cola fh difPeent section called Aableg. athen ewe need poxticuSo Bile we look inte gontioaln sation (table) & get the Fle ve Eg:- conlock tist, tn box , Pickuse gollesy Sn phone. eed. 4 rete dla Meta doa Sey on SaRoxmation about the dat. (Re, Data obaut ~he dato. | EE digto! photo. E ¥ BS ; => when the polo wos on WF ie PN Be > ores 3% cag Acker a i > Camexa Selings --- ede Tye & Metadata i) Desesiptive rieladata clued ° ) Steuctusal Metadata Wdministaatie Meledata Ww) ReReasence metadata : v) Statistical Metodala * Dale Case Management System (B2"9) :- , 4 um ‘DBMS’ Stonds -fx “ Dotobose Moregerent ayer" feo T+ #5 a collection of application pagans eat © alles the uses Ao cagmise , seSte ord, vetsieve fafoxmation abet dato eRicient ly and oy effec Luely y a possible. . wed Peg may sal, Osacle & gyouse, ete (os) “Datobase Mlonogement Syste 25 g Tete —ochikh 7p used te SteXe ord aetsieve the date databaye. > Dems pxostdeg lhe Various pesotivrs \ike modigication ,- - el: sree foce param te cxeation, detebrr, tp CxeaKe AKG ~~ ro os alls the vse ij dalakagey oS pes hels acquiserent | > DBMS dws Abe URRY KO he application — > pems accepts the acquet -from ond pscvidey pectic dal. “thzugh re cpecting Sytem ; > vers provide the geup F pcaganes cadely acts accexdiing +o the Uses rastsuction. — Ft pavides Scout, +o he ddloballe + ROB ‘gppma, Stands fox“ Relational Datoloae Morogener Exile OEMS) con ke eed fos Inplemenirg Oens ( Oakoloage ryan Sytem) ggtenaticaly ¢ , (os) ' A ‘Dems’ i Sold 4o be RDBMS’ ; Ane doto must be reper Cs) Stosed Fr Abe —fosm of selation (lable), Ex:- odocle, sol, My SAL sai saver (QW) Dt --- eke. HIe. — oT A Table ( Relation) im a collection > Rows Columng- Roto i- 5 A'sor Ka-obk i also called a xecoud (os) tuple: > fi 15 © besigontal entity io the sable. Slama '- 5 A colmn is a vestical entity in the Joble ; cdrich contains all infosenaten aascioled with a specific eld in Joble. ag * otbte (os) Field . 7 ‘colunn ‘gy also calkd | pana ko Colurnns// Fieldy //Heiboules j | Va rH SS por _|_ nae Age [coves | 2 Fo) | Roma a3 comp Scie | 3 4 — XS Fog Roto a Correnence 3 wed |_Rend ag | zookgs “ Fol Radha al Boro Ve cobmn voluy_/ tala. Hees * fle :- ‘File’ 3 a “collabion xeleled Bids used oy a Sigle anit’ Ps called file- > pik % algo known of dato set > File axe Slosel oO gheesent Stosege Had disk, us8 , ond optical disk, .--efc > ne used to Stoxe the dota fr Popes Gorky, - ek Gin his way we stowed the dela Gn Books , So mors dxcwencks — axe thelr. media Uke | tke : » fgsmotion thd mead SF athe book fs | v° missing A missed then data - fs “abo missed, Ww Seasthing- coda WW) Time anste These pecblems axe axrtond +0 Spbecduced pile Based System " | a Be in file bad oper, we Used to She -the da 7? fo coepulevS . 2 tT fs a collechor of application parm -y we steed the chlo 88 ly oq “Notepads, ele. mg-cowd, MS Exel, - fn Piles, ~then the chta > we Steed the colo ‘6 rot missed, i.e; time 1S goved, ee. rsaclesisks & & Féle e le eased eysien + rt is o collection & fle & Stostd the dota : gach file 73 frlependent to each other’ cach ile fs called 0” Plat Pile” Each file conlains pesteunitg RE Féle, axe destined by. vst P pacers longucsges thE C, Cee, tree > Each fle, thot vx hy © coxwe the prccedurves for ranging the dito ae sass. Job Ab the sen ble axe the 1st & ceow backs fa flat Fle s- “they ose 9 ora Redundancy . a) Data Lo censi tery ; 3) pala TZ so lation | u) Seo! 9) pptuky fe essing Date | 9 Data Redurdarey :- >‘ Data Redundancy" reeany, . Same Samswotion % duplicated fo sevewal Hind” > “ paplicetinn of data” FB called of ‘dole Pedurdore gla TLnconsisleney -- > ‘Cala Redundancy coo teady to. Calo Tocorst ste, ee yedundart data ox not updated. simultancony > ‘palo Loconststeney” meory diffesent copig the | Sore data axe ol matching. i > ifs cccusS cdhen the wilt op eparte cpexations | thot ote rot updating the Some dala stoved at ditfesert places. Su "Ades strfewmrtion & 0 custorer ts xccackd clfRexently fo difPexert Gel . — Delo Lsoletion :- Drla axe seatlesed % \petous Px) ti be fn difrexent Rena ae ond fe | 1 costing 0a files 4 pacgenm -to xelsteve abla fs ditPfoutl. | applfeation 4) Seoul paeelems “= 3 Amolher podblem fi Sect Seorkve, guch of | efective gosswoed ‘ protection” : gle egpfefent secuily &elem ckes not per 7 rile mrechan’sms . So hee fs 2 Seay pablem fox dato. Sloed fn dre (le. D) DiRicully tr flecessing Dale > Tt fs not easy ‘to werwicve Sofoxsmartion using o. File prccesing apie: > Conventent & ecerrset PaGxmation wetstouol s almost rrposstole using converrtforat fle paocessing ‘gym vt) Deesn't guppost mnpltf Uses 2002s" > pplt-vsess con't _octess aye Gorre a Hire. fe, ane user oni “tt fs ob o dyotboacks 07 —_ Splem : caer dato at gates the dita pile - ee Datolose techoolegy elmira rang oF We paoblems of syodfiienal -Ffle cxportaation . by cagpnfzinn dole : Commbralt ing dato and corttadling xedundom data, and sane ony appliations and daktexerd” yap | at the ome tine: | | thle the database cppscach f2 | Steving ond rong date 80 lecativn: ; tt allows multiple Uses and opplcatfons to ; welled F | » cerdealfaed | occers ord pate “he data. Semultone . A Calokose Manageme afte (ests) 2s so tal: > fcls os an giesface bho ogplitation prqeard ord the dala fled. > kepacty +e togical Vie & the dotaboie (‘red the deta ts peaxceRad end 05288) | and -the physical view Cr “he data PS actually oxprisdd on Stoxoge ea). | 4 ogo allecss speech Logi vie? | By dipexerd - US: Hels to reduce dla xedundorey oe H ond obta Treonsistenay 4 nial ° meh OOF dala Saurce: Shoxed ——~ “he « 2 714 Revels arena “ Heath Ce | EmplageIO | RNG Ven eeepc eae eer flava Database postion <9 | Momgement Dale_yised | System G85 - POY I. oe Nek. poy Uke Trsusance pension ence | \ peatth_coxe J ——— ee a ical on Reson Geess-Poy | View Database nel ray | ‘ alventoggs of ebage pect > oat cTalegetiy :- . Ensuses the accuioyy , canpkleress , condslersf, ond valdity & the ohio. ) ata =tindepenclence Albws “the cblabage Sbueune “B t re opplteations 7 be chonged oe Shout — affectio the dela- mee Lj “gi athe Seon ' ‘ *) Ogle She? — Hews rouldfpe yess P cece ord Shore Albeo she dato sens alae \ — reclurderey eich occurs tk Pn ruil a sl cvedy * pases Fr erulti a & v’) | robs he dilokaie ree ekCiciert - | shies | ow it cook > taker Moregarert agen (DENS) 9 ose Stee, manipalode and x¢etsfese data. > colo descxiptions ove Sted fo 0 central leakix called * pola Ciel mf a7 ie dikes allees fox avick - sets! & tape orreutdy & cto. EL pa Std ing datokate custome’ deladls, pacluct vakesmotion Ny ced Se cute, ee > ‘pes % ° allection page ‘the dotabose gckae 078 centro! 08 to the dato steed ta We drlabose- fr vers consist > t+ cole Bon & athis post & pens *S ehewve pgs used to 08, oR sel & application dela. opsote, ond rar? apis gost constitutes dala ercngerreet dyotem (as): > 4 peMs 5 gel puspos? sles. 2; Pe, rot ogpleetien specrhie - ve (ca oxcle gyeose. etc) can ke used fn vathany seseavation Spi, Libsong 10007 a way % “ “fn and access dato, # pars aks coe & Stay leay only opploation gecchic +0 Preppy, sky -to application lem: Sroawe of Deve dS curries cP Daldonse Monggerns Tonle verison \ | a J\ topo | | (coreptal | | sales _ \ Bee | WW Fil” “Shuckwse fh Dolobose Maregerent sy'n a & DBMS - | Para rhe main cbjeeiel & chlabase wompement 6s" axe data ovarlability chla Ande vy chlo Seunnity ‘ord cota ®ndependence - aS qlbecs USAS to access dala ws > DBMS also aod Shove ft aczess plat eens: D ode Avarlobtttiy :- > DBMSs rnb ep dake. oveilable +> 0sxS fn 1 a Podmoat hal S easy so Unde . => Derss peootde a louse Stoeoge spoce Lox dota. .» ode utegsy . —> DBMSs Ensie dala * aceesorte and consistent. > DBMSs use validity checks to qrointein dala inlegit . ) Dato Seeustty ‘- > DBMSs_ psotect dela From conautthostaied 06088 os baeaches. —) DBMSs control uses access and enfoace Scausity polkcies - > DBM ensuxe tha ons cartheviged Users Gr aces “dato. gs ms” ~ V ¥) Data Independence :~ > DBNMSs allo uses Showe dota acwoSs pot, ancl applications. > OBMSs olbo vusws te change the physica! Stone eorthout oF ecing “the logic! dota.’ " v) Data Recovery! _ > DBMs pootde OBER plstfextn to &Stpxe dalakoses -to -thels psediouy site. > DBMSs pale bakup ond aceredy -fealins +o paclect ogeinst dato SS: VP Data Shassirg DGNSs alls multiple vss to accey and Shove the came data. : u . 142 Jap 3 Evolotion / 17 Stoxy eee A Database Monagerert sytem (Darts) arstts of Collchon & Prlexxelated dota ard a set & pxogens to access that deta. + ond valaing a database. caches to DBMS Sa recert yeoss, 60 opp : exe moxse popuilox . eahich axe Object - Cferted pens (covers) and mec _ Relational pris (or 068) the cheonoleg’cal ovdex F the development & pers fs 05 fellows : 25 sane tht ‘S helpfal Sm malntoic ing alokase __ Tere Flot files 1960s _ \ABs Afesaxchical Dadolnse, | \asos —\a9s Netioosk Dolakuse | {9908 ~ 19903 i Relotional Ostolase Jags - pscsent chiee t--oxtented patobese 1990s — psesent chject Rational Dalobose - (0s - paeseat - . Dato. - woxehoustng } [Qos - present | Dato. - woachousing | eos =P | Wel - Enololed adds — eee | — EEE SI Bacheon od GE created “YH genezal “puspose DEMS foteguated Oata Stoxe Zt cxaled the basis oe the netwoxk ode which coos Stordawdfsed by CODASYL Corforeig on Osla System Longuage ), > Late 1960s, LEM developed the tnfosmavien Morogemant _ S,skm Cans). tms used an aHesnate model, called the | “Hfewoxchical Data Mader’ . 1970 “Echos Codd’, Soem IGM cuected the Relations Oslo. Model.” Ta 1981 Codd wecefved the’ “Toving usd’ fos ahs comsfbulins +o dalabase theowy. Codd passed ascoy tn Apel scoe 1996. petex chen” pscserled * Grrtty- Relcronship redkl, eohich 35 coidely used Sn detabese design, | 7 BO _Sol. develped, ty Zen, became the “slob | SUEY Long AE” foxx dascbases. Sal Stordaydized by Tso. [9902 ord 1990s. Tem, cuocle, aferbe ord othesS dateleped powestsl DEMS . — a the belowd table “Gencaeeen time | Model Excarples gest (IOs 14105 rele apn ivris CVistoal Meme apie) / VeAri(Vistual Stexcge Access Melted) Hfesouchioal & EMS ( Cofoxeration 1940s teoowk geond re Management System) Mid 30! thesd to ow Relational OBa, Cxocle & e : Sal Sess Md 19805 | Leak -cxeered| 7 Fourth 7 pe chiect -ostenled) — @yacle 103, extended | DBIz. Tet patel ee oo LGenerene? | culos Dx™L; DBR, Oxacle x Dota Models : - ~> Data a medels deine haw -the logical struclsse g a datobase ts modeled. > the undealying stuckwe of the dala & called 08 Dota model. > Data models dene how dyla 5 connected to foch othey and haw they Stored fnsfde the System. ave proressed and ‘ascent avatlable 4) tifesoschica! dala model 8) Netesosk dato medel 5) Relotienal dato eredel. © Bently zelatienal model 1) cbject -csteted woel | the D UBwaechtol 0ate Model “ yee stauckuse™ . > Ti % gust Uke a “ > Lt follows poser! & child selation Sup: [Root cade | = level o [child rode | aay lael a L—_ py. fetid] fed | fe _ =letle child i —> Each poxent Con hw sony ckfldseys lout | CHAS ra only one ponents — &s ee re, ees ed ASSt- romps [asst war Dgenal = level NN ist 4) Cleat ck 8] | =) wd & 3 zt supposts Dela Shoxing ia rt peoudes Qatabase Seuusity- in) Qala Fndependencé peiotwye inegs ty v) zd Sxppost ‘one to mony gelation ship (a:m). ps ad ordogs : #) Compler explementation 4) pifticulk to manage ii) Sbroctoral rx Mi eh chesa’l Suppett * macy +p 8) paxxk Dato redel *- > In tk etc cede, poverts con hove Seva childsenS ond 0 child cor hove ae pasent gecoxds > Recosds oe pryscally linked sigh pomers - > tn Netwesk Datobsie Jeaniedeay a xelationstip % called a set: : > A sel sepecsenlS “ome to ron xebstorship Hw oa posad ond child. t — A nekeosk databases one odoly yeed on o loge diol Corp steos- ron” xelatinship. 1 eteperegpenttaon 2 cemnetionS Gan be mode between oie Reet types oF dota. > the retewouk cocdel 8 cxeated to xepscseat compl dota xelotionships me*e efeectively than the . Hfexoxchical wrodel- : Exr. —— \Teachex4 Pelvartoges*. | a Data -Alecess Pleibility : : Et Syppoxls “many to mori, xelatisnstip « | : TEL SuppostS Database rolgstty: W) srt geppew’s DL & OML Comrands: DiS - Advarckore’s + 8) Stwebvral dependency i) Cearplex. Tenplemendrtitw 38) Et Gepost small Dalaboye J) Relotfonal Cato. eradel == —» The xelational model a Sp (940 so Soleola By EFeaeel —> the most Common data P5 welatisnal medel. ease model. Ris Ceo gst" Rs, weopresemted tthe fax of ue i > Dota > Relation enean8 ‘gable! “ER the data %S xepsesented fp the “Bsn F obles then % PS called os © pelartional mredel’” [stadent reba Student nome Bludert odhess | a zh Noge. | Gort 4 [708 Rodha. ool? 403 | nlandu velop cela wedel (ER enedel) Srbwoduced the ER-wodel Pn 1996. 5 4 > the seaphieal wepsccertation & entities ond thet weloten sips: > ER- wedel uses ER dtogsoms te wepreserd the doin 4) Entity -Relationship > pebes chen” «303 Aaharcog es i _* ®) Vtgual wepwesemiovion rakes Ft a0" prrectfve Communication . ot i) BER eh domain xelational erextel: medel beth dota arg "0 Single data Skauctuse > Fe adds daiobase functTonalty te the chfect oxterted pacgso mention og lorguagss Buch a§ C4H4 & Sen Typ & DSMs Database Nenggenrerd Spfters Con be close based on Sevexal catesia, Sich ©} 4) gased on runbes of uses a) Simle usex &) mult? user ® Gssed on papose 9) Genewal paxpose ©) Spectl poynse ®) BeBel on roms f Ste, %) cerlyalted » Ofststhsled : [ |rumbes of uses > Single Use mul user class’fication R DMS ~ inven p= euspase Ls» Special purpose [ ycenisalized Splem [ » Dist sibuted System soregees , Helongereas L, Hesosehical mectel |, Nlebuosk wedel | > Relatioral medel fo 9 Site Usey Gents - Tn She wee permis, the dolobase ts Saal on Sitgle comple’ and accessed only one ose : a ime. ae TR use 'A’ f usig the database uSe8 B ox’ must colt antl uses A’ fs thscugi b) Mull? Uses DBMS = The ditokage %% Stesal in Single System and accessed by multiple uses Stril Loneous ly. 8) Easel on puapese a) Genedal puspos? DBMS -- . the datokose cchich scutes chta tox gencta puxpese application %p called “Geneval puyaose OBMS- 5 Special pespose DBMS /- The OBMS whith Eon be decked fy a speitts Prepase such of Rafleays ond banky. oxe called Spectal purpose Dens". 2) Cosel on Nurber of Ste - a) Centeal? ged DEMS :- A contaacd dolobise i stosd of a. sigle Roeer Ord 2 1S maintained and medbtied From Pe ene oy ard wscally accessed usin an . * = mlesnet connec iesn Such os LON ad tw. ania: a A Aobsibuled colobose fs basically datobose “pot United to one gyten, 3 difPesedd_ SHES. oa : _5 Tin Homogeneous DBMS, all the dsfrewent diley stove dalabose Sderrtfcally =) the cpescting S,pier, datakas enonoggnend aystern and Lhe dota Styuckwe used ~ all Game oF all Sites. lence, they ase €054, te cranoge: ®) Heleaogeneous DBMS A Helesegeneets agsugbuial dabolonte wsei ditfeseat opescting Systems, DENS ond Asfrexent dato! ode. fence, Abe, axe decemulk to OPS datoknse trot % rot limita) ko oe SyStern, aL ts spcod ond divfexend Sites. : <> a Site 4 | | Shes SP < aa eS | Lo 7 Correrexicstion \ X Nebwile 7 ee a \J grey | i _— ~—= 1S ‘paolo Drlo madeL:- ike a *-txee stuctexe 2 a yh az folios poset & child xelotionthip- _> Bach paserct con hove mony, childyeng but child ay only one poxert - 4 5 PdlocoS © “one to ero * geloordhie- - a = level 0 a Men wees = level 4 ee “vo” \y, aa [ewta | 2 } b) Nekecowk Dala Medel ~ In the network model, childesens ond a child cam hae cory > Recosd ove physically Lfaked ieee pointes 5 Tp Newark Daicbose seamiodleg} a Tae is cale§ a “eet” ~y ft set’ cepacsrty “one to inary), aelotionship retacen@ co posent and a child: FA Nekeexk dotoleoses ase mar sad ijt comptes iy eel on a one & Mee connectons Con be 4 bles dd Revert types of dala. a ——es—éwe °5 just we hove several xcs * cosets can — the netesk —redel ts. cxeated “te 5 > eect ee complex dato. sclobonships ree eepectioely thon the tHesoxchical onodel- [reaches 4 Teacher J reo ches = | Ls —=/ ee ee exe ©) Relatfenal Data Medel :- > the Reloteral Date mmedel ens ‘ntseduced by “BF cad in 1990" > the mxst commen databaye model ox neo Systery ?s welational medel. > Dale’ Ps aepaccaded Yo the Bam of “Relations: > “Relation eneans “lable”. TP the dola Re wepaesend th jhe eam of tably then 4 ts calkd of "Relational medel”. LN [edict a | gulglect & =a, 3 | | 2 a sul rte otdet rane ude Slee 1 Shed | =Pame Student _-Alddyess ' i __Noga ‘& Ld | 1 Gentes 1 Rocha | teal? 4 403 - L Nondus | a ‘ Ran |_Vjogo # 4 4 the Database Monogement astern hoy rumbar PL dvortogs® of Compased +0 eadttional Compares Pile —bosed psccessing appscach: the Moin advantoges of DEMS OC desea They 8 = 2) comzalling Dato Redundancy a) Lmpwoved Shasta, & Dota 3) Dota censfateny 4) Belles dato Fotegeotion 5) Tolgsty, Condixolrts Q Pato Seay A) Bock up and xecovery, procedrses 3) Dada =redependenc€ 9) Lenpscged Decision walling _— ) atncseased end -usex productivity 2 cootealting, Oslo Reduundarey = > “Redundancy” neors Dupltcatien x) Repel > Fin Flot ses 6pstem» the duplteates cpies of the Some dato fe cussed Po crams places lak 99 DBMS the dale ts sccauded Fo only ore pice fo ake database ard YH fs not duplicated. ®) inproved shastog f Ooka = > In DBMS, dala con be Shas by aurthoxtaed uses & Ake cope zation. ° > Tre ctolaje odrinistrolas mamgel we data and Ares welds to usess te occeys zhe data Shed cele? » tion & Are dota. ist to oces te gomamanon S ecuhar edad oncy, the dota Conia, “go Bee appees® ont oe then” 1 hola, -the dotabaye are DEMS oF len aye es the consi —&) Betes Dato Tolegsertion + > Tp Dolabose wanegerred ayster, table. > an Single dolobase certains erulliple tabler and acltion con be cxcated bw sade. “WS coke EoIy to welsfeve ond “uphte cota. dola 28 Stoxed fn 5) negation Constsalnts :- ‘ > Tolegsty “censtecints (os) Cansibtency wiles Can be applied -to delabage Apat the cassect dato can be eckeded fro dolakeye. “7 the cersisainls rox be oppltd to data Term Ath O stole secoxd ox the moy be agelfed +0 weloirehips betazen wecoxdy . @ Dota Seas? | 7 Data is oe vital fpeblance to an exactzatfon oof | mt confidential. Such conPilential data must 4 be accessed by unausthext ged pessors. DBMS PHOS Seensty Be goskaus date ond cpesotiens. tye i | cnethed, 7F oxreunt Tt ?s veer dime conSumtop, of data 7S large > DEMS proufle the kockup the bockup & doto and 3 7 Gockup meons maintaining the duplicate copy , whee af aecovesy means arity she resol State athen o pwcklem occuyted - and recosery Hat provides 1 sae dala FF nequbsed. %) Dato Todependence :- > the sepaxarfon dota Staucuxe F doioloose Prom the appltcation pgm thot sg the dota called dato Fndeperdence: Jn DMs, we can costly chorge are st wockwe & dotcbaye without edifying te application Pee ' » Linpsoved’ Deaiion making -- > Belles moroged dafo and Y%npscved dota acceas make ft possible to genesate toek tex qualtty 2 Basooton on chith betkey cecPstens ane baled. aaa Z = rxre ggnesared depends —> The guolity & on the quality ; > CBMs pare teltes quality date Se thexe Fg, ‘ g esrble. betkex decisé S cliurty - oe ee colored. ith the -teds ge the andeslyrg dala. ony making the availabil? on Posero¥bn, | that ee data tnt usable a“ dechet ‘ : 5 to woke quick dectSiong . eet erd USS , * Connporents & Datobose Manogement System = A colaknse Monogement gysten Coems) hes gevesal Components. They ose 4) Uses 8) Soacaxe - 3) Hosdkwoxe 4) Data 2) USeSS The uses ase the people eho “ramos. he paSckase (Og). Nee a ow BE programmes, plobne "usese,, DeA, - eke. Sophisticated Usexs, Specialiaed USES, and Applicckion upas,-- eke. a) Sophisticated | End USexs Gophisticaled end users Cateract coth the sytem ceithead coving pergtamt, Airey fossr Ques by wasting, GUeSY, In a dodobese gusta languoge - ree axe Sulomitted 42 Guesy paces). w Specoliaed End USEHS * sSpecaliaed end seas eostle ‘geecol ration’ that cee not FE fo ied dolebsse appl to data _ psccesstog Some lle. Application Rowalues, kneaded? tate and expest Sater + Eoytxentnend credeing, gystem SC: Native end Usend »- nlokive End uses Frtesck cotth the sytem Fcokion paogsem 4 using pesmranend agel a) SPtesoxe ane “gpplaose’ means " cellection progam. “To make ‘re dolokose Sgtem ‘vection ally, awe WYP oR S&Ptwose’s O88 ceeded. ) 0-9 Software * “Ce crenages all hoxeeoawe components ond “wok Te posstele ex all owes gStasose'S KO MUN on Lhe computes: Err UNIX, UNDX , WINDS. ©) DBMS aPtanke + LA mowog’s Ae dodobo oRth tn Ake Jakaye Apter. Ex Gal Seaves, ovecle, OGa, MS-Accem , Syoote , OLaMBC'S + - wr on pas mo J ; - 1 to access ord cranipulates ava ™ tt us want he computes E pursenmment fo w . . cces$ and rronipulakion takes place ©) Appltot DBMS oF fm eich data oF i Gul 2 ea D pootknxe ‘ Hoxdaxe we ess dasices. : . EL Computers [miexo cempuers, Mafo fxorres, ccoxk | stolions and sesvesd- |) | * Stowage devite, pointes, netwosk deu7ee (Hubs, seotichey, weuless, Fiber eptics and othex | devices (ATH). : | | | to oll the systen's physical u) Gepicsosen Dota. - A Botaboge * o sepusttony fos dato. edhich % fntegwted Shared and gessrstent. ay aintgpoled Data: when data rom diPFesent scusces, [ke Seposele applications “s) deoxt inerd 93, combfred ato a Sige | © Showed Dato :- I ‘Data’ eaithin o dalakage ayes “don be acceed an utibaed by moltiple usexs > applications Strultoneously . Se ek nls 1 pesssbent Dot Data that is stoxal on a pesmanent Stooge deste and xemoinS ovosleble egen aFleS +he application cx) system % shut dawn. [sees Khe Echero fachieecluse Dolobose = Te ONAN ee (os) 5 Explain obak DegeeeS & Dolo itostaaction 2 Cox) ; Explain cleut Levis & cote abstyactfon? (os) Explain Asi [Spoxk pata ricdel C Amestean Natfenal stondosd rostiete | Standosds, plarnfrg ord Requiserertt Committee she cxwall deccuiption & the aatoease Fe called 0S Patolase scheme Ta Anko oxctvtectose, schema CON une Fleeting B-Leved :- They ose :- 4) Sorexral tel Cx) erysical Level 2) Cencepteal Level (os) Legfeal Level 3) Extesral Level (& View level we deefned of End Usss ed UST SB Ered use, : ype a | --- Neon mo aa wa ~! NN | Sw a . | cerceptucl Schemo. | Lo ntesral ———{~4 ——} Level ‘ann Scher | c_> | Dotaleos LT a Databae Sy thesee Scheme Aschitec eae a A) rateena! Level :- > ‘Intesrol revel 2 abo called a3" physical — > atis leet descdba Per che dela 38 actually 5 in the Stosoge devices > this level % alto yesporsible x allocating got 4o 4he dota. 7 This %5 she lost level GF the axchitechuse- a) Concepreal Leu: Level > Tt % alse called & ” tejeal_ level —> Fe cextibgs what dita Fs Stucd to the datos cl the selationships ameng the cela and cemplere yrew Gf the uses's __ wegeixerenth - > Delabose - conStrahils and Seeustty oxe alte & this level oF axchFeckee. inplemerded % — -this level $8 mato tained ky DGA (Dedoloye Administra 3 Extesnal tewel !- Ne > “Exlesnal level * Balso @ alled a3 * vie tesel > the uses deasn't veel to bras tre debate Schema delabls such af “dato shuckee, ord toble ePinthin.” ele» ° dola hich “4 User °S cencesned about chat yelusred’ back to the v%eo level aftes Pe hag been fetched fern dadoboSe- 7 Tn this way, fe psovids powes fal and Flexfde Secanity erechantom viding the pasts of the datobole fre cestain Uses:

You might also like