Structured Data | Unstructured data | |
Characteristics | Pre-defined data models | No Pre-defined-data model |
Usually text only | Maybe text, image, sound, video or Other formats | |
Easy to search | Difficult to search | |
Resides in | Relational databases | Applications |
Data warehouses | NoSQL databases | |
Data lakes | ||
Data warehouses | ||
Generatedby | Humans or machines | Humans or machines |
Typical applications | Airline reservation systems | Word processing |
Inventory control | Presentation software | |
ERP systems | Email clients | |
CRM systems | Tools for viewing or editing media | |
Examples | Dates | Text files |
Phone numbers | Reports | |
Social security numbers | Email messages | |
Credit card numbers | Audio files | |
Customer names | Video files | |
Addresses | Images | |
Product names and numbers | Surveillance imagery | |
Transaction Information |