Jump to content
Lilly

Sequence Queries - What is a predicate in this context?

Recommended Posts

Hello friends!

So I'm working on this report on optimizing sequence queries and I'm specifically studying SQL TS (SQL for Time Series). It's basically an extension for SQL for finding patterns in sequences. So I need help to translate this phrase into English, because I really have no idea what it means:

Quote

Thus, a star pattern such as ∗Y fails only when the predicates that become fully instantiated at Y fail on the first input. However, if such predicates succeed on the first n ≥ 1 tuples and fail on tuple n+1, then ∗Y succeed and completes on the nth tuple, and the n+1 tuple is tested against the element in the pattern immediately following ∗Y

What is a predicate?

What is a fully instantiated predicate?

Thank you in advance!

Share this post


Link to post
Share on other sites

In database terms:

Quote

Is an expression that evaluates to TRUE, FALSE, or UNKNOWN. Predicates are used in the search condition of WHERE clauses and HAVING clauses, the join conditions of FROM clauses, and other constructs where a Boolean value is required.

in FileMaker terms a predicate is one or more fields used as parent or foreign keys between two table occurrences. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who Viewed the Topic

    1 member has viewed this topic:
    hutchlad 
×

Important Information

By using this site, you agree to our Terms of Use.