Differences
This shows you the differences between two versions of the page.
en:database [2024/09/11 13:17] – brahmantra | en:database [2024/09/11 13:30] () – brahmantra | ||
---|---|---|---|
1: | 1: | ||
====== DATABASE ====== | ====== DATABASE ====== | ||
+ | * DATABASE DIFFERENCES ON THE BASIS OF DATA STRUCTURE | ||
+ | * [[: | ||
+ | * [[: | ||
+ | * [[: | ||
+ | * DATABASE CONCERNED WITH THE SPECIFIC FIELDS | ||
+ | * [[: | ||
- | * TREES ( HIERARCHIAL DATABASE ) | ||
- | * NESTS | ||
- | * LISTS ( LISTED | ||
- | |||
- | Entities and Attributes | ||
- | |||
- | * 1. Disease | ||
- | * DiseaseID (Primary Key) - (PAGE LEVEL - ALPHABETIC CODE LEVEL) | ||
- | * DiseaseName ( NAME LEVEL ) | ||
- | * Description ( SENTENCE LEVEL AND SENTENCE TYPES ) | ||
- | * Symptoms | ||
- | * Causes | ||
- | * TreatmentMethods | ||
- | * Prognosis | ||
- | * 2. Anatomy | ||
- | * AnatomyID (Primary Key) | ||
- | * AnatomyName | ||
- | * Description | ||
- | * Location | ||
- | * Function | ||
- | * RelatedDiseases | ||
- | * 3. Investigation | ||
- | * InvestigationID (Primary Key) | ||
- | * InvestigationName | ||
- | * Description | ||
- | * Purpose | ||
- | * Procedure | ||
- | * ResultsInterpretation | ||
- | * RelatedDiseases | ||
- | * RelatedAnatomy | ||
- | * 4. Drug | ||
- | * DrugID (Primary Key) | ||
- | * DrugName | ||
- | * GenericName | ||
- | * ChemicalFormula | ||
- | * Dosage | ||
- | * SideEffects | ||
- | * Indications | ||
- | * Contraindications | ||
- | * RelatedDiseases | ||
- | * 5. Technique | ||
- | * TechniqueID (Primary Key) | ||
- | * TechniqueName | ||
- | * Description | ||
- | * Purpose | ||
- | * Procedure | ||
- | * RelatedDiseases | ||
- | * RelatedAnatomy | ||
- | |||
- | |||
- | Relationships Between Entities: | ||
- | |||
- | * Disease-Anatomy: | ||
- | * Disease-Investigation: | ||
- | * Disease-Drug: | ||
- | * Disease-Technique: | ||
- | * Investigation-Anatomy: | ||
- | * Drug-Anatomy: | ||
- | * Technique-Anatomy: | ||
- | |||
- | ===== DATA STRUCTURE | ||
- | |||
- | * Concept: Represents a medical concept (e.g., disease, procedure, anatomical site). Each concept has a unique identifier (concept ID) and a preferred term. | ||
- | * Description: | ||
- | * Relationship: | ||
- | |||
- | **ABSTRACT STRUCTURE ** | ||
- | * Create a root page: This page will represent the top-level of the SNOMED CT hierarchy. | ||
- | * Create child pages: For each concept, create a child page of the root page or another concept page. The page title can be the preferred term of the concept. | ||
- | * Use headings: Use headings (e.g., == Concept Name ==) to represent the concept name. | ||
- | * Add descriptions: | ||
- | * Link concepts: Use internal links (e.g., [[Concept Name]]) to link related concepts. | ||
- | * Represent relationships: | ||
- | |||
- | **Relationships** | ||
- | * **Is a:** [[Parent Concept]] | ||
- | * **Is a part of:** [[Parent Concept]] | ||
- | * **Is associated with:** [[Related Concept]] | ||
- | |||
- | ===== SAMPLE ===== | ||
- | |||
- | == Heart Attack == | ||
- | * **Description: | ||
- | |||
- | === Relationships === | ||
- | * **Is a:** [[Acute Coronary Syndrome]] | ||
- | * **Is associated with:** [[Chest Pain]] | ||
- | * **Is associated with:** [[Shortness of Breath]] | ||