e13954sql挂起
sql挂起 时间:2021-04-05 阅读:()
XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
1SQL,XQuery,andSPARQLWhat'sWrongWithThisPictureXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
2JimMelton,OracleCorp.
Editor:allpartsofSQLstandardEditor:XQueryF&O,XQueryXCo-chair:W3CXMLQueryWGAuthor:5SQLbooks,forthcoming"QueryingXML"fromMorganKaufmannXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
3QueryLanguages:SQL(SQLQueryLanguage)Alanguageforqueryingcollectionsoftuples:SELECTSALARY,HIRE_DATEFROMEMPSWHEREEMP_ID=13954EMP_IDNAMEHIRE_DATESALARY13954Joe2000-04-144800010335Mary1998-11-2352000…………04182Bob2005-02-1021750XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
4QueryLanguages:XQuery(XMLQuery)AlanguageforqueryingtreesofXDMnodes:for$eindocument(my_employees.
xml)where$emp/emp/@emp-id=13954return$emp/emp/salaryemp-id=13954Joe2000-04-1448000.
.
.
.
.
.
.
.
.
XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
5CrossingDataModelBoundariesSQL/XMLEMP_IDNAMEHIRE_DATESALARY13954Joe2000-04-144800010335Mary1998-11-2352000…………04182Bob2005-02-1021750PublishingFunctionsXMLTableemp-id=13954Joe2000-04-1448000.
.
.
.
.
.
.
.
.
XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
6RDF:CollectionsofTuples(ResourceDescriptionFramework)3-tuples:subject,predicate,objectemps:e13954HR:name'Joe'emps:e13954HR:hire-date2000-04-14emps:e13954HR:salary48000RDFinatable:TrivialSQLstatement:SELECTobjectFROMRDFtableWHEREsubject="emps:e13954"SubjectPredicateObjectemps:e13954HR:name'Joe'emps:e13954HR:hire-date2000-04-14emps:e13954HR:salary48000XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
7RDF:NotQuiteThatSimpleRDFcanindicatemembershipinclasses(emps:e13954rdf:typeHR:employee)RDFprefixesareshorthandforfullURIsRDFisagraphdatamodelHR:empemps:e13954emps:e10335dept:salesrdf:typerdf:typeHR:supervisesHR:managesHR:worksInHR:emprdf:typeXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
8OWL(WebOntologyLanguage)AparticularvocabularyofRDFRepresentsmeaningsoftermsandrelationshipsbetweenterms:anontologyOWLaddstoRDF:–Relationsbetweenclasses–Cardinality–Equality–Moretypingofandcharacteristicsofproperties–EnumeratedclassesXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
9RDFvsTheRelationalModelRelational–Flat,tabular,implicittyping(columndefinition)–Joinsusedtocombineinformationfromtables–Foreignkeys:semanticsandgraph-likestructure–Eachtable:manycolumns=manyattributesofobjectRDF–Maybeviewedasflat;explicittypingcommon–Explicitrelationshipsviapredicates–Inherentgraphstructureviolates"flatness"–TriplesformE-Rmodel(similartoatablew/2columns)XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
10RDFvsXDMXDM–Tree-structuredplussequencesofitems–Nosupportforexplicitrelationships(references)–Notuples,notlimitedbytuplesRDF–Networkofobjects;moregeneralthantrees–Relationships/referencesarethepointofRDF–TriplenaturecreatesplethoraoftinydataXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
11QueryLanguages:SPARQL(SPARQLProtocolAndRDFQueryLanguage)Designedtoquerycollectionsoftriples……andtoeasilytraverserelationshipsVaguelySQL-likesyntax(SELECT,WHERE)"Matchesgraphpatterns"SELECTsalWHERE{emps:e13954HR:salarysal.
}XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
12SPARQLvsSQLSPARQLSELECTsalWHERE{emps:e13954HR:salarysal.
}SQLSELECTsalaryFROMemployeesWHEREemp_id='e13954'XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
13SPARQLvsSQLSPARQLSELECTid,salWHERE{idHR:salarysal}SQLSELECTemp_id,salaryFROMemployeesXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
14SPARQLvsSQLSPARQLSELECThdateWHERE{idHR:salarysal.
idHR:hire_datehdate.
FILTERsal>=21750}SQLSELECThire_dateFROMemployeesWHEREsalary>=21750XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
15SPARQLvsSQLSPARQLSELECThdateWHERE{idHR:salarysal.
idHR:hire_datehdate.
FILTERsal>=21750}SQLSELECTv.
hire_dateFROMemp_varsASv,emp_constsAScWHEREv.
salary>=21750ANDv.
emp_id=c.
emp_idXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
16ConclusionsSQL:Greatforfindingdatafromtabularrepresentations,cangetcomplexwhenmanytablesareinvolvedinagivenqueryXQuery:Greatforfindingdataintreerepresentations,cangetcomplexwhenmanyrelationshipshavetobetraversedSPARQL:Goodpatternmatchingparadigm,especiallywhenrelationshipshavetobeusedtoansweraquerySurprisingconclusion:SPARQLcanbetranslatedtoSQLandpossiblytoXQuery!
XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
17*,**"0&)10&)1/0&)'1"+'#23*45'#0&126'*'#6'4"70&),1"0&&1#''$&('"8$66$,9$*:96"#/0&@@1&0&(1"%"7*,*'F&(0&&(1"F&5H&(#$#"I'**2*''4"*6J$',0&)!
'*1I+HKH+;(HH$#,'I2#4'-9570&7)1''*'*''"H*-2'4.
'##L.
9'97;I=I;7I"2)'4I'#*"DEFCGF@@A#>#/*"6249$'9H$6#6''9$#6'#62#/4.
*9*'"J2/4.
'99**''**";'0&12'*#'$#4"$*$9*90&),*1+*'69,*'9MC2/4-,*2$CA@@@"@@4.
'*)*2*4-2CEDA)@G)CA4.
"-0&)1.
F&2424&(2/4"+**+**8$'24.
"7,*9#9*#F;0&),*1'*&"DEFCGF@@A#>#/!
"#24>#-0&*)#10&*)#1.
&('-0&*)'10&*)'1.
0&)''1.
24*0&*)#10&*)#1*'$"I0&*)'10&*)'1*'$",!
-+"/+0"()1"/23"/+3//-+',/4"4+!
546/3',/4"4+3,!
-+"/+3"/+//-+3//-+',/4"4+3',/4"4+3,!
-+,!
-'#78#+"/+/,16"'"3"/+H(7HH+#C@A#///-+8$.
%%%%3//-+',/4"4+/24"(3',/4"4+3,!
-+3,!
-+',/4"4+',/4"4'#7$546/#+/"/(5#$%.
#3+3',/4"4+',/4"4/"/(5##3+3',/4"4+',/4"4'#*9#24"(#+/"/(5#$%.
#3+3',/4"4+3',/4"4++&,*>5!
:"5";'!
&:'"5";'!
&C@A#>*F'PC@A#>*F'PC@A@@@"@@*>C@A#>*F'P**>C*>E#>*F'P**>E#>*F'PECA@@"@@*>E#>*F'P**>NF'P""""""*>C#>*F'PADEFCGF@@A#>#/7&4//-61C'B;,!
-3&!
0"A''B;',/4"43&!
0"A/"/(D***2*'4'/9**#9#'''"'',*6''"5'24*7'''6*''#$6#6**'L.
6*,*'6'"56**$6*5!
'#6'61'*"+6*>C#>*F'P*>C@A*>C#>*F'P(/*>N#>*F'P*>C@AF'P""""""GDEFCGF@@A#>#/''#/'"'#'"QR!
"!
"#QRQ'R!
"#Q!
'*RQ,RQ&R$Q@@R;7F;H!
E@DA>7::@@"Q(R$Q&(R;7F;H!
E@DA)CO>0$%"7Q7R12"21""DDEFCGF@@A#>#/
1SQL,XQuery,andSPARQLWhat'sWrongWithThisPictureXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
2JimMelton,OracleCorp.
Editor:allpartsofSQLstandardEditor:XQueryF&O,XQueryXCo-chair:W3CXMLQueryWGAuthor:5SQLbooks,forthcoming"QueryingXML"fromMorganKaufmannXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
3QueryLanguages:SQL(SQLQueryLanguage)Alanguageforqueryingcollectionsoftuples:SELECTSALARY,HIRE_DATEFROMEMPSWHEREEMP_ID=13954EMP_IDNAMEHIRE_DATESALARY13954Joe2000-04-144800010335Mary1998-11-2352000…………04182Bob2005-02-1021750XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
4QueryLanguages:XQuery(XMLQuery)AlanguageforqueryingtreesofXDMnodes:for$eindocument(my_employees.
xml)where$emp/emp/@emp-id=13954return$emp/emp/salaryemp-id=13954Joe2000-04-1448000.
.
.
.
.
.
.
.
.
XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
5CrossingDataModelBoundariesSQL/XMLEMP_IDNAMEHIRE_DATESALARY13954Joe2000-04-144800010335Mary1998-11-2352000…………04182Bob2005-02-1021750PublishingFunctionsXMLTableemp-id=13954Joe2000-04-1448000.
.
.
.
.
.
.
.
.
XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
6RDF:CollectionsofTuples(ResourceDescriptionFramework)3-tuples:subject,predicate,objectemps:e13954HR:name'Joe'emps:e13954HR:hire-date2000-04-14emps:e13954HR:salary48000RDFinatable:TrivialSQLstatement:SELECTobjectFROMRDFtableWHEREsubject="emps:e13954"SubjectPredicateObjectemps:e13954HR:name'Joe'emps:e13954HR:hire-date2000-04-14emps:e13954HR:salary48000XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
7RDF:NotQuiteThatSimpleRDFcanindicatemembershipinclasses(emps:e13954rdf:typeHR:employee)RDFprefixesareshorthandforfullURIsRDFisagraphdatamodelHR:empemps:e13954emps:e10335dept:salesrdf:typerdf:typeHR:supervisesHR:managesHR:worksInHR:emprdf:typeXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
8OWL(WebOntologyLanguage)AparticularvocabularyofRDFRepresentsmeaningsoftermsandrelationshipsbetweenterms:anontologyOWLaddstoRDF:–Relationsbetweenclasses–Cardinality–Equality–Moretypingofandcharacteristicsofproperties–EnumeratedclassesXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
9RDFvsTheRelationalModelRelational–Flat,tabular,implicittyping(columndefinition)–Joinsusedtocombineinformationfromtables–Foreignkeys:semanticsandgraph-likestructure–Eachtable:manycolumns=manyattributesofobjectRDF–Maybeviewedasflat;explicittypingcommon–Explicitrelationshipsviapredicates–Inherentgraphstructureviolates"flatness"–TriplesformE-Rmodel(similartoatablew/2columns)XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
10RDFvsXDMXDM–Tree-structuredplussequencesofitems–Nosupportforexplicitrelationships(references)–Notuples,notlimitedbytuplesRDF–Networkofobjects;moregeneralthantrees–Relationships/referencesarethepointofRDF–TriplenaturecreatesplethoraoftinydataXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
11QueryLanguages:SPARQL(SPARQLProtocolAndRDFQueryLanguage)Designedtoquerycollectionsoftriples……andtoeasilytraverserelationshipsVaguelySQL-likesyntax(SELECT,WHERE)"Matchesgraphpatterns"SELECTsalWHERE{emps:e13954HR:salarysal.
}XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
12SPARQLvsSQLSPARQLSELECTsalWHERE{emps:e13954HR:salarysal.
}SQLSELECTsalaryFROMemployeesWHEREemp_id='e13954'XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
13SPARQLvsSQLSPARQLSELECTid,salWHERE{idHR:salarysal}SQLSELECTemp_id,salaryFROMemployeesXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
14SPARQLvsSQLSPARQLSELECThdateWHERE{idHR:salarysal.
idHR:hire_datehdate.
FILTERsal>=21750}SQLSELECThire_dateFROMemployeesWHEREsalary>=21750XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
15SPARQLvsSQLSPARQLSELECThdateWHERE{idHR:salarysal.
idHR:hire_datehdate.
FILTERsal>=21750}SQLSELECTv.
hire_dateFROMemp_varsASv,emp_constsAScWHEREv.
salary>=21750ANDv.
emp_id=c.
emp_idXQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
16ConclusionsSQL:Greatforfindingdatafromtabularrepresentations,cangetcomplexwhenmanytablesareinvolvedinagivenqueryXQuery:Greatforfindingdataintreerepresentations,cangetcomplexwhenmanyrelationshipshavetobetraversedSPARQL:Goodpatternmatchingparadigm,especiallywhenrelationshipshavetobeusedtoansweraquerySurprisingconclusion:SPARQLcanbetranslatedtoSQLandpossiblytoXQuery!
XQuerySPARQLSQL2005-11-16Copyright2005OracleCorp.
17*,**"0&)10&)1/0&)'1"+'#23*45'#0&126'*'#6'4"70&),1"0&&1#''$&('"8$66$,9$*:96"#/0&@@1&0&(1"%"7*,*'F&(0&&(1"F&5H&(#$#"I'**2*''4"*6J$',0&)!
'*1I+HKH+;(HH$#,'I2#4'-9570&7)1''*'*''"H*-2'4.
'##L.
9'97;I=I;7I"2)'4I'#*"DEFCGF@@A#>#/*"6249$'9H$6#6''9$#6'#62#/4.
*9*'"J2/4.
'99**''**";'0&12'*#'$#4"$*$9*90&),*1+*'69,*'9MC2/4-,*2$CA@@@"@@4.
'*)*2*4-2CEDA)@G)CA4.
"-0&)1.
F&2424&(2/4"+**+**8$'24.
"7,*9#9*#F;0&),*1'*&"DEFCGF@@A#>#/!
"#24>#-0&*)#10&*)#1.
&('-0&*)'10&*)'1.
0&)''1.
24*0&*)#10&*)#1*'$"I0&*)'10&*)'1*'$",!
-+"/+0"()1"/23"/+3//-+',/4"4+!
546/3',/4"4+3,!
-+"/+3"/+//-+3//-+',/4"4+3',/4"4+3,!
-+,!
-'#78#+"/+/,16"'"3"/+H(7HH+#C@A#///-+8$.
%%%%3//-+',/4"4+/24"(3',/4"4+3,!
-+3,!
-+',/4"4+',/4"4'#7$546/#+/"/(5#$%.
#3+3',/4"4+',/4"4/"/(5##3+3',/4"4+',/4"4'#*9#24"(#+/"/(5#$%.
#3+3',/4"4+3',/4"4++&,*>5!
:"5";'!
&:'"5";'!
&C@A#>*F'PC@A#>*F'PC@A@@@"@@*>C@A#>*F'P**>C*>E#>*F'P**>E#>*F'PECA@@"@@*>E#>*F'P**>NF'P""""""*>C#>*F'PADEFCGF@@A#>#/7&4//-61C'B;,!
-3&!
0"A''B;',/4"43&!
0"A/"/(D***2*'4'/9**#9#'''"'',*6''"5'24*7'''6*''#$6#6**'L.
6*,*'6'"56**$6*5!
'#6'61'*"+6*>C#>*F'P*>C@A*>C#>*F'P(/*>N#>*F'P*>C@AF'P""""""GDEFCGF@@A#>#/''#/'"'#'"QR!
"!
"#QRQ'R!
"#Q!
'*RQ,RQ&R$Q@@R;7F;H!
E@DA>7::@@"Q(R$Q&(R;7F;H!
E@DA)CO>0$%"7Q7R12"21""DDEFCGF@@A#>#/
cloudcone：特价便宜VPS补货通知贴,SAS或SSD低价有磁盘阵列，SAS或SSD raid10 硬盘
cloudcone经常性有特价促销VPS放出来，每次的数量都是相当有限的，为了方便、及时帮助大家，主机测评这里就做这个cloudcone特价VPS补货专题吧，以后每次放货我会在这里更新一下日期，方便大家秒杀！官方网站：https://cloudcone.com/预交费模式，需要充值之后方可使用，系统自动扣费！信用卡、PayPal、支付宝，均可付款购买！为什么说cloudcone值得买？cloudc...
Tudcloud(月付7.2美元),香港VPS,可选大带宽或不限流量
Tudcloud是一家新开的主机商，提供VPS和独立服务器租用，数据中心在中国香港(VPS和独立服务器)和美国洛杉矶(独立服务器)，商家VPS基于KVM架构，开设在香港机房，可以选择限制流量大带宽或者限制带宽不限流量套餐。目前提供8折优惠码，优惠后最低每月7.2美元起。虽然主机商网站为英文界面，但是支付方式仅支付宝和Stripe，可能是国人商家。下面列出部分VPS主机套餐配置信息。CPU：1cor...
星梦云：四川100G高防4H4G10M月付仅60元
星梦云怎么样?星梦云资质齐全，IDC/ISP均有，从星梦云这边租的服务器均可以备案，属于一手资源，高防机柜、大带宽、高防IP业务，一手整C IP段，四川电信，星梦云专注四川高防服务器,成都服务器,雅安服务器。星梦云目前夏日云服务器促销,四川100G高防4H4G10M月付仅60元;西南高防月付特价活动，续费同价，买到就是赚到!点击进入：星梦云官方网站地址1、成都电信年中活动机(成都电信优化线路，封锁...
sql挂起为你推荐
-
1头牛168万人民币1头700千克的牛多少钱云爆发什么是蒸汽云爆炸？要具备那些条件？www.983mm.com哪有mm图片？你懂得www.299pp.com免费PP电影哪个网站可以看啊avtt4.comwww.51kao4.com为什么进不去啊?bbs2.99nets.com西安论坛、西安茶馆网、西安社区、西安bbs 的网址是多少？www.zhiboba.com登录哪个网站可以看nba当天的直播 是直播ww.66bobo.com有的网址直接输入***.com就行了,不用WWW, 为什么?www.jsjtxx.com苏州考驾照，理论考试结束后，要在网上学习满12小时，网站是什么干支论坛天干地支常识？