Structured vs Unstructured Data

Question 1

What is the difference between Structured and Unstructured Data? Provide an example of structured data.

Answer 1

• Structured Data is Data that has been entered into a table in a database; has a rigid schema (rows and columns). E.g: Spreadsheet in Microsoft Excel.
• Unstructured Data is data that hasn’t been organized into tables; doesn’t have a rigid schema. E.g: Text document within word.

Question 2

What is Semi-Structured Database?

Answer 2

Is a database that dosen’t have a rigid schema like a structured database but still has some structure to it when it comes to storing data.