计算机外文翻译外文文献英文文献数据库系统.docx
- 文档编号:28767915
- 上传时间:2023-07-19
- 格式:DOCX
- 页数:17
- 大小:28.99KB
计算机外文翻译外文文献英文文献数据库系统.docx
《计算机外文翻译外文文献英文文献数据库系统.docx》由会员分享,可在线阅读,更多相关《计算机外文翻译外文文献英文文献数据库系统.docx(17页珍藏版)》请在冰豆网上搜索。
计算机外文翻译外文文献英文文献数据库系统
外文资料原文
DatabaseSystems
1.IntroductiontoDatabaseSystem
Today,morethanatanyprevioustime,thesuccessofanorganizationdependsonitsabilitytoacquireaccurateandtimelydataaboutitsoperation,tomanagethisdataeffectively,andtouseittoanalyzeandguideitsactivities.Phrasessuchastheinformationsuperhighwayhavebecomeubiquitous,andinformationprocessingisarapidlygrowingmultibilliondollarindustry.
Theamountofinformationavailabletousisliterallyexploding,andthevalueofdataasanorganizationalassetisbeingwidelyrecognized.Thisparadoxdrivestheneedforincreasinglypowerfulandflexibledatamanagementsystems.
Adatabaseisacollectionofdata,typicallydescribingtheactivitiesofoneormorerelatedorganizations.Forexample,auniversitydatabasemightcontaininformationaboutthefollowing.
●Entitiessuchasstudents,faculty,courses,andclassrooms.
●Relationshipsbetweenentities,suchasstudents’enrollmentincourses,facultyteachingcourses,andtheuseofroomsforcourses.
Adatabasemanagementsystem,orDBMS,issoftwaredesignedtoassistinmaintainingandutilizinglargecollectionsofdata,andtheneedforsuchsystems,aswellastheiruse,isgrowingrapidly.ThealternativetousingaDBMSistouseadhocapproachesthatdonotcarryoverfromoneapplicationtoanother,forexample,tostorethedatainfilesandwriteapplication-specificcodetomanageit.
Theareaofdatabasemanagementsystemsisamicrocosmofcomputerscienceingeneral.Theissuesaddressedandthetechniquesusedspanawidespectrum,includinglanguages,object-orientationandotherprogrammingparadigms,compilation,operatingsystemsconcurrentprogramming,datastructures,algorithms,theory,parallelanddistributedsystems,userinterfaces,expertsystemsandartificialintelligence,statisticaltechniques,anddynamicprogramming.
Databasemanagementcontinuestogainimportanceasmoreandmoredataisbroughton-line,andmadeevermoreaccessiblethroughcomputernetworking.Todaythefieldisbeingdrivenbyexcitingvisionssuchasmultimediadatabases,interactivevideo,digitallibraries,ahostofscientificprojectssuchasthehumangenomemappingeffortandNASA’sEarthObservationSystemproject,andthedesireofcompaniestoconsolidatetheirdecision-makingprocessesandminetheirdatarepositoriesforusefulinformationabouttheirbusiness.Commercially,databasemanagementsystemsrepresentoneofthelargestandmostvigorousmarketsegments.Thusthestudyofdatabasesystemscouldprovetoberichlyrewardinginmorewaysthanone.
2.Databaseconsists
Adatabaseconsistsofafileorasetoffiles.Theinformationinthesefilesmaybebrokendownintorecords,eachofwhichconsistsofoneormorefields.Fieldsarethebasicunitsofdatastorage,andeachfieldtypicallycontainsinformationpertainingtooneaspectorattributeoftheentitydescribedbythedatabase.Usingkeywordsandvarioussortingcommands,userscanrapidlysearch,rearrange,group,andselectthefieldsinmanyrecordstoretrieveorcreatereportsonparticularaggregatesofdata.
Databaserecordsandfilesmustbeorganizedtoallowretrievaloftheinformation.Earlysystemswerearrangedsequentially(i.e.,alphabetically,numerically,orchronologically);thedevelopmentofdirect-accessstoragedevicesmadepossiblerandomaccesstodataviaindexes.Queriesarethemainwayusersretrievedatabaseinformation.Typically,theuserprovidesastringofcharacters,andthecomputersearchesthedatabaseforacorrespondingsequenceandprovidesthesourcematerialsinwhichthosecharactersappear.Ausercanrequest,forexample,allrecordsinwhichthecontentofthefieldforaperson’slastnameisthewordSmith.
Inflatdatabases,recordsareorganizedaccordingtoasimplelistofentities;manysimpledatabasesforpersonalcomputersareflatinstructure.Therecordsinhierarchicaldatabasesareorganizedinatreelikestructure,witheachlevelofrecordsbranchingoffintoasetofsmallercategories.Unlikehierarchicaldatabases,whichprovidesinglelinksbetweensetsofrecordsatdifferentlevels,networkdatabasescreatemultiplelinkagesbetweensetsbyplacinglinks,orpointers,toonesetofrecordsinanother;thespeedandversatilityofnetworkdatabaseshaveledtotheirwideuseinbusiness.
Relationaldatabasesareusedwhereassociationsamongfilesorrecordscannotbeexpressedbylinks;asimpleflatlistbecomesonetable,or“relation〞,andmultiplerelationscanbemathematicallyassociatedtoyielddesiredinformation.Object-orienteddatabasesstoreandmanipulatemorecomplexdatastructures,called“objects〞,whichareorganizedintohierarchicalclassesthatmayinheritpropertiesfromclasseshigherinthechain;thisdatabasestructureisthemostflexibleandadaptable.
3.StructureoftheRelationaldatabase
Therelationalmodelisthebasisforanyrelationaldatabasemanagementsystem(RDBMS).Arelationalmodelhasthreecorecomponents:
acollectionofobjectsorrelations,operatorsthatactontheobjectsorrelations,anddataintegritymethods.Inotherwords,ithasaplacetostorethedata,awaytocreateandretrievethedata,andawaytomakesurethatthedataislogicallyconsistent.
Arelationaldatabaseusesrelations,ortwo-dimensionaltables,tostoretheinformationneededtosupportabusiness.
3.1.Tables,Row,andColumns
Atableinarelationaldatabase,alternativelyknownasarelation,isatwo-dimensionalstructureusedtoholdrelatedinformation.Adatabaseconsistsofoneormorerelatedtables.
Note:
Don'tconfusearelationwithrelationships.Arelationisessentiallyatable,andarelationshipisawaytocorrelate,join,orassociatetwotables.
Arowinatableisacollectionorinstanceofonething,suchasoneemployeeoronelineitemonaninvoice.Acolumncontainsalltheinformationofasingletype,andthepieceofdataattheintersectionofarowandacolumn,afield,isthesmallestpieceofinformationthatcanberetrievedwiththedatabase'squerylanguage.Forexample,atablewithinformationaboutemployeesmighthaveacolumncalledLAST_NAMEthatcontainsalloftheemployees'lastnames.Dataisretrievedfromatablebyfilteringonboththerowandthecolumn.
3.2.PrimaryKeys,Datatypes,andForeignKeys
Relation:
Atwo-dimensionalstructureusedtoholdrelatedinformation,alsoknownasatable.
Row:
Agroupofoneormoredataelementsinadatabasetablethatdescribesaperson,place,orthing.
Column:
Thecomponentofadatabasetablethatcontainsallofthedataofthesamenameandtypeacrossallrows.
PrimaryKey:
Acolumn(orcolumns)inatablethatmakestherowinthetabledistinguishablefromeveryotherrowinthesametable.
Datatypes:
numericvalues,characteroralphabeticvalues,anddatevalues.
Aforeignkeyenforcestheconceptofreferentialintegrityinarelationaldatabase.
ForeignKey:
Acolumn(orcolumns)inatablethatdrawsitsvaluesfromaprimaryoruniquekeycolumninanothertable.Aforeignkeyassistsinensuringthedataintegrityofatable.ReferentialIntegrityAmethodemployedbyarelationaldatabasesystemthatenforcesone-to-manyrelationshipsbetweentables.
3.3.DataModeling
Inthisprocess,thedeveloperconceptualizesanddocumentsallthetablesforthedatabase.OneofthecommonmethodsformodelingadatabaseiscalledERA,whichstandsforentities,relationships,andattributes.Thedatabasedesignerusesanapplicationthatcanmaintainentities,theirattributes,andtheirrelationships.Ingeneral,anentitycorrespondstoatableinthedatabase,andtheattributesoftheentitycorrespondtocolumnsofthetable.
DataModeling:
Aprocessofdefiningtheentities,attributes,andrelationshipsbetweentheentitiesinpreparationforcreatingthephysicaldatabase.
Thedata-modelingprocessinvolvesdefiningtheentities,definingtherelationshipsbetweenthoseentities,andthendefiningtheattributesforeachoftheentities.Onceacycleiscomplete,itisrepeatedasmanytimesasnecessarytoensurethatthedesigneriscapturingwhatisimportantenoughtogointothedatabase.Let'stakeacloserlookateachstepinthedata-modelingprocess.
3.4.DefiningtheEntities
First,thedesigneridentifiesalloftheentitieswithinthescopeofthedatabaseapplication.
Theentitiesarethepersons,places,orthingsthatareimportanttotheorganizationandneedtobetrackedinthedatabase.Entitieswillmostlikelytranslateneatlytodatabasetables.
3.5.DefiningtheRelationshipsBetweenEntities
Oncetheentitiesaredefined,thedesignercanproceedwithdefininghoweachoftheentitiesisrelated.Often,thedesignerwillpaireachentitywitheveryotherentityandask,"Istherearelationshipbetweenthesetwoentities?
"Somerelationshipsareobvious;somearenot.
Inthewidgetcompanydatabase,thereismostlikelyarelationshipbetweenEMPandDEPT,butdependingonthebusinessrules,itisunlikelythattheDEPTandSALGRADEentitiesarerelated.Ifthebusinessrulesweretorestrictcertainsalarygradestocertaindepartments,therewouldmostlikelybeanewentitythatdefinestherelationshipbetweensalarygradesanddepartments.Thisentitywouldbeknownasanassociativeorintersectiontableandwouldcontainthevalidcombinationsofsalarygradesanddepartments.
AssociativeTable:
Adatabasetablethatstoresthevalidcombinationsofrowsfromtwoothertablesandusuallyenforcesabusinessrule.Anassociativetableresolvesamany-to-manyrelationship.
Ingeneral,therearethreetypesofrelationshipsinarelation
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 计算机 外文 翻译 文献 英文 数据库 系统