Database - Week 2

Quiz

Capture

“GET THE DATA“

The exact moment data is born or recorded into a system.

Example:

You enroll in school and enter:

Name: Maria
Student ID: 12345
Course: BSIT

Storage

“KEEP THE DATA”

Housing the data with physical and logical organization.

For example:

Database server → Student Records Database

Maintenance

“PROTECTING THE DATA“

Defending against inevitable decay and corruption.

Examples:

• Updating incorrect information

• Backing up the database

• Checking for corrupted data

• Protecting it from unauthorized access

Retrieval

"GET THE DATA BACK"

Delivering the right information to authorized users.

For example:

A teacher asks:

"Show me Maria's grades."

The database finds Maria's record and gives it to the authorized teacher.

Disposal

"DESTROY THE DATA"

The secure assassination of expired data to eliminate liability.

"Secure assassination" basically means securely deleting the data.

Creation

Generating net-new information

👉 You're creating something new.

• Examples: Writing a business proposal, coding a new software module, drafting a memo.

Capture

Recording existing real-world events or facts into a system.

👉You RECORD information that already exists

Examples:

Barcode: A customer buys a product → cashier scans the barcode → system records the sale.

The Concept

Data should be captured exactly where and when the business event occurs, by the person or device closest to it.

“Re-enter” step

If a customer fills out a paper form, and a clerk types it into a computer later, you have introduced a?

Validation at Point of Entry

Check the data at the moment it is entered.

IoT (Internet of Things)

Sensors capturing machine data (e.g., a delivery truck's GPS and engine temperature).

Examples:

• 📱 Smartphone → connects to the internet

• ⌚ Smartwatch → tracks your steps and sends data to your phone

• 🏠 Smart lights → you can turn them on/off using your phone

• 🚗 Smart car → can send information about the car's condition

• 🌡 Smart thermostat → detects temperature and adjusts automatically

OCR (Optical Character Recognition)

Scanning a physical ID and automatically extracting the text.

APIs (Aoolication Programming Entrfaces)

Systems capturing data directly from other systems (e.g., your school's system capturing payment confirmations directly from GCash/Maya).

“A bridge that lets systems talk and exchange data.“

Speed vs Cost vs Durability

What are the trade-off tringle?

SSD / RAM

Extremely fast, very expensive, volatile/less durable. (Used for active processing).

Magnetic Tape/Cloud Glacier

Very slow to retrieve, incredibly cheap, highly durable. (Used for long-term backups).

useless

Storage without organization is?

Taxonomy

The aisles and shelves organize the boxes into groups.
In IT, this is like:

• Folders

• Categories

• Tags

Metadata

"Data about data."

Each box has a label telling you what's inside.

Indexing

Creating a "cheat sheet" for the database so it doesn't have to read every single row to find what you want.

Taxonomy, Metadata, Indixing

What are the three Organizational tool IT/CS?

Security, Accessibility, Redundancy

The three imperatives of modern storage

Security

Encryption at rest. Protecting the binary data (protecting data while it sits on the hard drive).

Accessibility

Ensuring data is immediately available to authorized stakeholders when requested.

Redundancy

RAID configurations, replicating data across multiple cloud availability zones.