Pitney Bowes MapInfo Professional - Manual (Page 196)

Oracle Spatial Requirements
To connect to Oracle Spatial within MapInfo Professional, you must have the Oracle Spatial or Oracle
9i and 9i release 2, or 10G client installed. See your Oracle documentation for detailed information.
Primary Key used for New Table Creation or When Saving a Remote Copy
An Unique key ensures that an entry does not match any other entry from a different record. If a record
does not contain any value, no error is reported. A Primary key requires that every record contains a
unique value in that field. By making these values Primary keys, we enforce that every record has a
value in this field.
Primary Key Auto-Increment for Oracle Databases
The Primary auto-increment feature manages the Primary key value for you. When you add a new record
to a remote Oracle table, MapInfo Professional locks the table, checks for the highest value of the Primary
key of the table, increments it by one (1), and then puts that value in the Primary key field. SQL Server
Spatial users do not require this feature as the server-side software manages the Primary key
automatically.
Use the Auto Key check box in the Open DBMS Table Option dialog box to enable this feature. When
you select the Auto Key check box, the Primary key field is not editable and the Unique key is automatically
incremented. If you do not select this check box, the Primary key field remains editable.
To access this feature:
1. From the File menu, click Open and select an Oracle database from the Files of Type drop-down
list. Click OK to display the Open DBMS Table Options dialog box.
2. Select the Auto Key option to increment the Primary key of the selected table automatically for any
new records.
3. Click OK to continue.
Oracle Object Map Verification Supporting Object/Map Validation
The Check Regions menu option enables you to remove region line segments that intersect each other.
You can also think of this as nodes within a single polygon of a region where the polygon intersects itself,
as when a node has more than 2 line segments emanating from it.
These cases can be broken down into two other instances:
• If a polygon has 2 looped sections, and the path traced by the nodes of the polygon follow a cursive
figure 8 pattern, then we call this a Figure 8 polygon.
• If the same 2 looped polygon can trace its path as a cursive capital letter B, then we call this a Bow
Tie polygon.
We think of Figure 8 as worse than Bow Tie because the area of a Figure 8 is always incorrect, while
the area of a Bow Tie can be correct and accurate. Both Figure 8's and Bow Ties are detected.
Creating Legends from/for a Live Table
You can retrieve unique styles from the table using the Create Legend wizard. You can retrieve styles
from the map catalog, if performance is your primary concern, but if you prefer a more visually descriptive
and appealing spatial representation of the unique map styles in your live table, you can create legends
from a live table instead.
When are unique map styles available for a live table?
In general, remote databases have no consistent way of storing styles for geographic data. MapInfo
Professional gives you two different ways of associating styles with geographic data for remote databases.
The first way is to specify a common style for a database table in the map catalog, which is used for all
records in that database table. The second way is to have an additional column for the database table
that specifies a style for each record in that table. (MapInfo Professional uses the map catalog to keep
track of the style column for a database table.) Unique map styles are available for a database table
when it has this designated style column.
To see this functionality:
MapInfo Professional 12.5 196
Working with Remote Tables from Specific Databases