iRM (integration Repository Manager)

Figure1: The iRM mSQLConsole. [Enlarge]

The mSQL console is a normal repository application which an be used to execute mSQL queries. It operates with the mSQL engine just as a normal application would do. The mSQL console collects a range of useful information, e.g. intermediary data, used to track the execution of the query: check different operators and the intermediary data produced and consumed at every stage.

In this short demonstration we shall follow the execution of the following mSQL query:

SELECT   DISTINCT ti.name, ti.level, t.name, t.level, x.name, x.level, dt.name
FROM      M2::RDBPackage2->t ti, ti->ai^dt, TYPEm(t) x
WHERE    dt.name = 'date' AND t <> M2::RDBPackage2:RDBModellingElement;

It returns the names and the meta-layers of all classes t in the RDBPackage2 on the M2 level, their (M1) instances ti, their attributes ai and datatypes dt, as well as the classes' direct meta-class (type) x. The following condition must be met: the datatype dt (of the attributes ai of the instances ti of the classes t) must be date and the class must not be M2::RDBPackage2:RDBModellingElement.

Demo Home     Next >>