OracleのRDFサポート

Size: px

Start display at page:

Download "OracleのRDFサポート"

たつぞういとえ
5 years ago
Views:

1 Oracle RDF 1. Resource Description Framework RDF Universal Resource Identifier URI Web [1] RDF GIS RDF Web [2] RDF Web [3] RDF <subject, predicate, object> subject object predicate 1 1: RDF Oracle RDF RDF Oracle RDF Oracle Spatial Network Data Model NDM NDM Oracle RDF NDM RDF Oracle RDF RDF RDF RDF RDF RDF RDF RDF Oracle RDF 1

2 2. Oracle Database 10g RDF Oracle Spatial 10g Release 2 RDF Oracle RDF RDF Oracle Database 10g RDF Oracle Oracle Database 10g RDF RDF Web : Web Web : : Friend of a Friend : Web: Web : RDF RDF RDF SQL RDF RDF URI RDF RDF RDF URI : SQL Java API : subclassof subpropertyof Oracle RDF 2

3 RDF Oracle : Oracle : Oracle : Oracle SQL Loader : N-triple : XML GeoRaster XML : Oracle Application Server BPEL XSLT UDDI 3. RDF RDF Web RDF RDF RDF URI URI URI URI : Uniform Resource Locator URL n-ary RDF _: _:anyname001 Oracle RDF 3

4 : 25 ^^ URI RDF RDF 4 R <S,P,O> 4 <R, rdf:type, rdf:statement> <R, rdf:subject, S> <R, rdf:property, P> <R, rdf:object, O> R <S,P,O> <N, ora:said, R> 4. Oracle Oracle RDF Oracle Spatial Network Data Model NDM RDF NDM RDF Oracle RDF RDF <S1, P1, O1> <S1, P2, O2> <S2, P2, O2> RDF Oracle RDF 4

5 2: Oracle RDF RDF Oracle RDF ID RDF RDF_MODEL$ RDF_VALUE$ RDF_NODE$ RDF_LINK$ RDF_BLANK_NODE$ RDF_NODE$ RDF_LINK$ 4.1 RDF RDF_MODEL$ RDF RDF_VALUE$ VALUE_ID RDF_LINK$ ID RDF_VALUE$ VALUE_ID VALUE_ID RDF_NODE$ RDF_LINK$ LINK_ID RDF_LINK$ VALUE_ID P_VALUE_ID VALUE_ID START_NODE_ID END_NODE_ID RDF_LINK$ _:ORABNuniqueID Oracle Oracle VALUE_ID RDF_BLANK_NODE$ RDF RDF_BLANK_NODE$ Oracle RDF 5

6 4.2 RDF Oracle RDF SDO_RDF_TRIPLE SDO_RDF- _TRIPLE_S 2 SDO_RDF_TRIPLE RDF <subject, predicate, object> SDO_RDF_TRIPLE_S RDF RDF RDF ID SDO_RDF_TRIPLE SDO_RDF_TRIPLE_S ID ID RDF_T_ID: ID RDF_LINK$ LINK_ID RDF_M_ID: MODEL_ID RDF_LINK$ MODEL_ID RDF_S_ID: VALUE_ID RDF_LINK$ START_NODE_ID RDF_P_ID: VALUE_ID RDF_LINK$ P_VALUE_ID RDF_O_ID: VALUE_ID RDF_LINK$ END_NODE_ID GET_TRIPLE() SDO_RDF_TRIPLE GET_SUBJECT() GET_PROPERTY() GET_OBJECT() GET_OBJECT() CLOB 5. RDF Oracle RDF RDF RDF RDF_TBLSPACE CREATE TABLESPACE rdf_tblspace DATAFILE '/oradata/orcl/rdf_tblspace.dat' SIZE 1024M REUSE AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED SEGMENT SPACE MANAGEMENT AUTO; 1. RDF : RDF Oracle RDF RDF DBA Oracle 1 RDF_TBLSPACE RDF EXECUTE SDO_RDF.CREATE_RDF_NETWORK('rdf_tblspace'); Oracle RDF 6

