460 likes | 571 Views
This guide provides a comprehensive overview of using Oracle 10gR2 for implementing RDF spatial and network data models. It covers necessary preparations, including Red Hat Linux installation and the Oracle Universal Installer. Step-by-step instructions are provided for creating table spaces, RDF networks, and data models for both articles and family structures. The guide also includes details on data insertion, querying, and performing inference on family models, making it a valuable resource for database administrators and developers working with semantic technologies.
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