關(guān)系數(shù)據(jù)庫管理系統(tǒng)外文翻譯文獻(xiàn)

關(guān)系數(shù)據(jù)庫管理系統(tǒng)外文翻譯文獻(xiàn)PAGE關(guān)系數(shù)據(jù)庫管理系統(tǒng)外文翻譯文獻(xiàn)(文檔含中英文對照即英文原文和中文翻譯)原文：Access2000RelationalDatabaseMembersoftheOfficefamily,thepeopleofAccess2000understanding,oftenlimitedinitsinterface,forthedatabasemanagementfunctionisstillattheestablishmenttable,dataentry,UseFormguideReportingWizard,DataAccess2000PageWizardandothersimpleapplications.Infact,thefunctionsoftheAccess2000isapowerfulandbeyondyourimagination.ItisreleasedfromMicrosoftAccess2000functionssincemostcomprehensive,WindowsandtheInternetmorecloselywiththedatabasesoftware,isaverypowerful,andsimple,easy-to-usedatabasemanagementsystem(DBMS)thatthedatabasestorage,processingandmanagementsystem.Access2000relationaldatabasemanagementsystemisMicrosoftOfficePublicautomationsoftwareasanintegralpart.Itcaneffectivelyorganize,manageandsharetheinformationinthedatabase,anddatabaseinformationwiththeWebtogether.ThroughtheInternettosharedatabaseinformationwiththebasicplatform.Withthedevelopmentofinformationtechnology.Informationtechnologyplatformisoftenthechoiceofestablishingorre-establishingapplicationsofthekeyissues,thedatabaseispartoftheneedtomakeachoiceasakeyplatform.Access2000asarelationaldatabasemanagementsystemsmallandmedium-sizedinformationmanagementsystemidealdevelopmentenvironment,thecurrentdatabaseinthefield,therearemoreandmorepeopleuse.ItisapowerfuldatabasemanagementsystemMISdevelopmenttools.Thedatabaseisstoredtogetheracollectionofrelevantdata,thedataisstructured.Thedatabaseisadatastorageanddataoperationofthetool.Theroleofthedatabaseistoorganizeandpresentinformation,inshort,thedatabaseisacollectionofinformation.Computerdatabasecanbedividedintotwocategories:non-relationaldatabase(flat-)andrelationaldatabase(relational).Relationaldatabasecontainsanumberofdatatables,databasescontainingvariouspartsoftheterminology,likerecords.Relationaldatabasemanagementsystemhasthetechnologicaldominanceofthemainstream,butthistraditionaldatabasemanagementsystemsbyusingtwo-dimensionaldatamodel,andthereareinherentlimitationsandrestrictions.Itdifficulttoadapttotoday'srapidlychangingbusinessneeds,andthedevelopmentofnewtechnologies.WiththerapidITdevelopment,dataprocessing,notonlyinquantityincreasinglydemanding,butalsothequalityofincreasinglyhighdemand,databasemanagementdatahasbeenafundamentalchange.Thischangetothedatabasetechnologyhasbroughttremendouschallenges,Objectdatabasemanagementisnolongerlimitedtotextdataandothersimpledatatypes.Andthedescriptionandtheneedtopreservealotofcomplexunstructuredmultimediadata,andtherelationshipbetweenthedata.Furthermore,inthewakeofpopularwebsitessurgeinthenumberofvisitstoitsowndatabasestoragemechanism,alargenumberofconcurrentuserstothedemand,storageefficiencyintheuseofspace,anddataintegrityandsecurity,andotheraspectsofhigherdemand.Thesearenottraditionalrelationaldatabase,theuseofasimpletwo-dimensionaltablestructureofthemeet.Access2000istherelationaldatabasedevelopmenttools,databasepoolinginformationfortheinquiry,Storageandretrieval.Access2000theadvantageliesinitsabilitytousedatamaporcustomwindowstocollectinformation.DataprovidesamapsimilartotheExcelspreadsheet,databasetransparent.Inaddition,theAccess2000allowscreationofcustomstatementstoprintorexporttheinformationinthedatabase.Access2000alsoprovidesadatarepository.Canusedesktopdatabasefiletoextendthedatabasefileatthenetworkfileserverandothernetworkuserstosharedatabases?Access2000isarelationaldatabasetools,databasedevelopment,isthemostcommondatabases.Asnotedabove,asanAccess2000databasedevelopmentpossessesmanyadvantages,inadatapacketavailableatthesametimefacilitatethedesktopdatabaseandapowerfulrelationaldatabasefunctions.InAccess2000,withtheuserdatabaseaccesspermissionsaretwotypes:Explicitandimplicitpowersauthority.Explicitauthorityisgrantedadirectuseraccountcompetence,whichistheexclusiveuseofuseraccounts,hasnothingtodowithotherusers.Implicitauthorityisdelegatedtheauthoritygroupaccount,theuseraddedtothegroupwasgivenbythegroup'smandate.Ifauserwiththesametimethesetwopowers,therightsetofusersecuritydatabaseforavisit,thenHehadsuchauthorityistheintersectionofthetwopowers.TheAccess20002000database,thegroupofusers’accesstothedatabaseandtheauthoritysetupwork,completedonlythroughtheadministrator.Setuptheauthorityinclude:"Open/Run",readdesign,designmodifications,management,readdata,updatedatainsertionanddeletionofdata.Relationaldatabasemanagementsysteminherentlimitationsinthefollowingthreeaspects:Relationaldatabaseusedinthetwo-dimensionaltabledatamodel,cannoteffectivelyhandlethemajorityofbusinessapplications,Typicalofmultidimensionaldata.Itsinevitableresultisthatincomplexways,theinteractionofthedramaticincreaseinthenumberoftables,notverygoodbutalsotoproviderealisticsimulationofthedatamodel.Relationaldatabaseastheyusemoredatamodel,whichmightleadtoamassivestoragespaceandwastingalotofincrease,andcausethesystemtorespondtothedecliningperformance.Furthermore,thedatainreality,therearemanytypesofrelationaldatabaseisnotwelladdressed.Staticapplicationssuchasreportgeneration,andthedesignoftherelationaldatabasemanagementsystemafternoresponseandefficientbusinessprocessingfortheoptimizationprocess.Theresultisoftensomerelationaldatabaseproducts,intheGUIandWebServicesprocessing,notachievedthedesiredresults.Unlessadditionalhardwareinvestment,butitdoesnotresolvethefundamentalproblem.Relationswiththetwo-dimensionaldatabasetabledatamodelcandealwiththemajorityofbusinessapplicationofatypicalmulti-dimensionaldata,buttheresultsareoftentheestablishmentanduseofalargeamountofdataforms,itisdifficulttoestablishasimulationofreal-worlddatamodel.Andtheneedfordataoutputstatementswhenthey,inturn,wouldhavedispersedthelargenumberoftwo-dimensionaldatatables.Reuseindexingtechnologylinkingthetableinordertofindallthenecessarydata,this,inturn,isboundtoaffecttheuseoftheresponsespeed.Databasevariousdatabasesiscurrentlythemostimportantandthemostpopulardatabase.Relationaldatabasesystemtosupporttherelationalmodelofdatabasesystems,relationshipsbetweendatamodelstructure,relationsoperationandintegrityconstraintsetiscomposedofthreeparts.OfficeAccess2000istheChineseversionofoneofthecomponents.Access2000tothepreviousversion,theAccess2000isnotonlyamorefriendlyinterface,buttheirfunctionshavealsobeenstrengthened,especiallynetworkfunctionwasimproved,InternetAccess2000sothatitmorecloselyconnected.Access2000isasmallandmedium-sizeddatabasemanagementsystem,easytouse,powerful,andotherdatabaseshaveagoodinterface.Access2000throughpowerfultool,userscanfacilitatetheuseandmanagementofdatabases,suchasthecreationandeditingofdatatables,designandtheuseofvarioustoolsinquiriesqueryoperation,designandtheuseofwindows,productionandprintingstatements,thedesignanduseofAcer,thedesignanduseofsuchWebpages.MayalsobeusedinVisualBasic6.0A(VisualBasic6.0forApplication)AdvancedApplicationDevelopmentprocedures.Access2000isacompletedatabaseapplicationdevelopmenttool,theusercandesign,modify,Viewarecordofthebasicdatatable;inthetabledataforvariousscreenandqueryoperation;designanduseofWindowtoachievedataandoperations;Datatablescandesignvariousprintstatements;designanduseofAcer,aseriesoftablesforspecificoperations.Access2000withastrongoperationalguide,andtoprovideuserswitharichdatabasetablebasictemplate.Usersonlyneedasimpledatabaseoperationscanbeestablishedbyusingthebasicform,Formandstatements.InAccess2000,canbeset,toalterthebasiccorrelationbetweenthetables,thusachievinganumberofrelatedtablesintherelationshipbetweentheinquiries.Access2000-Theoperationcanachieveautomation,theoperatorismoresimpleandefficient.Access2000toenhancethenetworkfunction,userscancompletetheeaseofwebpublication.Access2000cannotonlydealwiththeirowndatabasefiles.Couldalsoaddresssomeotherdatabasemanagementsoftwaresystemestablishedbythedatabasefiles,theabilitytodistinguishBase.FoxBASE,FoxPro,Paradox,databaseformats,suchasdocuments,andsupporttheopendatabaseconnectivitystandard(ODBC)SQL.Access2000withworkstations,serversordatabasesonthemainframedatabaseinterconnectedandcanbeusedforbuildingclient/serverapplicationsoftheworkstation.Andotherrelationaldatabasemanagementsystems,Access2000havethefollowingadvantages:Storagesingledocument.Access2000ofadatabasefilecontainsthedatabaseofalldatatables,query,windows,allstatements,andotherdatamanageable.Supportforlongfilenamesandfilenamecanbeaddedtotheblank,documentseasilycomprehensiblesearch.Powerfulnetworkfunctioncanbetransmittedthroughthenetworkdata.Easytouse,youdonotneedtounderstandtheprogramminglanguagecaneasilydesignanddevelopmentofdatabaseapplications.Canhandleavarietyofdataandinformation,suchastextfilesandotherdatabasesofdocuments.翻譯：Access2000關(guān)系型數(shù)據(jù)庫在Office家族成員中，人們對于Access2000的了解，往往只局限在它的操作界面中，對于數(shù)據(jù)庫管理的功能仍只是停留在建立表、數(shù)據(jù)輸入、使用窗體向?qū)А?bào)表向?qū)А?shù)據(jù)訪問頁向?qū)У纫恍┖唵蔚膽?yīng)用上。其實(shí)Access2000的功能十分強(qiáng)大，且超乎你的想象。它是微軟自公布Access以來功能最全面、與Windows和Internet結(jié)合最緊密的數(shù)據(jù)庫軟件，是一個(gè)功能非常強(qiáng)大，而且簡單易用的數(shù)據(jù)庫管理系統(tǒng)（DBMS），即對數(shù)據(jù)庫進(jìn)行存儲、處理和管理的系統(tǒng)。Access2000關(guān)系型數(shù)據(jù)庫管理系統(tǒng)是Microsoft公司的Office辦公自動化軟件的一個(gè)組成部分。它可以有效地組織、管理和共享數(shù)據(jù)庫的信息，并將數(shù)據(jù)庫信息與Web結(jié)合在一起并通過Internet共享數(shù)據(jù)庫信息提供了基礎(chǔ)平臺。隨著信息技術(shù)的發(fā)展，信息技術(shù)平臺的選擇常常是建立或重新建立應(yīng)用系統(tǒng)時(shí)的關(guān)鍵問題，而數(shù)據(jù)庫正是其中需要做出選擇的關(guān)鍵平臺。Access2000作為一種關(guān)系型數(shù)據(jù)庫管理系統(tǒng)，是中小型信息管理系統(tǒng)的理想開發(fā)環(huán)境，在當(dāng)前數(shù)據(jù)庫領(lǐng)域，已有越來越多的人使用。它是一個(gè)功能強(qiáng)大的數(shù)據(jù)庫管理系統(tǒng)的MIS系統(tǒng)開發(fā)工具。數(shù)據(jù)庫是存儲在一起的相關(guān)數(shù)據(jù)的集合，這些數(shù)據(jù)是結(jié)構(gòu)化的，數(shù)據(jù)庫是一種存儲數(shù)據(jù)并對數(shù)據(jù)進(jìn)行操作的工具。數(shù)據(jù)庫的作用在于組織和表達(dá)信息，簡而言之，數(shù)據(jù)庫就是信息的集合。計(jì)算機(jī)的數(shù)據(jù)庫可以分為兩類：非關(guān)系數(shù)據(jù)庫（flat-file）和關(guān)系數(shù)據(jù)庫（relational）。關(guān)系數(shù)據(jù)庫中包含了多個(gè)數(shù)據(jù)表的信息，數(shù)據(jù)庫含有各個(gè)不同部分的術(shù)語，象記錄等。關(guān)系數(shù)據(jù)庫管理系統(tǒng)曾處于技術(shù)主流而獨(dú)領(lǐng)風(fēng)騷，但是這種傳統(tǒng)的數(shù)據(jù)庫管理系統(tǒng)因采用兩維數(shù)據(jù)模型，而存在著本身固有的約束和限制。難以適應(yīng)當(dāng)今迅速變化的業(yè)務(wù)需求，以及新技術(shù)發(fā)展。隨著信息技術(shù)的飛速發(fā)展，數(shù)據(jù)處理不僅在數(shù)量上要求越來越大，而且在質(zhì)量上也要求越來越高，數(shù)據(jù)庫所管理的數(shù)據(jù)已經(jīng)發(fā)生了根本的變化。這一變化給數(shù)據(jù)庫技術(shù)帶來了巨大挑戰(zhàn)，數(shù)據(jù)庫管理的對象已不再僅限于文本數(shù)據(jù)等簡單的數(shù)據(jù)類型，而需要描述和保存大量多媒體非結(jié)構(gòu)化的復(fù)雜數(shù)據(jù)，以及數(shù)據(jù)間的關(guān)系。此外，隨著熱門網(wǎng)站訪問數(shù)量的激增，對數(shù)據(jù)庫本身的存儲機(jī)制、大量并發(fā)用戶的使用需求、存儲空間的使用效率、以及數(shù)據(jù)的完整性和安全性等方面都提出了更高要求。而這些都不是傳統(tǒng)關(guān)系數(shù)據(jù)庫中，使用二維表簡單結(jié)構(gòu)就可以滿足的。Access2000就是關(guān)系數(shù)據(jù)庫開發(fā)工具，數(shù)據(jù)庫能匯集各種信息以供查詢、存儲和檢索。Access2000的優(yōu)點(diǎn)在于它能使用數(shù)據(jù)表示圖或自定義窗體收集信息。數(shù)據(jù)表示圖提供了一種類似于Excel的電子表格，可以使數(shù)據(jù)庫一目了然。另外，Access2000允許創(chuàng)建自定義報(bào)表用于打印或輸出數(shù)據(jù)庫中的信息。Access2000也提供了數(shù)據(jù)存儲庫，可以使用桌面數(shù)據(jù)庫文件把數(shù)據(jù)庫文件置于網(wǎng)絡(luò)文件服務(wù)器，與其他網(wǎng)絡(luò)用戶共享數(shù)據(jù)庫。Access2000是一種關(guān)系數(shù)據(jù)庫工具，關(guān)系數(shù)據(jù)庫是已開發(fā)的最通用的數(shù)據(jù)庫之一。如上所述，Access2000作為關(guān)系數(shù)據(jù)庫開發(fā)具備了許多優(yōu)點(diǎn)，可以在一個(gè)數(shù)據(jù)包中同時(shí)擁有桌面數(shù)據(jù)庫的便利和關(guān)系數(shù)據(jù)庫的強(qiáng)大功能。

