Structured data and semi-structured data
Posted: Sun Feb 02, 2025 4:04 am
Unstructured data is information that does not follow a fixed or predefined format. It lacks formal organization and does not fit easily into tabular structures commonly found in relational databases.
These include unformatted text documents, images, audio, video, and data from social networks such as posts and tweets. The lack of a uniform structure makes analyzing and extracting insights from this data challenging.
Semi-structured data has some form of structure, but it is not as rigid as that found in fully structured data. It may include tags, markers, or other forms of organization that provide some degree of structure, although not as formal as the tables in a relational database.
Examples are documents in XML or JSON ivory coast telegram data format, CSV files with some flexibility in columns, HTML data, and emails with a defined structure, such as headers and body.
3. Graph database
A graph database is a type of database management system (DBMS) that uses graph structures to represent and store data.
Instead of relying on tables and relationships as in relational databases, they consist of nodes, edges, and properties. Each node represents an entity, each edge a relationship between the entities, and properties provide additional information about the nodes and edges.
4. Hierarchical database
Hierarchical models, often represented by XML or JSON, are suitable for data organized in a hierarchy. They are common in environments where the data structure is predefined and follows a hierarchical tree, such as in system configurations.
The choice between them often depends on the specific needs of the application and the preferences of the developer community.
XML
XML ( Extensible Markup Language ) is a markup language that allows the structured representation of data in a hierarchical manner. In a hierarchical XML model, data is organized into nested elements, forming a tree structure.
Each element can contain attributes and data, and the hierarchy is indicated by how they are nested within each other.
JSON
As for JSON ( JavaScript Object Notation ), it is a lightweight and easy-to-read data interchange format. Like XML, JSON can represent data in a hierarchical way.
In a hierarchical JSON model, data is organized as key-value pairs within objects and arrays, forming a nested structure.
These include unformatted text documents, images, audio, video, and data from social networks such as posts and tweets. The lack of a uniform structure makes analyzing and extracting insights from this data challenging.
Semi-structured data has some form of structure, but it is not as rigid as that found in fully structured data. It may include tags, markers, or other forms of organization that provide some degree of structure, although not as formal as the tables in a relational database.
Examples are documents in XML or JSON ivory coast telegram data format, CSV files with some flexibility in columns, HTML data, and emails with a defined structure, such as headers and body.
3. Graph database
A graph database is a type of database management system (DBMS) that uses graph structures to represent and store data.
Instead of relying on tables and relationships as in relational databases, they consist of nodes, edges, and properties. Each node represents an entity, each edge a relationship between the entities, and properties provide additional information about the nodes and edges.
4. Hierarchical database
Hierarchical models, often represented by XML or JSON, are suitable for data organized in a hierarchy. They are common in environments where the data structure is predefined and follows a hierarchical tree, such as in system configurations.
The choice between them often depends on the specific needs of the application and the preferences of the developer community.
XML
XML ( Extensible Markup Language ) is a markup language that allows the structured representation of data in a hierarchical manner. In a hierarchical XML model, data is organized into nested elements, forming a tree structure.
Each element can contain attributes and data, and the hierarchy is indicated by how they are nested within each other.
JSON
As for JSON ( JavaScript Object Notation ), it is a lightweight and easy-to-read data interchange format. Like XML, JSON can represent data in a hierarchical way.
In a hierarchical JSON model, data is organized as key-value pairs within objects and arrays, forming a nested structure.