#acl Sebastian Walter:read,write Hannah Bast:read,write All:read
= Welcome to the Wiki of the courses "Databases and Information Systems" and "Information Retrieval" in the winter semester 2023/2024 =
{{{
#!html
Information about the exam on Monday, March 18, 2024
}}}
{{{
#!html
Results of the official evaluation of this course
}}}
The course is given by [[http://ad.informatik.uni-freiburg.de/staff/bast|Prof. Dr. Hannah Bast]] and assisted by [[https://ad.informatik.uni-freiburg.de/staff/walter|Sebastian Walter]].
It takes place every Tuesday from 14:'''05''' - 15:'''55''' h in the seminar room [[https://mm.informatik.uni-freiburg.de/room/101-1-9|101-1-9/13]] and on Zoom ([[https://uni-freiburg.zoom.us/j/66883835704?pwd=eDNSNWdML3BvREhUTE03V3d5VS9BUT09|meeting link]], meeting ID: 668 8383 5704, passcode: IRWS23/24). The first lecture is on Tuesday 17.10.2023 and the last lecture is on Tuesday 06.02.2024. There will be no lectures on the Tuesdays 26.12.2023 and 02.01.2024 (Christmas break) and on two additional Tuesdays not determined yet. In total there will be 13 lectures.
The tutors for this course are Daniel Bindemann, [[https://ad.informatik.uni-freiburg.de/staff/brosi|Patrick Brosi]], [[https://ad.informatik.uni-freiburg.de/staff/kalmbach|Johannes Kalmbach]], [[https://ad.informatik.uni-freiburg.de/staff/prange|Natalie Prange]] and Robin Textor-Falconi.
The administrator of the supporting systems (Daphne, SVN, Forum, Jenkins) is [[http://ad.informatik.uni-freiburg.de/staff/lehmann|Axel Lehmann]].
== Important Links ==
* Our course management system [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/|Daphne]] (login with your RZ user name and password).
* The [[https://daphne.informatik.uni-freiburg.de/forum/viewforum.php?f=1281|forum]] for announcements and questions.
* The [[Manuals/AskingOnAForum|manual]] for how to ask questions on the forum.
* Our [[InformationRetrievalWS2324/Rules|rules for the exercise sheets]]. Please read them '''carefully, completely''' and '''before''' you start working on the exercises. They are valid for all exercise sheets of this course.
* Information about Subversion (SVN) can be found [[SVN|here (in German)]] and [[SVNEnglish|here (in English)]]; about some editors (including Vim) [[Editoren|here (in German)]].
* The courses from previous semesters: [[InformationRetrievalWS2223|Information Retrieval WS 22/23]], [[InformationRetrievalWS2122|Information Retrieval WS 21/22]], [[InformationRetrievalWS1920|Information Retrieval WS 19/20]], [[InformationRetrievalWS1819|Information Retrieval WS 18/19]], [[InformationRetrievalWS1718|Information Retrieval WS 17/18]], [[InformationRetrievalWS1617|Information Retrieval WS 16/17]], [[InformationRetrievalWS1516|Information Retrieval WS 15/16]], [[InformationRetrievalWS1314|Information Retrieval WS 13/14]], [[InformationRetrievalWS1213|Information Retrieval WS 12/13]].
* The exams from previous semesters: [[InformationRetrievalWS2223/Exam|WS 22/23]], [[InformationRetrievalWS2122/Exam|WS 21/22]], [[InformationRetrievalWS1920/Exam|WS 19/20]], [[InformationRetrievalWS1819/Exam|WS 18/19]], [[InformationRetrievalWS1718/Exam|WS 17/18]], [[InformationRetrievalWS1617/Exam|WS 16/17]], [[InformationRetrievalWS1516/Exam|WS 15/16]], [[InformationRetrievalWS1314/Exam|WS 13/14]], [[InformationRetrievalWS1213/Exam|WS 12/13]].
* [[InformationRetrievalWS2324/PythonEnv|Here]] you find a list of the Python packages you should have installed in your environment. Alternatively you can download and use our [[InformationRetrievalWS2324/LinuxImage|Linux Image]] (for Virtualbox or VMWare) which already contains all packages.
* A !PyTorch cheatsheet can be found [[PyTorchCheatSheet|here]]. An overview over basic tensor usage within !PyTorch can be found [[https://pytorch.org/tutorials/beginner/ptcheat.html#tensors|here]]. If you are already familiar with !NumPy you can find information about how !NumPy operations translate to !PyTorch operations [[https://github.com/wkentaro/pytorch-for-numpy-users|here]].
* [[https://youtu.be/96r3iqJhx8Y|Here]] you can find a link to a video tutorial about how to work on the exercise sheets with our course system Daphne and SVN.
* [[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/timeslots/|Here]] you can book individual time slots with your tutor.
== Lecture Slides, Video Recordings, Exercise Sheets, and Code ==
'''For visitors from outside the University of Freiburg: You can freely access all the course materials below, except the solutions, by replacing /svn/ by /svn-public/ in the URL.'''
* Lecture 1, Tuesday, October 17, 2023 (Introduction, Inverted Index, Zipf's Law): <
>[[https://youtu.be/iSmGBkSkMvg|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-01.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-01.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-01.pdf|Exercise Sheet 1]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/code/lecture-01/|Code from the lecture]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-01/|Code template for ES1]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies.tsv|Dataset for ES1]] (115,454 movies with title + description + 3 columns with scores that you can ignore for this sheet). Note: If the dataset download does not start automatically when clicking the link, copy the link address and paste it in a new tab or download it using the wget command. [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-01/|Solution for ES1]]
* Lecture 2, Tuesday, October 24, 2023 (Ranking and Evaluation): <
>[[https://youtu.be/B-LlRMBg7q4|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-02.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-02.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-02.pdf|Exercise Sheet 2]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-02/|Code template for ES2]], [[InformationRetrievalWS2324/ResultsES2|Table to enter your benchmark results]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies-benchmark.train.tsv|Training benchmark]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies-benchmark.test.tsv|Testing benchmark]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-02/|Solution for ES2]]
* Lecture 3, Tuesday, October 31, 2023 (Database basics, SQLite3, SQL Introduction): <
>[[https://youtu.be/uK_ndAYbR24|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-03.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-03.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-03.pdf|Exercise Sheet 3]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/code/lecture-03/|SQL from the lecture]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-03/|Template for ES3]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-03/|Solution for ES3]]
* Lecture 4, Tuesday, November 7 2023 (Query planning and joins): <
>[[https://youtu.be/vvNzzFBOMmw|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-04.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-04.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-04.pdf|Exercise Sheet 4]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-04/|Code template for ES4]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies-tables.tar.gz|TSV files (.tar.gz)]], [[InformationRetrievalWS2324/ResultsES4|Table to enter your query results]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-04/|Solution for ES4]]
* Lecture 5, Tuesday, November 14 2023 (Merge join, more SQL, dynamic tables): <
>[[https://youtu.be/ZvRWwLlq0kQ|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-05.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-05.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-05.pdf|Exercise Sheet 5]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-05/|Code template for ES5]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies-tables-new.tar.gz|New TSV files (.tar.gz)]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-05/|Solution for ES5]]
* Lecture 6, Tuesday, November 21 2023 (Knowledge Graphs, SPARQL, SPARQL to SQL): <
>[[https://youtu.be/xWJb06SAdhQ|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-06.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-06.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-06.pdf|Exercise Sheet 6]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-06/|Code template for ES6]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-simple.tsv|wikidata-simple.tsv (915 MB, 17'360'245 lines)]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-complex.tsv|wikidata-complex.tsv (3.4 GB, 60'022'981 lines)]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-06/|Solution for ES6]]
* Lecture 7, Tuesday, December 5 2023 (Fuzzy Search, Prefix Edit Dist, Q-Gram Index): <
>[[https://youtu.be/KSSA5BhkYp8|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-07.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-07.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-07.pdf|Exercise Sheet 7]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-07/|Code template for ES7]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-entities.tsv|wikidata-entities.tsv (269 MB, 1'581'140 entities)]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-entities.100k.tsv|wikidata-entities.100k.tsv (21 MB, 100'000 entities)]], [[InformationRetrievalWS2324/ResultsES7|Table to enter your query results]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-07/|Solution for ES7]]
* Lecture 8, Tuesday, December 12 2023 (Web Applications 1): <
>[[https://youtu.be/nEqoHW_ZL-I|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-08.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-08.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-08.pdf|Exercise Sheet 8]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-08/|Code template for ES8]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-entities-new.tsv|wikidata-entities-new.tsv (UPDATED)]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-entities-new.100k.tsv|wikidata-entities-new.100k.tsv (UPDATED)]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-properties.tsv|wikidata-properties.tsv (400 new triples for optional task 4)]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-08/|Solution for ES8 (without SPARQL-to-SQL functionality for now)]]
* Lecture 9, Tuesday, December 19 2023 (Web Applications 2): <
>[[https://youtu.be/nKCYJI34AZY|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-09.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-09.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-09.pdf|Exercise Sheet 9]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-09/|Code template for ES9]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-entities-new.tsv|wikidata-entities-new.tsv (UPDATED)]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-entities-new.100k.tsv|wikidata-entities-new.100k.tsv (UPDATED)]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/wikidata-properties.tsv|wikidata-properties.tsv (400 new triples for predicate counts and labels)]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-09/|Solution for ES9]]
* Lecture 10, Tuesday, January 16 2024 (Vector Space Model, Word embeddings): <
>[[https://youtu.be/zJrpToFfmyc|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-10.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-10.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-10.pdf|Exercise Sheet 10]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/code/lecture-10/|Code from the lecture]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-10/|Code template for ES10]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies-plots.tsv|movies-plots.tsv]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/embeddings.fasttext.pt|embeddings.fasttext.pt]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/embeddings.random.pt|embeddings.random.pt]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-10/|Solution for ES10]]
* Lecture 11, Tuesday, January 23 2024 (Linear Classifiers, Preceptrons, Logistic Regression): <
>[[https://youtu.be/ciz37Xe3wxo|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-11.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-11.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-11.pdf|Exercise Sheet 11]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-11/|Code template for ES11]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies-funny.train.tsv|movies-funny.train.tsv]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/movies-funny.test.tsv|movies-funny.test.tsv]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/embeddings.fasttext.pt|embeddings.fasttext.pt]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/embeddings.random.pt|embeddings.random.pt]], [[InformationRetrievalWS2324/ResultsES11|Table to enter your results]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-11/|Solution for ES11]]
* Lecture 12, Tuesday, January 30 2024 (Language Models): <
>[[https://youtu.be/xNAbvLnvYbE|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-12.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-12.pdf|Slides]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/exercises/sheet-12.pdf|Exercise Sheet 12]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/code/lecture-12/|Code from the lecture]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/templates/sheet-12/|Code template for ES12]], [[http://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/datasets/lecture_transcripts.txt|lecture_transcripts.txt]], [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/solutions/sheet-12/|Solution for ES12]]
* Lecture 13, Tuesday, February 6 2024 (Evaluation, Exam, Work at AD Chair): <
>[[https://youtu.be/4PC8RtKEwsg|Video recording]] ([[https://ad-teaching.informatik.uni-freiburg.de/InformationRetrievalWS2324/lecture-13.mp4|MP4 Download]]), [[https://daphne.informatik.uni-freiburg.de/ws2324/InformationRetrieval/svn/public/slides/lecture-13.pdf|Slides]]