Changes between Version 4 and Version 5 of MmsDatabase

Timestamp:

Apr 26, 2013, 12:00:23 PM (12 years ago)

Author:

Chakib Faghloumi

Comment:

--

MmsDatabase

@@ -2 +2 @@
 
 == Modules ==
- * '''BASE  '''
- * '''OZA'''
- * '''SUMMURY '''
- * '''PARAMETERS '''
- * '''RESULTS '''
+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