What is the difference between structured and unstructured data in ESG information, and give examples?

What is the difference between structured and unstructured data in ESG information, and give examples?

• A. Unstructured data cannot be analyzed; structured data is text-heavy.
• B. Structured data is largely qualitative; unstructured data is largely quantitative.
• C. Structured data cannot be stored in a relational database; unstructured data can.
• D. Structured data is largely quantitative and easily stored in a relational database; unstructured data is text-heavy, such as news articles and reports.

Answer: (D)

Understanding the data types helps explain how ESG information is stored and analyzed. Structured data is organized into fixed fields in rows and columns, so it’s largely quantitative and easy to store in relational databases. This makes it straightforward to run queries, aggregate results, and generate metrics. In ESG, examples include numeric measures like greenhouse gas emissions, energy use, water intensity, waste recycled, and dates or counts of incidents. Unstructured data isn’t confined to fixed fields; it’s mostly text-heavy or media content that doesn’t fit neatly into a table. Extracting insights from it requires processing such as natural language processing to pull out meaningful numbers or topics. In ESG, this includes news articles about a company’s sustainability performance, annual or sustainability reports, policy documents, emails, and social media posts. So the correct choice captures both parts: structured data is largely quantitative and easily stored in a relational database, while unstructured data is text-heavy and found in sources like news articles and reports.

Understanding the data types helps explain how ESG information is stored and analyzed. Structured data is organized into fixed fields in rows and columns, so it’s largely quantitative and easy to store in relational databases. This makes it straightforward to run queries, aggregate results, and generate metrics. In ESG, examples include numeric measures like greenhouse gas emissions, energy use, water intensity, waste recycled, and dates or counts of incidents.

Unstructured data isn’t confined to fixed fields; it’s mostly text-heavy or media content that doesn’t fit neatly into a table. Extracting insights from it requires processing such as natural language processing to pull out meaningful numbers or topics. In ESG, this includes news articles about a company’s sustainability performance, annual or sustainability reports, policy documents, emails, and social media posts.

So the correct choice captures both parts: structured data is largely quantitative and easily stored in a relational database, while unstructured data is text-heavy and found in sources like news articles and reports.