關系數據庫管理系統外文翻譯文獻PAGE關系數據庫管理系統外文翻譯文獻(文檔含中英文對照即英文原文和中文翻譯)原文：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關系型數據庫在Office家族成員中，人們對于Access2000的了解，往往只局限在它的操作界面中，對于數據庫管理的功能仍只是停留在建立表、數據輸入、使用窗體向導、報表向導、數據訪問頁向導等一些簡單的應用上。其實Access2000的功能十分強大，且超乎你的想象。它是微軟自公布Access以來功能最全面、與Windows和Internet結合最緊密的數據庫軟件，是一個功能非常強大，而且簡單易用的數據庫管理系統（DBMS），即對數據庫進行存儲、處理和管理的系統。Access2000關系型數據庫管理系統是Microsoft公司的Office辦公自動化軟件的一個組成部分。它可以有效地組織、管理和共享數據庫的信息，并將數據庫信息與Web結合在一起并通過Internet共享數據庫信息提供了基礎平臺。隨著信息技術的發展，信息技術平臺的選擇常常是建立或重新建立應用系統時的關鍵問題，而數據庫正是其中需要做出選擇的關鍵平臺。Access2000作為一種關系型數據庫管理系統，是中小型信息管理系統的理想開發環境，在當前數據庫領域，已有越來越多的人使用。它是一個功能強大的數據庫管理系統的MIS系統開發工具。數據庫是存儲在一起的相關數據的集合，這些數據是結構化的，數據庫是一種存儲數據并對數據進行操作的工具。數據庫的作用在于組織和表達信息，簡而言之，數據庫就是信息的集合。計算機的數據庫可以分為兩類：非關系數據庫（flat-file）和關系數據庫（relational）。關系數據庫中包含了多個數據表的信息，數據庫含有各個不同部分的術語，象記錄等。關系數據庫管理系統曾處于技術主流而獨領風騷，但是這種傳統的數據庫管理系統因采用兩維數據模型，而存在著本身固有的約束和限制。難以適應當今迅速變化的業務需求，以及新技術發展。隨著信息技術的飛速發展，數據處理不僅在數量上要求越來越大，而且在質量上也要求越來越高，數據庫所管理的數據已經發生了根本的變化。這一變化給數據庫技術帶來了巨大挑戰，數據庫管理的對象已不再僅限于文本數據等簡單的數據類型，而需要描述和保存大量多媒體非結構化的復雜數據，以及數據間的關系。此外，隨著熱門網站訪問數量的激增，對數據庫本身的存儲機制、大量并發用戶的使用需求、存儲空間的使用效率、以及數據的完整性和安全性等方面都提出了更高要求。而這些都不是傳統關系數據庫中，使用二維表簡單結構就可以滿足的。Access2000就是關系數據庫開發工具，數據庫能匯集各種信息以供查詢、存儲和檢索。Access2000的優點在于它能使用數據表示圖或自定義窗體收集信息。數據表示圖提供了一種類似于Excel的電子表格，可以使數據庫一目了然。另外，Access2000允許創建自定義報表用于打印或輸出數據庫中的信息。Access2000也提供了數據存儲庫，可以使用桌面數據庫文件把數據庫文件置于網絡文件服務器，與其他網絡用戶共享數據庫。Access2000是一種關系數據庫工具，關系數據庫是已開發的最通用的數據庫之一。如上所述，Access2000作為關系數據庫開發具備了許多優點，可以在一個數據包中同時擁有桌面數據庫的便利和關系數據庫的強大功能。

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