Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 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

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
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

More courses for UC Leuven-Limburg > Toegepaste Informatica

  • Statistiek
  • Ba-minor
  • Besturingssystemen 2
  • Computer networks
  • Computernetwerken 2
  • Ip-major
  • It&recht
  • Oosa
  • Pvm
  • Routing&switching
CA$5.79
Get access to the full document:
Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
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
2
Member since
3 year
Number of followers
1
Documents
23
Last sold
2 months ago

4.0

1 reviews

5
0
4
1
3
0
2
0
1
0

Recently viewed by you

Thumbnail
Presentation
MECHANICS UNIT 4 Rotational dynamics
-
2022
$ 5.99 More info
Thumbnail
Exam (elaborations)
EMT CHAPTER 19 Study Guide Questions 2024
-
2024
$ 14.49 More info
Thumbnail
Presentation
Refractive Index.pdf
-
2022
£ 6.58 More info
Thumbnail
Exam (elaborations)
MA Manicurist Instructor Vietnamese Exam
-
2025
$ 85.99 More info

Why students choose Stuvia

Created by fellow students, verified by reviews

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

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card 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