Adding and managing views
RISE supports creation of views. These views results, when generating relational database code, in SQL views. The purposes of a RISE view are to:
-
Combine an information structure into a single list of higher level objects, i.e. flattening out a structure.
-
Apply a filtering condition to generate a subset of an entity or another view
-
Specify group by columns and functions to generate aggregated results.
-
Combinations of the above.
Views in RISE automatically joins entities and views along defined relations in a model. RISE does not support building views based on other join criteria than the existing relations. Thus, a view is built according to the following schema:
-
Pick a base entity for the view (corresponds to the SQL FROM table).
-
For each extension to the base entity (corresponds to SQL JOIN).
-
Select a relation starting at base entity.
-
Pick one of the objects (entity or view) found at the other end of the relation.
-
Select any number of attributes of the selected object.
-
Optionally, specify that the extension is mandatory (corresponds to an INNER JOIN).
-
Optionally, specify the filterings criterias for the view (corresponds to the WHERE clause).
-
Optionally, specify GROUP BY-columns and apply aggregate functions on the non-grouped columns.
As indicated by step 2.4 above extension objects are allowed to be non-existant by default, i.e. LEFT OUTER JOIN.
