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#>#/
imidc：$88/月，e3-1230/16G内存/512gSSD/30M直连带宽/13个IPv4日本多IP
imidc对日本独立服务器在搞特别促销，原价159美元的机器现在只需要88美元，而且给13个独立IPv4，30Mbps直连带宽，不限制流量。注意，本次促销只有一个链接，有2个不同的优惠码，你用不同的优惠码就对应着不同的配置，价格也不一样。88美元的机器，下单后默认不管就给512G SSD，要指定用HDD那就发工单，如果需要多加一个/28（13个）IPv4，每个月32美元...官方网站：https:...
无忧云( 9.9元/首月),河南洛阳BGP 2核 2G,大连BGP线路 20G高防 ,
无忧云怎么样？无忧云服务器好不好？无忧云值不值得购买？无忧云，无忧云是一家成立于2017年的老牌商家旗下的服务器销售品牌，现由深圳市云上无忧网络科技有限公司运营，是正规持证IDC/ISP/IRCS商家，自营有国内雅安高防、洛阳BGP企业线路、香港CN2线路、国外服务器产品等，非常适合需要稳定的线路的用户，如游戏、企业建站业务需求和各种负载较高的项目，同时还有自营的高性能、高配置的BGP线路高防物理...
易探云：买香港/美国/国内云服务器送QQ音乐绿钻豪华版1年,价值180元
易探云产品限时秒杀&QQ音乐典藏活动正在进行中!购买易探云香港/美国云服务器送QQ音乐绿钻豪华版1年,价值180元，性价比超级高。目前，有四大核心福利产品推荐：福利一、香港云服务器1核1G2M，仅218元/年起(香港CN2线路，全球50ms以内);福利二、美国20G高防云服务器1核1G5M，仅336元/年起(美国BGP线路，自带20G防御);福利三、2G虚拟主机低至58.8元/年(更有免费...
sql挂起为你推荐
-
急救知识纳入考试急救证容易拿到么？微信回应封杀钉钉为什么微信被封以后然后解封了过了一会又被封了梦之队官网梦之队是什么呢？是那个国家的呢？他们又是参加那个项目的呢？得了几块金牌呢？刘祚天DJ这个职业怎么样？sss17.comwww.com17com.com是什么啊？m.2828dy.comwww.dy6868.com这个电影网怎么样?www.789.com.cn有什么网站可以玩游戏的.关键词分析如何进行关键词指数分析关键词分析关键词分析的考虑思路是怎样的，哪个数据是最重要的www.884tt.com刚才找了个下电影的网站www.ttgame8.com，不过好多电影怎么都不能用QQ旋风或者是迅雷下在呢？