CLM (RTC/RM) Database Definitions (RIDW, RIODS, RICALM) Help
2 answers
Looking for the same info I found this, in case it can help:
https://jazz.net/library/article/1489
The Data Warehouse has 3 schema's that are relevant for reporting:
https://jazz.net/library/article/1489
The Data Warehouse has 3 schema's that are relevant for reporting:
- RIODS (originally an abbreviation for Rational Insight Operational Data Store) that consist of highly normalized database tables containing information regarding the various CLM artefact's such as projects, work items, requirements and test artefact's - including their attributes and relationships.
-
RICALM (Rational Insight Collaborative Application Lifecycle Management) that contains information related to custom CLM attributes as well as history tables for reporting on artifact changes, such as changes to the requirements, work items and test cases (amongst others).
- RIDW (originally an abbreviation for Rational Insight Data Warehouse) that contains information for the various data marts to support trend reporting. Basically this boils down to star schema's being defined in terms of fact tables storing the metrics as well as the dimension tables representing the dimensions of the star schema.