Question

What does the term filtering mean in the context of a database?

Answer 1

Filtering is on eof the most powerful ans useful functions of database. Filtering in database refers to filtering out the data of interest. In other words, filtering refers to choosing a particular set of data to be displayed that is of interest. For data to be filtered in the database, query has to be run. The database returns the queried data. For example if there is huge data of male and female, smokers and non-smokers, athletes and non-athletes, educated and non-educated and so on, we can choose the data that is to be queried. If our variable of interest is male smokers, then male and smoker rows are to be filtered, the database returns the male smokers. Similarly, athlete non-smokers is to be viewed, the rows are selected and the data is interest is dispalyed. In this way, data of any interest can be filtered and accessed.