60 | | -- drop table mms_f_parameter_results; |
61 | | --//////////////////////////////////////////////////////////////////////////// |
62 | | create table mms_f_parameter_results ( |
63 | | --//////////////////////////////////////////////////////////////////////////// |
64 | | id_object integer not null, |
65 | | co_parameter varchar not null, |
66 | | co_node varchar not null, |
67 | | co_term varchar, |
68 | | co_type varchar not null, |
69 | | nu_block integer, -- period, category, piece |
70 | | nu_degree integer, |
71 | | -- definition |
72 | | vl_initial numeric, |
73 | | vl_is_fixed numeric, |
74 | | vl_prior_mean numeric, |
75 | | vl_prior_sigma numeric, |
76 | | vl_cns_minimum numeric, |
77 | | vl_cns_maximum numeric, |
78 | | -- results |
79 | | vl_mean numeric, |
80 | | vl_sigma numeric, |
81 | | vl_minimum numeric, |
82 | | vl_maximum numeric, |
83 | | vl_median numeric, |
84 | | |
85 | | constraint PK01_mms_f_parameter_results |
86 | | primary key (id_object, co_parameter), |
87 | | |
88 | | constraint FK01_mms_f_parameter_results |
89 | | foreign key (id_object) references mms_d_object(id_object) |
90 | | ); |
91 | | }}} |
92 | | |
93 | | |
94 | | ==== RESULTS ==== |
95 | | es el modulo del guardato de resultado de submodelos estimados |
96 | | |
97 | | |
98 | | |
99 | | ====== Script de tablas RESULTS versión 1 ====== |
100 | | |
101 | | {{{ |
102 | | insert into mms_d_module |
103 | | values ('RESULTS', 1); |
104 | | |
105 | | -- drop table mms_d_submodel_results; |
106 | | --//////////////////////////////////////////////////////////////////////////// |
107 | | create table mms_d_submodel_results ( |
108 | | --//////////////////////////////////////////////////////////////////////////// |
109 | | id_object integer not null, |
110 | | co_submodel varchar not null, |
111 | | co_type varchar not null, |
112 | | co_function varchar, -- link o transformation LOG PROBIT |
113 | | co_arima_label varchar, -- P1DIF1AR1MA1 |
114 | | vl_data_size numeric, |
115 | | vl_parameters_size numeric, |
116 | | vl_log_likelihood numeric, |
117 | | |
118 | | constraint PK01_mms_d_submodel_results |
119 | | primary key (id_object, co_submodel), |
120 | | |
121 | | constraint FK01_mms_d_submodel_results |
122 | | foreign key (id_object) references mms_d_object(id_object) ); |
123 | | |
124 | | -- drop table mms_f_submodel_statistic; |
125 | | --//////////////////////////////////////////////////////////////////////////// |
126 | | create table mms_f_submodel_results_statistic ( |
127 | | --//////////////////////////////////////////////////////////////////////////// |
128 | | id_object integer not null, |
129 | | co_submodel varchar not null, |
130 | | co_statistic varchar not null, |
131 | | vl_statistic numeric not null, |
132 | | |
133 | | constraint PK01_mms_f_submodel_results_statistic |
134 | | primary key (id_object, co_submodel, co_statistic), |
135 | | |
136 | | constraint FK01_mms_f_submodel_results_statistic |
137 | | foreign key (id_object) references mms_d_object(id_object) |
138 | | ); |
139 | | |
140 | | -- drop table mms_f_submodel_c_results_series; |
141 | | --//////////////////////////////////////////////////////////////////////////// |
142 | | create table mms_f_submodel_c_results_series ( |
143 | | --//////////////////////////////////////////////////////////////////////////// |
144 | | id_object integer not null, |
145 | | co_submodel varchar, |
146 | | dt_series timestamp, |
147 | | vl_observations numeric, |
148 | | vl_output numeric, |
149 | | vl_interruptions numeric, |
150 | | vl_additive_filter numeric, |
151 | | vl_filter numeric, |
152 | | vl_noise numeric, |
153 | | vl_dif_noise numeric, |
154 | | vl_residuals numeric, |
155 | | vl_std_residuals numeric, |
156 | | vl_prediction numeric, |
157 | | vl_obs_prediction numeric, |
158 | | vl_obs_predictionMedian numeric, |
159 | | |
160 | | constraint PK01_mms_f_submodel_results_series |
161 | | primary key (id_object, co_submodel, dt_series), |
162 | | |
163 | | constraint FK01_mms_f_submodel_results_series |
164 | | foreign key (id_object) references mms_d_object(id_object)); |
165 | | |
166 | | -- drop table mms_f_submodel_d_results_matrix; |
167 | | --//////////////////////////////////////////////////////////////////////////// |
168 | | create table mms_f_submodel_d_results_matrix ( |
169 | | --//////////////////////////////////////////////////////////////////////////// |
170 | | id_object integer not null, |
171 | | co_submodel varchar, |
172 | | nu_row integer, |
173 | | vl_output numeric, |
174 | | vl_filter numeric, |
175 | | vl_residuals numeric, |
176 | | vl_prediction numeric, |
177 | | |
178 | | constraint PK01_mms_f_submodel_d_results_matrix |
179 | | primary key (id_object, co_submodel, nu_row), |
180 | | |
181 | | constraint FK01_mms_f_submodel_d_results_matrix |
182 | | foreign key (id_object) references mms_d_object(id_object) |
183 | | ); |
184 | | }}} |
185 | | |
186 | | == Metodos == |
187 | | |
188 | | Todos los metodos de repositorio Folder son aplicable a repositorio Data Base |
189 | | |
190 | | Loas argumentos |
191 | | * Text subclass (pueden ser DataSet, Model, Estimation, Forecast) |
192 | | * Anything info |
193 | | * ''{{{Text info = }}}'' tiene que ser ''{{{ObjectName__ObjectVersion}}}'' |
194 | | * ''{{{Set info = }}}'' tiene que ser ''{{{[[ ObjectName, ObjectVersion ]]}}}'' |
195 | | * ''{{{Real info = }}}'' tiene que ser su identificador ''{{{id_object}}}'' de la tabla mms_d_object |
196 | | |
197 | | || {{{Set GetSummury (Text subclass, Anything info) }}}|| Genera el sne de un objeto || |
| 57 | || {{{Set GetSummary (Text subclass, Anything info) }}}|| Obtiene el resumen (SNE) de un objeto || |