[Analysis] Structured and Unstructured Data – Semi-structured Data | Storage | Examples

  • Blog|FEMA & Banking|
  • 7 Min Read

Structured, unstructured and semi-structured data explained from IIBF’s Emerging Technologies courseware, with examples, the differences between them and how each is stored.

  • By Taxmann
  • |
  • Last Updated on 14 November, 2026

Structured and Unstructured Data

Structured and unstructured data differ in how they are organised. Structured data follows a predefined format, usually rows and columns in a relational database, so it is easy to search and analyse. Unstructured data, such as emails, documents, images, audio and social media posts, has no predefined format or data model and is usually kept in data lakes or NoSQL databases. Semi-structured data, such as JSON, CSV and XML files, sits between the two. The IIBF courseware on Emerging Technologies puts unstructured data at 80 per cent or more of all enterprise data.

Table of Contents

  1. What are the types of data?
  2. What is structured data?
  3. What is unstructured data?
  4. What is semi-structured data?
  5. What is the difference between structured and unstructured data?
  6. Where are structured and unstructured data stored and used?
  7. How should banks manage and store data?
  8. Quick answers

1. What are the types of data?

Data can be grouped by how it is organised and by where it comes from. By organisation, data is structured, unstructured or semi-structured. Some data is structured, but a large portion is unstructured, and each type needs different methods of analysis and storage.

By source, there is primary data and secondary data. Researchers collect primary data directly, through interviews, surveys, questionnaires, observations and experiments, and it is considered the most valuable because it comes straight from the source. Secondary data has been gathered by someone other than the researcher, such as government census or demographic data, administrative data, books, journals, newspapers and websites, and it is more readily available.

A business draws its data from sources such as customer feedback, sales data and demand patterns, social media, reports on online engagement, and transactional information from sales reports, ledgers and online payment transactions.

2. What is structured data?

Structured data is data stored in a predefined format within a file or record, usually in rows and columns. It is normally kept in a Relational Database Management System (RDBMS), which allows efficient storage, retrieval and analysis. Structured data can hold numbers and text, and it depends on a data model that defines what types of data to include and how to store and process them.

It is usually quantitative, and it is highly organised, which makes it easy for machine learning algorithms to read. Names, dates, addresses, credit card numbers, stock information and geolocation are typical examples.

The sample of structured data in the courseware comes from banking: a table of advances with columns for borrower number, name, type of advance, sanctioned limit, interest rate and amount outstanding. Every record fits the same fields, so the data can be searched easily in a relational database.

Taxmann.com | Research | Subscribe Now!

3. What is unstructured data?

Unstructured data is data that does not follow a predefined format or data model. It may have some internal structure, but it is not organised in a way that traditional data analysis tools can easily process. It is generally qualitative, and it is stored in non-relational (NoSQL) databases, which need no fixed schema, or kept in its raw form in data lakes.

People generate much of it: word-processing documents, presentations and logs; the message field of an email; social media data from Facebook, Twitter and LinkedIn; photo and video sites such as YouTube and Instagram; text messages; chat, instant messaging and phone recordings; and media such as MP3s, digital photos, audio and video files. Machines generate it too, in satellite imagery, scientific data from oil and gas exploration, space exploration and seismic imaging, surveillance photos and video, and readings from traffic, weather and oceanography sensors.

Unstructured data accounts for 80 per cent or more of all enterprise data, and the share is increasing. A business that ignores it misses a great deal of valuable business intelligence, which is why the most comprehensive big data analysis uses both structured and unstructured data.

4. What is semi-structured data?

Semi-structured data combines features of structured and unstructured data. It follows a certain schema and consistency but has no predefined data model, so it does not fit the formal structure of a relational database. It is more complex than structured data but easier to store than unstructured data, and it uses metadata, such as tags and semantic markers, to identify data characteristics and organise data into records and preset fields. In this sense it works as a bridge between structured and unstructured data.

A photo stored on a smartphone is a typical example: the image itself is unstructured, but the time, location and other tags attached to it are structured. Other examples are JSON, CSV and XML files, electronic mail, HTML and web pages, tools for maintaining non-relational data, and EDI (Electronic Data Interchange), a collection of standards for exchanging business information. CSV, XML and JSON are the three main formats used to transfer data between a web server and a client.

Email shows how blurred the line can be. Its metadata gives it some internal structure, so it is sometimes semi-structured, but its message field is unstructured.

5. What is the difference between structured and unstructured data?

Structured data has a predefined data model and is easy to search, while unstructured data has no predefined model, comes in many formats, shapes and sizes, and needs processing before it can be understood. The main differences are:

Point of difference Structured data Unstructured data
Data model Predefined; formatted to a set structure before it is stored None; stored in its native format until it is extracted for analysis
Nature Quantitative: numbers, values and strings Qualitative: images, audio, video, sensor data, text files and more
Examples Dates, customer names and addresses, credit card numbers Emails, text files, reports, audio and video files, images, scanned PDFs
Where it is stored Tabular formats such as Excel sheets and SQL databases, and data warehouses Media files, NoSQL databases and data lakes
Storage space Requires less Requires more
Analysis Classification, regression and clustering Advanced analytics such as data mining and data stacking
Scaling Tools scale vertically, adding processing power, memory or storage to a single node Tools scale horizontally, adding more nodes
Ease of use Easy to search and understand Difficult to search and understand

Without a predefined structure, data mining becomes complicated. That is why handling rich media, blogs, social media data and customer communication calls for its own best practices.

6. Where are structured and unstructured data stored and used?

Structured data is usually stored in relational databases and data warehouses, while unstructured data fits best in non-relational (NoSQL) databases and data lakes.

