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#>#/
台湾云服务器整理推荐UCloud/易探云！
台湾云服务器去哪里买?国内有没有哪里的台湾云服务器这块做的比较好的?有很多用户想用台湾云服务器，那么判断哪家台湾云服务器好，不是按照最便宜或最贵的选择，而是根据您的实际使用目的选择服务器，只有最适合您的才是最好的。总体而言，台湾云服务器的稳定性确实要好于大陆。今天，云服务器网(yuntue.com)小编来介绍一下台湾云服务器哪里买和一年需要多少钱！一、UCloud台湾云服务器UCloud上市云商,...
OneTechCloud（31元），美国CN2 GIA高防VPS月
OneTechCloud发布了本月促销信息，全场VPS主机月付9折，季付8折，优惠后香港VPS月付25.2元起，美国CN2 GIA线路高防VPS月付31.5元起。这是一家2019年成立的国人主机商，提供VPS主机和独立服务器租用，产品数据中心包括美国洛杉矶和中国香港，Cera的机器，VPS基于KVM架构，采用SSD硬盘，其中美国洛杉矶回程CN2 GIA，可选高防。下面列出部分套餐配置信息。美国CN...
TmhHost香港三网CN2 GIA月付45元起,美国CN2 GIA高防VPS季付99元起
TmhHost是一家国内正规公司，具备ISP\ICP等资质，主营国内外云服务器及独立服务器租用业务，目前，商家新上香港三网CN2 GIA线路VPS及国内镇江BGP高防云主机，其中香港三网CN2 GIA线路最低每月45元起；同时对美国洛杉矶CN2 GIA线路高防及普通VPS进行优惠促销，优惠后美国洛杉矶Cera机房CN2 GIA线路高防VPS季付99元起。香港CN2 GIA安畅机房，三网回程CN2 ...
sql挂起为你推荐
-
摩拜超15分钟加钱摩拜单车不是按骑行时间收费吗，我怎么只要开锁就要支付一元（而且只骑十几分钟）西部妈妈网烟台分类妈妈网 分类妈妈网的前2个字什么？刘祚天Mc浩然的资料以及百科谁知道？比肩工场比肩之意是什么意思xyq.163.cbg.com梦幻西游里，CBG是什么？在那里，能帮忙详细说一下吗www.kanav001.com长虹V001手机小游戏下载的网址是什么百度指数词百度指数是指，词不管通过什么样的搜索引擎进行搜索，都会被算成百度指数吗？avtt4.comwww.5c5c.com怎么进入www.15job.com广州天河区的南方人才市场www.175qq.com求带名字的情侣网名！