100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Previously searched by you
Previously searched by you
logo
  • UC Leuven-Limburg
  • Toegepaste Informatica
  • Databanken 2
To add items to your wishlist, you must be logged in
Summary

Samenvatting kort overzicht- db2

Rating
-
Sold
-
Pages
3
Uploaded on
17-01-2023
Written in
2021/2022

Samenvatting van 3 pagina's voor het vak Databanken 2 aan de UC Leuven-Limburg (kort overzicht- db2)

Institution
UC Leuven-Limburg
Course
Databanken 2








Whoops! We can’t load your doc right now. Try again or contact support.
Report Copyright Violation

Written for

Institution
UC Leuven-Limburg
Study
Toegepaste Informatica
Course
Databanken 2
All documents for this subject (1)

Document information

Uploaded on
January 17, 2023
Number of pages
3
Written in
2021/2022
Type
Summary

Subjects

  • databanken 2
  • db2

Content preview

Planning
1. Inleiding en Herhaling db1
2. Optimalisatie: Indexen en Algemene regels
3. Explain en benchmarks
4. Beperken resultaten: ORDER BY .. OFFSET .. FETCH ..
a. Lateral
5. Procedurele SQL
6. Ethiek (uitgesteld naar zelfstudie en gepland om te bespreken in een les na de
paasvakantie academiejaar 21-22)
7. Vensters en aggregaties
8. CTEs en beveiliging
a. Paas
b. Projektweek
9. (N)R_DBMS :ORDBMS/ODMS/NoSQL/YeSQL (CAP)
10. Exotische datatypes ea (XML/JSON/GIS MED), Inleiding Replicatie ea
11. Herhaling en voorbereiding examen, (tijdsgebonden: bespreking ethiek)
12. Laatste les + lezingen



OPTIMALISATIE

Index beînvloeden van verwerkingstijd
→ rijen worden in bestanden opgeslagen

2 methodes voor het opzoeken:
● sequentiële zoekmethode = rij voor rij
● Geindexeerde zoekmethode = index (b-tree)

Create index




Reindex
$3.62
Get access to the full document:
100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached
Get to know the seller
Seller avatar
marlenebraem
4.0
(1)

Get to know the seller

Seller avatar
marlenebraem UC Leuven-Limburg
View profile
Follow You need to be logged in order to follow users or courses
Sold
1
Member since
2 year
Number of followers
1
Documents
23
Last sold
1 year ago

4.0

1 reviews

5
0
4
1
3
0
2
0
1
0

Recently viewed by you

Thumbnail
Summary
Sociaal methodisch werken: human resources basics - 1e jaar, 2e semester
3.0
(1)
72 2021
$ 0.00 More info
Thumbnail
Exam (elaborations)
Caregiver Training Assessment CG 100: Questions & Answers : Updated Solution
-
2023
$ 7.99 More info
Thumbnail
Exam (elaborations)
QRB 501 Final Exam 2 - Question and Answers (100% CORRECT)
-
2021
$ 15.49 More info
Thumbnail
Exam (elaborations)
EPP2601 Assignment 1 COMPLETE ANSWERS) Semester 2 2024 - DUE 30 August 2024
-
2024
$ 2.50 More info
Thumbnail
Summary
The Speech Process
-
2023
$ 10.87 More info
Thumbnail
Other
Estimation research
-
2021
$ 3.49 More info
Thumbnail
Exam (elaborations)
PMK-EE (E-5) Career Information Part 1 | 50 Questions with 100% Correct Answers
-
2022
$ 5.49 More info
Thumbnail
Exam (elaborations)
Argus Exam Chapter QUESTIONS WITH DETAILED VERIFIED ANSWERS (100% CORRECT ANSWERS) /ALREADY GRADED A+
-
2025
$ 13.49 More info
Thumbnail
Exam (elaborations)
Oracle 1Z0-1067 Dumps - Getting Ready For The Oracle 1Z0-1067 Exam
-
2021
R 0,00 More info

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their exams and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can immediately select a different document that better matches what you need.

Pay how you prefer, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card or EFT and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions