Project

General

Profile

Actions
Copy link

Activity #2482

closed

Feature #1768: Software Design

Feature #3754: Design and development for oracle based Data storage and management system

Module #3755: Design of database tables

Module #1958: DB configuration

Activity #2226: Setup database with tables

Popuate data for unstructured data

Added by Thara S Pillai over 2 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Siji Mathew
Start date:
04/17/2024
Due date:
04/18/2024
% Done:

100%

Estimated time:
Planned Due Date:

Description

create rows in miss_sensors for analog and digital hydrophones.
Create records in miss_dpl_sen to create miss_dpl_sen_id
update records in data_unstruct_store for miss_dpl_sen_id
Instead of multiple columns for different data locations, create the following:
1. DATA_TYPE column CHAR with values
A for Acoustic Noise Data –Live
O for Acoustic Noise 1/3rd Octave –Live
S for Acoustic Acoustic Noise Spectrogram –Live
P for Acoustic Noise PDF –Live
2. DATA_OR_LOC
The field stores either data itself or the location of data in NAS. To be retrieved based on DATA_TYPE column value

Actions
Copy link

Also available in: Atom PDF