Distributed Systems: Concepts, Technologies, and Examples
Two-Phase Commit Problems (Locking the entire cluster if one node is down, Possible to implement timeouts, Possible to use Quorum, Quorum: in a distributed environment, if there is a partition, then the nodes vote to commit or rollback)
Vector Clocks (Used for conflict detection of data, Timestamp-based resolution of conflicts is not enough, generating a partial ordering of events in a distributed system and detecting causality violations, A vector clock of a system of N processes is an array/vector
Read MoreUnderstanding Computer Storage: From ROM and RAM to External Drives
Computer Storage: An Overview
A computer utilizes two primary types of storage: main storage and backing storage. Main storage comprises ROM and RAM, while backing storage can be internal, such as a hard disk, or external, like a CD or USB flash drive.
ROM and RAM
ROM (Read-Only Memory)
ROM is non-volatile memory that persists even when the computer is powered off. It stores essential instructions, such as the computer’s startup routine. Neither programs nor users can modify ROM content.
RAM (Random
Read MoreUnderstanding Relational Databases, SQL, and NoSQL: A Comprehensive Guide
1. Informal Design Guidelines for Relational Schema Design
Informal design guidelines for relational schema design help ensure efficiency, flexibility, and manageability. Here are some key guidelines:
- Simplicity: Aim for an easy-to-understand and maintain schema. Avoid excessive complexity.
- Naming Conventions: Use meaningful and consistent names for tables and columns (e.g., use ‘Employee’ instead of ‘Emp’).
- Eliminate Redundancy: Apply normalization techniques (up to the third normal form) to minimize
Understanding Information Systems: Components, Characteristics, and Types
Understanding Information Systems
Meaning and Elements of a System
A system is a set of interconnected things working together towards a common goal. Key elements include:
- Components: The individual parts of the system.
- Relationships: How the components interact and form the system’s structure.
- Purpose: The overall objective of the system.
- Environment: The external context surrounding the system.
- Boundaries: The demarcation between the system and its environment.
Data Transformation into Information
Data
Read MoreIntroduction to Information Systems: Concepts, Components, and Technologies
Read More– Meaning of System is a set of things neatly interrelated contributing to a given objective.
Elements of a system:
– System components.
The relations between them that determine the structure of the system.
“The purpose of the system.
“The system environment: that which surrounds it, within which it is located.
“The system boundaries: the boundary between what the system is and what constitutes the environment.
For the data transformed into information is needed with the data operations that add value
Introduction to Information Systems: Concepts, Components, and Technologies
Read More– Meaning of System is a set of things neatly interrelated contributing to a given objective.
Elements of a system:
– System components.
The relations between them that determine the structure of the system.
“The purpose of the system.
“The system environment: that which surrounds it, within which it is located.
“The system boundaries: the boundary between what the system is and what constitutes the environment.
For the data transformed into information is needed with the data operations that add value