Multimodal data

What is a view?

A view is a derived table whose rows are produced from a base table, often one row per frame, chunk, or other iterator output, and stay aligned when the base changes.

Updated

How it works

  • The view names its base table.
  • An iterator expands one source row into many child rows.
  • Child rows keep a pointer to the source, so a hit can name the original file.

What it is not

It is not a one-shot export you re-run by hand, and it is not only a SQL view over scalar columns.

view: this, and the thing it is confused with

view: this, and the thing it is confused with
ThisNot this
RowsDerived from a baseInserted by the application
When the base changesAffected child rows updateYou reload a dump
Typical shapeFrames, passages, sentencesA joined report of numbers

Where Pixeltable fits

In Pixeltable a view is a TableModel subclass with base= and, when it expands rows, iterator=.

Questions

How does view work?
The view names its base table. An iterator expands one source row into many child rows. Child rows keep a pointer to the source, so a hit can name the original file.
What is view often confused with?
It is not a one-shot export you re-run by hand, and it is not only a SQL view over scalar columns.