iddu

somehow trying to get into tech while having a lot of skill issues

[iddu @1drie5]

it was all my fault

[iddu @1drie5]

@memoizedk

[iddu @1drie5]

@memoizedk okayishhhh... profile lock kyun??

[iddu @1drie5]

@memoizedk how are you?

[iddu @1drie5]

@watermelonCodes yeah may be

[iddu @1drie5]

Aayein

[iddu @1drie5]

L75

db security: role-based access control (rbac)

rbac stops permission micro-management.
flow: permissions (read) ➔ roles (admin) ➔ users.

why?
• scale: update 1 role to update all users in it.
• security: enforces least privilege.

#DBMS #SQL #Databases

[iddu @1drie5]

L74

db scaling:
• vertical (scale up): add cpu/ram to 1 instance. simple, but hits hardware limits & creates a spof.
• horizontal (scale out): add servers via replication (master=writes, slave=reads) or sharding (split data across dbs).

#DBMS #SQL #Databases

[iddu @1drie5]

L74

db scaling:
• vertical (scale up): add cpu/ram to 1 instance. simple, but hits hardware limits & creates a spof.
• horizontal (scale out): add servers via replication (master=writes, slave=reads) or sharding (split data across dbs).

#DBMS #SQL #Databases

[iddu @1drie5]

L73

b-tree vs b+ tree:
• storage: b-tree stores data in all nodes. b+ only in leaves.
• links: b+ leaves form a linked list.
• queries: b+ optimized for range scans.
• fanout: b+ routing nodes hold only keys, minimizing i/o.

#DBMS #SQL #Databases

[iddu @1drie5]

@watermelonCodes idk agar hota toh bhi sayad dhang se nahi de pata, i was tired af

[iddu @1drie5]

@raydotsh whoaaaa cool
which playlist are you exactly following???

[iddu @1drie5]

@raydotsh @_khusheyyy nejamavaa???😲

[iddu @1drie5]

@raydotsh 😭😭😭

[iddu @1drie5]

L73

b-tree vs b+ tree:
• storage: b-tree stores data in all nodes. b+ only in leaves.
• links: b+ leaves form a linked list.
• queries: b+ optimized for range scans.
• fanout: b+ routing nodes hold only keys, minimizing i/o.

#DBMS #SQL #Databases

[iddu @1drie5]

L72 (3)

b-tree deletion: uses borrowing (parent drops, sibling rises) or merging.

b+ trees (modern dbms standard):
• internal nodes = routing (keys only).
• leaves = data + linked list (fast range scans).
• higher fanout = less i/o.

#DBMS #SQL #Databases

[iddu @1drie5]

L72 (3)

b-tree deletion: uses borrowing (parent drops, sibling rises) or merging.

b+ trees (modern dbms standard):
• internal nodes = routing (keys only).
• leaves = data + linked list (fast range scans).
• higher fanout = less i/o.

#DBMS #SQL #Databases

[iddu @1drie5]

L72 (2)

b-tree insertion: a bottom-up process guaranteeing strict balance.

1. traverse to correct leaf.
2. insert key in sorted order.
3. if keys > max (m-1), split the node in half.
4. promote median key to parent.

root splits increase tree height.

#DBMS #SQL #Databases

[iddu @1drie5]

@raydotsh

[iddu @1drie5]

L72 (2)

b-tree insertion: a bottom-up process guaranteeing strict balance.

1. traverse to correct leaf.
2. insert key in sorted order.
3. if keys > max (m-1), split the node in half.
4. promote median key to parent.

root splits increase tree height.

#DBMS #SQL #Databases

[iddu @1drie5]

L72 (1)

b-trees physically implement dbms indexes, providing o(log n) search, insertion, and deletion complexity.

classical b-tree block sizing equation (nodes hold keys + child/data pointers):
m * pb + (m - 1) * (k + pd) <= b

#DBMS #SQL #Databases

[iddu @1drie5]

@codexharshit wahi wahi

[iddu @1drie5]

arrived 45 mins early

[iddu @1drie5]

L72 (1)

b-trees physically implement dbms indexes, providing o(log n) search, insertion, and deletion complexity.

classical b-tree block sizing equation (nodes hold keys + child/data pointers):
m * pb + (m - 1) * (k + pd) <= b

#DBMS #SQL #Databases

[iddu @1drie5]

L71 (3)

dbms indexing:
• primary: pk, sorted data (sparse).
• clustered: non-key, sorted. boosts range scans & group by.
• secondary: unsorted data (dense).
• multilevel: outer index maps inner blocks to minimize i/o.

sql: create/drop index.

#DBMS #SQL #Databases

[iddu @1drie5]

@raydotsh chumma thaan, naan vella illama irukan lan athan 😂😭

[iddu @1drie5]

@raydotsh @serotoninwave manje urdu nakko maalum

[iddu @1drie5]

@raydotsh you bought the books as well?