Algorithm TxtChi Square RtDistance QtyDistance UOM Code SkD Prime RtEffective From DtEffective To DtLinkage Analysis SkLoad Info SkLOD Score RtParameter TxtP Value RtSource Code SkTenant SkTheta RtValid From TsValid To TsZ mean Rt
| Atomic Warehouse Model Data Model |
| Description | Contains linkage, linkage disequilibrium, and association data on Cohorts of Subjects. |
| Relationship | |
 Linkage Analysis Detail_Linkage Analysis_FK |
|
| Primary Key | |
 Linkage Analysis Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Algorithm Txt
| Description | The algorithm use to define results. |
| 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 |
Chi Square Rt
| Description | A statistical value. A measurement of how expectations compare to results. Chi Square is employed to test the difference between an actual sample and another hypothetical or previously established distribution such as that which may be expected due to chance or probability. Chi Square can also be used to test differences between two or more actual samples. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Distance Qty
| Description | A statistical value. Physical distance between two loci |
| Data Type | Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Distance UOM Code Sk
| Description | It is a unit of measure type for Physical distance between two loci. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
D Prime Rt
| Description | A statistical value. The amount of Linkage disequilibrium (LD) between the Quantitative Trait Locus (QTL) Analysis and the marker is specified as D-prime (0 d 1). A value of 0 indicates that the two loci are in complete equilibrium, whereas 1 represents the highest amount of disequilibrium possible is present (this amount depends of the relative allele frequencies of QTL and marker - i.e. complete disequilibrium could never be observed if the allele frequencies are different at QTL and marker). D-prime is related to other common measures of LD, such as R-squared (the square root of D-prime -- see the abovementioned article for further detail). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
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 |
Linkage Analysis Sk
| Description | The surrogate key for anchor Linkage Analysis. |
| 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 |
LOD Score Rt
| Description | A statistical value. (logodds). The LOD score (logarithm (base 10) of odds), developed by Newton E. Morton, is a statistical test often used for linkage analysis in human, animal, and plant populations. The LOD score compares the likelihood of obtaining the test data if the two loci are linked, to the likelihood of observing the same data purely by chance. Positive LOD scores favor the presence of linkage, whereas negative LOD scores indicate that linkage is less likely. Computerized LOD score analysis is a simple way to analyze complex family pedigrees in order to determine the linkage between Mendelian traits (or between a trait and a marker, or two markers). By convention, a LOD score greater than 3.0 is considered evidence for linkage. A LOD score of +3 indicates 1000 to 1 odds that the linkage being observed did not occur by chance. On the other hand, a LOD score less than -2.0 is considered evidence to exclude linkage. Although it is very unlikely that a LOD score of 3 would be obtained from a single pedigree, the mathematical properties of the test allow data from a number of pedigrees to be combined by summing the LOD scores. It is important to keep in mind that this traditional cutoff of LOD+3 is an arbitrary one and that the difference between certain types of linkage studies, particularly analyses of complex genetic traits with hundreds of markers, these criteria should probably be modified to a somewhat higher cutoff. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Parameter Txt
| Description | The parameters used in the linkage analysis. |
| 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 |
P Value Rt
| Description | A statistical value. Measure of Statistical significance: P-value. It indicates the probability of obtaining results. That is whether the marker was not associated with variation for the trait. The lower the P-value, the higher the probability that a Quantitative Trait Locus (QTL) truly exists in the region of marker. Generally confidence in QTL is not fixed unless the P-value of the linked marker is less than 0.01. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| 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 |
Theta Rt
| Description | A statistical value. Theta is the recombinant fraction, it is equal to R / (NR + R) NR denotes the number of non-recombinant offspring, and R denotes the number of recombinant offspring. The reason 0.5 is used in the denominator is that any alleles that are completely unlinked (for example, alleles on separate chromosomes) have a 50% chance of recombination, due to independent assortment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 |
Z mean Rt
| Description | A statistical value. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Linkage Analysis Detail_Linkage Analysis_FK
| Is Identifying Relationship | true |
| Child Table | Linkage Analysis 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 | Linkage Analysis |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Linkage Analysis Detail PK
| Key Attribute | Linkage Analysis Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |