The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Other What is this type of database filtering called?

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #35958

    Im probably just thinking to much maybe theres no specific kind of name for it or anything … but you know how on 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



    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.


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


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

    would come up with the results for your example.

Viewing 3 posts - 1 through 3 (of 3 total)
  • The forum ‘Other’ is closed to new topics and replies.