Q3: Compare structured and unstructured data.
Answer:
Structured and unstructured data are two major forms of data in today’s digital world.
Structured data is organized and stored in relational databases, while unstructured data
lacks a predefined model. Both are essential for decision-making, but they differ greatly in
terms of storage, management, and analysis.
Structured Data:
- Stored in predefined rows and columns (tabular format).
- Easy to store in relational databases (SQL).
- Examples: Banking transactions, employee details, product sales records.
Unstructured Data:
- Does not follow a strict format.
- Includes multimedia (images, videos, audio) and text (emails, blogs, social media posts).
- Examples: Tweets, YouTube videos, X-ray images.
Comparison Table:
Aspect Structured Data Unstructured Data
Format Row-column, schema-based Free-form: text, image, video, audio
Storage RDBMS (MySQL, Oracle) NoSQL, Hadoop, cloud storage
Processing Simple with SQL queries Complex, requires AI/ML and NLP
Scalability Vertical scaling Horizontal scaling
Examples Banking transactions, Inventory DB WhatsApp chats, YouTube, PDFs
Conclusion:
Structured data is suitable for transactional systems and traditional analytics, while
unstructured data provides richer insights into customer behavior, sentiments, and
multimedia patterns. Both together form the backbone of modern Big Data analytics and
decision-making systems.
Q4: What are the different characteristics of unstructured data?
Answer:
Unstructured data represents the majority of data generated today, accounting for nearly
80–90% of global data. Its characteristics make it both valuable and challenging.
Key Characteristics:
1. Variety: Comes in different formats such as text documents, images, videos, audio, and
sensor logs.
- Example: Tweets, Facebook posts, PDF reports.
2. Volume: Generated in massive quantities daily through social media, IoT, and digital
devices.
- Example: YouTube uploads over 500 hours of video per minute.
3. Velocity: Produced continuously at high speed in real time.
- Example: Stock market tickers, live sports feeds.
4. Complexity: Analysis is difficult due to mixed formats, languages, and multimedia.
- Example: Voice recognition in call centers.
5. No predefined schema: Unlike structured data, it does not fit neatly into tables.
Use Case:
In healthcare, unstructured data such as X-rays and MRI scans are used with AI to detect
diseases. In marketing, customer reviews help understand satisfaction and improve
services.
Q5: Write short note on unstructured data.
Answer:
Unstructured data refers to any information that does not have a fixed schema or
structure. Unlike relational data, it exists in raw formats such as multimedia files,
documents, and logs.
Importance:
- Represents 80–90% of business data.
- Contains hidden insights about customer behavior and market trends.
- Requires advanced tools such as Hadoop, Spark, and AI/ML algorithms for processing.
Examples:
- Emails and text messages.
- Video surveillance recordings.
- Social media interactions.
- Scientific research documents.
Diagram:
Raw Data → Storage in Data Lakes → Preprocessing (NLP/ML) → Analytics → Business
Insights
Conclusion:
Unstructured data, when properly managed, helps businesses improve decision-making,
personalize services, and maintain a competitive edge in the digital era.
Q6: Brief about the importance of unstructured data.
Answer:
Unstructured data is critical for modern organizations as it reveals information not present
in structured data. Its importance can be explained through the following points:
1. Customer Sentiment Analysis: Reviews, comments, and tweets reveal customer
satisfaction levels.
2. Fraud Detection: Financial institutions analyze unstructured logs and emails to detect
suspicious activity.
3. Healthcare: Medical scans and patient histories (unstructured) assist doctors in
accurate diagnosis.
4. Competitive Advantage: Retailers analyze unstructured shopping behavior to provide
recommendations.
5. Innovation: Research organizations extract insights from published papers and
datasets.
Example: Netflix uses viewing history (videos watched, ratings, browsing activity) to
generate personalized movie recommendations.
Conclusion:
Unstructured data drives real-time insights and innovation, making it an invaluable asset
for decision-making and strategy in every industry.