Please enable JavaScript to view this site.

Data Cache Data Model

Navigation: » No topics above this level «

dc_table_partitions: Data Cache Table Partitions

Contents Previous Home Next More

Structure for all rows in a data set of a specific partition.

Catalog: Cache

Schema: Invantive

Alias: tpt

Primary Keys: tpt_id

Label: Table Partitions

This is a read-only view. The Data Cache API may not support changing the data or the Invantive SQL driver for Data Cache does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Cache API.

View Columns

The columns of the view dc_table_partitions are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ptn_id

decimal

Partition ID

Reference to a partition.

tbe_id

decimal

Table ID

Reference to a table.

tpt_check_count_rows_max

decimal

Check Count of Rows (Max)

Maximum number of rows that all table partitions of this table should contain.

tpt_check_count_rows_min

decimal

Check Count of Rows (Min)

Minimum number of rows that all table partitions of this table should contain.

tpt_count_rows_first

decimal

Number of Rows in First Load

Number of rows in first version.

tpt_count_rows_last

decimal

Number of Rows in Last Load

Number of rows in last version.

tpt_count_rows_max

decimal

Maximum Number of Rows in Load

Maximum number of rows in a version ever seen.

tpt_count_rows_min

decimal

Minimum Number of Rows in Load

Minimum number of rows in a version ever seen.

tpt_count_rows_total

decimal

Total Number of Rows

Total number of rows in all versions.

tpt_created_at

string(60)

Created in

The code of the function in the modules table from within which the user created the record. This value will never change after creation of the record.

tpt_created_by

string(60)

Created by

Who created the record.

tpt_date_copy_activated

datetime

Date Copy Approach Activated

Moment in time at which the copy approach was activated last.

tpt_date_created

datetime

Created at

The system time in UTC at which the record was created. This value will never change after creation of the record.

tpt_date_modified

datetime

Updated at

The system time in UTC at which the record was last updated. This value will change for every mutation of the record.

tpt_date_row_cnt_last_change

datetime

Date Row Count Last Changed

Moment in time at which the row count changed last.

tpt_date_smart_activated

datetime

Date Smart Approach Activated

Moment in time at which the smart approach was activated last.

tpt_date_trickle_activated

datetime

Date Trickle Approach Activated

Moment in time at which the trickle approach was activated last.

tpt_date_trickle_first_message

datetime

Date Reception First Message for Trickle Approach

Moment in time at which a first trickle message was received first.

tpt_estimated_size_chars_first

decimal

Estimated Size in Characters in First Load

Estimated size in characters in first version.

tpt_estimated_size_chars_last

decimal

Estimated Size in Characters in Last Load

Estimated size in characters in last version.

tpt_estimated_size_chars_max

decimal

Maximum Estimated Size in Characters

Maximum estimated size in characters in a version ever seen.

tpt_estimated_size_chars_min

decimal

Minimum Estimated Size in Characters

Minimum estimated size in characters in a version ever seen.

tpt_estimated_size_chars_total

decimal

Estimated Total Size (characters)

Total estimated size in characters in all versions.

tpt_id

decimal

ID

Unique identifier.

tpt_lv_ptn_view_md5

string(60)

Logical Partition View MD5

MD5 of the SQL used to create the logical partition view.

tpt_lv_ptn_view_name

string(240)

Logical Partition View Name

Name of the logical partition view in the database.

tpt_modified_at

string(60)

Updated in

The code of the function in the modules table from within which the user last updated the record. This value will change for every mutation of the record.

tpt_modified_by

string(60)

Updated by

The name of the user in the users table whom last updated the record. This value will change for every update of the record.

tpt_orig_system_group

string(240)

Original System Group

Reference for identifying the group of records on the system from which it originated. It is commonly used to group records for later validation in an application control.

tpt_orig_system_reference

string(240)

Original System Reference

Reference for identifying the record on the system from which it originated.

tpt_seconds_before_droppable

decimal

Seconds before Droppable

Minimum number of seconds before a table partition version facts table becomes droppable.

tpt_seconds_before_obsolete

decimal

Seconds before Obsolete

Minimum number of seconds before a table partition version facts table becomes obsolete.

tpt_seconds_metadata_is_droppable

decimal

Seconds before Metadata Droppable

Minimum number of seconds before a table partition version facts table becomes obsolete.

tpt_seeding_approach_used_code

char

Seeding Approach Used Code

Seeding approach to get a up-to-date data set. Seeding approaches include 'C' for 'Complete', 'S' for 'Smart Sampling' and ' T' for 'Trickle Loading'.

tpt_seeding_approach_used_description

string

Seeding Approach Used Description

Description of the seeding approach.

tpt_seeding_parameter_used_1

string

Seeding Parameter Used #1

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_2

string

Seeding Parameter Used #2

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_3

string

Seeding Parameter Used #3

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_4

string

Seeding Parameter Used #4

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_parameter_used_5

string

Seeding Parameter Used #5

Value of a parameter used for the seeding process. Meaning depends on the seeding approach.

tpt_seeding_time_sec_first

decimal

Seeding Time in Seconds in First Load

Time in seconds to seed the facts table in first version.

tpt_seeding_time_sec_last

decimal

Seeding Time in Seconds in Last Load

Time in seconds to seed the facts table in last version.

tpt_seeding_time_sec_max

decimal

Maximum Seeding Time in Seconds in Load

Maximum time in seconds to seed the facts table in a version ever seen.

tpt_seeding_time_sec_min

decimal

Minimum Seeding Time in Seconds in Load

Minimum time in seconds to seed the facts table in a version ever seen.

tpt_seeding_time_sec_total

decimal

 

Total time in seconds to seed the facts table in all versions.

tpt_session_created

string(240)

Session Created

The ID of the session which created the record. This value will not change after insert.

tpt_session_modified

string(240)

Session Updated

The ID of the session which last updated the record.

tpt_transaction_created

string(240)

Transaction Created

The ID of the transaction which created the record.

tpt_transaction_modified

string(240)

Transaction Updated

The ID of the transaction which last updated the record.

tpt_version_last

decimal

 

Number of version that last got issued.

 

09-12-2020 18:57 Version 20.1.300-BETA+3020