User guide

View models in Avaki Studio
6 Data Integration with Sybase Avaki Studio
Operators
Avaki Studio provides a selection of elements and operators you can use to manipulate
data in a view model. The operators are described briefly here. For details on how the
operators work and how to use them, see Chapter 7‚ “Operator reference.”
Beginning and ending data flows. Two important elements identify the beginnings
and the end of the flow in a view model:
• Input Source
Use Input Source elements to specify where the data for you view model comes
from, such as existing view models (data services), database operations, or grid
files. A view model can have zero or more input sources.
• Result
Studio puts a Result element at the end of each view model’s data flow. A view
model has one result.
Relational operations. These operators let you perform SQL-style operations:
• Select
Given one input result set and a Boolean where expression, Select produces a new
result set containing the input rows for which the where expression evaluates to
true.
• Projection
Projection lets you modify the schema—you can remove columns, add computed
columns, or apply formulas to alter existing column values.
• Order By
Given one input result set and your specification of which column(s) to sort on and
whether to sort in ascending or descending order, Order By produces a new result
set in which the content of the input is sorted.
• Aggregate
Avaki provides a number of predefined aggregation functions (including sum,
count, average, minimum, maximum). Given one input result set, Aggregate pro-
duces a new, single-row result set by applying aggregate functions to the input.
• Group By
Group By uses the same aggregation functions used in Aggregate. Given one input
result set, Group By applies aggregate functions to the input and groups the rows
in the result set according to input columns you specify.