Database schema in RiskyProject

General discussion and questions about project risk management and risk analysis software RiskyProject. Includes discussion on how to perform efficient project risk analysis using our software.

Moderator: Intaver Support

Post Reply
Nathan
Posts: 17
Joined: Fri Apr 09, 2010 7:33 pm
Location: Brussels
Contact:

Database schema in RiskyProject

Post by Nathan » Thu Feb 04, 2016 1:45 pm

We are trying to integrate RiskyProject to our system. Can we read RiskyProject results from RiskyProject Database directly?

Intaver Support
Posts: 823
Joined: Wed Nov 09, 2005 9:55 am

Re: Database schema in RiskyProject

Post by Intaver Support » Sat Feb 06, 2016 11:46 am

RiskyProject Enterprise has open data schema. It has all information necessary for performing project risk analysis and risk management.

Image

We don't store information about project schedules in the tables. They are saved in the binary object (BLOB). Here is a set of tables for RiskyProject database. The rest of information, including simulation results for tasks and for whole projects are stored in the database. It includes all samples for duration, cost, start and finish times on all iterations. Other information in the database include all data related to risk register. All risk properties are saved in the database, as well as risk categories, risk history, risk reviews and risk assignments. Risk assignment table includes information about risk probabilities and impact for all risk alternatives.

We will maintain this database structure for all versions forward. We will add tables and columns for specific tables, but we will preserve all data structure in existing columns. If you are thinking about integration with RiskyProject Enterprise we will provide you with detailed description of our database structure.
Intaver Support Team
Intaver Institute Inc.
Home of Project Risk Management and Project Risk Analysis software RiskyProject
www.intaver.com

Post Reply