Unit 5: Database Management System
DBMS 1: Data Storage Foundations & Big Data Fundamentals
ICT 110: IT for Business
🎯 Session Overview (1 Hour)
This session consolidates foundational concepts of data storage and big data, focusing on their strategic importance across all business functions.
- ✅ 0-15 min: Data Storage & Database Fundamentals
- ✅ 15-30 min: Structured vs Unstructured Data & Data Retrieval
- ✅ 30-45 min: Introduction to Big Data (5 Vs)
- ✅ 45-60 min: Big Data's Strategic Value & Real-World Examples
Why Data Storage Matters to Business 💼
Data is a core business asset — just like cash, buildings, or inventory.
Availability ⚡
Data is accessible when needed by authorized users.
Integrity ✓
Data is correct, consistent, and trustworthy throughout its lifecycle.
Foundation 🏗️
It grounds all business intelligence, reporting, and strategic decision-making.
Bottom Line: How you store data determines its business value.
Evolution: From Paper to Cloud ☁️
Traditional Storage 🗄️
- Paper files (physical, hard to share)
- Local hard drives (limited access)
- On-premise servers (expensive to scale)
Challenge: Hard to access, share, and analyze. High data loss risk.
Modern Storage ☁️
- Databases (SQL, NoSQL)
- Data Warehouses (centralized analytics)
- Cloud Storage (AWS, Azure, Google)
Advantage: Scalable, accessible globally, enables powerful analytics.
Two Types of Business Data 📊
Structured Data 📈
Data organized in rows & columns (like a spreadsheet).
- Finance: Transaction records
- HR: Employee details (ID, name, salary)
- Operations: Inventory levels (SKU, qty, location)
- Marketing: Customer transactions ($, date, product)
Unstructured Data 📄
Data without predefined format (text, images, video).
- Marketing: Customer reviews, social media posts
- HR: Resumes, meeting recordings
- Operations: Equipment logs, maintenance notes
- General: Internal emails, documents
The Database: Organization's Data Engine 🛠️
A Database is an organized collection of structured information stored electronically in a computer system.
University Library Analogy 📚
- The Library: The database (stores all books/data)
- Card Catalog: The index (finds things quickly)
- Librarian: The DBMS (manages, secures, retrieves everything)
Key Benefit: A good DBMS lets managers ask questions like "Show me all Finance department employees with salary > NPR 90,000" without knowing how to code.
Data Retrieval Across Business Functions 🎯
Finance 💰
- Quarterly reporting (pulling all Q transactions)
- Budgeting & forecasting (3-year spending analysis)
- Compliance checks (transactions > NPR 1M)
Operations ⚙️
- Real-time inventory tracking
- Logistics optimization
- Production planning
- Quality control
HR 🤝
- Recruitment candidate search
- Payroll processing
- Performance management
- Workforce planning
Key Insight: Every business function depends on being able to ask the right data questions.
Transition: From Data to Big Data
As businesses accumulate more data from more sources, a fundamental challenge emerges:
Question: What happens when data becomes too large, too fast, and too diverse for traditional database systems to handle?
➡️ Welcome to Big Data
Big Data Definition 📊
Big Data: Extremely large and complex datasets that cannot be easily managed or analyzed with traditional tools. It's about the potential to uncover patterns and insights for strategic advantage.
NOT just about volume — it's about complexity and the business value hidden within it.
Example: A bank with 1 million customers has "large data." But analyzing these millions of transactions in real-time to detect fraud = Big Data opportunity. 🎯
The 5 Vs of Big Data 🎲
📊 Volume
The sheer scale: Terabytes to petabytes of data.
Example: Facebook generates 4+ petabytes daily.
⚡ Velocity
Speed of creation & processing: Real-time streams.
Example: Stock market trades processed in microseconds.
🔍 Variety
Multiple formats: Spreadsheets, text, images, sensors, video.
Example: Netflix analyzes video viewing, clicks, ratings.
✓ Veracity
Quality & accuracy. Poor data = poor decisions.
💰 Value
Business outcomes. Data without value is just noise.
Why Big Data Matters to Business 🎯
- 🎯 Enhanced Decision-Making: From gut-feeling to evidence-based strategy.
- ⚙️ Operational Excellence: Identify bottlenecks, reduce waste, optimize processes.
- 🤝 Customer Intelligence: Analyze behavior for personalization and loyalty.
- 🔐 Risk & Fraud Detection: Real-time pattern recognition.
- 💡 Innovation: Discover new products, services, and market opportunities.
Big Data Across Business Functions 📈
Operations & Supply Chain ⚙️
- Predictive Maintenance: Sensor data predicts machine failures before they happen.
- Route Optimization: Real-time traffic & weather data minimizes delivery time.
- Inventory Prediction: Demand forecasting prevents stockouts & overstocking.
Example: CG Foods uses sales data to decide which Wai Wai flavor to produce.
Finance 💰
- Fraud Detection: Millions of transactions analyzed in real-time.
- Credit Risk: Predict likelihood of loan defaults.
- Algorithmic Trading: Speed and pattern recognition create competitive edge.
- Compliance: Automated monitoring of regulatory requirements.
Example: Banks flag unusual spending (foreign purchases) instantly.
Big Data in HR & Marketing 📊
Human Resources 🤝
- Smarter Recruiting: Analyze CVs & networks to predict hire success.
- Retention Prediction: Identify at-risk employees before they leave.
- Fair Performance: Reduce bias with objective metrics.
- Workforce Planning: Forecast future hiring needs.
Marketing & Sales 🎯
- Customer Segments: Group by behavior, not just demographics.
- Sentiment Analysis: Gauge brand opinion from social media in real-time.
- Recommendations: "You might also like..." (Netflix, Daraz model).
- Dynamic Pricing: Adjust prices based on demand & supply.
Big Data in Nepal 🇳🇵
eSewa (FinTech)
Big Data Use: Fraud detection, spending patterns, personalized services.
Impact: Protects millions of users in the digital payment ecosystem.
Daraz (E-commerce)
Big Data Use: Inventory prediction by city, demand forecasting, recommendations.
Impact: Optimizes logistics across all of Nepal and the region.
Pathao (Ride-Sharing)
Big Data Use: Real-time GPS analysis, surge pricing, route optimization.
Impact: Matches drivers & riders in real-time, maximizes efficiency.
📌 Session Takeaways
- 1️⃣ Data Storage Foundation: Proper storage of structured and unstructured data is the backbone of all business operations.
- 2️⃣ Database as Strategy: The ability to query data is a core business competency, not just an IT function.
- 3️⃣ Big Data Opportunity: Volume + Velocity + Variety + Veracity + Value = Competitive Advantage.
- 4️⃣ Cross-Functional Impact: All business functions — Operations, Finance, HR, Marketing — are transformed by data-driven insights.
- 5️⃣ Next Step: Understanding how to manage, secure, and ethically use this data is critical (coming in DBMS 2).