After two years in stealth mode, ActiveFacts is ready for you to try. This project implements the CQL language for Semantic Modeling. This enables your data to be designed, expressed and queried in a completely natural way for the first time. Read more at the ActiveFacts home page: <http://dataconstellation.com/ActiveFacts>, or just browse the examples: <http://dataconstellation.com/ActiveFacts/examples/.... This version provides robust SQL generation, with a small skin that emits schemas suitable for SQL Server (this skin is less than 3% of the codebase, and generators for MySQL and PostgreSQL will follow soon, so please don't hound me!) An option to inject surrogate key fields for use with Rails will follow soon. No query support is available in this release, which is why it's not 1.0. However there is a Ruby generator that works with the Constellation API, so you can generate code that will manage the data your model requires. In fact, it's so solid that the CQL compiler actually uses the Ruby code emitted from it processing the meta-model. Full RDoc is available for the Constellation API - it's easiest to read if you run a "gem server". ActiveFacts is a Ruby gem - just say "gem install activefacts". This will install "afgen", the ActiveFacts generator program. Also installed with the gem is a directory of example models in CQL; you can immediately generate these to Ruby or SQL, or edit them to build your own models. Documentation of the syntax of CQL is provided on the home page, and the semantics are the same as those of Object Role Modeling, for which several books are available. Clifford Heath, Data Constellation, http://dataconstellation.com Agile Information Management and Design.
on 2009-01-09 06:00