• http://dataconstellation.com/ActiveFacts/

ActiveFacts provides a fact-based semantic modeling language, the Constellation Query Language (CQL). CQL combines natural language verbalisation and formal logic, producing a formal language that reads like plain English. ActiveFacts converts semantic models from CQL to relational and object models in SQL, Ruby and other languages.

The generated models are guaranteed congruent, which can eliminate the object-relational impedance mismatch. Fact based models are much more stable under evolving requirements than either relational or object-oriented models, because they directly express the underlying conceptual structure as elementary facts, so are not susceptible to ramifying change in the way those attribute-oriented approaches are.

Semantic modeling is a refinement of fact-based modeling techniques such as ORM2, NIAM and others. ActiveFacts can convert ORM2 files from NORMA to CQL. Fact-based modeling is closely related to relational modeling in the sixth normal form (as Codd intended it!), but the generated relation schemas are in 5NF, so they don't suffer from 6NF inefficiency. The relational models it derives are highly efficient.

Note: ActiveFacts generators now belong in the activefacts-compositions gem, which offers better generators. This gem contains some important older ones that have not yet been migrated across.

afgen --help
afgen --sql/server myfile.cql
afgen --ruby myfile.cql
afgen --cql myfile.orm
afgen --transform/surrogate --rails/schema myfile.cql
afgen --transform/datavault --sql/server myfile.cql
cql (command-line interpreter, including a query evaluator)

sudo gem install activefacts

• The definition language is complete and the main generators are usable.

• Arithmetic and aggregate operations in queries are recognised but not compiled.

• Queries and derived fact types not yet generated to SQL queries or views..

• The Constellation API is solid; the CQL compiler uses the generated Ruby code extensively

• Advanced constraint types are mostly ignored by the generators.

• Treetop parser generator

• NORMA (see http://www.ormfoundation.org/files/), if you want to use ORM (needs Visual Studio Pro or Community edition)