Wednesday, September 18, 2013

Must Know-Database Design Models & Terminology

  1. Conceptual Data Model
  2. Logical Data Model
  3. Physical Data Model
Conceptual- Involves entity relationship model at high level. Involves relationship defination w.r.t entity. This may constitutes high level entity boxes with rough relationship and missing cardinality and modality.

Logical Model- This contains ER diagram with details of cardinality and modality. Logical relationship with key entities member defined. Can layout normalization and denormalization as per business and application style specifications.

Physical - It replicates logical and it is phyical table and overall database defination in implementation mode.

Some Key Technology Jargaons

  • Soft Delete
  • Hard Delete
  • Back Door Enteries
  • Audit Trail
  • Master Table
  • Transaction Table
  • DDL
  • DML
  • SandBox
  • Table Lock
  • Primary Key
  • Refrencial Integrity
  • Foreign Key
  • Secondary Key
  • Cardinality
  • Modality
  • Commit RollBack
  • Transactions
  • Records
  • Fields
  • Indexing
  • Clustered vs Non clustered
  • Execution plan
  • Db Advisor
  • Db Examiner
  • SQL Lint
  • Database Schema
  • Replication
  • Cursor
  • Transaction Log
  • Transaction File System
  • Temp DB Shrink
  • Partision Table
  • Scalar Function
  • Aggregate Function
  • Joins-Set based query
  • ACID
  • Atomicity
  • Link Server
  • RDMS-Relational DB Management System
  • Blob- Binary Large object



 
Post a Comment