Class DatabaseTorgDataSource

java.lang.Object
neqsim.process.mechanicaldesign.torg.DatabaseTorgDataSource
All Implemented Interfaces:
TorgDataSource
public class DatabaseTorgDataSource extends Object implements TorgDataSource
Database-based data source for loading Technical Requirements Documents (TORG).

This implementation loads TORG data from the NeqSim process design database. It expects the following tables:

TORG_Projects table

CREATE TABLE TORG_Projects (
  PROJECT_ID VARCHAR(50) PRIMARY KEY,
  PROJECT_NAME VARCHAR(200),
  COMPANY VARCHAR(100),
  REVISION VARCHAR(20),
  ISSUE_DATE DATE,
  MIN_AMBIENT_TEMP DOUBLE,
  MAX_AMBIENT_TEMP DOUBLE,
  SEAWATER_TEMP DOUBLE,
  SEISMIC_ZONE VARCHAR(10),
  CORROSION_ALLOWANCE DOUBLE,
  PRESSURE_SAFETY_FACTOR DOUBLE,
  DEFAULT_PLATE_MATERIAL VARCHAR(50),
  DEFAULT_PIPE_MATERIAL VARCHAR(50)
);

TORG_Standards table

CREATE TABLE TORG_Standards (
  PROJECT_ID VARCHAR(50),
  DESIGN_CATEGORY VARCHAR(100),
  STANDARD_CODE VARCHAR(50),
  VERSION VARCHAR(20),
  PRIORITY INT,
  FOREIGN KEY (PROJECT_ID) REFERENCES TORG_Projects(PROJECT_ID)
);

Alternatively, this data source can also read from the existing TechnicalRequirements_Process table for backward compatibility.

Version:
1.0
Author:
esol