460 likes | 564 Views
Oracle 10gR2 RDF Spatial Network Data Model Examples. Steven Wadsworth Oracle Reston, VA. 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:
E N D
Oracle 10gR2 RDF Spatial Network Data Model Examples Steven Wadsworth Oracle Reston, VA
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
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
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
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
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