0 / 0
Go back to the English version of the documentation
Importy metadanych i enrichments tabele raportowania
Last updated: 27 lip 2023
Importy metadanych i enrichments tabele raportowania

Sprawdź instrukcje Postgresi Db2 dotyczące tabel, które są powiązane z importami i wzbogacaniem metadanych.

Obszar tematu Nazwa tabeli Opis
Importy i wzbogacanie metadanych importy metadanych Metadata import .
Importy i wzbogacanie metadanych wykonunie_importu_metadanych Zaplanowany czas zadania importowania metadanych.
Importy i wzbogacanie metadanych metadata_enrichments Informacje o bogactwie metadanych.

Tabela importu metadanych

Ta tabela zawiera informacje na temat importowania metadanych.

Ta tabela zawiera następujące kolumny:

  • metadata_import_id -identyfikator importu metadanych.
  • container_id -Identyfikator projektu.
  • metadata_import_name -nazwa importu metadanych.
  • target_container_id -identyfikator projektu docelowego.
  • connection_id -identyfikator połączenia, dla którego tworzony jest import.

  • Instrukcja CREATE TABLE:

    create table metadata_imports(metadata_import_id varchar(128) not null,
container_id varchar(128) not null,
metadata_import_name varchar(256) not null,
target_container_id varchar(128),
connection_id varchar(128),
metadata_enrichment_id varchar(128),
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(container_id,
metadata_import_id))

    Instrukcja ALTER TABLE:

    alter table metadata_imports add constraint fk_metadata_imports_container_assets_2 foreign key (container_id,
metadata_import_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

  • Instrukcja CREATE TABLE:

    create table metadata_imports(metadata_import_id varchar(128) not null,
container_id varchar(128) not null,
metadata_import_name varchar(256) not null,
target_container_id varchar(128),
connection_id varchar(128),
metadata_enrichment_id varchar(128),
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(container_id,
metadata_import_id),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

    Instrukcja ALTER TABLE:

    alter table metadata_imports add constraint fk_metadata_imports_container_assets_2 foreign key (container_id,
metadata_import_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

tabela metadata_import_executions

Ta tabela zawiera informacje na temat zadania importowania metadanych.

Ta tabela zawiera następujące kolumny:

  • metadata_import_id -identyfikator importu metadanych.
  • container_id -Identyfikator projektu.
  • job_run_id -Identyfikator uruchomienia zadania.
  • invoked_by -Identyfikator osoby, która ją uruchomiła.
  • is_scheduled_run -zaplanowany czas zadania importowania metadanych.
  • start_time -Czas rozpoczęcia zadania importowania metadanych.
  • end_time -Czas zakończenia zadania importowania metadanych.
  • state -Stan zadania importowania metadanych.
  • count_discovered -liczba wykrytych zasobów.
  • count_discovered_with_children -liczba wykrytych zasobów z elementami podrzędnymi.
  • count_submitted -liczba wykrytych zasobów.
  • count_succeeded -liczba pomyślnie zaimportowanych zasobów aplikacyjnych.
  • count_succedded_with_children -liczba zasobów, które zostały pomyślnie zaimportowane z elementami podrzędnymi.
  • count_new_assets -liczba nowych zasobów aplikacyjnych.
  • count_updated_assets -Liczba zaktualizowanych zasobów aplikacyjnych.
  • count_deleted_assets -Liczba usuniętych zasobów.

  • Instrukcja CREATE TABLE:

    create table metadata_import_executions(metadata_import_id varchar(128) not null,
container_id varchar(36) not null,
job_run_id varchar(128) not null,
invoked_by varchar(128) not null,
is_scheduled_run boolean not null,
start_time timestamp(6) not null,
end_time timestamp(6),
state varchar(32) not null,
count_discovered bigint default 0 not null,
count_discovered_with_children bigint default 0 not null,
count_submitted bigint default 0 not null,
count_succeeded bigint default 0 not null,
count_succedded_with_children bigint default 0 not null,
count_new_assets bigint default 0 not null,
count_updated_assets bigint default 0 not null,
count_deleted_assets bigint default 0 not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(container_id,
metadata_import_id,
job_run_id))

    Instrukcje ALTER TABLE:

    alter table metadata_import_executions add constraint fk_metadata_import_executions_metadata_imports_3 foreign key (container_id,
metadata_import_id) references metadata_imports(container_id,
metadata_import_id) on
delete
	cascade on
	update
	no action

    alter table metadata_import_executions add constraint fk_metadata_import_executions_container_assets_4 foreign key (container_id,
job_run_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

  • Instrukcja CREATE TABLE:

    create table metadata_import_executions(metadata_import_id varchar(128) not null,
container_id varchar(36) not null,
job_run_id varchar(128) not null,
invoked_by varchar(128) not null,
is_scheduled_run boolean not null,
start_time timestamp(12) not null,
end_time timestamp(12),
state varchar(32) not null,
count_discovered bigint default 0 not null,
count_discovered_with_children bigint default 0 not null,
count_submitted bigint default 0 not null,
count_succeeded bigint default 0 not null,
count_succedded_with_children bigint default 0 not null,
count_new_assets bigint default 0 not null,
count_updated_assets bigint default 0 not null,
count_deleted_assets bigint default 0 not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(container_id,
metadata_import_id,
job_run_id),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

    Instrukcje ALTER TABLE:

    alter table metadata_import_executions add constraint fk_metadata_import_executions_metadata_imports_3 foreign key (container_id,
metadata_import_id) references metadata_imports(container_id,
metadata_import_id) on
delete
	cascade on
	update
	no action

    alter table metadata_import_executions add constraint fk_metadata_import_executions_container_assets_4 foreign key (container_id,
job_run_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

tabela metadata_enrichments

Ta tabela zawiera informacje na temat bogactwa metadanych.

Ta tabela zawiera następujące kolumny:

  • metadata_enrichment_id -identyfikator wzbogacania metadanych.
  • container_id -Identyfikator projektu.
  • metadata_enrichment_name -Nazwa wzbogacania metadanych.

  • Instrukcja CREATE TABLE:

    create table metadata_enrichments(metadata_enrichment_id varchar(128) not null,
container_id varchar(36) not null,
metadata_enrichment_name varchar(256) not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(container_id,
metadata_enrichment_id))

    Instrukcja ALTER TABLE:

    alter table metadata_enrichments add constraint fk_metadata_enrichments_container_assets_1 foreign key (container_id,
metadata_enrichment_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

  • Instrukcja CREATE TABLE:

    create table metadata_enrichments(metadata_enrichment_id varchar(128) not null,
container_id varchar(36) not null,
metadata_enrichment_name varchar(256) not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(container_id,
metadata_enrichment_id),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

    Instrukcja ALTER TABLE:

    alter table metadata_enrichments add constraint fk_metadata_enrichments_container_assets_1 foreign key (container_id,
metadata_enrichment_id) references container_assets(container_id,
asset_id) on
delete
	cascade on
	update
	no action

Więcej inform.

Temat nadrzędny: Tabele raportowania

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more