Search Results sys_il0000083073c00014

Overview

CSF.CSF_TDS_TILES is a spatial index table in the Oracle E-Business Suite (EBS) Telephony/Transportation Data Server (TDS) schema (CSF). It stores the individual tiles generated when TDS creates a spatial index over a road network. Each row represents a rectangular region of the network containing nodes and edges (segments), and it can be loaded independently into memory to support routing, proximity search, or geographic lookup operations.

From a relational-modeling perspective, the ETRM heuristic classifies CSF.CSF_TDS_TILES as hub-leaning. This is a modeling suggestion rather than a formal Data Vault label: the table functions as a central reference point (a hub) around which the dependent node and segment tables orbit, and it is referenced by two child tables. The design uses a single surrogate/business identifier (TILE_ID) with successive-tile pointers, giving it a connected node structure typical of spatial graph indices.

Key Information Stored

The table has eight documented columns. The most significant are:

• TILE_ID — Numeric unique identifier for the tile; the sole column in the primary key constraint CSF_TDS_TILES_PK. This is the surrogate primary key.
• GEOMETRY — An MDSYS.SDO_GEOMETRY value describing the rectangular spatial extent of the tile. This is the column that ties the row into Oracle Spatial indexing (the two SYS_IL$$ LOB unique indexes, SYS_IL0000083073C00013$$ and SYS_IL0000083073C00014$$, are the underlying LOB indexes for this geometry column).
• SUCC_TILE_1, SUCC_TILE_2, SUCC_TILE_3, SUCC_TILE_4 — References to up to four successive tiles (neighbouring tiles in the traversal order). They implement the graph adjacency of the tiled network.
• BIN_INDEX — Numeric value used to generate the index for a segment in the binary TDS file. This is the storage-layout lookup value.
• SECURITY_GROUP_ID — Identifier used when running in hosted (multi-tenant) mode; foreign key to FND_SECURITY_GROUPS.

The documented unique indexes (SYS_IL…00013$$ and SYS_IL…00014$$) are LOB unique indexes rather than business-key candidates, so the only true primary-key-based unique identifier is TILE_ID. All eight columns are summarized above; no other columns are documented.

Common Use Cases and Queries

Typical scenarios include reconstructing the tile graph for a route, retrieving the geometry envelope for spatial joins, and locating the tile into which a node or segment falls.

• Retrieve a single tile and its neighbours:

  SELECT tile_id, succ_tile_1, succ_tile_2,
         succ_tile_3, succ_tile_4, bin_index
  FROM   csf.csf_tds_tiles
  WHERE  tile_id = :tile_id;

• Find the tile containing a point using Oracle Spatial:

  SELECT tile_id
  FROM   csf.csf_tds_tiles
  WHERE  SDO_RELATE(geometry,
         SDO_GEOMETRY(2001,8307,
         SDO_POINT_TYPE(:lon,:lat,NULL),NULL,NULL),
         'mask=CONTAINS') = 'TRUE';

• Join nodes to their owning tile:

  SELECT n.node_id, t.tile_id, t.bin_index
  FROM   csf.csf_tds_nodes n,
         csf.csf_tds_tiles t
  WHERE  n.tile_id = t.tile_id
  AND    t.tile_id = :tile_id;

• Reporting uses: tile counts per security group, spatial extent bounding boxes, and traversal-chain integrity checks by following the SUCC_TILE_n pointers.

Related Objects

The most significant related objects, based on the documented FK/PK relationships, are:

• CSF.CSF_TDS_NODES — Child table; join on CSF_TDS_NODES.TILE_ID = CSF_TDS_TILES.TILE_ID. Holds the network nodes contained in each tile.
• CSF.CSF_TDS_SEGMENTS — Child table; join on CSF_TDS_SEGMENTS.TILE_ID = CSF_TDS_TILES.TILE_ID. Holds the network edges within each tile.
• FND_SECURITY_GROUPS — Parent referenced by SECURITY_GROUP_ID (CSF_TDS_TILES.SECURITY_GROUP_ID → FND_SECURITY_GROUPS), supporting hosted-mode tenancy filtering.
• MDSYS.SDO_GEOMETRY — Oracle Spatial datatype and spatial operators used with the GEOMETRY column.
• APPS.CSF_TDS_TILES — The APPS-synonym view of this base table used by seeded EBS code and reports.

The dependency metadata lists SYS.STANDARD as a referenced object and identifies CSF.CSF_TDS_TILES as the base for dependent code and the APPS synonym, confirming it as the hub of the TDS spatial tiling model.