DBA Data[Home] [Help] [Dependency Information]

TABLE: CSF.CSF_TDS_ROUTE_CACHE_WM

Object Details
Object Name: CSF_TDS_ROUTE_CACHE_WM
Object Type: TABLE
Owner: CSF
Subobject Name:
Status: VALID


DEFINITION
A TDS ROUTE CACHE contains cache rows for calculated routes.
Time Distance Server will not recalculate a route if found in this cache table,
but will use the time and distance found in this row instead.
EXAMPLE
SEGMENT_FROM SIDE_FROM SPOT_FROM
---------------------------------------- --------- ---------
SEGMENT_TO SIDE_TO SPOT_TO
---------------------------------------- --------- ---------
RESULTTIME RESULTDISTANCE DATETIME
---------------------------------------- -------------- -----------------
HITCOUNT
---------
1019520000000503 2 0
1019520000004350 2 50
51335618560 14259894 20-FEB-2001 13:48
3

MISCELLANEOUS
Initial measurements indicate a 30% to 40% speed increase when a hit is
found in the cache table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000493493C00010$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
ROUTE_CACHE_ID NUMBER (30)
The ROUTE CACHE ID defines the unique identifier for the entity.
SEGMENT_FROM NUMBER

Segment from defines the start segment from this route.
SIDE_FROM NUMBER

Side from defines which road-side the route starts from.
SPOT_FROM NUMBER

Spot from defines the spot on the segment from which this route starts.
SEGMENT_TO NUMBER

Segment to defines the end segment from this route.
SIDE_TO NUMBER

Side to defines which road-side the route ends.
SPOT_TO NUMBER

Spot to defines the spot on the segment where this route ends.
RESULTTIME NUMBER

The result time is the calculated time this route takes to travel on the specified date-time.
RESULTDISTANCE NUMBER

The result distance is the calculated distance between the start- and end-spot from this route.
ROUTE CLOB (4000)
The route object
DATETIME DATE

The date and time on which the calculated resulttime and resultdistance are valid (calculated).
HITCOUNT NUMBER

The hitcount counts the number of times this cache rows is queried.
SECURITY_GROUP_ID NUMBER

standard security column
FROM_SEGMENT_ID NUMBER (15)
Segment from defines the start segment for this route.
TO_SEGMENT_ID NUMBER (15)
Segment to defines the end segment for this route.
CONFIG VARCHAR2 (100)
The route configuration information
TIME NUMBER (15)
Travel time calculated by TDS for this route
DISTANCE NUMBER (15)
Travel distance calculated by TDS for this route
COST NUMBER (15)
The cost factor for this route
RAMHITCOUNT NUMBER (15)
Stores the count of memory cache hits for the route
CREATION_DATE DATE

The creation date
LAST_UPDATE_DATE DATE

The last update date
FROM_SEGMENT_SIDE VARCHAR2 (1)
Side from defines which road-side the route starts from.
TO_SEGMENT_SIDE VARCHAR2 (1)
Side to defines which road-side the route ends.
FROM_SEGMENT_POSITION VARCHAR2 (3)
Spot from defines the spot on the segment from which this route starts.
TO_SEGMENT_POSITION VARCHAR2 (3)
Spot to defines the spot on the segment where this route ends.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROUTE_CACHE_ID
,      SEGMENT_FROM
,      SIDE_FROM
,      SPOT_FROM
,      SEGMENT_TO
,      SIDE_TO
,      SPOT_TO
,      RESULTTIME
,      RESULTDISTANCE
,      ROUTE
,      DATETIME
,      HITCOUNT
,      SECURITY_GROUP_ID
,      FROM_SEGMENT_ID
,      TO_SEGMENT_ID
,      CONFIG
,      TIME
,      DISTANCE
,      COST
,      RAMHITCOUNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      FROM_SEGMENT_SIDE
,      TO_SEGMENT_SIDE
,      FROM_SEGMENT_POSITION
,      TO_SEGMENT_POSITION
FROM CSF.CSF_TDS_ROUTE_CACHE_WM;

Dependencies

[top of page]

CSF.CSF_TDS_ROUTE_CACHE_WM does not reference any database object

CSF.CSF_TDS_ROUTE_CACHE_WM is referenced by following:

SchemaAPPS
SynonymCSF_TDS_ROUTE_CACHE_WM