已阅读5页,还剩1页未读, 继续免费阅读
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
DatabaseFundamentalsIntroductiontoDBMSAdatabasemanagementsystem(DBMS)isanimportanttypeofprogrammingsystem,usedtodayonthebiggestandthesmallestcomputers.Asforothermajorformsofsystemsoftware,suchascompilersandoperatingsystems,awell-understoodsetofprinciplesfordatabasemanagementsystemshasdevelopedovertheyears,andtheseconceptsareusefulbothforunderstandinghowtousethesesystemseffectivelyandfordesigningandimplementingDBMSs.DBMSisacollectionofprogramsthatenablesyoutostore,modify,andextractinformationfromadatabase.TherearemanydifferenttypesofDBMSs,rangingfromsmallsystemsthatrunonpersonalcomputerstohugesystemsthatrunonmainframes.Therearetwoqualitiesthatdistinguishdatabasemanagementsystemsfromothersortsofprogrammingsystems.1)Theabilitytomanagepersistentdata,and2)Theabilitytoaccesslargeamountsofdataefficiently.Point1)merelystatesthatthereisadatabasewhichexistspermanently;thecontentofthisdatabaseisthedatathataDBMSaccessesandmanages.Point2)distinguishesaDBMSfromafilesystem,whichalsomanagespersistentdata.ADBMSscapabilitiesareneededmostwhentheamountofdataisverylarge,becauseforsmallamountsofdata,simpleaccesstechniques,suchaslinearscansofthedata,areusuallyadequate.WhileweregardtheabovetwopropertiesofaDBMSasfundamental,thereareanumberofothercapabilitiesthatarealmostuniversallyfoundincommercialDBMSs.Theseare:(1)Supportforatleastonedatamodel,ormathematicalabstractionthroughwhichtheusercanviewthedata.(2)Supportforcertainhigh-levellanguagesthatallowtheusertodefinethestructureofdata,accessdata,andmanipulatedata.(3)Transactionmanagement,thecapabilitytoprovidecorrect,concurrentaccesstothedatabasebymanyusersatonce.(4)Accesscontrol,theabilitytolimitaccesstodatabyunauthorizedusers,andtheabilitytocheckthevalidityofdata.(5)Resiliency,theabilitytorecoverfromsystemfailureswithoutlosingdata.DataModelsEachDBMSprovidesatleastoneabstractmodelofdatathatallowstheusertoseeinformationnotasrawbits,butinmoreunderstandableterms.Infact,itisusuallypossibletoseedataatseverallevelsofabstraction.Atarelativelylowlevel,aDBMScommonlyallowsustovisualizedataascomposedoffiles.EfficientFileAccessTheabilitytostoreafileisnotremarkable:thefilesystemassociatedwithanyoperatingsystemdoesthat.ThecapabilityofaDBMSisseenwhenweaccessthedataofafile.Forexample,supposewewishtofindthemanagerofemployeeClarkKent.Ifthecompanyhasthousandsofemployees,ItisveryexpensivetosearchtheentirefiletofindtheonewithNAME=ClarkKent.ADBMShelpsustosetupindexfiles,orindices,thatallowustoaccesstherecordforClarkKentinessentiallyonestrokenomatterhowlargethefileis.Likewise,insertionofnewrecordsordeletionofoldonescanbeaccomplishedintimethatissmallandessentiallyconstant,independentofthefilelength.AnotherthingaDBMShelpsusdoisnavigateamongfiles,thatis,tocombinevaluesintwoormorefilestoobtaintheinformationwewant.QueryLanguagesTomakeaccesstofileseasier,aDBMSprovidesaquerylanguage,ordatamanipulationlanguage,toexpressoperationsonfiles.Querylanguagesdifferinthelevelofdetailtheyrequireoftheuser,withsystemsbasedontherelationaldatamodelgenerallyrequiringlessdetailthanlanguagesbasedonothermodels.TransactionManagementAnotherimportantcapabilityofaDBMSistheabilitytomanagesimultaneouslylargenumbersoftransactions,whichareproceduresoperatingonthedatabase.Somedatabasesaresolargethattheycanonlybeusefuliftheyareoperateduponsimultaneouslybymanycomputers:oftenthesecomputersaredispersedaroundthecountryortheworld.Thedatabasesystemsusebybanks,accessedalmostinstantaneouslybyhundredsorthousandsofautomatedtellermachines(ATM),aswellasbyanequalorgreaternumberofemployeesinthebankbranches,istypicalofthissortofdatabase.Anairlinereservationsystemisanothergoodexample.Sometimes,twoaccessesdonotinterferewitheachother.Forexample,anynumberoftransactionscanbereadingyourbankbalanceatthesametime,withoutanyinconsistency.Butifyouareinthebankdepositingyoursalarycheckattheexactinstantyourspouseisextractingmoneyfromanautomaticteller,theresultofthetwotransactionsoccurringsimultaneouslyandwithoutcoordinationisunpredictable.Thus,transactionsthatmodifyadataitemmust“lockout”othertransactionstryingtoreadorwritethatitematthesametime.ADBMSmustthereforeprovidesomeformofconcurrencycontroltopreventuncoordinatedaccesstothesamedataitembymorethanonetransaction.Evenmorecomplexproblemsoccurwhenthedatabaseisdistributedovermanydifferentcomputersystems,perhapswithduplicationofdatatoallowbothfasterlocalaccessandtoprotectagainstthedestructionofdataifonecomputercrashes.SecurityofDataADBMSmustnotonlyprotectagainstlossofdatawhencrashesoccur,aswejustmentioned,butitmustpreventunauthorizedaccess.Forexample,onlyuserswithacertainclearanceshouldhaveaccesstothesalaryfieldofanemployeefile,andtheDBMSmustbeableassociatewiththevarioususerstheirprivilegestoseefiles,fieldswithinfiles,orothersubsetsofthedatainthedatabase.ThusaDBMSmustmaintainatabletellingforeachuserknowntoit,whataccessprivilegestheuserhasforeachobject.Forexample,oneusermaybeallowedtoreadafile,butnottoinsertordeletedata;anothermaynotbeallowedtoseethefileatall,whileathirdmaybeallowedtoreadormodifythefileatwill.DBMSTypesDesignersdevelopedthreedifferenttypesofdatabasestructures:hierarchical,network,andrelational.Hierarchicalandnetworkwerefirstdevelopedbutrelationalhasbecomedominant.Whiletherelationaldesignisdominant,theolderdatabaseshavenotbeendropped.CompaniesthatinstalledahierarchicalsystemsuchasIMSinthe1970swillbeusingandmaintainingthesedatabasesforyearstocomeeventhoughnewdevelopmentisbeingdoneonrelationalsystems.Theseoldersystemsareoftenreferredtoaslegacysystems.数据库基础DBMS简介数据库管理系统是编程系统中的重要的一种,现今可以用在最大的以及最小的电脑上。其他主要形式的系统软件,比如说汇编以及操作系统,近些年来开发出一系列容易理解的数据库管理系统原则,并且这些概念既有助于理解如何有效利用系统,又可以帮助设计和执行DBMS系统。DBMS是一个程序的集合,它使你能够存储、修改以及从数据库中提取信息。有很多种不同类型的DBMS系统,从运行在个人电脑上的小型系统到运行在大型主机上的巨型系统。DBMS的功能有两种功能使数据库管理系统区别于其他设计系统:1)管理固有数据的能力,以及2)高效访问大量数据的能力。第一点只是表明现有一个固定存在的数据库;而这个数据库的内容也就是DBMS所要访问和管
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2024年工业有机废气净化设备项目资金筹措计划书代可行性研究报告
- 2024届青海省西宁市高三上学期期末联考数学试题(理)(解析版)
- 2022-2023学年山西省长治市高一下学期期中数学试题(解析版)
- 公共卫生保健服务方案
- 供求与价格-均衡价格的定义及应用(经济学理论课件)
- 为上司把好发文与政策关(办公室管理课件)
- 分裂样和分裂型人格障碍
- 二年级数学上册教案-4.1乘法的初步认识32-人教版
- 美业美容医疗开业活动品质生活服务暖场策划方案
- 常识高分专项课-中国的帝王将相10
- 2023年09月云南招生考试服务中心公开招聘人员(7人)笔试历年高频考点试题含答案带详解
- 电梯使用单位安全风险日管控、周排查、月调度管理制度
- 江森楼宇自控系统培训资料课件
- 感动中国十大人物顾方舟事迹ppt(思修课堂展示or爱国主题演讲)
- 小学综合实践活动-《神奇的指纹》教学设计学情分析教材分析课后反思
- 读书分享读书交流会《昆虫记》目录课件
- 2023动力锂离子电池运输安全技术规范
- 304不锈钢水槽施工方案
- Zippo年度机系列(更新至C23)
- 华能集团全员绩效考核指导意见
- 工业下的智能制造系统优化与应用
评论
0/150
提交评论