Tersus: Modeling relation data

Modeling relation dataDate: May 15, 2013I'm evaluating Tersus and have to say that I'm impressed by the way of visual modelling applications shown here. All other "visual" programming tools I've evaluated are either some sort of toy language or paint-gui-and-code-the-logic IDE.I'm reading through the Step-by-Step tutorial. In the Stage related to modeling relational data I saw an approach wich is based on program logic to model relations.This approach has some shortcomings:

This is no declarative way of modeling the relation. You have to look through the business logic to discover the relations.

It has no implicit definition of referential integrity. The only way to do it is to define the database manually and declare some foreign key relations.

There is no type safety when resolving references. (To which table belongs the referencing ID field?)

Is there another -- more declarative -- way of modeling relational data?I'm asking this because the missing declarative way may not be a problem in small apps like the one from the tutorial but I'm comparing this to the application I'm currently working on which uses about 800 tables.Thanks in advance,HelgeSee Also:

Re: Modeling relation data

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...