Search Results sys_il0000083075c00004

Overview

CSF.CSF_TDS_BINARY_TILES is a persistent table in the Oracle E-Business Suite Application Object Library schema (CSF), part of the Transportation and Distribution / spatial data infrastructure used by Oracle EBS 12.1.1 and 12.2.2. The table stores the physical binary content of a map tile — a discrete spatial index into a digital map. Each row corresponds to one tile belonging to a parent binary map, holding road network segment and node geometry as binary large objects (BLOBs). The FND design data registration (CSF.CSF_TDS_BINARY_TILES) confirms this object is a supported, dictionary-registered Application Object Library artifact, and its status is VALID.

The table resides in the APPS_TS_MEDIA tablespace, consistent with other EBS objects that persist large binary media such as images, documents, and spatial data. The heuristic Data Vault classification for this object is satellite-leaning. This suggests that, in a Data Vault model, CSF_TDS_BINARY_TILES would most naturally be modeled as a satellite of the parent map hub (CSF_TDS_BINARY_MAPS), carrying descriptive and large-object attributes rather than acting as an independent hub or as a link table.

Key Information Stored

The table has five documented columns. The following are the most significant:

• BINARY_TILE_ID (NUMBER, 30) — The surrogate primary key, protected by the unique constraint CSF_TDS_BINARY_TILES_PK. It is the unique identifier for a single binary tile.
• BINARY_MAP_ID (NUMBER, 30) — A foreign key to CSF_TDS_BINARY_MAPS. It identifies the parent map to which the tile belongs, establishing the tile-to-map grouping that drives spatial tiling logic.
• SEGMENTS (BLOB, 4000) — A binary large object holding road network segment data. This is the core geometry payload for the tile.
• NODES (BLOB, 4000) — A binary large object holding road network node data, accompanying the segment geometry.
• SECURITY_GROUP_ID (NUMBER) — Identifies the security group used when the EBS instance runs in hosted or multi-tenant mode, enabling row-level partitioning of map data by operating unit or hosted environment.

Two LOB indexes are documented: SYS_IL0000083075C00003$$ and SYS_IL0000083075C00004$$, both UNIQUE LOB indexes in APPS_TS_MEDIA, corresponding to the SEGMENTS and NODES BLOB columns. These are system-generated LOB locator indexes rather than business-key candidates; the true business identity of a tile is the BINARY_TILE_ID.

Common Use Cases and Queries

Because tiles are large-object containers, queries typically filter by map or by tile identifier and avoid selecting the BLOB columns unless the binary content is required. A representative query to enumerate tiles for a map is:

• SELECT BINARY_TILE_ID, BINARY_MAP_ID FROM CSF.CSF_TDS_BINARY_TILES WHERE BINARY_MAP_ID = :map_id;
• SELECT BINARY_TILE_ID, BINARY_MAP_ID, SECURITY_GROUP_ID FROM CSF.CSF_TDS_BINARY_TILES WHERE SECURITY_GROUP_ID = :sg_id;
• SELECT COUNT(*) FROM CSF.CSF_TDS_BINARY_TILES WHERE BINARY_MAP_ID = :map_id; — tile counts per map for capacity planning.

Reporting use cases include spatial content inventory (number of tiles per map), security-group distribution audits in hosted deployments, and integrity checks confirming that every tile references a valid parent map. Extraction of the SEGMENTS and NODES BLOBs is performed by spatial or mapping background processes rather than by ad hoc reporting.

Related Objects

• CSF.CSF_TDS_BINARY_MAPS — The parent table; joined on CSF_TDS_BINARY_TILES.BINARY_MAP_ID = CSF_TDS_BINARY_MAPS.BINARY_MAP_ID.
• FND_SECURITY_GROUPS — Referenced by CSF_TDS_BINARY_TILES.SECURITY_GROUP_ID, used for hosted-mode row security.
• CSF_TDS_BINARY_TILES# — The underlying dictionary base table referenced by this object.
• CSF_TDS_BINARY_TILES_PK — Primary key constraint on BINARY_TILE_ID.
• SYS_IL0000083075C00003$$ / SYS_IL0000083075C00004$$ — LOB indexes supporting the SEGMENTS and NODES BLOB columns.

The table does not reference any other database objects beyond the two foreign keys noted above, and its principal dependency chain is upward to the parent map definition and the security group definition.