2021-12-01
Dec 1 In-Class Exercise Thread .
Please post your solutions to the Dec 1 In-Class Exercise Thread.
Best,
Chris
Please post your solutions to the Dec 1 In-Class Exercise Thread.
Best,
Chris
The graphs differ slightly because the data is shuffled for each run and the validation data batches used would most likely be different for each epoch/run.
((resource:epoch_accuracy (1).png|Resource Description for epoch_accuracy (1).png))
The graphs differ slightly because the data is shuffled for each run and the validation data batches used would most likely be different for each epoch/run.
((resource:run_2021_m_01-16_14_10_train.png|Resource Description for run_2021_m_01-16_14_10_train.png))
Epoch Accuracy graph:
How similar are the curves? Why aren't they the same? The curves are similar in a way they are rising towards better accuracy every epoch. The curves are not exactly the same because the weights are initialized differently in every run, also the batches are randomly chosen in every run.
Main Graph: 
Epoch Accuracy graph:((resource:Screen Shot 2021-12-01 at 16.24.00.png|Resource Description for Screen Shot 2021-12-01 at 16.24.00.png))
How similar are the curves? Why aren't they the same?
The curves are similar in a way they are rising towards better accuracy every epoch. The curves are not exactly the same because the weights are initialized differently in every run, also the batches are randomly chosen in every run.
Main Graph: ((resource:Screen Shot 2021-12-01 at 16.24.29.png|Resource Description for Screen Shot 2021-12-01 at 16.24.29.png))
The curves are similar in the sense that they go towards higher accuracy in each iteration. However, they are not exactly the same because with each run the data is shuffled (chosen randomly).
((resource:Screen Shot 2021-12-01 at 4.24.17 PM.png|Resource Description for Screen Shot 2021-12-01 at 4.24.17 PM.png))
The curves are similar in the sense that they go towards higher accuracy in each iteration. However, they are not exactly the same because with each run the data is shuffled (chosen randomly).
((resource:run_2021_m_02-00_07_32_train.png|Resource Description for run_2021_m_02-00_07_32_train.png))
The graphs differ slightly because the data is shuffled for each run and the validation data batches used would most likely be different for each epoch/run.
((resource:Screen Shot 2021-12-01 at 5.04.51 PM.png|Resource Description for Screen Shot 2021-12-01 at 5.04.51 PM.png))
The graphs differ slightly because the data is shuffled for each run and the validation data batches used would most likely be different for each epoch/run.
((resource:Screen Shot 2021-12-01 at 4.50.37 PM.png|Resource Description for Screen Shot 2021-12-01 at 4.50.37 PM.png))
The validation data batches used are different for each epoch/run. and also data has been shuffled for each run. This is why the graphs differ slightly.
(Edited: 2021-12-01)((resource:10. tensorboard.JPG|Resource Description for 10. tensorboard.JPG))
((resource:11. tensorboard.JPG|Resource Description for 11. tensorboard.JPG))
The validation data batches used are different for each epoch/run. and also data has been shuffled for each run. This is why the graphs differ slightly.
The graphs are not similar because the data is shuffled for each run and the validation data batches change for every epoch.
(Edited: 2021-12-01)((resource:Picture2.png|Resource Description for Picture2.png))
((resource:Picture1.png|Resource Description for Picture1.png))
The graphs are not similar because the data is shuffled for each run and the validation data batches change for every epoch.
2021-12-02
The curves are similar in that each iteration progresses toward greater precision. They are not identical, though, because the data is scrambled with each iteration
((resource:Screen Shot 2021-12-02 at 6.46.59 PM.png|Resource Description for Screen Shot 2021-12-02 at 6.46.59 PM.png))
((resource:Screen Shot 2021-12-02 at 6.47.21 PM.png|Resource Description for Screen Shot 2021-12-02 at 6.47.21 PM.png))
The curves are similar in that each iteration progresses toward greater precision. They are not identical, though, because the data is scrambled with each iteration
Because the data is shuffled for each run, and the validation data batches utilized are most likely different for each epoch or run, the graphs differ slightly.
((resource:Screen Shot 2021-12-02 at 6.55.38 PM.png|Resource Description for Screen Shot 2021-12-02 at 6.55.38 PM.png))
((resource:Screen Shot 2021-12-02 at 6.54.55 PM.png|Resource Description for Screen Shot 2021-12-02 at 6.54.55 PM.png))
Because the data is shuffled for each run, and the validation data batches utilized are most likely different for each epoch or run, the graphs differ slightly.
Over here Graphs are different because the data is shuffled for each run and the validation data batches change for every epoch.
((resource:Capture.JPG|Resource Description for Capture.JPG))
Over here Graphs are different because the data is shuffled for each run and the validation data batches change for every epoch.
(c) This Site - This Search Engine
Query Statistics
https://www.yioop.com/thread/445728
Total Elapsed Time for Queries: 0.04107475280761719 seconds.
Total Elapsed Time for Queries: 0.04107475280761719 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.0002951622009277344 seconds.
SELECT COALESCE(MAX(UPDATE_TIMESTAMP), 0) AS MOST_RECENT FROM ITEM_IMPRESSION_SUMMARY WHERE USER_ID = 2 AND ITEM_TYPE = 3 AND ITEM_ID IN (SELECT GROUP_ID FROM USER_GROUP WHERE USER_ID = 2 AND STATUS = 1) AND UPDATE_PERIOD = -4
Time: 0.0004010200500488281 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY
WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 445728 [2] => 1 )
Array ( [0] => 2 [1] => 445728 [2] => 1 )
Time: 0.002958059310913086 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES
(?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 445728 [2] => 1 [3] => 1789997194 )
Array ( [0] => 2 [1] => 445728 [2] => 1 [3] => 1789997194 )
Time: 0.002129077911376953 seconds.
UPDATE ITEM_IMPRESSION_SUMMARY
SET NUM_VIEWS = NUM_VIEWS + 1 WHERE USER_ID=? AND
ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -2
AND UPDATE_TIMESTAMP = 0
Array ( [0] => 2 [1] => 445728 [2] => 1 )
Array ( [0] => 2 [1] => 445728 [2] => 1 )
Time: 8.702278137207031E-5 seconds.
DELETE FROM ITEM_IMPRESSION_SUMMARY
WHERE USER_ID=? AND ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -4
Array ( [0] => 2 [1] => 331 [2] => 3 )
Array ( [0] => 2 [1] => 331 [2] => 3 )
Time: 0.002183914184570312 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES
(?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 331 [2] => 3 [3] => 1789997194 )
Array ( [0] => 2 [1] => 331 [2] => 3 [3] => 1789997194 )
Time: 0.002149105072021484 seconds.
UPDATE ITEM_IMPRESSION_SUMMARY
SET NUM_VIEWS = NUM_VIEWS + 1 WHERE USER_ID=? AND
ITEM_ID=? AND ITEM_TYPE=? AND UPDATE_PERIOD = -2
AND UPDATE_TIMESTAMP = 0
Array ( [0] => 2 [1] => 331 [2] => 3 )
Array ( [0] => 2 [1] => 331 [2] => 3 )
Time: 7.796287536621094E-5 seconds.
SELECT COUNT(GI.ID) AS NUM FROM GROUP_ITEM GI WHERE GI.GROUP_ID IN (SELECT GROUP_ID FROM USER_GROUP WHERE USER_ID = ? AND STATUS = 1) AND GI.TITLE NOT LIKE ? AND GI.PUBDATE > ?
Array ( [0] => 2 [1] => %2% [2] => 1789997190 )
Array ( [0] => 2 [1] => %2% [2] => 1789997190 )
Time: 0.0004241466522216797 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-4 )
Array ( [0] => -1 [1] => 2 [2] => 2-4 )
Time: 0.0002300739288330078 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-37 )
Array ( [0] => -1 [1] => 2 [2] => 2-37 )
Time: 6.4849853515625E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-202 )
Array ( [0] => -1 [1] => 2 [2] => 2-202 )
Time: 3.600120544433594E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-687 )
Array ( [0] => -1 [1] => 2 [2] => 2-687 )
Time: 3.218650817871094E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1115 )
Array ( [0] => -1 [1] => 2 [2] => 2-1115 )
Time: 3.409385681152344E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1138 )
Array ( [0] => -1 [1] => 2 [2] => 2-1138 )
Time: 5.102157592773438E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1140 )
Array ( [0] => -1 [1] => 2 [2] => 2-1140 )
Time: 3.290176391601562E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1149 )
Array ( [0] => -1 [1] => 2 [2] => 2-1149 )
Time: 3.290176391601562E-5 seconds.
SELECT PARENT_ID FROM GROUP_ITEM WHERE GROUP_ID=? AND USER_ID=? AND TITLE=? LIMIT 1
Array ( [0] => -1 [1] => 2 [2] => 2-1152 )
Array ( [0] => -1 [1] => 2 [2] => 2-1152 )
Time: 4.00543212890625E-5 seconds.
SELECT * FROM GROUP_ITEM WHERE ID=? LIMIT 1
Array ( [0] => 445728 )
Array ( [0] => 445728 )
Time: 0.0001058578491210938 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 4.792213439941406E-5 seconds.
SELECT COUNT(DISTINCT GI.ID) AS NUM FROM GROUP_ITEM GI, SOCIAL_GROUPS G,
USER_GROUP UG, USERS O WHERE GI.PARENT_ID='445728' AND NOT LOWER(group_name) LIKE LOWER('Personal$%') AND (UG.USER_ID='2' OR G.REGISTER_TYPE IN ('4','3') ) AND GI.USER_ID=O.USER_ID AND
GI.GROUP_ID=G.GROUP_ID AND GI.GROUP_ID=UG.GROUP_ID AND ((
G.MEMBER_ACCESS IN ('2','3','4', '5')) OR
(G.OWNER_ID = UG.USER_ID OR UG.USER_ID = '1'))
Time: 0.001108884811401367 seconds.
SELECT DISTINCT GI.ID AS ID,
GI.PARENT_ID AS PARENT_ID, GI.GROUP_ID AS GROUP_ID,
GI.TITLE AS TITLE, GI.DESCRIPTION AS DESCRIPTION,
GI.FLAG AS FLAG, GI.PUBDATE AS PUBDATE,
GI.EDIT_DATE AS EDIT_DATE, G.OWNER_ID AS OWNER_ID,
G.MEMBER_ACCESS AS MEMBER_ACCESS,
G.GROUP_NAME AS GROUP_NAME, P.USER_NAME AS USER_NAME,
P.USER_ID AS USER_ID, GI.TYPE AS TYPE, GI.UPS AS UPS,
GI.DOWNS AS DOWNS, G.VOTE_ACCESS AS VOTE_ACCESS
FROM GROUP_ITEM GI, SOCIAL_GROUPS G, USER_GROUP UG, USERS P
WHERE GI.PARENT_ID='445728' AND NOT LOWER(group_name) LIKE LOWER('Personal$%') AND (UG.USER_ID='2' OR G.REGISTER_TYPE IN ('4','3') ) AND GI.GROUP_ID=G.GROUP_ID AND GI.GROUP_ID=UG.GROUP_ID AND ((
G.MEMBER_ACCESS IN ('2','3','4', '5')) OR
(G.OWNER_ID = UG.USER_ID OR UG.USER_ID = '1')) AND GI.PARENT_ID NOT IN (SELECT DISCUSS_THREAD FROM GROUP_PAGE WHERE TITLE LIKE '%$$%' AND DISCUSS_THREAD IS NOT NULL) AND P.USER_ID = GI.USER_ID ORDER BY GI.PUBDATE ASC LIMIT 10 OFFSET 0
Time: 0.0254518985748291 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 0.0001780986785888672 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.884864807128906E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.09808349609375E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.002716064453125E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.9073486328125E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.193450927734375E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.406669616699219E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.287460327148438E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.287460327148438E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.287460327148438E-5 seconds.
SELECT * FROM GROUP_ITEM WHERE ID=? LIMIT 1
Array ( [0] => 445728 )
Array ( [0] => 445728 )
Time: 0.0001649856567382812 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 4.291534423828125E-5 seconds.
SELECT STATUS FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Array ( [0] => 2 )
Time: 0.0004401206970214844 seconds.
SELECT USER_NAME FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Array ( [0] => 2 )
Time: 0.000308990478515625 seconds.
SELECT * FROM VISITOR WHERE ADDRESS = :address
AND PAGE_NAME = :page_name LIMIT 1
Array ( [:address] => 216.73.216.124 [:page_name] => forbidden_time_out )
Array ( [:address] => 216.73.216.124 [:page_name] => forbidden_time_out )
Time: 0.000186920166015625 seconds.
SELECT COUNT(DISTINCT G.GROUP_ID) AS NUM FROM USER_GROUP UG, SOCIAL_GROUPS G WHERE UG.USER_ID = ? AND UG.GROUP_ID = G.GROUP_ID AND ( UG.STATUS = 1 OR UG.STATUS = 5)
Array ( [0] => 2 )
Array ( [0] => 2 )
Time: 0.000370025634765625 seconds.
SELECT G.GROUP_ID AS GROUP_ID FROM SOCIAL_GROUPS G WHERE G.GROUP_NAME = ?
Array ( [0] => Personal$2 )
Array ( [0] => Personal$2 )
Time: 0.0001881122589111328 seconds.
SELECT USER_ID FROM USER_GROUP WHERE GROUP_ID = ?
Array ( [0] => -1 )
Array ( [0] => -1 )
Time: 6.29425048828125E-5 seconds.
SELECT G.GROUP_ID AS GROUP_ID,
G.GROUP_NAME AS GROUP_NAME,
G.OWNER_ID AS OWNER_ID, O.USER_NAME AS OWNER, REGISTER_TYPE,
UG.STATUS AS STATUS, G.MEMBER_ACCESS AS MEMBER_ACCESS,
G.VOTE_ACCESS AS VOTE_ACCESS, G.POST_LIFETIME AS POST_LIFETIME,
UG.JOIN_DATE AS JOIN_DATE, G.OPTIONS AS OPTIONS,
G.RENDER_ENGINE AS RENDER_ENGINE,
G.GROUP_THEME AS GROUP_THEME, G.PAGE_HEADER AS PAGE_HEADER,
G.PAGE_FOOTER AS PAGE_FOOTER
FROM SOCIAL_GROUPS G, USERS O, USER_GROUP UG WHERE (UG.USER_ID = :user_id) AND UG.GROUP_ID= :group_id AND UG.GROUP_ID=G.GROUP_ID AND OWNER_ID = O.USER_ID LIMIT 1
Array ( [:group_id] => 331 [:user_id] => 2 )
Array ( [:group_id] => 331 [:user_id] => 2 )
Time: 0.0001947879791259766 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => -2 )
Array ( [0] => -2 )
Time: 0.0001509189605712891 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.908706665039062E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.312660217285156E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 8.606910705566406E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 7.104873657226562E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.694129943847656E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.597404479980469E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.502037048339844E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.406669616699219E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.478195190429688E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.502037048339844E-5 seconds.
SELECT G.GROUP_ID AS GROUP_ID,
G.GROUP_NAME AS GROUP_NAME,
G.OWNER_ID AS OWNER_ID, O.USER_NAME AS OWNER, REGISTER_TYPE,
UG.STATUS AS STATUS, G.MEMBER_ACCESS AS MEMBER_ACCESS,
G.VOTE_ACCESS AS VOTE_ACCESS, G.POST_LIFETIME AS POST_LIFETIME,
UG.JOIN_DATE AS JOIN_DATE, G.OPTIONS AS OPTIONS,
G.RENDER_ENGINE AS RENDER_ENGINE,
G.GROUP_THEME AS GROUP_THEME, G.PAGE_HEADER AS PAGE_HEADER,
G.PAGE_FOOTER AS PAGE_FOOTER
FROM SOCIAL_GROUPS G, USERS O, USER_GROUP UG WHERE (UG.USER_ID = :user_id OR G.REGISTER_TYPE IN (3,4)) AND UG.GROUP_ID= :group_id AND UG.GROUP_ID=G.GROUP_ID AND OWNER_ID = O.USER_ID LIMIT 1
Array ( [:group_id] => 331 [:user_id] => 2 )
Array ( [:group_id] => 331 [:user_id] => 2 )
Time: 0.0002710819244384766 seconds.
SELECT STATUS FROM USER_GROUP WHERE
USER_ID=? AND GROUP_ID=? LIMIT 1
Array ( [0] => 2 [1] => 331 )
Array ( [0] => 2 [1] => 331 )
Time: 6.604194641113281E-5 seconds.