RISE to Bloome Software
Log In    
Home
RISE
Marshal
Download
 
 
r2bsoftware.se r2bsoftware.se
 
 
 
Click to hide navigation tree
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:
  1. Pick a base entity for the view (corresponds to the SQL FROM table).
  2. For each extension to the base entity (corresponds to SQL JOIN).
    1. Select a relation starting at base entity.
    2. Pick one of the objects (entity or view) found at the other end of the relation.
    3. Select any number of attributes of the selected object.
    4. Optionally, specify that the extension is mandatory (corresponds to an INNER JOIN).
  3. Optionally, specify the filterings criterias for the view (corresponds to the WHERE clause).
  4. 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.
 
Filtering an entity
How to apply a filtering condition to generate a subset of an entity
Flattening out a structure
How to combine an information structure into a single list of higher level objects, i.e. flattening out a structure.
Using views in views
How to use a view in a view for instance to traverse a deeper structure along several relations.
Using aggregate functions
How to use group by and aggregate functions, eg Count, Sum, Max, Min, in views