软件工程专业毕业设计外文文献翻译.docx
- 文档编号:23515425
- 上传时间:2023-05-17
- 格式:DOCX
- 页数:16
- 大小:47.42KB
软件工程专业毕业设计外文文献翻译.docx
《软件工程专业毕业设计外文文献翻译.docx》由会员分享,可在线阅读,更多相关《软件工程专业毕业设计外文文献翻译.docx(16页珍藏版)》请在冰豆网上搜索。
软件工程专业毕业设计外文文献翻译
本科毕业设计外文文献翻译
(
英文题目:
SoftwareDatabaseAnObject-OrientedPerspective.
中文题目:
软件数据库的面向对象的视角
学生姓名:
宋兰兰
学院:
信息工程学院
系别:
软件工程系
专业:
软件工程
班级:
软件09-1
指导教师:
关玉欣讲师
二〇一三年六月
AHISTORICALPERSPECTIVE
Fromtheearliestdaysofcomputers,storingandmanipulatingdatahavebeenamajorapplicationfocus.Thefirstgeneral-purposeDBMSwasdesignedbyCharlesBachmanatGeneralElectricintheearly1960sandwascalledtheIntegratedDataStore.Itformedthebasisforthenetworkdatamodel,whichwasstandardizedbytheConferenceonDataSystemsLanguages(CODASYL)andstronglyinfluenceddatabasesystemsthroughthe1960s.BachmanwasthefirstrecipientofACM’sTuringAward(thecomputerscienceequivalentofaNobelprize)forworkinthedatabasearea;hereceivedtheawardin1973.Inthelate1960s,IBMdevelopedtheInformationManagementSystem(IMS)DBMS,usedeventodayinmanymajorinstallations.IMSformedthebasisforanalternativedatarepresentationframeworkcalledthehierarchicaldatamodel.TheSABREsystemformakingairlinereservationswasjointlydevelopedbyAmericanAirlinesandIBMaroundthesametime,anditallowedseveralpeopletoaccessthesamedatathroughcomputernetwork.Interestingly,todaythesameSABREsystemisusedtopowerpopularWeb-basedtravelservicessuchasTravelocity!
In1970,EdgarCodd,atIBM’sSanJoseResearchLaboratory,proposedanewdatarepresentationframeworkcalledtherelationaldatamodel.Thisprovedtobeawatershedinthedevelopmentofdatabasesystems:
itsparkedrapiddevelopmentofseveralDBMSsbasedontherelationalmodel,alongwitharichbodyoftheoreticalresultsthatplacedthefieldonafirmfoundation.Coddwonthe1981TuringAwardforhisseminalwork.Databasesystemsmaturedasanacademicdiscipline,andthepopularityofrelationalDBMSschangedthecommerciallandscape.Theirbenefitswerewidelyrecognized,andtheuseofDBMSsformanagingcorporatedatabecamestandardpractice.
Inthe1980s,therelationalmodelconsolidateditspositionasthedominantDBMSparadigm,anddatabasesystemscontinuedtogainwidespreaduse.TheSQLquerylanguageforrelationaldatabases,developedaspartofIBM’sSystemRproject,isnowthestandardquerylanguage.SQLwasstandardizedinthelate1980s,andthecurrentstandard,SQL-92,wasadoptedbytheAmericanNationalStandardsInstitute(ANSI)andInternationalStandardsOrganization(ISO).Arguably,themostwidelyusedformofconcurrentprogrammingistheconcurrentexecutionofdatabaseprograms(calledtransactions).Userswriteprogramsasiftheyaretoberunbythemselves,andtheresponsibilityforrunningthemconcurrentlyisgiventotheDBMS.JamesGraywonthe1999TuringawardforhiscontributionstothefieldoftransactionmanagementinaDBMS.
Inthelate1980sandthe1990s,advanceshavebeenmadeinmanyareasofdatabasesystems.Considerableresearchhasbeencarriedoutintomorepowerfulquerylanguagesandricherdatamodels,andtherehasbeenabigemphasisonsupportingcomplexanalysisofdatafromallpartsofanenterprise.Severalvendors(e.g.,IBM’sDB2,Oracle8,InformixUDS)haveextendedtheirsystemswiththeabilitytostorenewdatatypessuchasimagesandtext,andwiththeabilitytoaskmorecomplexqueries.Specializedsystemshavebeendevelopedbynumerousvendorsforcreatingdatawarehouses,consolidatingdatafromseveraldatabases,andforcarryingoutspecializedanalysis.
Aninterestingphenomenonistheemergenceofseveralenterpriseresourceplanning(ERP)andmanagementresourceplanning(MRP)packages,whichaddasubstantiallayerofapplication-orientedfeaturesontopofaDBMS.WidelyusedpackagesincludesystemsfromBaan,Oracle,PeopleSoft,SAP,andSiebel.Thesepackagesidentifyasetofcommontasks(e.g.,inventorymanagement,humanresourcesplanning,financialanalysis)encounteredbyalargenumberoforganizationsandprovideageneralapplicationlayertocarryoutthesetasks.ThedataisstoredinarelationalDBMS,andtheapplicationlayercanbecustomizedtodifferentcompanies,leadingtolowerIntroductiontoDatabaseSystemsoverallcostsforthecompanies,comparedtothecostofbuildingtheapplicationlayerfromscratch.Mostsignificantly,perhaps,DBMSshaveenteredtheInternetAge.WhilethefirstgenerationofWebsitesstoredtheirdataexclusivelyinoperatingsystemsfiles,theuseofaDBMStostoredatathatisaccessedthroughaWebbrowserisbecomingwidespread.QueriesaregeneratedthroughWeb-accessibleformsandanswersareformattedusingamarkuplanguagesuchasHTML,inordertobeeasilydisplayedinabrowser.AllthedatabasevendorsareaddingfeaturestotheirDBMSaimedatmakingitmoresuitablefordeploymentovertheInternet.Databasemanagementcontinuestogainimportanceasmoreandmoredataisbroughton-line,andmadeevermoreaccessiblethroughcomputernetworking.Todaythefieldisbeingdrivenbyexcitingvisionssuchasmultimediadatabases,interactivevideo,digitallibraries,ahostofscientificprojectssuchasthehumangenomemappingeffortandNASA’sEarthObservationSystemproject,andthedesireofcompaniestoconsolidatetheirdecision-makingprocessesandminetheirdatarepositoriesforusefulinformationabouttheirbusinesses.Commercially,databasemanage-mentsystemsrepresentoneofthelargestandmostvigorousmarketsegments.Thusthes-tudyofdatabasesystemscouldprovetoberichlyrewardinginmorewaysthanone!
INTRODUCTIONTOPHYSICALDATABASEDESIGN
Likeallotheraspectsofdatabasedesign,physicaldesignmustbeguidedbythenatureofthedataanditsintendeduse.Inparticular,itisimportanttounderstandthetypicalworkloadthatthedatabasemustsupport;theworkloadconsistsofamixofqueriesandupdates.Usersalsohavecertainrequirementsabouthowfastcertainqueriesorupdatesmustrunorhowmanytransactionsmustbeprocessedpersecond.Theworkloaddescriptionandusers’performancerequirementsarethebasisonwhichanumberofdecisionshavetobemadeduringphysicaldatabasedesign.
Tocreateagoodphysicaldatabasedesignandtotunethesystemforperformanceinresponsetoevolvinguserrequirements,thedesignerneedstounderstandtheworkingsofaDBMS,especiallytheindexingandqueryprocessingtechniquessupportedbytheDBMS.Ifthedatabaseisexpectedtobeaccessedconcurrentlybymanyusers,orisadistributeddatabase,thetaskbecomesmorecomplicated,andotherfeaturesofaDBMScomeintoplay.
DATABASEWORKLOADS
Thekeytogoodphysicaldesignisarrivingatanaccuratedescriptionoftheexpectedworkload.Aworkloaddescriptionincludesthefollowingelements:
1.Alistofqueriesandtheirfrequencies,asafractionofallqueriesandupdates.
2.Alistofupdatesandtheirfrequencies.
3.Performancegoalsforeachtypeofqueryandupdate.
Foreachqueryintheworkload,wemustidentify:
Whichrelationsareaccessed.
Whichattributesareretained(intheSELECTclause).
Whichattributeshaveselectionorjoinconditionsexpressedonthem(intheWHEREclause)andhowselectivetheseconditionsarelikelytobe.Similarly,foreachupdateintheworkload,wemustidentify:
Whichattributeshaveselectionorjoinconditionsexpressedonthem(intheWHEREclause)andhowselectivetheseconditionsarelikelytobe.
Thetypeofupdate(INSERT,DELETE,orUPDATE)andtheupdatedrelation.
ForUPDATEcommands,thefieldsthataremodifiedbytheupdate.
Rememberthatqueriesandupdatestypicallyhaveparameters,forexample,adebitorcreditoperationinvolvesaparticularaccountnumber.Thevaluesoftheseparametersdetermineselectivityofselectionandjoinconditions.
Updateshaveaquerycomponentthatisusedtofindthetargettuples.Thiscomponentcanbenefitfromagoodphysicaldesignandthepresenceofindexes.Ontheotherhand,updatestypicallyrequireadditionalworktomaintainindexesontheattributesthattheymodify.Thus,whilequeriescanonlybenefitfromthepresenceofanindex,anindexmayeitherspeeduporslowdownagivenupdate.Designersshouldkeepthistrade-offerinmindwhencreatingindexes.
NEEDFORDATABASETUNING
Accurate,detailedworkloadinformationmaybehardtocomebywhiledoingtheinitialdesignofthesystem.Consequently,tuningadatabaseafterithasbeendesignedanddeployedisimportant—wemustrefinetheinitialdesigninthelightofactualusagepatternstoobtainthebestpossibleperformance.
Thedistinctionbetweendatabasedesignanddatabasetuningissomewhatarbitrary.
Wecouldconsiderthedesignprocesstobeoveronceaninitialconceptualschemaisdesignedandasetofindexingandclusteringdecisionsismade.Anysubsequentchangestotheconceptualschemaortheindexes,say,wouldthenberegardedasatuningactivity.Alternatively,wecouldconsidersomerefinementoftheconceptualschema(andphysicaldesigndecisionsaffectedbythisrefinement)tobepartofthephysicaldesignprocess.
Wherewedrawthelinebetweendesignandtuningisnotveryimportant.
OVERVIEWOFDATABASETUNING
Aftertheinitialphaseofdatabasedesign,actualuseofthedatabaseprovidesavaluablesourceofdetailedinformationthatcanbeusedtorefinetheinitialdesign.Manyoftheoriginalassumptionsabouttheexpectedworkloadcanbereplacedbyobservedusagepatterns;ingeneral,someoftheinitialworkloadspecificationwillbevalidated,andsomeofitwillturnouttobewrong.Initialguessesaboutthesizeofdatacanbereplacedwithactualstatisticsfromthesystemcatalogs(althoughthisinformationwillkeepchangingasthesystemevolves).Carefulmonitoringofqueriescanrevealunexpectedproblems;
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 软件工程 专业 毕业设计 外文 文献 翻译
![提示](https://static.bdocx.com/images/bang_tan.gif)