We cannot apply binary search directly in actual disk records because records are not necessarily stored in a contiguous manner in the disk, we use B tree (threaded M way tree) for this. It makes insertion and deletion faster as well.
Most underrated course on SQL and DBMS,,, appreciate the effort 👏👏 Can you make a video after this course regarding in which different profiles we can get a job in SQL and DBMS.
Bhaiya mai SQL k jitne bhi interview questions dekh rha hu unn sbme triggers naam k ek topic ka question jrur h. Aap kb krwaoge wo topic kyunki maine abho saare notes download krke dekhe unme se ek me bhi triggers naam ka topic nhi tha. Baaki ye series bahot sahi jaa rhi h. MySQL ki 4 ghante wali video ne confidence de diya CV k skills section me MySQL likhne ka
1.Primary indexing simply meaning using primary key as a search key 2.Secondary indexing simply means using non prime key as a searching key 3.Clustering indexing is based on non primary key and of used when records are grouped Hope i am correct … Little bit i am getting confused by this lecture 😅
@@harshitpant6473 bhai vo diagram banane k purpose se banai hai.. concept yehi bata rhe hain ki binary search vagera se hi indexing ki jati hai.. and usually databases mein bhi aisa hi hota hai but nobody is discussing that in comments
at 10:00 dude however you break the blocks in the index table, you can never achieve faster binary search on the whole table... here is the calculation suppose we have n rows and these n rows are to be broken in m blocks then -> each block will have n/m rows now according to your approach, time taken would be log(m) + log(n/m) (first binary search for finding a block, then binary search on the block having n/m rows) i.e., log(m) + log(n/m) = log(m*n/m) = log(n) which is the time taken if you would have just binary searched in the first place. you are doing nothing but introducing constant factors.
Please try to complete the series as soon as possible because the videos are not coming at regular intervals. We have to wait alot for the next one. It's a request
Can someone please guide me does the OS and DBMS course covers System Designs as well? Pardon if I sound silly, I am not from CS background. Would appreciate the response.
Bhaiya video ke vich main ad maat daala kro yaar sara maja kharab ho jata hai 😭😡😬 Ya ta starting main ya fir ending main placed kro ess ad's ko please 🥺
We cannot apply binary search directly in actual disk records because records are not necessarily stored in a contiguous manner in the disk, we use B tree (threaded M way tree) for this. It makes insertion and deletion faster as well.
tnk u
Oh yeah nice pointing about that part. Learnt in paging OS concept that memory is not stored contiguously. Thank you for this information
yeah but keep in mind that index table will be sorted
@@devanshdalwadi6015No I won't what will you do
Please complete this course sooon . Thankyou for the efforts. This course these types of explanations are worth it ❤️
@10:55 , Bhaiya for student with roll no. 843,
the block will be Block-85, not Block-843 🙂
Most underrated course on SQL and DBMS,,, appreciate the effort 👏👏
Can you make a video after this course regarding in which different profiles we can get a job in SQL and DBMS.
placements have started .please tell when will this series be completed ??please complete this series as soon as possible.
This course is very much helpful, please complete it as soon as possible as placements are on its ways.
Best DBMS explanation ever
"Bahot hi badhiya" remains constant. Mazaa aa gya bhai OS me bhi aur ab DBMS me bhi...
OS kaha h?
Bhaiya mai SQL k jitne bhi interview questions dekh rha hu unn sbme triggers naam k ek topic ka question jrur h.
Aap kb krwaoge wo topic kyunki maine abho saare notes download krke dekhe unme se ek me bhi triggers naam ka topic nhi tha.
Baaki ye series bahot sahi jaa rhi h. MySQL ki 4 ghante wali video ne confidence de diya CV k skills section me MySQL likhne ka
shouldn't the student with id = 841 be at B85 and not at B841? timestamp: 10:55
It must me B84
Yup. B85 (not B84 bcz it starts with block numbering starts with 1 not 0)
@@Rajatcode vro, B85 pe hoga B84 pe nhi, index table dekho.
so for id=843, in index table
it would be 841 - B85, just like 9991 - B1000.
He meant to say the roll number is 841
I know you are doing your best.. but please complete the series fast, placements have started
kahi aur se padh le ye chalte rahe ga placement phir nahi aee ga.
@@kumarsamaksha7207 okay brother
@@xclusionmedia4149 Just saying it's entirely your choice.
@@kumarsamaksha7207 kaha se parhe bhai?
@@maitahom9958 time PE depend karta h, time nahi h toh thora theory dekho lo DBMS, rdbms, er diagram, normalisation and phir SQL dekh lo
lakshya sir abhi kitni or videos hai or kab tak complete hojayegi ? kyunki placements chal rhe hai...
Thanks for this video , please add more Videos Looking Forward to it....
Bhaiya your teaching skills are awesome. Thank you very much for this video.
Thanks for all your efforts!!
When are the next videos going to be released? Eagerly awaiting!
A thumbs up 👍 for your efforts and teaching skills , precise notes brother.
Lakshay bhaiya can you please tell how many more video are about to come on dbms ?
25
@@DikshaSharmaa Total 25 videos right ??
Yes, they told this in introduction video
@@DikshaSharmaa Ok
Awesome teaching Lakshay Bhaiiyya 💯🔥!
great content bhaiya keep it up☺
God level content literally god level , genius guys next level next level ....
Very helpful vidoes ,Love you sir❤
Thanks for the amazing video on indexing.
awesome explanation ☺️
Best explanation 💯
amazing series going
Why we cannot use hashmap like data structure for indexing... For fast retrieval
Nice explanation 👍.
GREAT EXPLANATION.
Please Complete this course Bhaiyya. DBMS Ache se flow main karna hai waiting for next lecture
Maine Video Pura dekha
what an amazing video!
If we want to search student no. 843 then it should be present on somewhere in 85th block right?
Thank you
Day 14 - Present Sir❤
Best lecture!❤
arey brother please complete the course two weeks passed no update till now, where are you?????
@CodeHelp - By Babbar sir if this message is received to you properly then kindly upload/ add a video on collation and its types in dbms
Please complete this series fast
1.Primary indexing simply meaning using primary key as a search key
2.Secondary indexing simply means using non prime key as a searching key
3.Clustering indexing is based on non primary key and of used when records are grouped
Hope i am correct …
Little bit i am getting confused by this lecture 😅
Bhaiya … please complete the playlist soon … placement have already started … plz bhaiya
Bhaiya schema design ke questions kaise karenge, please upload video on them.
Underrated video
i don't know why people are saying this is the best explanation , he is also confused in this video
bohot hi badhiya
Bhaiya jaldi se over karo esko and CN ka course bhi plz jaldi loa
CN kahan se kiya ??
bhaiya please complete this course as soon as possible
Can you make a video on Partitioning and SubPartitioning in DB.
Bhaiya moj kr diii
Maja Aa gaya bhaiya....
jab search character/string based rhti h jaise name,city tab index table m kaise strore kari jati h entries ki unpe binary search lag jaaye ?
Brother when next video come?
27:17 What if 1 is present on b2 block?
can anyone please explain this
Completed
too good
gr8 bhaiya
Indexing uses the concept of Hashing ? yes or not ?
LOVE THIS THANKS
Bhai someone tell me from where I can get full notes of all the episodes please 🙏
Sir aur lectures kab upload kroge
Op bhaiya🔥🔥
op matlab ?
Good Explanation!
How many videos are still remeaning ?
thanks bhaiya
For roll no. 843 , block no. should be 85 ??
Am i right or wrong ?? and explain
why do we need to use sorting, linear search or binary search ? Why can't we use hashMap ?
Block pointer s mapping mri toh h
@@harshitpant6473 bhai vo diagram banane k purpose se banai hai.. concept yehi bata rhe hain ki binary search vagera se hi indexing ki jati hai.. and usually databases mein bhi aisa hi hota hai
but nobody is discussing that in comments
5:03 i searched on google but its not necessasy ki P.K sorted hogi hamesha
at 10:00
dude however you break the blocks in the index table, you can never achieve faster binary search on the whole table...
here is the calculation
suppose we have n rows and these n rows are to be broken in m blocks then ->
each block will have n/m rows
now according to your approach, time taken would be log(m) + log(n/m) (first binary search for finding a block, then binary search on the block having n/m rows)
i.e., log(m) + log(n/m) = log(m*n/m) = log(n) which is the time taken if you would have just binary searched in the first place. you are doing nothing but introducing constant factors.
vhai aur vidio nehi ayegi?🙂🥺
finally completed
Thank youuuu
Bhaiya relational database design pai questions karaiye
Great Lecture sir
How many lectures will be there sir?
when will the next video gonna upload?
Please try to complete the series as soon as possible because the videos are not coming at regular intervals. We have to wait alot for the next one. It's a request
Don't wait bro, just search topics and complete them, from different channels.
index table mei toh 1, 11, 21... 841, 851...9991 aise honge na toh 843 direct index table se kaise nikala?
i also thought for roll no. 843 , block no. should be 85
great
Series mein aur kitni videos bachi hai?
please tell how many videos have left????
Love you sir
Hello Sir , is this series completed now ?
Can someone please guide me does the OS and DBMS course covers System Designs as well? Pardon if I sound silly, I am not from CS background. Would appreciate the response.
No
No.
It is separate subject itself.
Try Garurav Sen channel.
SudoCode
Jordan has no life
Bytebytego
awesome
bhaiya next video plzzzzzzz🙏🙏🙏
pls a course on oops!!!
Next Video soon please.
Why one video is hidden?
Sir dbms ke aur lecture lao plzz
Where is consistency bhiya
Learning++
17.04.2023
Will someone help me to learn data struture
🔥🔥
❤️❤️❤️
How many more videos to come on dbms?
1st comment
to kya kare fir ?
Bhaiya video ke vich main ad maat daala kro yaar sara maja kharab ho jata hai 😭😡😬
Ya ta starting main ya fir ending main placed kro ess ad's ko please 🥺
swad++
4th august 2024
01 / 07 / 2024