Browse Definitions :
Definition

structured data

What is structured data?

Structured data is data that has been organized into a formatted repository, typically a database. This is done so the data's elements can be made addressable for more effective processing and analysis. The data resides in a fixed field within a record or file.

Structured data contrasts with unstructured and semi-structured data. The three types of data exist on a continuum, with unstructured data being the least formatted and structured data being the most formatted. The more structured a set of data is, the more amenable to processing and analysis it is.

How does structured data work?

Structured data needs a data model and data repository, which is usually a database. A data model organizes elements of data and defines how they relate to one another. For example, a data model might specify that the data element representing a customer in a database contain several smaller elements or attributes that represent specific customer information. Examples of structured data in this scenario include a person's name, phone number, address and ZIP code.

The structure of the data might be enforced. For example, the ZIP code field might only accept numeric data that is five characters long. This maintains the integrity of the data, while preventing data that doesn't fit this description from being entered into the schema. The nature of structured data is that it can be logically grouped by similar values and constraints.

Data is defined narrowly by these constraints and written to defined slots in a data repository. For instance, in a database, each field in a record is discrete, and its information can be retrieved either on its own or along with data from other fields, in a various combination.

Databases make data more comprehensive so that it yields useful information. Structured data might also be stored in rows and columns in a relational database, which links tables of data together so they can be tapped by a broader set of search criteria to return more detailed information.

A database query language, such as structured query language (SQL), lets a database administrator interact with and manipulate the data in the database. Extract, transform and load (ETL) processes are sometimes used to integrate different structured databases into a data warehouse.

Table showing relational vs. nonrelational databases
Relational databases handle structured data, while nonrelational databases deal with unstructured data.

Benefits and drawbacks of structured data

There are many benefits to using structured data, including:

  • Storage. Because structured data is predefined within a series of constraints, it is easier to organize and store, especially in comparison to unstructured data.
  • Security. Narrow constraints make structured data easier to secure. Good data security requires data classification, which is facilitated when data falls into a ready-made data structure.
  • Data analysis. When there is more descriptive information attached to data, it's easier to process, analyze and draw inferences from it.
  • Easy to understand. Narrow constraints allow data to be quickly understood and used. Business users can read and understand structured data without needing to know a great deal about data formatting and databases.

There are also drawbacks to structured data, such as:

  • Rigid schema. Structured data must conform to a schema that dictates a predefined purpose. This approach can limit how the data is used. Data that does not conform to a particular schema might not be able to be processed in a structured database.
  • Missing data. Because data must adhere to certain data format, businesses might miss out on unstructured data that could improve decision-making.
  • Underrepresented. Modern devices generate a lot of unstructured and semi-structured data. Businesses must find a way to use this data, which might not fit neatly into a predetermined schema. If businesses only focus on collecting and processing structured data, they will not be able to capitalize on the full range of opportunity that internet of things devices and big data offer.

Use cases for structured data

Some common examples of how structured data is used include:

  • Search engine optimization tool. For search engines, website owners can edit their site's HTML to describe their webpage using a series of HTML tags, called microdata. Marking up a website with microdata tags helps search engines understand the website better and makes it more likely to appear in search results. Schema.org is a community that creates, maintains and promotes shared vocabularies of microdata that can be used to mark up webpages. In this context, structured data is functioning like metadata.
  • Machine learning algorithm training. Programmers use structured data to write and augment machine learning algorithms that use supervised learning. In supervised learning, machines are trained using well-labeled training data; structured data tends to apply more easily to the machine's rules.
  • Data management. Business intelligence software might use SQL databases or Excel files to track basic data such as customer contact information, account credentials and financial transactions. Some tools used to store structured data include online analytical processing, MySQL and PostgreSQL.
  • ETL. This process involves extracting data from original data sources, transforming it by cleaning it up and then loading it into a larger data repository such as a data warehouse.
Table showing structured vs. unstructured data
Key areas of differentiation between structured and unstructured data include the type of analysis, schema used, type of format and various storage criteria.

Structured vs. unstructured data

There are several key differences between unstructured and structured data. Whereas structured data is highly specific and conforms to a predefined data model, unstructured data does not. Unstructured data is generally stored in its native format. It is more plentiful and flexible than structured data, but it is harder to manipulate and often requires more advanced methods and data science techniques to do so.

Examples of unstructured data include social media posts; IoT remote sensor data; rich media, such as images, video and audio; and webpages. Unstructured data is often stored in data lakes.

When the HTML microdata function is used as an SEO tool, it helps provide structure to the otherwise unstructured data of webpages.

List of unstructured data types
Unstructured data can come from the web or other applications and does not need to fit into a predefined schema to be stored or used.

Data lake governance can be difficult because of the sheer amount of unstructured data stored. Learn some governance principles and best practices to keep a data lake from becoming a data swamp.

This was last updated in January 2023

Continue Reading About structured data

Networking
  • SD-WAN security

    SD-WAN security refers to the practices, protocols and technologies protecting data and resources transmitted across ...

  • net neutrality

    Net neutrality is the concept of an open, equal internet for everyone, regardless of content consumed or the device, application ...

  • network scanning

    Network scanning is a procedure for identifying active devices on a network by employing a feature or features in the network ...

Security
  • virtual firewall

    A virtual firewall is a firewall device or service that provides network traffic filtering and monitoring for virtual machines (...

  • cloud penetration testing

    Cloud penetration testing is a tactic an organization uses to assess its cloud security effectiveness by attempting to evade its ...

  • cloud workload protection platform (CWPP)

    A cloud workload protection platform (CWPP) is a security tool designed to protect workloads that run on premises, in the cloud ...

CIO
  • Regulation SCI (Regulation Systems Compliance and Integrity)

    Regulation SCI (Regulation Systems Compliance and Integrity) is a set of rules adopted by the U.S. Securities and Exchange ...

  • strategic management

    Strategic management is the ongoing planning, monitoring, analysis and assessment of all necessities an organization needs to ...

  • IT budget

    IT budget is the amount of money spent on an organization's information technology systems and services. It includes compensation...

HRSoftware
  • ADP Mobile Solutions

    ADP Mobile Solutions is a self-service mobile app that enables employees to access work records such as pay, schedules, timecards...

  • director of employee engagement

    Director of employee engagement is one of the job titles for a human resources (HR) manager who is responsible for an ...

  • digital HR

    Digital HR is the digital transformation of HR services and processes through the use of social, mobile, analytics and cloud (...

Customer Experience
  • chatbot

    A chatbot is a software or computer program that simulates human conversation or "chatter" through text or voice interactions.

  • martech (marketing technology)

    Martech (marketing technology) refers to the integration of software tools, platforms, and applications designed to streamline ...

  • transactional marketing

    Transactional marketing is a business strategy that focuses on single, point-of-sale transactions.

Close