Data Models
September 17, 2016
Categorised in: Database Management System
- 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
Pratik Kataria is currently learning Springboot and Hibernate.
Technologies known and worked on: C/C++, Java, Python, JavaScript, HTML, CSS, WordPress, Angular, Ionic, MongoDB, SQL and Android.
Softwares known and worked on: Adobe Photoshop, Adobe Illustrator and Adobe After Effects.