数据库中英文对照外文翻译文献.docx
- 文档编号:28171858
- 上传时间:2023-07-09
- 格式:DOCX
- 页数:14
- 大小:26.74KB
数据库中英文对照外文翻译文献.docx
《数据库中英文对照外文翻译文献.docx》由会员分享,可在线阅读,更多相关《数据库中英文对照外文翻译文献.docx(14页珍藏版)》请在冰豆网上搜索。
数据库中英文对照外文翻译文献
中英文对照外文翻译
DatabaseManagementSystems
Adatabase(sometimesspelleddatabase)isalsocalledanelectronicdatabase,referringtoanycollectionofdata,orinformation,thatisspeciallyorganizedforrapidsearchandretrievalbyacomputer.Databasesarestructuredtofacilitatethestorage,retrieval,modification,anddeletionofdatainconjunctionwithvariousdata-processingoperations.Databasescanbestoredonmagneticdiskortape,opticaldisk,orsomeothersecondarystoragedevice.
Adatabaseconsistsofafileorasetoffiles.Theinformationinthesefilesmaybebrokendownintorecords,eachofwhichconsistsofoneormorefields.Fieldsarethebasicunitsofdatastorage,andeachfieldtypicallycontainsinformationpertainingtooneaspectorattributeoftheentitydescribedbythedatabase.Usingkeywordsandvarioussortingcommands,userscanrapidlysearch,rearrange,group,andselectthefieldsinmanyrecordstoretrieveorcreatereportsonparticularaggregateofdata.
Complexdatarelationshipsandlinkagesmaybefoundinallbutthesimplestdatabases.Thesystemsoftwarepackagethathandlesthedifficulttasksassociatedwithcreating,accessing,andmaintainingdatabaserecordsiscalledadatabasemanagementsystem(DBMS).TheprogramsinaDBMSpackageestablishaninterfacebetweenthedatabaseitselfandtheusersofthedatabase..(Theseusersmaybeapplicationsprogrammers,managersandotherswithinformationneeds,andvariousOSprograms.)
ADBMScanorganize,process,andpresentselecteddataelementsformthedatabase.Thiscapabilityenablesdecisionmakerstosearch,probe,andquerydatabasecontentsinordertoextractanswerstononrecurringandunplannedquestionsthataren’tavailableinregularreports.Thesequestionsmightinitiallybevagueand/orpoorlydefined,butpeoplecan“browse”throughthedatabaseuntiltheyhavetheneededinformation.Inshort,theDBMSwill“manage”thestoreddataitemsandassembletheneededitemsfromthecommondatabaseinresponsetothequeriesofthosewhoaren’tprogrammers.
Adatabasemanagementsystem(DBMS)iscomposedofthreemajorparts:
(1)astoragesubsystemthatstoresandretrievesdatainfiles;
(2)amodelingandmanipulationsubsystemthatprovidesthemeanswithwhichtoorganizethedataandtoadd,delete,maintain,andupdatethedata;(3)andaninterfacebetweentheDBMSanditsusers.Severalmajortrendsareemergingthatenhancethevalueandusefulnessofdatabasemanagementsystems;
Managers:
whorequiremoreup-to-datainformationtomakeeffectivedecision
Customers:
whodemandincreasinglysophisticatedinformationservicesandmorecurrentinformationaboutthestatusoftheirorders,invoices,andaccounts.
Users:
whofindthattheycandevelopcustomapplicationswithdatabasesystemsinafractionofthetimeittakestousetraditionalprogramminglanguages.
Organizations:
thatdiscoverinformationhasastrategicvalue;theyutilizetheirdatabasesystemstogainanedgeovertheircompetitors.
TheDatabaseModel
Adatamodeldescribesawaytostructureandmanipulatethedatainadatabase.Thestructuralpartofthemodelspecifieshowdatashouldberepresented(suchastree,tables,andsoon).Themanipulativepartofthemodelspecifiestheoperationwithwhichtoadd,delete,display,maintain,print,search,select,sortandupdatethedata.
HierarchicalModel
Thefirstdatabasemanagementsystemsusedahierarchicalmodel-thatis-theyarrangedrecordsintoatreestructure.Somerecordsarerootrecordsandallothershaveuniqueparentrecords.Thestructureofthetreeisdesignedtoreflecttheorderinwhichthedatawillbeusedthatis,therecordattherootofatreewillbeaccessedfirst,thenrecordsonelevelbelowtheroot,andsoon.
Thehierarchicalmodelwasdevelopedbecausehierarchicalrelationshipsarecommonlyfoundinbusinessapplications.Asyouhaveknown,anorganizationcharoftendescribesahierarchicalrelationship:
topmanagementisatthehighestlevel,middlemanagementatlowerlevels,andoperationalemployeesatthelowestlevels.Notethatwithinastricthierarchy,eachlevelofmanagementmayhavemanyemployeesorlevelsofemployeesbeneathit,buteachemployeehasonlyonemanager.Hierarchicaldataarecharacterizedbythisone-to-manyrelationshipamongdata.
Inthehierarchicalapproach,eachrelationshipmustbeexplicitlydefinedwhenthedatabaseiscreated.Eachrecordinahierarchicaldatabasecancontainonlyonekeyfieldandonlyonerelationshipisallowedbetweenanytwofields.Thiscancreateaproblembecausedatadonotalwaysconformtosuchastricthierarchy.
RelationalModel
Amajorbreakthroughindatabaseresearchoccurredin1970whenE.F.Coddproposedafundamentallydifferentapproachtodatabasemanagementcalledrelationalmodel,whichusesatableasitsdatastructure.
Therelationaldatabaseisthemostwidelyuseddatabasestructure.Dataisorganizedintorelatedtables.Eachtableismadeupofrowscalledandcolumnscalledfields.Eachrecordcontainsfieldsofdataaboutsomespecificitem.Forexample,inatablecontaininginformationonemployees,arecordwouldcontainfieldsofdatasuchasaperson’slastname,firstname,andstreetaddress.
Structuredquerylanguage(SQL)isaquerylanguageformanipulatingdatainarelationaldatabase.Itisnonproceduralordeclarative,inwhichtheuserneedonlyspecifyanEnglish-likedescriptionthatspecifiestheoperationandthedescribedrecordorcombinationofrecords.Aqueryoptimizertranslatesthedescriptionintoaproceduretoperformthedatabasemanipulation.
NetworkModel
Thenetworkmodelcreatesrelationshipsamongdatathroughalinked-liststructureinwhichsubordinaterecordscanbelinkedtomorethanoneparentrecord.Thisapproachcombinesrecordswithlinks,whicharecalledpointers.Thepointersareaddressesthatindicatethelocationofarecord.Withthenetworkapproach,asubordinaterecordcanbelinkedtoakeyrecordandatthesametimeitselfbeakeyrecordlinkedtoothersetsofsubordinaterecords.Thenetworkmodehistoricallyhashadaperformanceadvantageoverotherdatabasemodels.Today,suchperformancecharacteristicsareonlyimportantinhigh-volume,high-speedtransactionprocessingsuchasautomatictellermachinenetworksorairlinereservationsystem.
Bothhierarchicalandnetworkdatabasesareapplicationspecific.Ifanewapplicationisdeveloped,maintainingtheconsistencyofdatabasesindifferentapplicationscanbeverydifficult.Forexample,supposeanewpensionapplicationisdeveloped.Thedataarethesame,butanewdatabasemustbecreated.
ObjectModel
Thenewestapproachtodatabasemanagementusesanobjectmodel,inwhichrecordsarerepresentedbyentitiescalledobjectsthatcanbothstoredataandprovidemethodsorprocedurestoperformspecifictasks.
Thequerylanguageusedfortheobjectmodelisthesameobject-orientedprogramminglanguageusedtodevelopthedatabaseapplication.Thiscancreateproblemsbecausethereisnosimple,uniformquerylanguagesuchasSQL.Theobjectmodelisrelativelynew,andonlyafewexamplesofobject-orienteddatabaseexist.Ithasattractedattentionbecausedeveloperswhochooseanobject-orientedprogramminglanguagewantadatabasebasedonanobject-orientedmodel.
DistributedDatabase
Similarly,adistributeddatabaseisoneinwhichdifferentpartsofthedatabaseresideonphysicallyseparatedcomputers.Onegoalofdistributeddatabasesistheaccessofinformationwithoutregardtowherethedatamightbestored.Keepinginmindthatoncetheusersandtheirdataareseparated,thecommunicationandnetworkingconceptscomeintoplay.
Distributeddatabasesrequiresoftwarethatresidespartiallyinthelargercomputer.Thissoftwarebridgesthegapbetweenpersonalandlargecomputersandresolvestheproblemsofincompatibledataformats.Ideally,itwouldmakethemainframedatabasesappeartobelargelibrariesofinformation,withmostoftheprocessingaccomplishedonthepersonalcomputer.
Adrawbacktosomedistributedsystemsisthattheyareoftenbasedonwhatiscalledamainframe-entiremodel,inwhichthelargerhostcomputerisseenasthemasterandtheterminalorpersonalcomputerisseenasaslave.Therearesomeadvantagestothisapproach.Withdatabasesundercentralizedcontrol,manyoftheproblemsofdataintegritythatwementionedearlieraresolved.Buttoday’spersonalcomputers,departmentalcomputers,anddistributedprocessingrequirecomputersandtheirapplicationstocommunicatewitheachotheronamoreequalorpeer-to-peerbasis.Inadatabase,theclient/servermodelprovidestheframeworkfordistributingdatabases.
Onewaytotakeadvantageofmanyconnectedcomputersrunningdatabaseapplicationsistodistributetheapplicationintocooperatingpartsthatareindependentofoneanther.Aclientisanenduserorcomputerprogramthatrequestsresourcesacrossanetwork.Aserverisacomputerrunningsoftwarethatfulfillsthoserequestsacrossanetwork.Whentheresourcesaredatainadatabase,theclient/servermodelprovidestheframeworkfordistributingdatabase.
Afileserveissoftwarethatprovidesaccesstofilesacrossanetwork.Adedicatedfileserverisasinglecomputerdedicatedtobeingafileserver.Thisisuseful,forexample,ifthefilesarelargeandrequirefastaccess.Insuchcases,aminicomputerormainframewouldbeusedasafileserver.Adistributedfileserverspreadsthefilesaroundonindividualcomputersinsteadofplacingthemononededicatedcomputer.
Advantagesofthelatterserverincludetheabilitytostoreandretrievefilesonothercomputersandthe
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据库 中英文 对照 外文 翻译 文献