invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMVIEWS: Data Dictionary Database Views

read only

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: Database Views

Views per active data container.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMVIEWS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
CAN_DELETE char Kann löschen Indicator whether you can delete data in this view.
CAN_INSERT char Kann einfügen Indicator whether you can insert data in this view.
CAN_SELECT char Kann auswählen Indicator whether you can select data in this view.
CAN_UPDATE char Kann aktualisieren Indicator whether you can update data in this view.
CATALOG varchar2 Catalog Catalog where the views are contained in.
CLIENT_SIDE_CACHEABLE char Table Client-Side Cacheable Are the contents eligible for caching on the client?
DESCRIPTION varchar2 Description Description.
DOCUMENTATION varchar2 Documentation Documentation.
EXAMPLE varchar2 Example Example of the contents.
ID int32 ID Unique ID of the view.
IS_PARTITION_SPECIFIC char Ist Partitionsspezifisch Indicator whether the contents of this table typically differ per partition.
NAME varchar2 Name Name of the view.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Datencontaineralias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datenkontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Treiberbeschreibung Provider description.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Anbietername Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Treiber Kurzname Provider short name.
QUERY varchar2 SQL-Abfrage SQL query defining the view contents.Only available for non-integrated views.
SCHEMA varchar2 Schema Schema within the catalog where the view is contained in.
STATIC_AVERAGE_ACCESS_LATENCY_MS double Statische durchschnittliche Zugriffsverzögerung (ms) Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.
STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE int32 Statischer Durchschnittswert der Zeilen pro Minute bei einem vollständigen Scan Average number of rows that fetched per minute on a full table scan, statically configured.
STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Statischer Durchschnittswert der Zeilen pro Minute bei einer Punkt-Query Average number of rows processed per minute on point queries, statically configured.
STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Statischer Durchschnitt der pro Minute geschriebenen Zeilen Average number of rows written per minute, statically configured.
TECHNICAL_DOCUMENTATION varchar2 Technische Dokumentation Technical documentation.

Tasten

Key Column Bezieht sich auf Kind Description
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk PROVIDER_INSTANCE_UID SYSTEMSCHEMAS.PROVIDER_INSTANCE_UID Key
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk CATALOG SYSTEMSCHEMAS.CATALOG Key
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk SCHEMA SYSTEMSCHEMAS.NAME Key
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk PROVIDER_INSTANCE_UID SYSTEMTABLES.PROVIDER_INSTANCE_UID Key
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk CATALOG SYSTEMTABLES.CATALOG Key
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk SCHEMA SYSTEMTABLES.SCHEMA Key
SYSTEMVIEWS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk NAME SYSTEMTABLES.NAME Key

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: