欢迎来到天天文库
浏览记录
ID:40640242
大小:58.25 KB
页数:9页
时间:2019-08-05
《外文翻译原文及译文V1》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、外文翻译原文及译文学院计算机学院专业计算机科学与技术班级14010105学号2011040101218姓名彭博文指导教师王丹负责教师沈阳航空航天大学2015年6月沈阳航空航天大学毕业设计(论文)外文翻译——译文SQLITEDISTINCTIVEFEATURESThisarticlehighlightssomeofthecharacteristicsofSQLitethatareunusualandwhichmakeSQLitedifferentfrommanyotherSQLdatabaseengines.Zero-
2、ConfigurationSQLitedoesnotneedtobe"installed"beforeitisused.Thereisno"setup"procedure.Thereisnoserverprocessthatneedstobestarted,stopped,orconfigured.Thereisnoneedforanadministratortocreateanewdatabaseinstanceorassignaccesspermissionstousers.SQLiteusesnoconfigu
3、rationfiles.NothingneedstobedonetotellthesystemthatSQLiteisrunning.Noactionsarerequiredtorecoverafterasystemcrashorpowerfailure.Thereisnothingtotroubleshoot.Othermorefamiliardatabaseenginesrungreatonceyougetthemgoing.Butdoingtheinitialinstallationandconfigurati
4、oncanbeintimidatinglycomplex.ServerlessMostSQLdatabaseenginesareimplementedasaseparateserverprocess.Programsthatwanttoaccessthedatabasecommunicatewiththeserverusingsomekindofinterprocesscommunication(typicallyTCP/IP)tosendrequeststotheserverandtoreceivebackresu
5、lts.SQLitedoesnotworkthisway.WithSQLite,theprocessthatwantstoaccessthedatabasereadsandwritesdirectlyfromthedatabasefilesondisk.Thereisnointermediaryserverprocess.Thereareadvantagesanddisadvantagestobeingserverless.Themainadvantageisthatthereisnoseparateserverpr
6、ocesstoinstall,setup,configure,initialize,manage,andtroubleshoot.ThisisonereasonwhySQLiteisa"zero-configuration"databaseengine.ProgramsthatuseSQLiterequirenoadministrativesupportforsettingupthedatabaseenginebeforetheyarerun.Anyprogramthatisabletoaccessthediskis
7、abletouseanSQLitedatabase.Ontheotherhand,adatabaseenginethatusesaservercanprovidebetterprotectionfrombugsintheclientapplication-straypointersinaclientcannotcorruptmemoryontheserver.Andbecauseaserverisasinglepersistentprocess,itisablecontroldatabaseaccesswithmor
8、eprecision,allowingforfinergrainlockingandbetterconcurrency.MostSQLdatabaseenginesareclient/serverbased.Ofthosethatareserverless,SQLiteistheonlyonethatthisauthorknowsofthata
此文档下载收益归作者所有