Predicate

   Share on Facebook  
hanuman_2000  #232832  Tue, 06 Jun 06 05:08 AM

Hello,

1. An assertion is a predicate  expressing  a condition that we wish  the database always to satisfy.

2. The where clause corresponds to the selection predicate of the relational algebra.

What is meaning of "predicate" here?

  
Top 75 Contributor
Joined on Thu, Aug 12 2004
INDIA
Contributing Member (1,625)
CalifJim  #232839  Tue, 06 Jun 06 05:20 AM
Any group of words that designates a property or characteristic of something is a predicate.

Suppose you want to find every description in your database that contains the word "amount".
Here's the predicate you are interested in:  contains the word "amount".
This group of words designates a certain property or characteristic that you are looking for in the database.

Suppose now that you want to find every total in your database that is greater than 100,000.
Here's the predicate you are interested in:  is greater than 100,000.
This group of words designates a certain property or characteristic that you are looking for in the database.

Predicates make it possible for you to look for specific things in a database and select specific things out of the database.  You look for and select the things that have the characteristics you designate in the predicates you specify.

I hope this helps.
CJ

  
Top 10 Contributor
Joined on Mon, Aug 2 2004
California
Veteran Member (17,714)
ModeratorProficient Speaker
"There are no facts, only interpretations" - Nietzsche
hanuman_2000  #232844  Tue, 06 Jun 06 05:39 AM

Hello,

Thanks Sir.(Mr. CJ)

  
AddThis Feed Button RSS Feed: ESL General English Grammar Questions
© 2008 MediaCET Ltd.
Terms and Conditions & Terms of Service