Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

CLM (RTC/RM) Database Definitions (RIDW, RIODS, RICALM) Help

Questions
Tags
Users
Badges
Joel Lonneker
(39●10●16) May 05 '15, 2:10 p.m.
 Can someone simply define each of these tables from the CLM database?
  1. RIODS
    • Would like validation, but think this is live data
  2. RIDW 
    • Believe this Data Warehouse data
  3. RICALM
    • Possibly custom field data (not sure if live data or DW)

The more basic the description of each, the better.  

1 vote

2 answers
6,311 views
1 vote

2 answers

Permanent link
Rafael Rodriguez Montes
(230●13●130●258) May 05 '15, 7:41 p.m.
Hi Joel, 

I been asking for the same information and the info that I got is that IBM has the property of the DBs and you should not be accessing directly to the DBs.

1 vote

Permanent link
Noel Gimeno
(152●14●17) Oct 19 '15, 5:36 a.m.
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:
  • 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.

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014
× 82

Question asked: May 05 '15, 2:10 p.m.

Question was seen: 6,311 times

Last updated: Oct 19 '15, 5:36 a.m.

Confirmation Cancel Confirm