欢迎来到天天文库
浏览记录
ID:32433050
大小:1.95 MB
页数:60页
时间:2019-02-04
《galy Postgres查询处理简介》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、QueryProcessing查询处理李元佳2013Postgres全国大会杭州目录SQLStandardQueryProcessingParserAnalysisRewritePlan/OptimizerExecutorSQLasQueryLanguageHigh-leveldeclarative,English-basedlanguagedeclarativelanguage:whatnothowwell-founded/simplesemanticsbasedonrelationalalg
2、ebrasmallsetofwell-understoodoperators,sooptimizerknows:howoperatorscanbeinterchanged/transformedwhatequivalentimplementationsareforeachopConsistentfordifferentfunctionalitiesdatadefinition:e.g.,tablecreation,viewdefinitiondatamanipulation:e.g.,queries,u
3、pdatesUniformfordifferentusagescenariosembeddingfromdifferenthostlanguages(cannedqueries)adhocuserqueriesfromcommandlinesUnexpectedbenefit:StandardizedDBinterface(mid80’s)3HistoryofSQL1970–E.Codddevelopsrelationaldatabaseconcept1974-1979–SystemRwithSeque
4、l(laterSQL)createdatIBMResearchLab1979–OraclemarketsfirstrelationalDBwithSQL1986–ANSISQLstandardreleased1989,1992,1999,2003,2011MajorANSIstandardupdatesCurrent–SQLissupportedbymostmajordatabasevendors4PurposeofSQLStandardSpecifysyntax/semanticsfordatadefi
5、nitionandmanipulationDefinedatastructuresEnableportabilitySpecifyminimal(level1)andcomplete(level2)standardsAllowforlatergrowth/enhancementtostandard5BenefitsofaStandardizedRelationalLanguageReducedtrainingcostsProductivityApplicationportabilityApplica
6、tionlongevityReduceddependenceonasinglevendorCross-systemcommunication6SQLStandard2011Part1:Framework(SQL/Framework)Part2:Foundation(SQL/Foundation)Part3:Call-LevelInterface(SQL/CLI)Part4:PersistentStoredModules(SQL/PSM)Part9:ManagementofExternalData(SQ
7、L/MED)Part10:ObjectLanguageBindings(SQL/OLB)Part11:InformationandDefinitionSchemas(SQL/Schemata)Part13:SQLRoutinesandTypesUsingtheJava™ProgrammingLanguage(SQL/JRT)Part14:XML-RelatedSpecifications(SQL/XML)SQLCatalogAsetofschemasthatconstitutethedescriptio
8、nofadatabaseSchemaThestructurethatcontainsdescriptionsofobjectscreatedbyauser(basetables,views,constraints)DataDefinitionLanguage(DDL)Commandsthatdefineadatabase,includingcreat
此文档下载收益归作者所有