It's all about the answers!

Ask a question

Is there a data model for the RTC database (i.e. foreign key relationships, mapping of tables to work items, etc.) that would allow for SQL querying?


Grace Fang (2112) | asked Mar 19 '15, 5:34 p.m.
 We are trying to generate reports through SQL querying of the RTC database tables. However, the database structure is not intuitive and the foreign key relationships as well as the table structure mapping to work items is difficult to follow. Is there a general data model diagram that describes how the data is persisted? 

Comments
Rafael Rodriguez Montes commented Mar 19 '15, 5:39 p.m.

I been looking for this answer as well long time ago, since we have not any logic structure or intuitive we decide keep ClearQuest, also for troubleshoot corrupt database will be really helpful

2 answers



permanent link
Francesco Chiossi (5.7k11119) | answered Mar 20 '15, 5:36 a.m.
Hello Grace,

as far as I know the data model of the RTC repository is IBM proprietary and hence not documented publicly.
Any direct access to the database is not recommended.

For reporting purpose you can directly access that data warehouse, even if only a subset of the information from the application repositories is available.

The data model of the data warehouse is described at the following links:

IBM Rational Insight version 1.1.1 Data Warehouse
http://www-01.ibm.com/support/knowledgecenter/SSRL5J_1.1.1/com.ibm.rational.raer.models.doc/topics/ModelReport111/index.html

Reporting data dictionaries
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html

IBM Rational Insight data warehouse metadata model
http://www-01.ibm.com/support/knowledgecenter/SSRL5J_1.1.1/com.ibm.rational.raer.help.doc/topics/c_ridwdatamodel.html

Understanding the data warehouse metadata model
http://www-01.ibm.com/support/knowledgecenter/SSRL5J_1.1.1/com.ibm.rational.raer.help.doc/topics/c_navigating_thru_fm.html

Best Regards,

Francesco Chiossi

permanent link
Rafael Rodriguez Montes (23013126247) | answered Mar 20 '15, 11:39 a.m.

Grace,

unfortunately, the warehouse does not provide data in real time, not all information is available, sometimes the documentation is not updated, they are been doing several changes without any control or warnings to the customers on the new releases and when you upgrade your JTS and apps, all reports crashes (hundred hours of work)

the "best" solution so far is thro the WebServices, is the only standardized way that they have.

The database is not clear,clean and standardized (3Normal Forms) as ClearQuest, so for troubleshoot corrupt database could be weeks for IBM figure out a solution, so there are a lot concerns around this topic.

 

Your answer


Register or 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.