Data, Data Types, Fields, Columns, Rows, Records, and databases
Data, Data Types, Fields, Columns, Rows, Records, and databases all are related to each other and these are used to store the information in the applications. Details of each term are given below:-
Data: Data means any unprocessed or unorganized information that can be stored, manipulated, and processed by a computer. Data can be text, numbers, images, audio, video, etc.
Different Types of Data:
There are several forms of data, each with a distinct function. The primary categories of data are:
Structured Data: Data that is structured is well-organized and adheres to a set format. It is best suited for use with preset fields, columns, and rows. Searching, sorting, and analysis of structured data is simple. Dates, numbers, and categorization information are some examples.
Unstructured Data: Unstructured data lacks a set format and is not organized in a predetermined way. It might be media-based, such as pictures, videos, or audio recordings, or it can be text-based, like emails, social media postings, or papers. Comparing unstructured data to structured data might make analysis more difficult.
Semi-Structured Data: Data that is semi-structured has components of both organized and unstructured data. Although it loosely follows a predetermined framework, it does have certain organizational characteristics. JSON or XML files are two examples.
Data Types: Data Type is an attribute of data that specifies the type of data. Like string, integer, decimal, etc. The data type defines the type of values that can be stored in the column.
Field: The field is the specific piece of data within a record. Suppose we have students' information, each record may contain fields such as name, class, address, marks obtained, etc.
Columns: The vertical arrangement of data within a table is known as a Column. Each column has a name that describes the type of data such as student name, age, class, and address.
