Transcript Oracle 10g R2 RDF Network Data Model’s Examples: Journal

Oracle 10gR2 RDF Spatial
Network Data Model Examples
Steven Wadsworth
Oracle
Reston, VA
1
Preface
• Preparations for the Demonstration:
– 1. Installation of Red Hat Linux:
• About 20 minutes over high-speed network.
• Slower from 4 CD-ROMs.
– Oracle 10gR2 Pre-installation Check List:
• About 2 hours because Steven was training Brand to do it.
– Oracle Universal Installer:
• Basic Installation–1.3 GB for Enterprise Edition (also installs Oracle Spatial)
• Companion CD-ROM to Install Demo Files.
– Thick (SQL) and Thin (iSQL*Plus):
• Used iSQL*Plus to Capture Scripts.
– Cookbook for Demos (Cut-n-Paste to Save Time):
• Oracle Technology Network:
– http://www.oracle.com/technology/index.html
» Documentation-Database-10gR2-View Library-Books-SPA-Spatial Topology
and Network Data Models.
• Semantic Technologies Center (Oracle Spatial Resource Description
Framework (RDF) 10g Release 2 (10.2) Manual):
– http://www.oracle.com/technology/tech/semantic_technologies/index.html
» http://download.oracle.com/otndocs/tech/semantic_web/pdf/rdfrm.pdf
2
Overview
•
•
•
•
•
•
•
•
•
•
1. Create Table Space
2. Table Space Created
3. Create RDF Network
4. RDF Network Created
5. Create Articles Table
6. Articles Table Created
7. Create Family Table
8. Family Table Created
9. Create Articles RDF Model
10. Articles RDF Model Created
3
Overview
(continued)
•
•
•
•
•
•
•
•
•
•
11. Create Family RDF Model
12. Family RDF Model Created
13. Create Family Indexes
14. Family Indexes Created
15. Insert Article Data 1
16. Insert Article Data 2
17. Insert Article Data 3
18. Article Data Inserted
19. Query Article Data 1
20. Query Article Data 2
4
Overview
(continued)
•
•
•
•
•
•
•
•
•
•
21. Query Article Data 3
22. Query Article Data 4
23. Query Article Data 5
Schematic of Family Data Model
24. Insert Family Data 1
25. Insert Family Data 2
26. Insert Family Data 3
27. Insert Family Data 4
28. Insert Family Data 5
29. Family Data Inserted
5
Overview
(continued)
•
•
•
•
•
•
•
•
•
•
30. Inference Family Model
31. Family Model Inferenced
32. Family Males – No Inferencing
33. Family Males – No Inferencing Results
34. 35. Family Males-With Inferencing
35. Family Males-With Inferencing Results
36. General Inferencing
37. Create Rules Index
38. Grandfathers – No Inferencing
39. Grandfathers – With Inferencing
6
1. Create Table Space
7
2. Table Space Created
8
3. Create RDF Network
9
4. RDF Network Created
10
5. Create Articles Table
11
6. Articles Table Created
12
7. Create Family Table
13
8. Family Table Created
14
9. Create Articles RDF Model
15
10. Articles RDF Model Created
16
11. Create Family RDF Model
17
12. Family RDF Model Created
18
13. Create Family Indexes
19
14. Family Indexes Created
20
15. Insert Article Data 1
21
16. Insert Article Data 2
22
17. Insert Article Data 3
23
18. Article Data Inserted
24
19. Query Article Data 1
25
20. Query Article Data 2
26
21. Query Article Data 3
27
22. Query Article Data 4
28
23. Query Article Data 5
29
Family Data Model
John & Janice
Matt & Martha
Tom
Suzie & Sammy
Cindy
Cathy
Jack
30
24. Insert Family Data 1
31
25. Insert Family Data 2
32
26. Insert Family Data 3
33
27. Insert Family Data 4
34
28. Insert Family Data 5
35
29. Family Data Inserted
36
30. Inference Family Model
37
31. Family Model Inferenced
38
32. Family Males – No Inferencing
39
33. Family Males – No Inferencing Results
40
34. Family Males-With Inferencing
41
35. Family Males-With Inferencing Results
42
36. General Inferencing
43
37. Create Rules Index
44
38. Grandfathers – No Inferencing
45
39. Grandfathers – With Inferencing
46