Please disable adblock to view this page.

← Go home

Data Models


September 17, 2016
Published By : Pratik Kataria
Categorised in:


  • Entity relationship model
    • Keywords: Entity, Relationship, Attributes
    • Advantages: Easy to develop, Mapping cardinalities, primary key, generalization and specialization
    • Disadvantages: not use for implementation
  • Relational model
    • Keywords: tables, columns with unique names
    • Advantages: Structural independence, Conceptual simplicity, Good for ad hoc requests, Simple to navigate, Greater flexibility
    • Disadvantages: Significant hardware and software overheads, Not as good for modeling, Slower processing times
  • Hierarchical model
    • Keywords: tree structure, main frame database
    • Advantages: High speed of access, ease of updates, simplicity, data security and efficiency
    • Disadvantages: implementation complexity, database management problems, lack of structural independence
  • Network model
    • Keywords: based on directed graph theory, ability to handle n:n relationships
    • Advantages: conceptual simplicity, capability to handle more relationship types, data independence
    • Disadvantages: detailed structural knowledge, lack of structural independence
  • Object oriented model
    • Keywords: based on collection of objects, methods, classes
    • Advantages: requires less code, data access is easy, more natural data model, code easier to maintain
  • Object relational model
    • Keywords: object infrastructe + relational extenders