MmsDatabase

Modules

creación de un catalogo de modules

create table mms_d_module (
--////////////////////////////////////////////////////////////////////////////
  co_module     varchar unique not null,  
  nu_version    integer        not null
);

BASE

es el modulo imprecindible para los demas siguientes donde se difine las caracteristicas del objeto guardad0

Script de tablas BASE.1

insert into mms_d_module
values ('BASE', 1); 

-- drop table mms_d_object; 
--////////////////////////////////////////////////////////////////////////////
create table mms_d_object (
--////////////////////////////////////////////////////////////////////////////
  id_object       serial unique not null,
  co_subclass     varchar       not null,
  co_name         varchar       not null,
  co_version      varchar       not null,
  ds_object       varchar,
  ds_tags         varchar, 
  dt_creation     timestamp     not null,
  dt_modification timestamp     not null,

  constraint PK01_mms_d_object
    primary key (id_object),

  constraint PK02_mms_d_object
    unique (co_subclass, co_name, co_version)); 

OZA

es el modulo del guardado de specificación del objeto objeto.oza

Script de tablas OZA.1

insert into mms_d_module
values ('OZA', 1); 

-- drop table mms_d_object_oza; 
--////////////////////////////////////////////////////////////////////////////
create table mms_d_object_oza (
--////////////////////////////////////////////////////////////////////////////
  id_object   integer not null,
  ob_oza      varchar not null,

  constraint PK01_mms_d_object_oza
    primary key (id_object),

  constraint FK01_mms_d_object_oza
    foreign key (id_object) references mms_d_object(id_object) 
);

SUMMURY

es el modulo del resumen de especificacones del objeto objeto.sne

Script de tablas SUMMURY.1

insert into mms_d_module
values ('SUMMARY', 1); 

-- drop table mms_d_object_summary; 
--////////////////////////////////////////////////////////////////////////////
create table mms_d_object_summary (
--////////////////////////////////////////////////////////////////////////////
  id_object     integer not null,
  co_section    varchar not null,
  co_name       varchar not null,
  co_grammar    varchar not null, 
  co_value      varchar not null,

  constraint PK01_mms_d_object_summary
    primary key (id_object, co_section, co_name),

  constraint FK01_mms_d_object_summary
    foreign key (id_object) references mms_d_object(id_object)
);

PARAMETERS

es el modulo del guardato de resultado de parametros estimados

Script de tablas PARAMETERS.1

insert into mms_d_module
values ('PARAMETERS', 1); 

-- drop table mms_f_parameter_results; 
--////////////////////////////////////////////////////////////////////////////
create table mms_f_parameter_results (
--////////////////////////////////////////////////////////////////////////////
  id_object     integer not null,
  co_parameter  varchar not null,
  co_node       varchar not null,
  co_term       varchar,
  co_type       varchar not null,
  nu_block      integer, -- period, category, piece
  nu_degree     integer,
  -- definition
  vl_initial     numeric,
  vl_is_fixed    numeric,
  vl_prior_mean  numeric,
  vl_prior_sigma numeric,
  vl_cns_minimum numeric,
  vl_cns_maximum numeric,
  -- results
  vl_mean       numeric,
  vl_sigma      numeric,
  vl_minimum    numeric,
  vl_maximum    numeric,
  vl_median     numeric,

  constraint PK01_mms_f_parameter_results
    primary key (id_object, co_parameter),

  constraint FK01_mms_f_parameter_results
    foreign key (id_object) references mms_d_object(id_object)
);

RESULTS

es el modulo del guardato de resultado de submodelos estimados

Script de tablas RESULTS.1

insert into mms_d_module
values ('RESULTS', 1); 

-- drop table mms_d_submodel_results; 
--////////////////////////////////////////////////////////////////////////////
create table mms_d_submodel_results (
--////////////////////////////////////////////////////////////////////////////
  id_object          integer not null,
  co_submodel        varchar not null,
  co_type            varchar not null,
  co_function        varchar,  -- link o transformation  LOG PROBIT
  co_arima_label     varchar,  -- P1DIF1AR1MA1
  vl_data_size       numeric,
  vl_parameters_size numeric,
  vl_log_likelihood  numeric,

  constraint PK01_mms_d_submodel_results
    primary key (id_object, co_submodel),

  constraint FK01_mms_d_submodel_results
    foreign key (id_object) references mms_d_object(id_object) );

-- drop table mms_f_submodel_statistic; 
--////////////////////////////////////////////////////////////////////////////
create table mms_f_submodel_results_statistic (
--////////////////////////////////////////////////////////////////////////////
  id_object          integer not null,
  co_submodel        varchar not null,
  co_statistic       varchar not null,
  vl_statistic       numeric not null,

  constraint PK01_mms_f_submodel_results_statistic
    primary key (id_object, co_submodel, co_statistic),

  constraint FK01_mms_f_submodel_results_statistic
    foreign key (id_object) references mms_d_object(id_object)
  );

-- drop table mms_f_submodel_c_results_series; 
--////////////////////////////////////////////////////////////////////////////
create table mms_f_submodel_c_results_series (
--////////////////////////////////////////////////////////////////////////////
  id_object             integer not null,
  co_submodel           varchar,
  dt_series             timestamp,
  vl_observations       numeric,
  vl_output             numeric,
  vl_interruptions      numeric,
  vl_additive_filter    numeric,
  vl_filter             numeric,
  vl_noise              numeric, 
  vl_dif_noise          numeric,
  vl_residuals          numeric,
  vl_std_residuals      numeric,
  vl_prediction         numeric, 
  vl_obs_prediction     numeric,

  constraint PK01_mms_f_submodel_results_series
    primary key (id_object, co_submodel, dt_series),

  constraint FK01_mms_f_submodel_results_series
    foreign key (id_object) references mms_d_object(id_object));

-- drop table mms_f_submodel_d_results_matrix; 
--////////////////////////////////////////////////////////////////////////////
create table mms_f_submodel_d_results_matrix (
--////////////////////////////////////////////////////////////////////////////
  id_object             integer not null,
  co_submodel           varchar,
  nu_row                integer,
  vl_output             numeric,
  vl_filter             numeric,
  vl_residuals          numeric,
  vl_prediction         numeric, 

  constraint PK01_mms_f_submodel_d_results_matrix
    primary key (id_object, co_submodel, nu_row),

  constraint FK01_mms_f_submodel_d_results_matrix
    foreign key (id_object) references mms_d_object(id_object)
);

Metodos

Todos los metodos de repositorio Folder son aplicable a repositorio Data Base