dq_issues_for_asset_columns, tabela

Ta tabela zawiera następujące kolumny:

• issue_id -Identyfikator problemu z zasobem.
• asset_id -Identyfikator zasobu.
• container_id -Identyfikator projektu.
• column_name -nazwa kolumny, dla której uruchamiane są reguły i analizy danych qulaity.
• check_id -Identyfikator sprawdzenia jakości danych.
• number_of_occurences -Liczba znalezionych wystąpień dla sprawdzenia jakości danych.
• number_of_tested_records -Liczba przetestowanych rekordów znalezionych dla sprawdzenia jakości danych.
• percent_occurences -Procent wystąpień.
• score -wynik znaleziony po uruchomieniu sprawdzenia.
• status -Bieżący status problemu.
• ignored -Flaga oznaczający, że bieżąca kwestia jest uczestnicząca w zagadnieniu jakości danych.

• Postgres

  Instrukcja CREATE TABLE:

  CREATE TABLE IF NOT EXISTS dq_issues_for_asset_columns (
    issue_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    container_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    column_name character varying(256) COLLATE pg_catalog.default NOT NULL,
    asset_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    check_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    number_of_occurrences bigint NOT NULL DEFAULT 0,
    number_of_tested_records bigint NOT NULL DEFAULT 0,
    percent_occurrences double precision,
    score double precision,
    status character varying(16) COLLATE pg_catalog.default NOT NULL,
    ignored boolean NOT NULL,
    tech_start timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    tech_end timestamp(6) without time zone NOT NULL DEFAULT to_timestamp('9999-12-30' :: text, 'YYYY-MM-DD' :: text),
    ts_id timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT dq_issues_for_asset_columns_pkey PRIMARY KEY (issue_id, asset_id, container_id, column_name),
    CONSTRAINT fk_dq_issues_for_asset_columns_container_data_asset_columns_6 FOREIGN KEY (container_id, asset_id, column_name) REFERENCES container_data_asset_columns (container_id, asset_id, name) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE,
    CONSTRAINT fk_dq_issues_for_asset_columns_dq_checks_5 FOREIGN KEY (container_id, check_id) REFERENCES dq_checks (container_id, check_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
  )
  

• Db2

  Instrukcja CREATE TABLE:

  CREATE TABLE DQ_ISSUES_FOR_ASSET_COLUMNS (
    ISSUE_ID VARCHAR(36 OCTETS) NOT NULL,
    CONTAINER_ID VARCHAR(36 OCTETS) NOT NULL,
    COLUMN_NAME VARCHAR(256 OCTETS) NOT NULL,
    ASSET_ID VARCHAR(36 OCTETS) NOT NULL,
    CHECK_ID VARCHAR(36 OCTETS) NOT NULL,
    NUMBER_OF_OCCURRENCES BIGINT NOT NULL WITH DEFAULT 0,
    NUMBER_OF_TESTED_RECORDS BIGINT NOT NULL WITH DEFAULT 0,
    PERCENT_OCCURRENCES DOUBLE,
    SCORE DOUBLE,
    STATUS VARCHAR(16 OCTETS) NOT NULL,
    IGNORED BOOLEAN 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,
    PERIOD SYSTEM_TIME (TECH_START, TECH_END)
  ) IN USERSPACE1 ORGANIZE BY ROW;
  

  Instrukcje ALTER TABLE:

  ALTER TABLE
    DQ_ISSUES_FOR_ASSET_COLUMNS
  ADD
    PRIMARY KEY (
      ISSUE_ID,
      ASSET_ID,
      CONTAINER_ID,
      COLUMN_NAME
    ) ENFORCED;
  

  ALTER TABLE
    DQ_ISSUES_FOR_ASSET_COLUMNS
  ADD
    CONSTRAINT FK_DQ_ISSUES_FOR_ASSET_COLUMNS_CONTAINER_DATA_ASSET_COLUMNS_6 FOREIGN KEY (CONTAINER_ID, ASSET_ID, COLUMN_NAME) REFERENCES CONTAINER_DATA_ASSET_COLUMNS (CONTAINER_ID, ASSET_ID, NAME) ON DELETE CASCADE ON UPDATE NO ACTION ENFORCED ENABLE QUERY OPTIMIZATION;
  

  ALTER TABLE
    DQ_ISSUES_FOR_ASSET_COLUMNS
  ADD
    CONSTRAINT FK_DQ_ISSUES_FOR_ASSET_COLUMNS_DQ_CHECKS_5 FOREIGN KEY (CHECK_ID, CONTAINER_ID) REFERENCES DQ_CHECKS (CHECK_ID, CONTAINER_ID) ON DELETE CASCADE ON UPDATE NO ACTION ENFORCED ENABLE QUERY OPTIMIZATION;
  

dq_issues_for_assets

Ta tabela zawiera następujące kolumny:

• issue_id -Identyfikator problemu z zasobem.
• container_id -Identyfikator projektu.
• asset_id -Identyfikator zasobu.
• check_id -Identyfikator sprawdzenia jakości danych.
• number_of_occurences -Liczba znalezionych wystąpień dla sprawdzenia jakości danych.
• number_of_tested_records -Liczba przetestowanych rekordów znalezionych dla sprawdzenia jakości danych.
• percent_occurences -Procent wystąpień.
• score -wynik znaleziony po uruchomieniu sprawdzenia.
• status -Bieżący status problemu.
• ignored -Flaga, aby określić, czy bieżący problem bierze udział w zagadnieniu jakości danych.

• Postgres

  Instrukcja CREATE TABLE:

  CREATE TABLE IF NOT EXISTS dq_issues_for_assets (
    issue_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    container_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    asset_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    check_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    number_of_occurrences bigint NOT NULL DEFAULT 0,
    number_of_tested_records bigint NOT NULL DEFAULT 0,
    percent_occurrences double precision,
    score double precision,
    status character varying(16) COLLATE pg_catalog.default NOT NULL,
    ignored boolean NOT NULL,
    tech_start timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    tech_end timestamp(6) without time zone NOT NULL DEFAULT to_timestamp('9999-12-30' :: text, 'YYYY-MM-DD' :: text),
    ts_id timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT dq_issues_for_assets_pkey PRIMARY KEY (issue_id, asset_id, container_id),
    CONSTRAINT fk_dq_issues_for_assets_container_data_assets_4 FOREIGN KEY (container_id, asset_id) REFERENCES container_data_assets (container_id, asset_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE,
    CONSTRAINT fk_dq_issues_for_assets_dq_checks_3 FOREIGN KEY (container_id, check_id) REFERENCES dq_checks (container_id, check_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
  )
  

• Db2

  Instrukcja CREATE TABLE:

  CREATE TABLE DQ_ISSUES_FOR_ASSETS (
    ISSUE_ID VARCHAR(36 OCTETS) NOT NULL,
    CONTAINER_ID VARCHAR(36 OCTETS) NOT NULL,
    ASSET_ID VARCHAR(36 OCTETS) NOT NULL,
    CHECK_ID VARCHAR(36 OCTETS) NOT NULL,
    NUMBER_OF_OCCURRENCES BIGINT NOT NULL WITH DEFAULT 0,
    NUMBER_OF_TESTED_RECORDS BIGINT NOT NULL WITH DEFAULT 0,
    PERCENT_OCCURRENCES DOUBLE,
    SCORE DOUBLE,
    STATUS VARCHAR(16 OCTETS) NOT NULL,
    IGNORED BOOLEAN 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,
    PERIOD SYSTEM_TIME (TECH_START, TECH_END)
  ) IN USERSPACE1 ORGANIZE BY ROW;
  

  Instrukcje ALTER TABLE:

  ALTER TABLE
    DQ_ISSUES_FOR_ASSETS
  ADD
    PRIMARY KEY (ISSUE_ID, ASSET_ID, CONTAINER_ID) ENFORCED;
  

  ALTER TABLE
    DQ_ISSUES_FOR_ASSETS
  ADD
    CONSTRAINT FK_DQ_ISSUES_FOR_ASSETS_CONTAINER_DATA_ASSETS_4 FOREIGN KEY (CONTAINER_ID, ASSET_ID) REFERENCES CONTAINER_DATA_ASSETS (CONTAINER_ID, ASSET_ID) ON DELETE CASCADE ON UPDATE NO ACTION ENFORCED ENABLE QUERY OPTIMIZATION;
  

  ALTER TABLE
    DQ_ISSUES_FOR_ASSETS
  ADD
    CONSTRAINT FK_DQ_ISSUES_FOR_ASSETS_DQ_CHECKS_3 FOREIGN KEY (CHECK_ID, CONTAINER_ID) REFERENCES DQ_CHECKS (CHECK_ID, CONTAINER_ID) ON DELETE CASCADE ON UPDATE NO ACTION ENFORCED ENABLE QUERY OPTIMIZATION;
  

dq_checks, tabela

Ta tabela zawiera następujące kolumny:

• check_id -Identyfikator sprawdzenia jakości danych.
• container_id -Identyfikator projektu.
• dq_check_type -Typ sprawdzania jakości danych (może to być profilling lub data_rule).
• dq_check_name -Nazwa sprawdzenia jakości danych.
• dq_dimension_id -Identyfikator wymiaru jakości danych.
• created_by -użytkownik, który utworzył tę kontrolę jakości danych.
• created_on -Czas utworzenia sprawdzenia jakości danych.

• Postgres

  Instrukcja CREATE TABLE:

  CREATE TABLE IF NOT EXISTS dq_checks (
    check_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    container_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    dq_check_type character varying(256) COLLATE pg_catalog.default NOT NULL,
    dq_check_name character varying(256) COLLATE pg_catalog.default NOT NULL,
    dq_dimension_id character varying(36) COLLATE pg_catalog.default NOT NULL,
    created_by character varying(256) COLLATE pg_catalog.default NOT NULL,
    created_on timestamp(6) without time zone NOT NULL,
    tech_start timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    tech_end timestamp(6) without time zone NOT NULL DEFAULT to_timestamp('9999-12-30' :: text, 'YYYY-MM-DD' :: text),
    ts_id timestamp(6) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT dq_checks_pkey PRIMARY KEY (check_id, container_id),
    CONSTRAINT fk_dq_checks_containers_1 FOREIGN KEY (container_id) REFERENCES containers (container_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE,
    CONSTRAINT fk_dq_checks_dq_v4_dimensions_2 FOREIGN KEY (dq_dimension_id) REFERENCES dq_v4_dimensions (dimension_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
  )
  

• Db2

  Instrukcja CREATE TABLE:

   CREATE TABLE   DQ_CHECKS   (
   CHECK_ID  VARCHAR(36 OCTETS) NOT NULL , 
   CONTAINER_ID  VARCHAR(36 OCTETS) NOT NULL , 
   DQ_CHECK_TYPE  VARCHAR(256 OCTETS) NOT NULL , 
   DQ_CHECK_NAME  VARCHAR(256 OCTETS) NOT NULL , 
   DQ_DIMENSION_ID  VARCHAR(36 OCTETS) NOT NULL , 
   CREATED_BY  VARCHAR(256 OCTETS) NOT NULL , 
   CREATED_ON  TIMESTAMP(12) 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 , 
   PERIOD SYSTEM_TIME ( TECH_START , TECH_END ) )   
   IN  USERSPACE1   
   ORGANIZE BY ROW;
  

  Instrukcje ALTER TABLE:

   ALTER TABLE   DQ_CHECKS  
   ADD PRIMARY KEY
   ( CHECK_ID ,
   CONTAINER_ID )
   ENFORCED;
  

  ALTER TABLE   DQ_CHECKS  
  ADD CONSTRAINT  FK_DQ_CHECKS_CONTAINERS_1  FOREIGN KEY
  ( CONTAINER_ID )
  REFERENCES   CONTAINERS 
  ( CONTAINER_ID )
  ON DELETE CASCADE
  ON UPDATE NO ACTION
  ENFORCED
  ENABLE QUERY OPTIMIZATION;
  

  ALTER TABLE   DQ_CHECKS  
  ADD CONSTRAINT  FK_DQ_CHECKS_DQ_V4_DIMENSIONS_2  FOREIGN KEY
  ( DQ_DIMENSION_ID )
  REFERENCES   DQ_V4_DIMENSIONS 
  ( DIMENSION_ID )
  ON DELETE CASCADE
  ON UPDATE NO ACTION
  ENFORCED
  ENABLE QUERY OPTIMIZATION;
  

Tabela dq_v4_dimensions

Ta tabela zawiera informacje na temat wymiarów jakości dla reguły.

Ta tabela zawiera następujące kolumny:

• dimension_id -Identyfikator wymiaru jakości danych.
• name -Nazwa wymiaru jakości danych.
• description -opis wymiaru jakości danych.

• Postgres

  Instrukcja CREATE TABLE:

  create table dq_v4_dimensions(dimension_id varchar(128) not null,
  container_id varchar(36) not null,
  name varchar(256) not null,
  description 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(dimension_id,
  container_id))
  

  Instrukcja ALTER TABLE:

  alter table dq_v4_dimensions add constraint fk_dq_v4_dimensions_containers_1 foreign key (container_id) references containers(container_id) on
  delete
  	cascade on
  	update
  	no action
  

  Instrukcja ALTER TABLE:

  ALTER TABLE IF EXISTS  dq_v4_dimensions
      OWNER to postgres;
  
  

• Db2

  Instrukcja CREATE TABLE:

  create table dq_v4_dimensions(dimension_id varchar(128) not null,
  container_id varchar(36) not null,
  name varchar(256) not null,
  description 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(dimension_id,
  container_id),
  period SYSTEM_TIME (tech_start,
  tech_end) ) ORGANIZE by row
  

  Instrukcja ALTER TABLE:

  alter table dq_v4_dimensions add constraint fk_dq_v4_dimensions_containers_1 foreign key (container_id) references containers(container_id) on
  delete
  	cascade on
  	update
  	no action
  

dq_rule_definitions, tabela

Ta tabela zawiera rzeczywiste metadane dla reguły jakości danych.

Ta tabela zawiera następujące kolumny:

• rule_definition_id -identyfikator definicji reguły jakości danych.
• container_id -identyfikator katalogu lub projektu.
• expression -Wyrażenie definicji reguły jakości danych.
• dq_dimension_id -Identyfikator wymiaru jakości danych.
• name -nazwa definicji jakości danych.

• Postgres

  Instrukcja CREATE TABLE:

  create table dq_rule_definitions(rule_definition_id varchar(128) not null,
  container_id varchar(36) not null,
  expression text not null,
  dq_dimension_id varchar(128),
  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(rule_definition_id))
  

  Instrukcje ALTER TABLE:

  alter table dq_rule_definitions add constraint fk_dq_rule_definitions_containers_2 foreign key (container_id) references containers(container_id) on
  delete
  	cascade on
  	update
  	no action
  

  alter table dq_rule_definitions add constraint fk_dq_rule_definitions_dq_v4_dimensions_3 foreign key (dq_dimension_id,
  container_id) references dq_v4_dimensions(dimension_id,
  container_id) on
  delete
  	cascade on
  	update
  	no action
  

• Db2

  Instrukcja CREATE TABLE:

  create table dq_rule_definitions(rule_definition_id varchar(128) not null,
  container_id varchar(36) not null,
  expression clob not null,
  dq_dimension_id varchar(128),
  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(rule_definition_id),
  period SYSTEM_TIME (tech_start,
  tech_end) ) ORGANIZE by row
  

  Instrukcje ALTER TABLE:

  alter table dq_rule_definitions add constraint fk_dq_rule_definitions_containers_2 foreign key (container_id) references containers(container_id) on
  delete
  	cascade on
  	update
  	no action
  

  alter table dq_rule_definitions add constraint fk_dq_rule_definitions_dq_v4_dimensions_3 foreign key (dq_dimension_id,
  container_id) references dq_v4_dimensions(dimension_id,
  container_id) on
  delete
  	cascade on
  	update
  	no action
  

dq_rules_defs, tabela

Ta tabela zawiera szczegóły powiązania między regułą i definicją, ponieważ można utworzyć wiele powiązań.

Ta tabela zawiera następujące kolumny:

• rule_id -Identyfikator reguły jakości danych.
• rule_definition_id -identyfikator definicji reguły.
• disambiguator -numer disambiguatora.

• Postgres

  Instrukcja CREATE TABLE:

  create table dq_rules_defs(rule_id varchar(128) not null,
  rule_definition_id varchar(128) not null,
  disambiguator integer,
  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(rule_id,
  rule_definition_id))
  

  Instrukcje ALTER TABLE:

  alter table dq_rules_defs add constraint fk_dq_rules_defs_dq_rules_1 foreign key (rule_id) references dq_rules(rule_id) on
  delete
  	cascade on
  	update
  	no action
  

  alter table dq_rules_defs add constraint fk_dq_rules_defs_dq_rule_definitions_2 foreign key (rule_definition_id) references dq_rule_definitions(rule_definition_id) on
  delete
  	cascade on
  	update
  	no action
  

• Db2

  Instrukcja CREATE TABLE:

  create table dq_rules_defs(rule_id varchar(128) not null,
  rule_definition_id varchar(128) not null,
  disambiguator integer,
  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(rule_id,
  rule_definition_id),
  period SYSTEM_TIME (tech_start,
  tech_end) ) ORGANIZE by row
  

  Instrukcje ALTER TABLE:

  alter table dq_rules_defs add constraint fk_dq_rules_defs_dq_rules_1 foreign key (rule_id) references dq_rules(rule_id) on
  delete
  	cascade on
  	update
  	no action
  

  alter table dq_rules_defs add constraint fk_dq_rules_defs_dq_rule_definitions_2 foreign key (rule_definition_id) references dq_rule_definitions(rule_definition_id) on
  delete
  	cascade on
  	update
  	no action
  

dq_rules, tabela

Ta tabela zawiera informacje na temat reguł jakości danych.

Ta tabela zawiera następujące kolumny:

• rule_id -Identyfikator reguły jakości danych.
• container_id -identyfikator katalogu lub projektu.
• dq_dimension_id -Identyfikator wymiaru reguły jakości danych.
• name -nazwa reguły jakości danych.
• output_asset_id -Identyfikator zasobu wyjściowego.
• output_asset_container_id -identyfikator katalogu wyjściowego lub projektu.

• Postgres

  Instrukcja CREATE TABLE:

  create table dq_rules(rule_id varchar(128) not null,
  container_id varchar(36) not null,
  dq_dimension_id varchar(128),
  name varchar(256) not null,
  output_asset_id varchar(128),
  output_asset_container_id varchar(36),
  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(rule_id))
  

  Instrukcja ALTER TABLE:

  alter table dq_rules add constraint fk_dq_rules_dq_v4_dimensions_5 foreign key (dq_dimension_id,
  container_id) references dq_v4_dimensions(dimension_id,
  container_id) on
  delete
  	cascade on
  	update
  	no action
  

• Db2

  Instrukcja CREATE TABLE:

  create table dq_rules(rule_id varchar(128) not null,
  container_id varchar(36) not null,
  dq_dimension_id varchar(128),
  name varchar(256) not null,
  output_asset_id varchar(128),
  output_asset_container_id varchar(36),
  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(rule_id),
  period SYSTEM_TIME (tech_start,
  tech_end) ) ORGANIZE by row
  

  Instrukcja ALTER TABLE:

  alter table dq_rules add constraint fk_dq_rules_dq_v4_dimensions_5 foreign key (dq_dimension_id,
  container_id) references dq_v4_dimensions(dimension_id,
  container_id) on
  delete
  	cascade on
  	update
  	no action
  

Tabela dq_rule_bindings

Ta tabela zawiera informacje na temat powiązań reguł jakości danych.

Ta tabela zawiera następujące kolumny:

• rule_id -Identyfikator reguły jakości danych.
• rule_definition_id -identyfikator definicji reguły.
• variable_name -identyfikator zmiennej, która jest konsolidowana z kolumną dla reguły jakości danych.
• column_name -nazwa kolumny.
• container_id -identyfikator katalogu lub projektu.
• asset_id -Identyfikator zasobu.

• Postgres

  Instrukcja CREATE TABLE:

  create table dq_rule_bindings(rule_id varchar(128) not null,
  variable_name varchar(256) not null,
  column_name varchar(256) not null,
  container_id varchar(36) not null,
  asset_id varchar(128) not null,
  rule_definition_id varchar(128) default 'na' 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(rule_id,
  rule_definition_id,
  variable_name,
  column_name))
  

  Instrukcje ALTER TABLE:

  alter table dq_rule_bindings add constraint fk_dq_rule_bindings_dq_rules_6 foreign key (rule_id) references dq_rules(rule_id) on
  delete
  	cascade on
  	update
  	no action
  

  alter table dq_rule_bindings add constraint fk_dq_rule_bindings_container_data_asset_columns_7 foreign key (container_id,
  asset_id,
  column_name) references container_data_asset_columns(container_id,
  asset_id,
  name) on
  delete
  	cascade on
  	update
  	no action 
  

  alter table dq_rule_bindings add constraint fk_dq_rule_bindings_dq_rules_defs_3 foreign key (rule_id,
  rule_definition_id) references dq_rules_defs(rule_id,
  rule_definition_id) on
  delete
  	cascade on
  	update
  	no action
  

• Db2

  Instrukcja CREATE TABLE:

  create table dq_rule_bindings(rule_id varchar(128) not null,
  variable_name varchar(256) not null,
  column_name varchar(256) not null,
  container_id varchar(36) not null,
  asset_id varchar(128) not null,
  rule_definition_id varchar(128) default 'na' 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(rule_id,
  rule_definition_id,
  variable_name,
  column_name),
  period SYSTEM_TIME (tech_start,
  tech_end) ) ORGANIZE by row
  

  Instrukcje ALTER TABLE:

  alter table dq_rule_bindings add constraint fk_dq_rule_bindings_dq_rules_6 foreign key (rule_id) references dq_rules(rule_id) on
  delete
  	cascade on
  	update
  	no action
  

  alter table dq_rule_bindings add constraint fk_dq_rule_bindings_container_data_asset_columns_7 foreign key (container_id,
  asset_id,
  column_name) references container_data_asset_columns(container_id,
  asset_id,
  name) on
  delete
  	cascade on
  	update
  	no action
  

  alter table dq_rule_bindings add constraint fk_dq_rule_bindings_dq_rules_defs_3 foreign key (rule_id,
  rule_definition_id) references dq_rules_defs(rule_id,
  rule_definition_id) on
  delete
  	cascade on
  	update
  	no action
  

dq_rule_execution, tabela

Ta tabela zawiera informacje na temat zadania reguły dla reguły jakości danych.

Ta tabela zawiera następujące kolumny:

• dq_rule_id -Identyfikator reguły jakości danych.
• job_run_id -identyfikator zadania dla zadania reguły jakości danych.
• start_time -Czas rozpoczęcia zadania dla zadania reguły jakości danych.
• end_time -Czas zakończenia zadania dla zadania reguły jakości danych.
• nb_tested_rows -liczba przetestowanych wierszy dla zadania reguły jakości danych.
• nb_passing_rows -liczba przechodzących wierszy dla zadania reguły jakości danych.
• nb_failing_rows -liczba wierszy, w których wystąpił błąd, dla zadania reguły jakości danych.
• percent_passing_rows -Procent przekazywania wierszy dla zadania reguły jakości danych.
• percent_failing_rows -Procent uszkodzonych wierszy dla zadania reguły jakości danych.
• sampling_used -określa, czy próbkowanie jest używane dla reguły jakości danych.
• sample_size -Wielkość próbkowania dla reguły jakości danych.
• sample_type -Typ próbkowania dla reguły jakości danych.

• Postgres

  Instrukcja CREATE TABLE:

  create table dq_rule_execution(dq_rule_id varchar(128) not null,
  job_run_id varchar(256) not null,
  start_time timestamp(6) not null,
  end_time timestamp(6) not null,
  nb_tested_rows bigint not null,
  nb_passing_rows bigint not null,
  nb_failing_rows bigint not null,
  percent_passing_rows float not null,
  percent_failing_rows float not null,
  sampling_used boolean not null,
  sample_size bigint,
  sample_type varchar(256),
  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(dq_rule_id,
  job_run_id))
  

  Instrukcja ALTER TABLE:

  alter table dq_rule_execution add constraint fk_dq_rule_execution_dq_rules_8 foreign key (dq_rule_id) references dq_rules(rule_id) on
  delete
  	cascade on
  	update
  	no action
  

• Db2

  Instrukcja CREATE TABLE:

  create table dq_rule_execution(dq_rule_id varchar(128) not null,
  job_run_id varchar(256) not null,
  start_time timestamp(12) not null,
  end_time timestamp(12) not null,
  nb_tested_rows bigint not null,
  nb_passing_rows bigint not null,
  nb_failing_rows bigint not null,
  percent_passing_rows float not null,
  percent_failing_rows float not null,
  sampling_used boolean not null,
  sample_size bigint,
  sample_type varchar(256),
  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(dq_rule_id,
  job_run_id),
  period SYSTEM_TIME (tech_start,
  tech_end) ) ORGANIZE by row
  

  Instrukcja ALTER TABLE:

  alter table dq_rule_execution add constraint fk_dq_rule_execution_dq_rules_8 foreign key (dq_rule_id) references dq_rules(rule_id) on
  delete
  	cascade on
  	update
  	no action
  

Więcej inform.

• Model danych dla raportowania w produkcie Watson Knowledge Catalog
• Interfejs API danychWatson

Temat nadrzędny: Tabele raportowania