Tools for structured data include OLAP, for high-performance, multidimensional analysis from central data stores; SQLite, a self-contained, serverless relational database engine that needs no configuration; MySQL; and PostgreSQL, which supports SQL and JSON querying. Tools for unstructured data include MongoDB, which uses flexible documents; DynamoDB; Hadoop, a framework for the distributed processing of large data sets; and Azure, a cloud platform that can store, process and consume both structured and unstructured data at scale.

The uses differ too. Structured data runs customer relationship management (CRM) software, online booking of hotels and tickets, and the recording of financial transactions in accounting. Unstructured data supports data mining to identify consumer behaviour, product sentiment and purchasing patterns, predictive data analytics that warns businesses of significant market shifts, and chatbots that analyse text to route customers’ questions to the right answers.

7. How should banks manage and store data?

Integrity and availability of data are of paramount importance in banking, and unstructured data should follow the same access rules as structured data. The courseware gives five best practices for keeping unstructured data under control:

  • Use only trusted data sources, vetting any external provider, its data sources and how it prepares and secures the data.
  • Set guidelines for user access and permissions, limit access to users who need the data, define privileges by job function or role, and review access controls periodically.
  • Secure unstructured data to the same level as structured data, with trusted networks, strong access controls, user monitoring, perimeter defence, data leakage prevention, physical protection of hardware and cloud security protocols.
  • Track who or what is accessing the data, when and from where.
  • Dispose of bad data as a continuous process, and refresh big data repositories so that data no longer needed is discarded.

Storage itself comes in three broad types. Direct attached storage (DAS) is part of, or connected directly to, a host computer; it is basic, cheaper and needs minimum maintenance, but sharing data between systems is harder. Network-attached storage (NAS) lets multiple systems share common storage over a network and is a top choice for small and medium-sized businesses. A storage area network (SAN) is a dedicated, high-performance system that transfers block-level data between servers and storage devices, suited to mission-critical operations in data centres and large enterprises. Efficient storage gives a bank reliable preservation of data, round-the-clock access, quick recovery after a disaster, easy scalability and data protection.

8. Quick answers

What is the difference between structured and unstructured data?

Structured data has a predefined format, usually rows and columns in a relational database, and is easy to search. Unstructured data has no predefined format or data model, comes in many formats such as emails, images and videos, and is harder to search and analyse.

What is structured data?

Structured data is stored in a predefined format, usually rows and columns in a relational database management system (RDBMS). Names, dates, addresses, credit card numbers and stock information are examples.

What is unstructured data?

Unstructured data does not follow a predefined format or data model. Emails, word-processing documents, social media posts, photos, audio and video files are examples, and it is usually stored in NoSQL databases or data lakes.

What is semi-structured data?

Semi-structured data combines features of both. It has no predefined data model but uses metadata such as tags to organise data. JSON, CSV and XML files, emails and photos on a smartphone are examples.

Is email structured or unstructured data?

Email is partly both. Its metadata gives it some internal structure, so it is sometimes semi-structured, but its message field is unstructured.

Where is unstructured data stored?

Unstructured data is stored in non-relational (NoSQL) databases or kept raw in data lakes. Structured data is usually stored in relational databases and data warehouses.

How much enterprise data is unstructured?

Unstructured data accounts for 80 per cent or more of all enterprise data, and the share is increasing.

What are the types of data?

By organisation, data is structured, unstructured or semi-structured. By source, it is primary data, collected directly by the researcher, or secondary data, gathered by someone else.


Chapter 1 of Emerging Technologies (2026 Edition), the Indian Institute of Banking & Finance’s courseware for its Certificate Course on Emerging Technologies, published by Taxmann, introduces data analytics, from the information value chain, data sources and the types of data to types of data storage, cloud storage, data extraction and the types of data analytics. It ends with multiple choice questions and terminal questions for practice.

For the rules that banks work under, Taxmann.com | Research, FEMA & Banking brings together the Acts, Rules, circulars and notifications, case laws and articles on FEMA, banking and insurance. Taxmann.com | Store also lists IIBF’s courseware for its other certificate courses, including Information System for Banks and IT Security.

Related reading: data summarisation and visualisation strategies · the role of big data analytics in chartered accountancy.

More in this series: emerging technologies in banking · types of data analytics · characteristics of big data · the Hadoop ecosystem · types of machine learning.

Based on the 2026 Edition of Emerging Technologies, IIBF’s courseware for the Certificate Course on Emerging Technologies.

Disclaimer: The content/information published on the website is only for general information of the user and shall not be construed as legal advice. While the Taxmann has exercised reasonable efforts to ensure the veracity of information/content published, Taxmann shall be under no liability in any manner whatsoever for incorrect information, if any.

Leave a Reply

Your email address will not be published. Required fields are marked *

Everything on Tax and Corporate Laws of India

To subscribe to our weekly newsletter please log in/register on Taxmann.com

Author: Taxmann

Taxmann Publications has a dedicated in-house Research & Editorial Team. This team consists of a team of Chartered Accountants, Company Secretaries, and Lawyers. This team works under the guidance and supervision of editor-in-chief Mr Rakesh Bhargava.

The Research and Editorial Team is responsible for developing reliable and accurate content for the readers. The team follows the six-sigma approach to achieve the benchmark of zero error in its publications and research platforms. The team ensures that the following publication guidelines are thoroughly followed while developing the content:

  • The statutory material is obtained only from the authorized and reliable sources
  • All the latest developments in the judicial and legislative fields are covered
  • Prepare the analytical write-ups on current, controversial, and important issues to help the readers to understand the concept and its implications
  • Every content published by Taxmann is complete, accurate and lucid
  • All evidence-based statements are supported with proper reference to Section, Circular No., Notification No. or citations
  • The golden rules of grammar, style and consistency are thoroughly followed
  • Font and size that's easy to read and remain consistent across all imprint and digital publications are applied