版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)
文檔簡(jiǎn)介
關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng)外文翻譯文獻(xiàn)PAGE關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng)外文翻譯文獻(xiàn)(文檔含中英文對(duì)照即英文原文和中文翻譯)原文: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ù)庫(kù)在Office家族成員中,人們對(duì)于Access2000的了解,往往只局限在它的操作界面中,對(duì)于數(shù)據(jù)庫(kù)管理的功能仍只是停留在建立表、數(shù)據(jù)輸入、使用窗體向?qū)?、?bào)表向?qū)А?shù)據(jù)訪問頁(yè)向?qū)У纫恍┖?jiǎn)單的應(yīng)用上。其實(shí)Access2000的功能十分強(qiáng)大,且超乎你的想象。它是微軟自公布Access以來(lái)功能最全面、與Windows和Internet結(jié)合最緊密的數(shù)據(jù)庫(kù)軟件,是一個(gè)功能非常強(qiáng)大,而且簡(jiǎn)單易用的數(shù)據(jù)庫(kù)管理系統(tǒng)(DBMS),即對(duì)數(shù)據(jù)庫(kù)進(jìn)行存儲(chǔ)、處理和管理的系統(tǒng)。Access2000關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)是Microsoft公司的Office辦公自動(dòng)化軟件的一個(gè)組成部分。它可以有效地組織、管理和共享數(shù)據(jù)庫(kù)的信息,并將數(shù)據(jù)庫(kù)信息與Web結(jié)合在一起并通過(guò)Internet共享數(shù)據(jù)庫(kù)信息提供了基礎(chǔ)平臺(tái)。隨著信息技術(shù)的發(fā)展,信息技術(shù)平臺(tái)的選擇常常是建立或重新建立應(yīng)用系統(tǒng)時(shí)的關(guān)鍵問題,而數(shù)據(jù)庫(kù)正是其中需要做出選擇的關(guān)鍵平臺(tái)。Access2000作為一種關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng),是中小型信息管理系統(tǒng)的理想開發(fā)環(huán)境,在當(dāng)前數(shù)據(jù)庫(kù)領(lǐng)域,已有越來(lái)越多的人使用。它是一個(gè)功能強(qiáng)大的數(shù)據(jù)庫(kù)管理系統(tǒng)的MIS系統(tǒng)開發(fā)工具。數(shù)據(jù)庫(kù)是存儲(chǔ)在一起的相關(guān)數(shù)據(jù)的集合,這些數(shù)據(jù)是結(jié)構(gòu)化的,數(shù)據(jù)庫(kù)是一種存儲(chǔ)數(shù)據(jù)并對(duì)數(shù)據(jù)進(jìn)行操作的工具。數(shù)據(jù)庫(kù)的作用在于組織和表達(dá)信息,簡(jiǎn)而言之,數(shù)據(jù)庫(kù)就是信息的集合。計(jì)算機(jī)的數(shù)據(jù)庫(kù)可以分為兩類:非關(guān)系數(shù)據(jù)庫(kù)(flat-file)和關(guān)系數(shù)據(jù)庫(kù)(relational)。關(guān)系數(shù)據(jù)庫(kù)中包含了多個(gè)數(shù)據(jù)表的信息,數(shù)據(jù)庫(kù)含有各個(gè)不同部分的術(shù)語(yǔ),象記錄等。關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng)曾處于技術(shù)主流而獨(dú)領(lǐng)風(fēng)騷,但是這種傳統(tǒng)的數(shù)據(jù)庫(kù)管理系統(tǒng)因采用兩維數(shù)據(jù)模型,而存在著本身固有的約束和限制。難以適應(yīng)當(dāng)今迅速變化的業(yè)務(wù)需求,以及新技術(shù)發(fā)展。隨著信息技術(shù)的飛速發(fā)展,數(shù)據(jù)處理不僅在數(shù)量上要求越來(lái)越大,而且在質(zhì)量上也要求越來(lái)越高,數(shù)據(jù)庫(kù)所管理的數(shù)據(jù)已經(jīng)發(fā)生了根本的變化。這一變化給數(shù)據(jù)庫(kù)技術(shù)帶來(lái)了巨大挑戰(zhàn),數(shù)據(jù)庫(kù)管理的對(duì)象已不再僅限于文本數(shù)據(jù)等簡(jiǎn)單的數(shù)據(jù)類型,而需要描述和保存大量多媒體非結(jié)構(gòu)化的復(fù)雜數(shù)據(jù),以及數(shù)據(jù)間的關(guān)系。此外,隨著熱門網(wǎng)站訪問數(shù)量的激增,對(duì)數(shù)據(jù)庫(kù)本身的存儲(chǔ)機(jī)制、大量并發(fā)用戶的使用需求、存儲(chǔ)空間的使用效率、以及數(shù)據(jù)的完整性和安全性等方面都提出了更高要求。而這些都不是傳統(tǒng)關(guān)系數(shù)據(jù)庫(kù)中,使用二維表簡(jiǎn)單結(jié)構(gòu)就可以滿足的。Access2000就是關(guān)系數(shù)據(jù)庫(kù)開發(fā)工具,數(shù)據(jù)庫(kù)能匯集各種信息以供查詢、存儲(chǔ)和檢索。Access2000的優(yōu)點(diǎn)在于它能使用數(shù)據(jù)表示圖或自定義窗體收集信息。數(shù)據(jù)表示圖提供了一種類似于Excel的電子表格,可以使數(shù)據(jù)庫(kù)一目了然。另外,Access2000允許創(chuàng)建自定義報(bào)表用于打印或輸出數(shù)據(jù)庫(kù)中的信息。Access2000也提供了數(shù)據(jù)存儲(chǔ)庫(kù),可以使用桌面數(shù)據(jù)庫(kù)文件把數(shù)據(jù)庫(kù)文件置于網(wǎng)絡(luò)文件服務(wù)器,與其他網(wǎng)絡(luò)用戶共享數(shù)據(jù)庫(kù)。Access2000是一種關(guān)系數(shù)據(jù)庫(kù)工具,關(guān)系數(shù)據(jù)庫(kù)是已開發(fā)的最通用的數(shù)據(jù)庫(kù)之一。如上所述,Access2000作為關(guān)系數(shù)據(jù)庫(kù)開發(fā)具備了許多優(yōu)點(diǎn),可以在一個(gè)數(shù)據(jù)包中同時(shí)擁有桌面數(shù)據(jù)庫(kù)的便利和關(guān)系數(shù)據(jù)庫(kù)的強(qiáng)大功能。
在Access2000中,用戶所具有的數(shù)據(jù)庫(kù)訪問權(quán)限有兩種類型:顯式權(quán)限和隱式權(quán)限。顯式權(quán)限是指直接授予某一用戶賬號(hào)的權(quán)限,這是該用戶賬號(hào)專用的,與其他用戶無(wú)關(guān)。隱式權(quán)限是指授予組賬號(hào)的權(quán)限,即用戶加入到組中的同時(shí)被賦予的組的權(quán)限。如果一個(gè)用戶同時(shí)具有上述兩種權(quán)限,當(dāng)該用戶對(duì)設(shè)置了安全性的數(shù)據(jù)庫(kù)進(jìn)行訪問時(shí),那么,他所具有的權(quán)限就是兩種權(quán)限的交集。在Access數(shù)據(jù)庫(kù)中,對(duì)組和用戶訪問數(shù)據(jù)庫(kù)權(quán)限的設(shè)置工作,只能通過(guò)管理員完成。設(shè)置的權(quán)限包括:“打開/運(yùn)行”,讀取設(shè)計(jì)、修改設(shè)計(jì)、管理、讀取數(shù)據(jù),更新數(shù)據(jù)、插入數(shù)據(jù)和刪除數(shù)據(jù)。關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)本身固有的局限性,表現(xiàn)在以下三個(gè)方面:關(guān)系數(shù)據(jù)庫(kù)所采用的兩維表數(shù)據(jù)模型,不能有效地處理在大多數(shù)事務(wù)處理應(yīng)用中,典型存在的多維數(shù)據(jù)。其不可避免的結(jié)果是,在復(fù)雜方式下,相互作用表的數(shù)量激增,而且還不能很好地提供模擬現(xiàn)實(shí)數(shù)據(jù)關(guān)系的模型。關(guān)系數(shù)據(jù)庫(kù)由于其所用數(shù)據(jù)模型較多,還可能造成存儲(chǔ)空間的海量增加和大量浪費(fèi),并且會(huì)導(dǎo)致系統(tǒng)的響應(yīng)性能不斷下降。而且,在現(xiàn)實(shí)數(shù)據(jù)中,有許多類型是關(guān)系數(shù)據(jù)庫(kù)不能較好地處理的。為靜態(tài)應(yīng)用例如報(bào)表生成,而設(shè)計(jì)的關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng),并沒有經(jīng)過(guò)針對(duì)高效事務(wù)處理而進(jìn)行的優(yōu)化過(guò)程。其結(jié)果往往是某些關(guān)系型數(shù)據(jù)庫(kù)產(chǎn)品,在對(duì)GUI和Web的
溫馨提示
- 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
- 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
- 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 2024年中國(guó)污水處理劑市場(chǎng)調(diào)查研究報(bào)告
- 2024年版權(quán)購(gòu)買合同:圖書出版與發(fā)行權(quán)轉(zhuǎn)讓
- 2024年度建筑外立面LED顯示屏安裝合同3篇
- 2024版產(chǎn)權(quán)式商鋪?zhàn)赓U與營(yíng)銷推廣合作協(xié)議3篇
- 2024年機(jī)械采購(gòu)協(xié)議模板版A版
- 2024年汽車抵押擔(dān)保糾紛處理合同3篇
- 臨沂大學(xué)《軟件工程綜合項(xiàng)目設(shè)計(jì)》2023-2024學(xué)年第一學(xué)期期末試卷
- 2024版城市綜合體物業(yè)管理與商業(yè)租賃合同3篇
- 臨夏現(xiàn)代職業(yè)學(xué)院《水處理新技術(shù)》2023-2024學(xué)年第一學(xué)期期末試卷
- 2024版婚內(nèi)財(cái)產(chǎn)約定書范本2篇
- 心理健康與大學(xué)生活學(xué)習(xí)通超星期末考試答案章節(jié)答案2024年
- 借款協(xié)議(父母借款給子女買房協(xié)議)(二篇)
- 國(guó)家開放大學(xué)電大本科《工程經(jīng)濟(jì)與管理》2023-2024期末試題及答案(試卷代號(hào):1141)
- 歌唱語(yǔ)音智慧樹知到期末考試答案章節(jié)答案2024年齊魯師范學(xué)院
- 國(guó)開(甘肅)2024年春《地域文化(專)》形考任務(wù)1-4終考答案
- MOOC 美在民間-南京農(nóng)業(yè)大學(xué) 中國(guó)大學(xué)慕課答案
- 國(guó)家開放大學(xué)《Python語(yǔ)言基礎(chǔ)》實(shí)驗(yàn)1:Python 基礎(chǔ)環(huán)境熟悉參考答案
- 《中國(guó)心力衰竭診斷和治療指南2024》解讀
- 中國(guó)馬克思主義與當(dāng)代課后習(xí)題答案
- 蹲踞式跳遠(yuǎn)教學(xué)課件
- 智能系統(tǒng)工程自評(píng)報(bào)告
評(píng)論
0/150
提交評(píng)論