it is our privilege to notify you of the general availability of biready version4.5, the acknowledged standardized data warehouse automation software.
besides a diversity of customer requested enhancements for the easiness of usage of biready there is also brand new functionality like the support of mysql and state oriented fact tables.
the state oriented fact table is unique functionality, close to what is known as kimball type 6, or as other people call ‘the twin timestamp approach’.
in short: in such a fact table each row represents the state of an object during a period of time in which this state didn’t change. it is a kind of type 2 approach to the fact table.
imagine an insurance company and claim reporting in particular, including open reserves and paid amounts as of the time of the end of a period. these reports must show the state of the claim and related policy as of the reporting date, not at the time of the transactions, nor at the time that the report is run. with a traditional transaction-oriented fact table and “type 1” or “type 2” dimensions this is quite complex and error-prone, but with a state-oriented fact table the query is very simple. this will cut development time, allows reports to run much faster, and will reduce the maintenance costs significantly.
for more information you can request the white paper at firstname.lastname@example.org, or check www.biready.com.
by the end of this year version 5 will be released with even more functionality and features, including another graphical display of the model and data marts, optimized restart capabilities and integration with etl tools (this means that the biready generated etl statements can be executed by third party etl tools, as an alternative for our own engine).
the latter will be very valuable for (larger) organizations that already have huge bi and etl investments in place. it also opens the door for using biready as a prototyping tool or communication between it and business enabler, where the production environment already in place can remain.
ceo & president