Notes, abstracts, papers, exams and problems of Computers

Concurrency Control in RDBMS

What are Transactions?

Transactions are sets of operations (like reading or writing data) treated as a single unit. Think of transferring money: multiple steps must happen together.

Isolation Levels

RDBMS uses isolation levels to manage how transactions interact:

• Read Uncommitted: Transactions see changes before they're finalized, which is risky due to potential inaccuracies.
• Read Committed: Transactions only see finalized changes, safer but still prone to inconsistencies.
• Repeatable Read: Data remains unchanged during a transaction, preventing some issues.
• Serializable: Transactions run sequentially, avoiding all problems but potentially slowing performance.

Concurrency Control Techniques

Techniques like locking data, timestamps,... Continue reading "Concurrency Control and ER Model in Database Systems" »

80386 Processor State After Reset

After a reset, the 80386 processor is initialized to a specific state to ensure proper operation. Here's an explanation of the processor state after reset:

1. Operating Mode

The processor is initially in Real Mode after a reset. Real Mode is a backward-compatible mode with earlier x86 processors like the 8086/8088. In Real Mode, the processor operates with a 20-bit address bus, allowing it to address up to 1 MB of memory.

2. Segment Registers

The segment registers CS, DS, SS, and ES are set to 0x0000, pointing to the bottom of the physical memory. In Real Mode, these segment registers are 16 bits wide.

3. Instruction Pointer (IP)

The instruction pointer (IP) is set to 0xFFFF, indicating the initial address from which... Continue reading "Understanding the 80386 Processor State After Reset" »

Sign-Up Form

Name:Date of Birth:

Sign Up

Insertion Sort Algorithm

def insertion_sort(arr) :

for i in range(1, len(arr)):

key = arr[i]

j = i - 1

while j >= 0 and key < arr[j]:

arr[j + 1] = arr[j]

j -= 1

arr[j + 1] = key

# Example usage:

arr = [12, 11, 13, 5, 6]

insertion_sort(arr)

print("Sorted array is:", arr)

Binary Search Algorithm

def binary_search(arr, target):

left, right = 0, len(arr) - 1

while left <= right:

mid = (left + right) // 2

if arr[mid] == target:

return mid

elif arr[mid] < target:

left = mid + 1

else:

right = mid - 1

return -1

# Example usage:

arr = [2, 3, 4, 10, 40]

target = 10

result = binary_search(arr, target)

if result != -1:

print("Element

Constructor

A constructor is a special method in object-oriented programming that is automatically called when an instance (object) of a class is created. The main purpose of a constructor is to initialize the object's attributes (properties) and allocate resources if needed. Constructors have the same name as the class and do not have a return type.

Example of a Constructor

Here is an example in Python:

class Person:
    def __init__(self):
        self.name = "John Doe"
        self.age = 30

# Creating an instance of the Person class
person = Person()

print(person.name)  # Output: John Doe
print(person.age)   # Output: 30

In this example, __init__ is the constructor method in the Person class. It initializes the name and age attributes of the... Continue reading "Understanding Constructors and Class Variables in OOP" »

Classes (الصفوف)

• A class consists of variables (fields) and methods.
• Variables are data members of a class.
• Methods are functions that define the class's behavior.

Variables (المتغيرات)

• Declared with a data type and a name.
• Can be public or private.
• Examples: int age, String name.

Methods (الأساليب)

• Functions that perform specific tasks.
• Can have parameters and return values.
• Types:
  • Void methods: Don't return a value.
  • Return type methods: Return a value.
  • Static methods: Can be called without creating an object.
  • Instance methods: Require an object to be called.
  • Abstract methods: Declared without a body; used in abstract classes.
  • Overloaded methods: Multiple methods with the same name but different parameters.

Constructors (البناؤون)

Microprocessor vs. Microcontroller

ii) Differentiate Between a Microprocessor and a Micro-Controller

Microprocessor

Definition:

A microprocessor is a central processing unit (CPU) on a single integrated circuit (IC) chip that performs the processing functions of a computer.

Functionality:

• It only includes the CPU core and lacks other components like memory, I/O ports, timers, and other peripherals.
• Requires external components like memory (RAM, ROM), input/output devices, timers, and other peripherals to function as a complete system.

Usage:

• Primarily used in systems requiring high computational power and flexibility, such as desktop computers, laptops, servers, and high-end embedded systems.
• Suited for applications where customization of peripherals

1. TCP Congestion Control

Slow Start: TCP initializes congestion window (cwnd) to a small size and doubles it every Round Trip Time (RTT) until a loss occurs (exponential growth) or the slow start threshold is reached.

Congestion Avoidance: After reaching the threshold, cwnd is incremented by one segment for each RTT, growing linearly to avoid congestion.

Fast Recovery: When triple duplicate ACKs are detected, TCP halves the cwnd and reduces the slow start threshold to half of the cwnd size before the loss, then transitions to congestion avoidance.

2. TCP RTT and Timeout

Estimating RTT: Uses Smoothed Round Trip Time (SRTT) which is a weighted average of previous RTT measurements.

Timeout Calculation: Often calculated as Timeout=SRTT+4×RTT

Unit 14: Moving Text

Cutting and Pasting

Anna: Ben, do you know how I can move this paragraph? I want to put it at the end of this page.

Ben: I think so. First, select the text with your mouse. Then, choose "Cut" from the Edit menu.

Anna: Like this?

Ben: Yes. The text disappears and is copied to the Clipboard. Click where you want the text to go.

Anna: Okay. Is that right?

Ben: Yes, if that's the correct spot. Next, choose "Paste" from the Edit menu, or press CTRL+V.

Anna: Okay, done. Is that all?

Ben: Yes. If you make a mistake, choose "Undo" from the Edit menu to reverse your last action.

Anna: Brilliant! Thanks!

Ben: You're welcome.

Unit 15: Spreadsheet Fundamentals

Introduction

Let's start with the basics. Spreadsheets are used in business for financial... Continue reading "Spreadsheet Basics and Text Editing Tips" »

What is Mathematical Logical Thinking?

These are the skills students develop associated with logical and mathematical concepts, reasoning, comprehension, and exploration of the world through real proportions, thus strengthening more abstract aspects of thought.

Geometry with Dinosaurs

This activity involves cutting out various geometric shapes with EVA rubber. Children will then create their own dinosaurs using these shapes. Through this activity, they can learn geometric shapes, count the number of elements used in each dinosaur (like the sides of the shapes), and create new geometric shapes from the ones they already have.

Logical Reasoning with Chupa Chups

This activity consists of creating logically structured material and playing with it using... Continue reading "Developing Logical and Mathematical Thinking in Children" »