在Access2000中，用戶所具有的數(shù)據(jù)庫訪問權(quán)限有兩種類型：顯式權(quán)限和隱式權(quán)限。顯式權(quán)限是指直接授予某一用戶賬號的權(quán)限，這是該用戶賬號專用的，與其他用戶無關(guān)。隱式權(quán)限是指授予組賬號的權(quán)限，即用戶加入到組中的同時(shí)被賦予的組的權(quán)限。如果一個(gè)用戶同時(shí)具有上述兩種權(quán)限，當(dāng)該用戶對設(shè)置了安全性的數(shù)據(jù)庫進(jìn)行訪問時(shí)，那么，他所具有的權(quán)限就是兩種權(quán)限的交集。在Access數(shù)據(jù)庫中，對組和用戶訪問數(shù)據(jù)庫權(quán)限的設(shè)置工作，只能通過管理員完成。設(shè)置的權(quán)限包括：“打開/運(yùn)行”，讀取設(shè)計(jì)、修改設(shè)計(jì)、管理、讀取數(shù)據(jù)，更新數(shù)據(jù)、插入數(shù)據(jù)和刪除數(shù)據(jù)。關(guān)系型數(shù)據(jù)庫管理系統(tǒng)本身固有的局限性，表現(xiàn)在以下三個(gè)方面：關(guān)系數(shù)據(jù)庫所采用的兩維表數(shù)據(jù)模型，不能有效地處理在大多數(shù)事務(wù)處理應(yīng)用中，典型存在的多維數(shù)據(jù)。其不可避免的結(jié)果是，在復(fù)雜方式下，相互作用表的數(shù)量激增，而且還不能很好地提供模擬現(xiàn)實(shí)數(shù)據(jù)關(guān)系的模型。關(guān)系數(shù)據(jù)庫由于其所用數(shù)據(jù)模型較多，還可能造成存儲空間的海量增加和大量浪費(fèi)，并且會導(dǎo)致系統(tǒng)的響應(yīng)性能不斷下降。而且，在現(xiàn)實(shí)數(shù)據(jù)中，有許多類型是關(guān)系數(shù)據(jù)庫不能較好地處理的。為靜態(tài)應(yīng)用例如報(bào)表生成，而設(shè)計(jì)的關(guān)系型數(shù)據(jù)庫管理系統(tǒng)，并沒有經(jīng)過針對高效事務(wù)處理而進(jìn)行的優(yōu)化過程。其結(jié)果往往是某些關(guān)系型數(shù)據(jù)庫產(chǎn)品，在對GUI和Web的