Chapter 1
IT Concepts and Terminology
Course: Comptia Tech Fc0 U71
Subject: Comptia Tech Fc0U71
Chapter: Data And Database Fundamentals
Different types of databases are suited for different kinds of data. The choice between structured, semi-structured, and unstructured data models — as well as relational and non-relational approaches — depends on performance needs, data format, and scalability requirements.
1. Structured vs. Semi-Structured vs. Unstructured Data
Understanding the nature of different data types is essential in database management, data engineering, analytics, and AI development. These three categories define how data is formatted, stored, processed, and used.
| Type | Description | Format Examples | Typical Storage Systems | | Structured Data | Data that is highly organized and follows a strict schema with rows and columns | SQL tables, Excel spreadsheets | Relational Databases (e.g., MySQL, PostgreSQL, Oracle) | | Semi-Structured | Data that has some organizational properties but does not conform to a fixed schema | JSON, XML, YAML, CSV | NoSQL Databases (e.g., MongoDB, DynamoDB, Couchbase) | | Unstructured | Data that lacks a predefined structure, often requiring advanced tools to analyze | Text files, images, videos, emails | Data Lakes, Blob/Object Storage (e.g., AWS S3, Azure Blob), Elasticsearch |