Index of /~sibel/dbs_notes/fall2020_lecture_notes

[ICO]NameLast modifiedSizeDescription
[PARENTDIR]Parent Directory  -  
[ ]Lecture24_inclass .pdf2020-12-03 21:32 808K 
[ ]Lecture25_inclass.pdf2020-12-07 21:30 2.0M 
[TXT]lecture1_1_introduction.txt2020-09-03 20:28 1.3K 
[TXT]lecture1_2_relational_model.txt2020-09-03 20:28 2.6K 
[TXT]lecture1_3_inclassnotes.txt2020-09-03 20:28 1.2K 
[TXT]lecture1_3_inclassnotes_2.txt2020-09-03 20:28 1.7K 
[TXT]lecture2_1_relationalalgebra.txt2020-09-03 20:28 1.4K 
[TXT]lecture2_2_relationalalgebra.txt2020-09-03 20:28 3.4K 
[TXT]lecture2_3_relationalalgebra.txt2020-09-03 20:28 3.8K 
[TXT]lecture2_4_relationalalgebra.txt2020-09-03 21:00 3.8K 
[TXT]lecture2_example_data_model.txt2020-09-03 20:28 1.1K 
[TXT]lecture3_1_relationalalgebra.txt2020-09-07 00:13 2.4K 
[TXT]lecture3_2_relationalalgebra.txt2020-09-06 20:30 219  
[TXT]lecture3_3_normalization_part1.txt2020-09-06 21:44 3.9K 
[TXT]lecture3_4_inclass.txt2020-09-08 20:32 3.9K 
[TXT]lecture4_1_normalization_normal_forms.txt2020-09-07 17:15 4.3K 
[TXT]lecture4_2_normalization_minimal_basis.txt2020-09-07 17:51 2.0K 
[TXT]lecture4_3_inclass.txt2020-09-10 20:32 4.4K 
[TXT]lecture5_1_decompositions.txt2020-09-13 20:48 4.1K 
[TXT]lecture5_2_decompositions.txt2020-09-13 21:11 2.1K 
[TXT]lecture5_3_3NFdecompositions.txt2020-09-13 21:39 1.0K 
[TXT]lecture5_4_BCNFdecompositions.txt2020-09-13 22:28 1.7K 
[TXT]lecture5_5_inclass.txt2020-09-14 20:31 3.8K 
[TXT]lecture6_1_fourthnormalform.txt2020-09-16 20:58 728  
[ ]lecture6_2_3_entity_relationship_diagrams.pdf2020-09-16 22:18 211K 
[TXT]lecture6_2_EntityRelationshipDiagrams.txt2020-09-16 21:58 1.7K 
[TXT]lecture6_2_and_3_EntityRelationshipDiagrams.txt2020-09-16 22:08 1.7K 
[TXT]lecture6_4_inclass.txt2020-09-17 20:19 1.2K 
[ ]lecture6_4_inclass_er.pdf2020-09-17 20:38 91K 
[ ]lecture7_1_2_entity_relationship_diagrams.pdf2020-09-20 22:23 671K 
[TXT]lecture7_1_er.txt2020-09-19 19:41 1.4K 
[TXT]lecture7_2_er.txt2020-09-19 20:02 1.0K 
[ ]lecture7_3_inclass.pdf2020-09-21 22:49 431K 
[TXT]lecture7_3_inclass.txt2020-09-21 22:50 2.6K 
[TXT]lecture8_1_entities_revisited.txt2020-09-20 21:08 1.3K 
[ ]lecture8_1_entity_relationship_diagrams_weakEntities.pdf2020-09-20 22:23 614K 
[ ]lecture8_2_entity_relationship_diagrams_gierarchies.pdf2020-09-20 22:23 607K 
[TXT]lecture8_2_hierarchies.txt2020-09-20 22:17 2.4K 
[ ]lecture8_3_in_class.pdf2020-09-24 20:42 314K 
[TXT]lecture8_3_inclass.txt2020-09-24 20:29 1.3K 
[TXT]lecture9_exam1_review.txt2020-09-29 23:29 10K 
[ ]lecture9_review_session.pdf2020-09-28 20:44 529K 
[TXT]lecture10_sql_intro.txt2020-10-05 20:18 5.5K 
[TXT]lecture11_1_sql_intro.txt2020-10-07 22:36 3.0K 
[TXT]lecture11_2_sql_from.txt2020-10-07 23:17 1.3K 
[TXT]lecture11_3_inclass.txt2020-10-08 20:33 6.0K 
[TXT]lecture11_3_sql_setbagoperations.txt2020-10-08 01:11 1.8K 
[TXT]lecture11_4_sql_groupbyhaving.txt2020-10-08 01:37 1.7K 
[TXT]lecture12_1_sql_leftouterjoin.txt2020-10-14 19:19 1.3K 
[TXT]lecture12_2_sql_scalar_queries.txt2020-10-14 20:14 2.1K 
[TXT]lecture12_3_sql_setcomparisons.txt2020-10-14 20:37 2.0K 
[TXT]lecture12_4_inclass.txt2020-10-15 20:43 3.7K 
[TXT]lecture13_1_sqlsubqueries_correlated.txt2020-10-19 01:20 2.5K 
[TXT]lecture13_2_transactionsinsert.txt2020-10-19 01:40 1.6K 
[TXT]lecture13_3_updatedelete.txt2020-10-19 02:06 1.8K 
[TXT]lecture13_4_inclass.txt2020-10-19 20:30 4.2K 
[TXT]lecture14_1_constraints.txt2020-10-21 20:52 1.4K 
[TXT]lecture14_1_example_sql.txt2020-10-21 20:26 4.6K 
[TXT]lecture14_2_isolation.txt2020-10-21 21:14 874  
[TXT]lecture14_3_procedural_programming.txt2020-10-21 22:07 1.5K 
[TXT]lecture14_4_inclass.txt2020-10-22 19:56 1.9K 
[TXT]lecture14_4_inclass_example_py.txt2020-10-22 19:13 284  
[TXT]lecture15_1_plpgsql.txt2020-10-26 19:14 6.4K 
[TXT]lecture15_2_triggers.txt2020-10-25 18:51 2.8K 
[TXT]lecture15_3_inclass.txt2020-10-26 21:41 9.7K 
[TXT]lecture16_1_views_access_rights.txt2020-10-28 21:43 2.2K 
[TXT]lecture16_2_advancedsql_features.txt2020-10-28 22:05 1.4K 
[TXT]lecture16_3_inclass.txt2020-10-29 20:15 916  
[TXT]lecture17_1_or_extensions.txt2020-10-30 22:34 606  
[TXT]lecture17_inclass_review.txt2020-11-02 21:21 5.3K 
[TXT]lecture18_1_inclass.txt2020-11-09 21:30 3.5K 
[TXT]lecture19_1_indexing_types.txt2020-11-11 23:33 1.1K 
[ ]lecture19_2_3.pdf2020-11-12 03:55 1.5M 
[TXT]lecture19_2_btrees.txt2020-11-12 02:13 417  
[TXT]lecture19_4_inclass.txt2020-11-12 21:26 1.4K 
[TXT]lecture20_1_btree_extensions.txt2020-11-15 22:44 525  
[TXT]lecture20_2_otherindex_types.txt2020-11-15 23:47 1.9K 
[TXT]lecture20_3_inclass.txt2020-11-16 21:23 2.4K 
[ ]lecture20_btree_examples.pdf2020-11-16 03:19 919K 
[TXT]lecture21_1_query_execution.txt2020-11-19 00:07 776  
[TXT]lecture21_2_index_scan.txt2020-12-01 01:58 2.4K 
[TXT]lecture21_3_block_nested_loop_join.txt2020-11-19 01:02 514  
[TXT]lecture21_4_inclass.txt2020-11-19 21:25 2.9K 
[TXT]lecture22_1_external_sort.txt2020-11-21 23:23 1.0K 
[TXT]lecture22_3_qopt_intro.txt2020-11-22 02:33 1.0K 
[TXT]lecture22_5_size_estimation.txt2020-11-22 03:37 1.6K 
[TXT]lecture22_6_inclass.txt2020-11-23 20:52 1.3K 
[TXT]lecture23_1_concurrency_introduction.txt2020-11-28 22:50 1.3K 
[TXT]lecture23_2_checking_serializability.txt2020-12-08 01:39 1.0K 
[TXT]lecture23_3_inclass.txt2020-12-08 01:40 3.6K 
[TXT]lecture24_1_two_phase_locking.txt2020-11-29 00:05 1.0K 
[TXT]lecture24_2_lock_management.txt2020-11-30 23:23 927  
[TXT]lecture24_2_locking_granularity.txt2020-11-29 00:06 0  
[TXT]lecture24_3_durability_intro.txt2020-12-01 00:02 487  
[ ]lecture25_1_3_durability.pdf2020-12-05 23:52 1.5M 
[TXT]lecture25_1_logging.txt2020-12-05 21:28 922  
[TXT]lecture25_2_force_steal.txt2020-12-05 21:49 934  
[TXT]lecture25_3_ARIES_recovery_algorithm.txt2020-12-05 23:24 1.0K 
[TXT]lecture25_4_inclass.txt2020-12-07 20:45 1.5K 
[TXT]lecture26.txt2020-12-10 20:50 4.1K