What is Data, Information and Meta Data?
What is data actually?
Data is stored representation of objects and events that have meaning and importance in user’s environment.
Data can be structure or unstructured.
Example of structure and unstructured data.
- Structured data -> Student Name, Address, Student ID and Student Course.
- Unstructured data -> Stud photo, address map and student ID Proof.
Representation of DATA: As an Example of Emp table.
| Emp_Name | Dept_ID | Salary | DOJ |
| King | 10 | 5500 | 10-02-2006 |
| Blake | 10 | 4500 | 02-03-2005 |
| Clark | 20 | 3500 | 15-05-2004 |
| Smith | 30 | 1800 | 06-10-2000 |
| Miller | 20 | 1100 | 22-12-2003 |
| Taylor | 30 | 3500 | 24-09-1998 |
What is information Actually.
Information:
It is data that is in processed form or text form that will provide characteristics of person and knowledge about person who used the data.
Representation of information:
| Organization: Polocon Employee information data sheet. Date: 30 August 2022 Place: Delhi
|
What is Meta Data Actually.
Metadata:
It is the data which describes the properties or characteristics of end users’ data and the context of the data.
Metadata properties can be included information such as:
- Data Name
- Definitions
- Length OR Size
- Values allowed
- Source of data.
- Ownership
Metadata and data are always separate.
Metadata enables the database designers and programmers to understand exactly in which form the data should exist with in the system.
Metadata for employees information
| Data Items Specification Employee information data sheet. Date: 30 August 2022 Place: Delhi
| ||||||||||||||||||||||||||||||
You may like this article as well : SQL-Interview-Questions
You can watch this video for more information. : Update data using case statement