SQL-Neural-Network/05 computational views.sql at main · lszel/SQL-Neural-Network · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
use mnist;

CREATE OR REPLACE VIEW `neuron_delta_relu` AS
SELECT
    *,
    (n.predicted - n.expected) *  RECTIFIEDLINEARUNIT_DERIVATIVE(`n`.`predicted`) new_delta
FROM
    neurons n
order by n.n_id;

CREATE OR REPLACE VIEW `neuron_delta_sig` AS
SELECT
    *,
    (n.predicted - n.expected) *  sigmoid_DERIVATIVE(`n`.`predicted`) new_delta
FROM
    neurons n
order by n.n_id;

CREATE OR REPLACE VIEW `neuron_delta_hidden_relu` AS
SELECT
    n.*,
    SUM( nou.delta * w.w * RECTIFIEDLINEARUNIT_DERIVATIVE(`n`.`predicted`) )  AS `new_delta`
    -- sum(  (nou.predicted-nou.expected) * (nou.predicted* (1-nou.predicted) )  *  w.w  ) new_delta
FROM
    neurons n
    join weights w on w.n_id_in=n.n_id
    join neurons nou on nou.n_id=w.n_id_out
group by n.n_id
order by n.n_id;

CREATE OR REPLACE VIEW `neuron_delta_hidden_sig` AS
SELECT
    n.*,
    SUM( nou.delta * w.w * sigmoid_DERIVATIVE(`n`.`predicted`) )  AS `new_delta`
    -- sum(  (nou.predicted-nou.expected) * (nou.predicted* (1-nou.predicted) )  *  w.w  ) new_delta
FROM
    neurons n
    join weights w on w.n_id_in=n.n_id
    join neurons nou on nou.n_id=w.n_id_out
group by n.n_id
order by n.n_id;


CREATE OR REPLACE VIEW forward_propagation_values_sig AS
    SELECT
        n.n_id AS n_id,
        n.predicted,
         SIGMOID(SUM(ni.predicted * w.w) + n.bias) AS `calculated_output`
    #    hiperbolictangent(SUM(ni.predicted * w.w) + n.bias) AS `calculated_output`
    FROM
        weights w
        JOIN neurons n  on n.n_id = w.n_id_out
        JOIN neurons ni on ni.n_id = w.n_id_in
    GROUP BY n.n_id;


CREATE OR REPLACE VIEW forward_propagation_values_relu AS
    SELECT
        n.n_id AS n_id,
        n.predicted,
         RectifiedLinearUnit(SUM(ni.predicted * w.w) + n.bias) AS `calculated_output`
    #    hiperbolictangent(SUM(ni.predicted * w.w) + n.bias) AS `calculated_output`
    FROM
        weights w
        JOIN neurons n  on n.n_id = w.n_id_out
        JOIN neurons ni on ni.n_id = w.n_id_in
    GROUP BY n.n_id;