What is this type of database filtering called?

[mikeman]

Im probably just thinking to much maybe theres no specific kind of name for it or anything … but you know how on Newegg.com you can filter products by all kinds of criteria, like… I want an
Intel Product, which is also a motherboard, which also holds at least X amount of ram… thats $100 or less, so thats 4 tables in a data base right? then the system filters results based off the value of the “tables” specified.. what is this referred to .. like in technical terms or something.. :-D

thanks

[davidlab.be]

It may be 4 tables or could even be one table with the information about the product divided into columns. It all depends on the developer of the database and how he designed the schema.

[gno]

The only thing needed to do such a filtering on a relational database is basic knowledge of SQL.

E.g.

SELECT * FROM products WHERE (price > 100) AND (ram > 2000) AND (manufacturer == 'Intel')

would come up with the results for your example.

[Author]

Posts