eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CSF.CSF_TDS_ROUTE_CACHE_EU

Object Details

Object Name:	CSF_TDS_ROUTE_CACHE_EU
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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000493487C00010$$	LOB	UNIQUE	APPS_TS_TX_DATA
CSF_TDS_RCT_EU_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FROM_SEGMENT_ID TO_SEGMENT_ID CONFIG FROM_SEGMENT_SIDE TO_SEGMENT_SIDE FROM_SEGMENT_POSITION TO_SEGMENT_POSITION

Columns

Name	Datatype	Length	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_EU;

Dependencies

[top of page]

CSF.CSF_TDS_ROUTE_CACHE_EU does not reference any database object

CSF.CSF_TDS_ROUTE_CACHE_EU is referenced by following:

CSF: CSF_TDS_ROUTE_CACHE_EU#