Sun Jun 12 2022 (6 months ago)
Engineer by mistake!
I am a software engineer by passion
In this article, we'll see some basic terms for Database, Management System, such as data, metadata, raw data, etc.
This is the main component of DBMS. The DBMS moves around data, weather it is about organising the data or querying the data.
Data is raw, unorganised facts that needs to be processed. For example marks of student, 50, 70, 90, etc.
When raw data is processed and present some useful meaning, then it is called information.
For example, a student have x marks is the data. Based on his marks student could be pass or fail and this is called information.
The data about data is called metadata, such as table name, column name, etc are called metadata.
Table : Faculty
Metadata for above data would be:
Table name - Faculty
Columns name - Emp_Name, Address, ...
Data types - Varchar, Int, etc
Data dictionary is the information repository which contains information about metadata.
A Data warehouse is the information of repository which stores data. It is the central repositories of integrated data from one or more disparate sources.
A field is a character or a group of characters that have a specific meaning. Ex, the value of employee name, age, etc are the fields of faculty table.
A record is a collection of logically related fields. E.g, the collection of fields (Emp_Name, Address, Mobile_No, Subject) forms a record for the Faculty.
A database is a named collection of tables. (see table). A database can also contain views, indexes, sequences, data types, operators, and functions. Other relational database products use the term catalog.
A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.
A table is a collection of related data held in a table format within a database. It consists of columns and rows.
A column is a set of data values of a particular type, one value for each row of the database.
In the above table Name is a column, Roll is a column and Branch is also a column.
In this article, we saw the most widely used database terminology.
© 2021 dsabyte. All rights reserved