SQL functions for linear systems. More...
Functions | |
bytea8 | dense_residual_norm_transition (bytea8 state, float8[] a, float8 b, float8[] x) |
bytea8 | dense_residual_norm_merge_states (bytea8 state1, bytea8 state2) |
residual_norm_result | dense_residual_norm_final (bytea8 state) |
aggregate residual_norm_result | dense_residual_norm (float8[] left_hand_side, float8 right_hand_side, float8[] solution) |
Compute the residual after solving the dense linear systems. More... | |
float8 [] | dense_direct_linear_system_transition (float8[] state, integer row_id, float8[] a, float8 b, integer num_rows, integer algorithm) |
float8 [] | dense_direct_linear_system_merge_states (float8[] state1, float8[] state2) |
dense_linear_solver_result | dense_direct_linear_system_final (float8[] state) |
aggregate dense_linear_solver_result | dense_direct_linear_system (integer row_id, float8[] left_hand_side, float8 right_hand_side, integer numEquations, integer algorithm) |
Solve a system of linear equations using the direct method. More... | |
varchar | linear_solver_dense (varchar input_string) |
Help function, to print out the supported families. More... | |
varchar | linear_solver_dense () |
void | linear_solver_dense (varchar source_table, varchar out_table, varchar row_id, varchar left_hand_side, varchar right_hand_side, varchar grouping_cols, varchar optimizer, varchar optimizer_options) |
A wrapper function for the various marginal linear_systemsion analyzes. More... | |
void | linear_solver_dense (varchar source_table, varchar out_table, varchar row_id, varchar left_hand_side, varchar right_hand_side) |
Marginal effects with default variables. More... | |
aggregate dense_linear_solver_result dense_direct_linear_system | ( | integer | row_id, |
float8 [] | left_hand_side, | ||
float8 | right_hand_side, | ||
integer | numEquations, | ||
integer | algorithm | ||
) |
row_id | Column containing the row_id |
left_hand_side | Column containing the left hand side of the system |
right_hand_side | Column containing the right hand side of the system |
numEquations | Number of equations |
algorithm | Algorithm used for the dense linear solver |
solution FLOAT8[]
- Array of marginal effectsresidual_norm FLOAT8
- Norm of the residualiters INTEGER
- Iterations takenSELECT linear_system_dense(row_id, left_hand_side, right_hand_side , numEquations ) FROM dataTable;
dense_linear_solver_result dense_direct_linear_system_final | ( | float8 [] | state | ) |
float8 [] dense_direct_linear_system_merge_states | ( | float8 [] | state1, |
float8 [] | state2 | ||
) |
float8 [] dense_direct_linear_system_transition | ( | float8 [] | state, |
integer | row_id, | ||
float8 [] | a, | ||
float8 | b, | ||
integer | num_rows, | ||
integer | algorithm | ||
) |
aggregate residual_norm_result dense_residual_norm | ( | float8 [] | left_hand_side, |
float8 | right_hand_side, | ||
float8 [] | solution | ||
) |
left_hand_side | Column containing the left hand side of the system |
right_hand_side | Column containing the right hand side of the system |
solution | Solution of the linear system |
SELECT dense_residual_norm(row_id, left_hand_side, right_hand_side , solution ) FROM dataTable;
residual_norm_result dense_residual_norm_final | ( | bytea8 | state | ) |
bytea8 dense_residual_norm_merge_states | ( | bytea8 | state1, |
bytea8 | state2 | ||
) |
bytea8 dense_residual_norm_transition | ( | bytea8 | state, |
float8 [] | a, | ||
float8 | b, | ||
float8 [] | x | ||
) |
varchar linear_solver_dense | ( | varchar | input_string | ) |
varchar linear_solver_dense | ( | ) |
void linear_solver_dense | ( | varchar | source_table, |
varchar | out_table, | ||
varchar | row_id, | ||
varchar | left_hand_side, | ||
varchar | right_hand_side, | ||
varchar | grouping_cols, | ||
varchar | optimizer, | ||
varchar | optimizer_options | ||
) |
source_table | String identifying the input table |
out_table | String identifying the output table to be created |
row_id | Column containing the row_id |
left_hand_side | Column containing the left hand side of the system |
right_hand_side | Column containing the right hand side of the system |
grouping_cols | Columns to group by |
optimizer | Optimizer to be used |
optimizer_options | Optimal parameters for the algorithms |
void linear_solver_dense | ( | varchar | source_table, |
varchar | out_table, | ||
varchar | row_id, | ||
varchar | left_hand_side, | ||
varchar | right_hand_side | ||
) |