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.04025626182556152 seconds.
Total Elapsed Time for Queries: 0.04025626182556152 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.0004699230194091797 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.0003638267517089844 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.00345301628112793 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES
(?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 445728 [2] => 1 [3] => 1789988831 )
Array ( [0] => 2 [1] => 445728 [2] => 1 [3] => 1789988831 )
Time: 0.002206087112426758 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: 9.202957153320312E-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.002084970474243164 seconds.
INSERT INTO ITEM_IMPRESSION_SUMMARY VALUES
(?, ?, ?, -4, ?, 0, -1, -1) ON CONFLICT DO NOTHING
Array ( [0] => 2 [1] => 331 [2] => 3 [3] => 1789988831 )
Array ( [0] => 2 [1] => 331 [2] => 3 [3] => 1789988831 )
Time: 0.002215862274169922 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: 8.0108642578125E-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] => 1789988831 )
Array ( [0] => 2 [1] => %2% [2] => 1789988831 )
Time: 0.0002160072326660156 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.0001518726348876953 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: 3.814697265625E-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.314018249511719E-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.194808959960938E-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.099441528320312E-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.099441528320312E-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: 3.099441528320312E-5 seconds.
SELECT * FROM GROUP_ITEM WHERE ID=? LIMIT 1
Array ( [0] => 445728 )
Array ( [0] => 445728 )
Time: 8.392333984375E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 4.38690185546875E-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.0008900165557861328 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.02318882942199707 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 0.000164031982421875 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.503395080566406E-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: 1.788139343261719E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.788139343261719E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.121925354003906E-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.311302185058594E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.311302185058594E-5 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 1.192092895507812E-5 seconds.
SELECT * FROM GROUP_ITEM WHERE ID=? LIMIT 1
Array ( [0] => 445728 )
Array ( [0] => 445728 )
Time: 0.0001211166381835938 seconds.
SELECT OPTIONS FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 4.696846008300781E-5 seconds.
SELECT STATUS FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Array ( [0] => 2 )
Time: 0.0003159046173095703 seconds.
SELECT USER_NAME FROM USERS WHERE USER_ID = ?
Array ( [0] => 2 )
Array ( [0] => 2 )
Time: 0.0001628398895263672 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.0004639625549316406 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.0004611015319824219 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.0002739429473876953 seconds.
SELECT USER_ID FROM USER_GROUP WHERE GROUP_ID = ?
Array ( [0] => -1 )
Array ( [0] => -1 )
Time: 0.0001020431518554688 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.0003590583801269531 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => -2 )
Array ( [0] => -2 )
Time: 0.0002658367156982422 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 0.0001578330993652344 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 0.0001289844512939453 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 0.0001389980316162109 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 0.0001840591430664062 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 0.0001969337463378906 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 9.512901306152344E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 9.989738464355469E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 9.608268737792969E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 5.698204040527344E-5 seconds.
SELECT RENDER_ENGINE FROM SOCIAL_GROUPS WHERE GROUP_ID = ?
Array ( [0] => 331 )
Array ( [0] => 331 )
Time: 2.09808349609375E-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.0002930164337158203 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: 7.796287536621094E-5 seconds.