Network Topology  «Prev  Next»
Lesson 4Course project
ObjectiveCreating a Network of Oracle Databases

Course project - Creating a network of Oracle Databases

Course project description for creating a network of Oracle Databases
As you work through the course, you will be building a project designed to apply what you're learning to a real-world situation. Project exercises build on each other incrementally and are strategically placed throughout the course to incorporate and provide immediate hands-on practice with significant chunks of material.
The course project involves creating a network of Oracle databases. We will start with the basics and move into more advanced topics, essentially giving you all the hands-on experience you will need to tackle the Networking section of the OCP exam. Again, my goal is to reinforce the concepts of Oracle Network Services through repetition, so you will be starting with simple parameter files, and adding detail as we move through the course. By the time you have finished, you will have a complete set of Net8 parameter files. Much of the work in mastering Oracle networking is rote memorization. Hence, the project will focus primarily on the syntax required to define the networking environment.
This concludes the first module of the course. In the next module, we'll preview the OCP exam and give you some tips and advice to help you prepare for it.

Oracle Release 11.1 Changes

This section describes new and changed features of the Oracle Spatial topology and network data models for Oracle Database 11g Release 1 .

Load on Demand Analysis and Network Partitioning

To perform network analysis, you now have the option of partitioning the network and having needed partitions automatically loaded on demand during network analysis. This approach supplements the previous in-memory approach for network editing and analysis.
Note: The in-memory approach will be deprecated in the next release of Spatial. Future development will enhance the load on demand approach, which you are encouraged use instead of the in-memory approach.
With the load on demand approach, you first partition the network into partitions of manageable size, and you use the load on demand Java API to perform analysis, which automatically loads and unloads needed partitions during analysis. This approach enables Spatial to perform network analysis on very large networks without memory limitation becoming a significant factor.


A subpath is partial path along a path, created either as a result of a network analysis operation or explicitly by a user. The start and end points of a subpath are defined as link indexes and the percentage of the distance to the next node in the path.

User Data Support
You can define your own data in the user data metadata view, and Spatial will manage the user data as well as the connectivity information. Each user data entry is stored as a column in node, link, path, and subpath tables. Spatial currently supports simple data types such as VARCHAR2, INTEGER, NUMBER, and SDO_GEOMETRY.