My Obsidian Notes

Home

❯

Tech notes

❯

Terminology & Definitions

❯

Software Terminology

❯

DBA Terminology

❯

Structured vs Unstructured vs Semi Structured Data

Structured vs Unstructured vs Semi-Structured Data

Jul 17, 20251 min read

  • tech
FeatureStructured DataSemi-Structured DataUnstructured Data
FormatFixed schema (tables, rows, columns)No strict schema but has tags/metadataNo predefined structure
ExamplesSQL databases, Excel sheetsJSON, XML, NoSQL databasesEmails, videos, social media posts
StorageRelational Databases (MySQL, PostgreSQL)NoSQL Databases (MongoDB, Cassandra)File systems, Data Lakes, Object Storage
ProcessingEasy with SQL queriesRequires parsing and mapping (XPath, XQuery, JSONPath)Needs AI, NLP, or big data tools

Graph View

Created with Quartz v4.5.1 © 2025

  • GitHub