7 scott RDF RDF scott DBA GRANT EXECUTE ON MDSYS.RDF_APIS_INTERNAL TO SCOTT; 2. RDF : DBA RDF SDO_RDF_TRIPLE_S NUMBER ID SDO_RDF_TRIPLE_S Oracle TRIPLE FAMILY_RDF_DATA CREATE TABLE FAMILY_RDF_DATA (id NUMBER, triple SDO_RDF_TRIPLE_S); 3. RDF : RDF RDF SDO_RDF_TRIPLE_S FAMILY EXECUTE SDO_RDF.CREATE_RDF_MODEL('FAMILY', 'FAMILY_RDF_DATA', 'TRIPLE'); 5.1 : RDF RDF 4 Cathy Jack Jack Tom Cindy 3: FAMILY_RDF_DATA A 1 John Janice Suzie Matt 2 Matt Martha Tom 5.75 Cindy Suzie Sammy Cathy 5.8 Jack 6 2 FAMILY_RDF_DATA Oracle RDF 7

8 -- Select all males from the family model SELECT m MALES FROM TABLE(SDO_RDF_MATCH( '(?m rdf:type :Male)', SDO_RDF_Models('family'), null, SDO_RDF_Aliases(SDO_RDF_Alias('',' null)); MALES Select all grandfathers and their grandchildren from the family model, -- No rows will be returned as grandparentof relationship is not explicitly -- defined in the data SELECT x grandparent, y grandchild FROM TABLE(SDO_RDF_MATCH( '(?x :grandparentof?y) (?x rdf:type :Male)', SDO_RDF_Models('family'), null, SDO_RDF_Aliases(SDO_RDF_Alias('',' null)); no rows selected Oracle RDF A1 SQL INSERT 3 Jack Tom Cindy Jack Cindy 6 RDF Jack Cindy RDF SELECT p Person, h Height FROM TABLE(SDO_RDF_MATCH( '(?p :height "06.00"^^xsd:decimal) (?p :height?h)', SDO_RDF_Models('family'), null, SDO_RDF_Aliases(SDO_RDF_Alias('',' null)); PERSON HEIGHT Oracle RDF 8

9 5.2 RDF RDF fatherof RDF Person Male Female 2 parentof fatherof motherof 2 siblingof brotherof sisterof 2 fatherof brotherof Male motherof sisterof Female A2 RDFS FAMILY RDF RDF RDFS RDFS RDF RDF RDF RDFS RDFS -- RDFS inferencing in the family model BEGIN SDO_RDF_INFERENCE.CREATE_RULES_INDEX( 'rdfs_rix_family', SDO_RDF_Models('family'), SDO_RDF_Rulebases('RDFS')); END; / RDFS -- Select all males from the family model, with RDFS inferencing. SELECT m MALES FROM TABLE(SDO_RDF_MATCH( '(?m rdf:type :Male)', SDO_RDF_Models('family'), SDO_RDF_Rulebases('RDFS'), SDO_RDF_Aliases(SDO_RDF_Alias('',' null)); MALES Oracle RDF 9

10 RDFS RDF grandparentof RDFS FAMILY_RB RULES INDEX EXECUTE SDO_RDF_INFERENCE.CREATE_RULEBASE('family_rb'); INSERT INTO mdsys.rdfr_family_rb VALUES( 'grandparent_rule', '(?x :parentof?y) (?y :parentof?z)', NULL, '(?x :grandparentof?z)', SDO_RDF_Aliases(SDO_RDF_Alias('',' EXECUTE SDO_RDF_INFERENCE.DROP_RULES_INDEX ('rdfs_rix_family'); BEGIN SDO_RDF_INFERENCE.CREATE_RULES_INDEX( 'rdfs_rix_family', SDO_RDF_Models('family'), SDO_RDF_Rulebases('RDFS', 'family_rb')); END; / -- Select all grandfathers and their grandchildren from the family model. -- Use inferencing from both the RDFS and family_rb rulebases. SELECT x grandparent, y grandchild FROM TABLE(SDO_RDF_MATCH( '(?x :grandparentof?y) (?x rdf:type :Male)', SDO_RDF_Models('family'), SDO_RDF_Rulebases('RDFS','family_rb'), SDO_RDF_Aliases(SDO_RDF_Alias('',' null)); GRANDPARENT GRANDCHILD GRANDPARENT_RULE 6 SQL Oracle RDF 10

11 UPDATE mdsys.rdfr_family_rb SET antecedents = '(?x :parentof?y) (?y :parentof?z) (?z :height?h)', filter = 'h >= 6', aliases = SDO_RDF_Aliases(SDO_RDF_Alias('',' WHERE rule_name = 'GRANDPARENT_RULE'; -- See the result of the update. SELECT index_name, status FROM MDSYS.RDF_RULES_INDEX_INFO; INDEX_NAME STATUS RDFS_RIX_FAMILY INVALID -- Because the rulebase has been updated, drop the preceding rules index, -- and then re-create it. EXECUTE SDO_RDF_INFERENCE.DROP_RULES_INDEX ('rdfs_rix_family'); -- Re-create the rules index. BEGIN SDO_RDF_INFERENCE.CREATE_RULES_INDEX( 'rdfs_rix_family', SDO_RDF_Models('family'), SDO_RDF_Rulebases('RDFS','family_rb')); END; / -- Find the rules index that was just created (that is, the -- one based on the specified model and rulebases). SELECT SDO_RDF_INFERENCE.LOOKUP_RULES_INDEX(SDO_RDF_MODELS('family'), SDO_RDF_RULEBASES('RDFS','family_rb')) AS lookup_rules_index FROM DUAL; LOOKUP_RULES_INDEX RDFS_RIX_FAMILY -- Select grandfathers of tall (>= 6) grandchildren, and their -- tall grandchildren. SELECT x grandparent, y TallGrandChild FROM TABLE(SDO_RDF_MATCH( '(?x :grandparentof?y) (?x rdf:type :Male)', SDO_RDF_Models('family'), SDO_RDF_RuleBases('RDFS','family_rb'), SDO_RDF_Aliases(SDO_RDF_Alias('',' null)); GRANDPARENT TALLGRANDCHILD Oracle RDF 11

12 A 1 -- John is the father of Suzie. INSERT INTO family_rdf_data VALUES (1, SDO_RDF_TRIPLE_S('family', ' ' -- John is the father of Matt. INSERT INTO family_rdf_data VALUES (2, SDO_RDF_TRIPLE_S('family', ' ' ' -- Janice is the mother of Suzie. INSERT INTO family_rdf_data VALUES (3, SDO_RDF_TRIPLE_S('family', ' ' -- Janice is the mother of Matt. INSERT INTO family_rdf_data VALUES (4, SDO_RDF_TRIPLE_S('family', ' ' -- Sammy is the father of Cathy. INSERT INTO family_rdf_data VALUES (5, SDO_RDF_TRIPLE_S('family', ' ' ' -- Sammy is the father of Jack. INSERT INTO family_rdf_data VALUES (6, SDO_RDF_TRIPLE_S('family', ' ' ' -- Suzie is the mother of Cathy. INSERT INTO family_rdf_data VALUES (7, SDO_RDF_TRIPLE_S('family', ' ' -- Suzie is the mother of Jack. INSERT INTO family_rdf_data VALUES (8, SDO_RDF_TRIPLE_S('family', ' ' ' -- Matt is the father of Tom. INSERT INTO family_rdf_data VALUES (9, SDO_RDF_TRIPLE_S('family', ' ' ' -- Matt is the father of Cindy INSERT INTO family_rdf_data VALUES (10, SDO_RDF_TRIPLE_S('family', ' ' -- Martha is the mother of Tom. INSERT INTO family_rdf_data VALUES (11, SDO_RDF_TRIPLE_S('family', ' ' ' Oracle RDF 12

13 -- Martha is the mother of Cindy. INSERT INTO family_rdf_data VALUES (12, SDO_RDF_TRIPLE_S('family', ' ' -- Cathy is the sister of Jack. INSERT INTO family_rdf_data VALUES (13, SDO_RDF_TRIPLE_S('family', ' ' ' -- Jack is male. INSERT INTO family_rdf_data VALUES (14, SDO_RDF_TRIPLE_S('family', ' ' ' -- Tom is male. INSERT INTO family_rdf_data VALUES (15, SDO_RDF_TRIPLE_S('family', ' ' ' -- Cindy is female. INSERT INTO family_rdf_data VALUES (16, SDO_RDF_TRIPLE_S('family', ' ' ' -- Use SET ESCAPE OFF to prevent the caret (^) from being -- interpreted as an escape character.two carets (^^) are -- used to represent typed literals. SET ESCAPE OFF; -- Cathy's height is 5.8 (decimal). INSERT INTO family_rdf_data VALUES (30, SDO_RDF_TRIPLE_S('family', ' ' '"5.8"^^xsd:decimal')); -- Jack's height is 6 (integer). INSERT INTO family_rdf_data VALUES (31, SDO_RDF_TRIPLE_S('family', ' ' '"6"^^xsd:integer')); -- Tom's height is (decimal). INSERT INTO family_rdf_data VALUES (32, SDO_RDF_TRIPLE_S('family', ' ' '"05.75"^^xsd:decimal')); -- Cindy's height is (decimal). INSERT INTO family_rdf_data VALUES (33, SDO_RDF_TRIPLE_S('family', ' ' '"06.00"^^xsd:decimal')); Oracle RDF 13

14 A 2 -- Person is a class. INSERT INTO family_rdf_data VALUES (17, SDO_RDF_TRIPLE_S('family', ' ' ' -- Male is a subclass of Person. INSERT INTO family_rdf_data VALUES (18, SDO_RDF_TRIPLE_S('family', ' ' ' -- Female is a subclass of Person. INSERT INTO family_rdf_data VALUES (19, SDO_RDF_TRIPLE_S('family', ' ' ' -- siblingof is a property. INSERT INTO family_rdf_data VALUES (20, SDO_RDF_TRIPLE_S('family', ' ' ' -- parentof is a property. INSERT INTO family_rdf_data VALUES (21, SDO_RDF_TRIPLE_S('family', ' ' ' -- brotherof is a subproperty of siblingof. INSERT INTO family_rdf_data VALUES (22, SDO_RDF_TRIPLE_S('family', ' ' ' -- sisterof is a subproperty of siblingof. INSERT INTO family_rdf_data VALUES (23, SDO_RDF_TRIPLE_S('family', ' ' ' -- A brother is male. INSERT INTO family_rdf_data VALUES (24, SDO_RDF_TRIPLE_S('family', ' ' ' -- A sister is female. INSERT INTO family_rdf_data VALUES (25, SDO_RDF_TRIPLE_S('family', ' ' ' Oracle RDF 14

15 -- fatherof is a subproperty of parentof. INSERT INTO family_rdf_data VALUES (26, SDO_RDF_TRIPLE_S('family', ' ' ' -- motherof is a subproperty of parentof. INSERT INTO family_rdf_data VALUES (27, SDO_RDF_TRIPLE_S('family', ' ' ' -- A father is male. INSERT INTO family_rdf_data VALUES (28, SDO_RDF_TRIPLE_S('family', ' ' ' -- A mother is female. INSERT INTO family_rdf_data VALUES (29, SDO_RDF_TRIPLE_S('family', ' ' ' [1] W3C RDF Primer [2] W3C Semantic Web [3] W3C Frequently Asked Questions about RDF [4] Kowari [5] Sesame [6] N. Alexander X. Lopez S. Ravada S. Stephens J. Wang RDF Data Model in Oracle. in W3C Workshop on Semantic Web for Life Sciences 2004 Cambridge Massachusetts USA [7] Oracle Corporation Application Developer's Guide Object-Relational Features. 10g Release 1 (10.1) 2003 [8] Oracle Corporation Topology and Network Data Models. 10g Release 1 (10.1) 2003 [9] S. Powers Practical RDF 2003 O'Reilly & Associates, Inc. 331 [10] J. Carroll I. Dickinson C. Dollin D. Reynolds A. Seaborne K. Wilkinson Jena: Implementing the Semantic Web Recommendations. in World Wide Web Conference 2004 New York New York USA [11] Oracle Corporation Oracle XML DB Developer's Guide, 10g Release 1 (10.1) 2003 Oracle RDF 15

_bodik.key

_bodik.key RDF Gnavi() WWW 4 www Resource Description Framework rdfs:type schema:website http://city.fukuoka.lg.jp schema:about schema:lastreviewed rdfs:label db:fukuoka "2015-2-1"^^xsd:date rdfs:label