Effective From DtEffective To DtExperiment DescrExperiment DtGenotype Experiment SkLoad Info SkPlatform TxtProtocol TxtSource Code SkTenant SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | An experiment with the purpose of genotyping an individual. Genotyping is important in research of genes and gene variants associated with disease. 1) Experiment Overview specifies general information that should be provided for the overall experiment, for example, experiment purpose, study personnel, study centers, etc. 2) Experiment Subjects Description specifies information that should be provided to unambiguously interpret how the experimental subjects were recruited and selected, as well as subject and population characteristics collected during the study. 3) Genotyping Procedure provides guidelines to report how biological samples were collected and processed from experimental subjects and how the raw data was generated. This section includes descriptions of the genomic variants assayed and descriptions of genotyping procedures and technologies. 4) Data Transformation section includes specification for reporting the data processing and analysis methods. |
| Attributes | |
| Effective From Dt |
|
| Effective To Dt |
|
| Experiment Descr |
|
| Experiment Dt |
|
| Genotype Experiment Sk |
|
| Load Info Sk |
|
| Platform Txt |
|
| Protocol Txt |
|
| Source Code Sk |
|
| Tenant Sk |
|
| Valid From Ts |
|
| Valid To Ts |
|
| Relationship | |
 Genotype Experiment Detail_Genotype Experiment_FK |
|
| Primary Key | |
 Genotype Experiment Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Experiment Descr
| Description | A description of the experiment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Experiment Dt
| Description | The date upon which the experimental characteristics were defined and recorded. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Genotype Experiment Sk
| Description | The surrogate key for anchor Genotype Experiment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Platform Txt
| Description | A textual description of the equipment that was used to run the experiment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Protocol Txt
| Description | A detailed description as to how the experiment is carried out. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Genotype Experiment Detail_Genotype Experiment_FK
| Is Identifying Relationship | true |
| Child Table | Genotype Experiment Detail |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Genotype Experiment |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Genotype Experiment Detail PK
| Key Attribute | Genotype Experiment Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |