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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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