Changeset 8d891ee in tol


Ignore:
Timestamp:
Nov 4, 2008, 3:39:20 PM (18 years ago)
Author:
Víctor de Buen <vdebuen@…>
Branches:
1941-docker-image-to-test, devel, master
Children:
f9045cd
Parents:
1fa4a38
Message:

New table bsrhlm_v_obs_sigma_block

git-svn-id: ​https://www.tol-project.org/svn/tolp/trunk@111 be4846ae-f051-483a-831f-b64e7d08527f

File:
1 edited

Legend:

Unmodified
Added
Removed

  • tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/db_bsrhlm_mysql.sql

    r1fa4a38 r8d891ee  
    1414  same or another data base server or even in other type of data storement
    1515  system (BDT, OIS, ...).
    16  
     16
    1717///////////////////////////////////////////////////////////////////////////// */
    1818
    … …  
    4343ALTER TABLE `bsrhlm_v_obs_transferFunction`     DROP FOREIGN KEY `FK_bsrhlm_v_obs_transferFunction_model_session_node`;
    4444ALTER TABLE `bsrhlm_v_obs_input`                DROP FOREIGN KEY `FK_bsrhlm_v_obs_input_model_session_node`;
     45ALTER TABLE `bsrhlm_v_obs_sigma_block`          DROP FOREIGN KEY `FK_bsrhlm_v_obs_sigma_block_model_session_node`;
    4546ALTER TABLE `bsrhlm_v_obs_arima_block`          DROP FOREIGN KEY `FK_bsrhlm_v_arima_block_model_session_node`;
    4647ALTER TABLE `bsrhlm_v_obs_output`               DROP         KEY `UK_bsrhlm_v_obs_output_model_session_node_series`;
    … …  
    7374DROP TABLE IF EXISTS `bsrhlm_v_obs_transferFunction`;
    7475DROP TABLE IF EXISTS `bsrhlm_v_obs_input`;
     76DROP TABLE IF EXISTS `bsrhlm_v_obs_sigma_block`;
    7577DROP TABLE IF EXISTS `bsrhlm_v_obs_arima_block`;
    7678DROP TABLE IF EXISTS `bsrhlm_v_obs_output`;
    … …  
    216218
    217219/* /////////////////////////////////////////////////////////////////////////////
    218 The user must insert a register for each distinct application of a session tag 
     220The user must insert a register for each distinct application of a session tag
    219221over a model
    220222///////////////////////////////////////////////////////////////////////////// */
    … …  
    258260This table is related to mixed nodes.
    259261The user must insert a register for each variable of all gibbs blocks of all
    260 nodes of each model-session. 
     262nodes of each model-session.
    261263///////////////////////////////////////////////////////////////////////////// */
    262264CREATE TABLE  `bsrhlm_v_mix_parameter` (
    … …  
    283285/* /////////////////////////////////////////////////////////////////////////////
    284286This table is related to mixed nodes.
    285 The user must insert a register for each non linear filter. 
     287The user must insert a register for each non linear filter.
    286288///////////////////////////////////////////////////////////////////////////// */
    287289CREATE TABLE  `bsrhlm_v_mix_non_lin_filter` (
    … …  
    357359In this table id_node is never the MIXTURE but just one OBS or LAT node where
    358360the parameter comes from.
    359 The user must insert a register for each parameter affected by each 
    360 constraining inequation. Remeber that if 
    361    constraint_border.id_node<>'MIXTURE' then 
    362    constraint_border.id_node=constraint_lin_cmb.id_node for all 
     361The user must insert a register for each parameter affected by each
     362constraining inequation. Remeber that if
     363   constraint_border.id_node<>'MIXTURE' then
     364   constraint_border.id_node=constraint_lin_cmb.id_node for all
    363365   constraint_border.nu_inequation=constraint_lin_cmb.nu_inequation
    364366///////////////////////////////////////////////////////////////////////////// */
    … …  
    401403  `dh_start` datetime NULL,
    402404  `dh_end`  datetime NULL,
     405  `vl_sigma` double  NULL,
    403406  PRIMARY KEY (`id_model`,`id_session`,`id_node`),
    404407  CONSTRAINT `UK_bsrhlm_v_obs_output_model_session_node_series`
    … …  
    411414COMMENT='Stores observational output related information for each model-session';
    412415
    413 
    414416/* /////////////////////////////////////////////////////////////////////////////
    415417This table is related to observational nodes.
    416 The user must insert a register for each ARIMA factor attached to an output
     418The user must insert a register for each latent node of each model-session.
     419///////////////////////////////////////////////////////////////////////////// */
     420CREATE TABLE  `bsrhlm_v_obs_sigma_block` (
     421  `id_model` varchar(64) NOT NULL,
     422  `id_session` varchar(64) NOT NULL,
     423  `id_node` varchar(64) NOT NULL,
     424  `vl_sigma` double NULL,
     425  PRIMARY KEY (`id_model`,`id_session`,`id_node`),
     426  CONSTRAINT `FK_bsrhlm_v_obs_sigma_block_model_session_node`
     427    FOREIGN KEY                (`id_model`, `id_session`, `id_node`)
     428    REFERENCES `bsrhlm_d_node` (`id_model`, `id_session`, `id_node`)
     429    ON UPDATE CASCADE ON DELETE CASCADE
     430) ENGINE=InnoDB DEFAULT CHARSET=latin1
     431COMMENT='Stores sigma block information about observational nodes for each model-session. If sigma is null then it will be simulated by Gibbs method';
     432
     433/* /////////////////////////////////////////////////////////////////////////////
     434This table is related to observational nodes.
     435The user must insert a register for each ARIMA factor attached to an output
    417436serie at observation level of each model-session
    418437AR and MA polinomial are given as text with maximum degree 2 in the standard way
    … …  
    443462/* /////////////////////////////////////////////////////////////////////////////
    444463This table is related to observational nodes.
    445 The user must insert a register for each input serie of each observation node of 
     464The user must insert a register for each input serie of each observation node of
    446465each model-session.
    447466Pair (id_node, id_series) will be used by a NameBlock series.handler to return
    … …  
    470489/* /////////////////////////////////////////////////////////////////////////////
    471490This table is related to observational nodes.
    472 The user must insert a register for each transfer function 
     491The user must insert a register for each transfer function
    473492  omega(B)*y = delta(B)*x
    474493of each observation node of each model-session.
    … …  
    483502  `id_transferFunction` varchar(64) NOT NULL,
    484503  `te_omega` varchar(1020) NOT NULL,
    485   `te_delta` varchar(1020) NOT NULL, 
     504  `te_delta` varchar(1020) NOT NULL,
    486505  `id_series` varchar(64) NOT NULL,
    487506  `vl_mis_pri_sig_fac` double  NULL,
    … …  
    516535This table is related to latent nodes.
    517536The user must insert a register for each regression equation of each latent node
    518 of each model-session. Each equation is attached to a linear combination of 
    519 child parameters at left side of equal sign, wich will be defined in 
    520 bsrhlm_v_lat_output; and other linear combination of father parameters at right 
     537of each model-session. Each equation is attached to a linear combination of
     538child parameters at left side of equal sign, wich will be defined in
     539bsrhlm_v_lat_output; and other linear combination of father parameters at right
    521540side of equal sign, wich will be defined in bsrhlm_v_lat_input.
    522541///////////////////////////////////////////////////////////////////////////// */
Note: See TracChangeset for help on using the changeset viewer.