數(shù)據(jù)庫引擎SQL編譯器的研究.pdf

1、武漢理工大學碩士學位論文數(shù)據(jù)庫引擎SQL編譯器的研究姓名：鄒輝申請學位級別：碩士專業(yè)：計算機科學與技術指導教師：楊克儉20100501AbstractInmeworldproducea1弼e鋤ouIltofinfo冊ationeVe巧day，sotospreadinformationworldwidewithavaritetyofwaySAsa11indiVidualorbusinesswillbeeXposedto鋤ountsofda

2、tainf0鋤ation，thedatabaseisa11essentialtoolwhlchdatabasemaIlagementsyst鋤re脅edtoasDBMSisthecoreofthesyst鉍，tlleIltomanagea11dmanipulatethesedataItcannotonlyeIlsurethesafety鋤dinte嘶tyofthedatabase，butalsoacomprehensivedat；lba

3、setomanipulateandmaJlageDBMScallprovidethelon哥temstorage，pro黟鋤mingint曲ces，transacnonmaIlagemeIltDatabaseen西neisessentialforimplenlentthe劬ctioIl，itisusedforstorage，processing觚dprotectionofdataincoreservicesIIlthismesis，as

4、malldatabaSemanag鋤entsystemSQLlanguagepre—compllerconstlllctioncStablishinthe、斬ndowsenvir0舯entFirstbe百n矗omcompilertheoⅨincludingknowledge，tothelexicaJallalyzersaIldpars％andfinallycodegelleratlonandoptimization，thecompila

5、tionandprocessingoftheSQLlanguageindctailh1thesvst鋤theSQL1anguageisstalldardlaIlguage，itisahi曲一leVelnon’proceduralpro黟amminglallgIlage，usersc甌useitinthehi曲leVelwork，wouldno‘haVedevelopedmedatabaseStoragemethods，butalsodo

6、notund耐鋤dthespecmcstOragewayThisth商sdesc曲edthevariousstagesofthecompilationprocess柚drelatedknowledge，including：regularexpressions，finiteautomata，conteXt。缸優(yōu)鏟卸mars，LALR(1)g陽mmarandsoon1’11enonmemainstageaIldmecompilatlonpr

7、ocesstobuildmesysl【觚sapproachasthebaSisforadetaileddes謝ption，includingtlleuseofLEXa11dYACCtooltogenerateleXicalanalyzersa11dpars％andgiVesth鋤theSQLlallguagecompilerdeVicetoa幽eVeaspecific印plicationprocessSQLpre。compilerand

8、nlenbuildonthemethodsaIldrelatedtecllll010酉esmadeadetailedroutedesc^ptionSQLprecompilerofthewholeideaistoinitiallybuildagenerationtoolLExleXicalaIlalyz％and也enbymeYACC酉鋤marparsergenerationtoolstobuildoutnlese伽opans弱the矗on