Fundamentals of database systems
Fundamentals of database systems
  • 49
  • 1 296 344
Big Data
To access the translated content:
1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation
The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video.
Your feedback is highly appreciated. Kindly fill this form forms.gle/XFZhSnHsCLML2LXA6
2. Regional language subtitles available for this course
To watch the subtitles in regional languages:
1. Click on the lecture under Course Details.
2. Play the video.
3. Now click on the Settings icon and a list of features will display
4. From that select the option Subtitles/CC.
5. Now select the Language from the available languages to read the subtitle in the regional language.
zhlédnutí: 6 822

Video

NoSQL: Different NoSQL Systems
zhlédnutí 4,8KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
NoSQL: Columnar Families
zhlédnutí 10KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
NoSQL: Introduction and Properties
zhlédnutí 11KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Concurrency Control: Deadlock Recovery and Update Operations
zhlédnutí 7KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Concurrency Control: Deadlock Prevention and Deadlock Detection
zhlédnutí 17KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Concurrency Control: Multiple Granularity for Locks
zhlédnutí 27KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Concurrency Control: Validation-based Protocol
zhlédnutí 34KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Concurrency Control: Timestamp Ordering Protocol
zhlédnutí 25KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Concurrency Control: Two-phase Locking Protocol
zhlédnutí 33KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Concurrency Control: Locks
zhlédnutí 22KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Schedules: Recoverability
zhlédnutí 12KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Schedules: Result Equivalence and Testing for Serializability
zhlédnutí 6KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Schedules: View Serializability
zhlédnutí 14KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Schedules: Conflict Serializability
zhlédnutí 11KPřed 9 lety
To access the translated content: 1. The translated content of this course is available in regional languages. For details please visit nptel.ac.in/translation The video course content can be accessed in the form of regional language text transcripts, books which can be accessed under downloads of each course, subtitles in the video and Video Text Track below the video. Your feedback is highly ...
Schedules: Introduction
zhlédnutí 9KPřed 9 lety
Schedules: Introduction
Recovery Systems: Checkpointing and Shadow Paging
zhlédnutí 41KPřed 9 lety
Recovery Systems: Checkpointing and Shadow Paging
Recovery Systems: Immediate Database Modification.
zhlédnutí 13KPřed 9 lety
Recovery Systems: Immediate Database Modification.
Database Transactions: States and Systems
zhlédnutí 9KPřed 9 lety
Database Transactions: States and Systems
Recovery Systems: Deferred Database Modification
zhlédnutí 19KPřed 9 lety
Recovery Systems: Deferred Database Modification
Database Transactions: Properties and Failures
zhlédnutí 12KPřed 9 lety
Database Transactions: Properties and Failures
Query Optimization: Heuristics and Sizes
zhlédnutí 20KPřed 9 lety
Query Optimization: Heuristics and Sizes
Query Optimization: Join Order
zhlédnutí 16KPřed 9 lety
Query Optimization: Join Order
Query Optimization: Complex Equivalence Rules
zhlédnutí 10KPřed 9 lety
Query Optimization: Complex Equivalence Rules
Query Optimization: Equivalent Expressions and Simple Equivalance Rules
zhlédnutí 27KPřed 9 lety
Query Optimization: Equivalent Expressions and Simple Equivalance Rules
Query Processing: Hash join and other Operations
zhlédnutí 20KPřed 9 lety
Query Processing: Hash join and other Operations
Query Processing: Sorting
zhlédnutí 17KPřed 9 lety
Query Processing: Sorting
Query Processing: Nested-Loop joins and Merge join
zhlédnutí 50KPřed 9 lety
Query Processing: Nested-Loop joins and Merge join
Query Processing: Selection
zhlédnutí 38KPřed 9 lety
Query Processing: Selection
Database Indexing: Tree-based Indexing
zhlédnutí 26KPřed 9 lety
Database Indexing: Tree-based Indexing

Komentáře

  • @atikurrahmanhridoy7192
    @atikurrahmanhridoy7192 Před 2 měsíci

    Good explanation

  • @adityavarma1334
    @adityavarma1334 Před 8 měsíci

    Superb explanation ❤️

  • @BS-eu9do
    @BS-eu9do Před 8 měsíci

    Thank you 👍

  • @dinesh.p8642
    @dinesh.p8642 Před 9 měsíci

    Dhanyavaad ji.

  • @LearningCS-jp4cb
    @LearningCS-jp4cb Před 11 měsíci

    Had to learn about precedence graph thinking its not covered in this series.

  • @LearningCS-jp4cb
    @LearningCS-jp4cb Před 11 měsíci

    Can someone tell does it matter if undo list is done before redo list or vice versa?

  • @LearningCS-jp4cb
    @LearningCS-jp4cb Před 11 měsíci

    T2 was added because it was never committed

  • @memoriesbyprasad3017

    vishnu ni set chestha jaldhi nee address pettu 9_21_7__28

  • @memoriesbyprasad3017

    bro Address pettu!

  • @aniloberoi3677
    @aniloberoi3677 Před rokem

    any book

  • @SarahMentel-cc1dq
    @SarahMentel-cc1dq Před rokem

    I appreciate your clarity and attention to detail. Great video

  • @supratiksarkar1195
    @supratiksarkar1195 Před rokem

    Sir, you could have shown using VS Code, or SQL Workbench. This writing by hand is so cumbersome.

  • @JohnDoe-kj2cs
    @JohnDoe-kj2cs Před 2 lety

    Thank You Sir

  • @jevinjivani5189
    @jevinjivani5189 Před 2 lety

    I really appreciate your efforts as aprart from you none of the youtube channel has covered this topic, thank you sir.

  • @niteshsingh4571
    @niteshsingh4571 Před 2 lety

    Why lecture 9... Where is 2-8?

  • @doctoronline461
    @doctoronline461 Před 2 lety

    wonderfully expression

  • @darkexodus6404
    @darkexodus6404 Před 2 lety

    At 12:36 for T3, why A = 9? Shouldn't it be A = 1 ?

    • @ajaykumarsoni31
      @ajaykumarsoni31 Před 2 lety

      Because T3 has committed after checkpoint so need to be redo.

  • @dynamite-bud
    @dynamite-bud Před 2 lety

    you look like a beatles singer. You teach good thanks

  • @abdelrhmanahmed1378
    @abdelrhmanahmed1378 Před 3 lety

    your last example ,how that the relation is in bncf and its not in 1nf we have multivalued attribute !?

  • @abhishekmazumdar2072
    @abhishekmazumdar2072 Před 3 lety

    The schedule @15:19 looks only recoverable (not cascadless). Please correct me, if I am wrong.

  • @Flutterdev6391
    @Flutterdev6391 Před 3 lety

    Worst explaintion

  • @upam_sarmah
    @upam_sarmah Před 3 lety

    Sir could you please supply the slides?

  • @rotrapmusic6577
    @rotrapmusic6577 Před 3 lety

    From select, union, project, set difference, cartesian product, rename which are logical operators?

  • @arunkumara1184
    @arunkumara1184 Před 3 lety

    THIS VIDEOS COMPLETES MY CSE VTU

  • @hasithahiranrajapaksa5611

    great explanation

  • @shashankrustagi2812
    @shashankrustagi2812 Před 3 lety

    But I am getting this photos.google.com/u/2/share/AF1QipOBvKhW3aLb08rLM-U4LJpFm_EJbuuLer0hD2Oh4xzJF5AHOjQcxaAHLmYA-AHNcw/photo/AF1QipO0tgWw0aCWatfebFW-vIylk9m6BQW612-ZkVBZ?key=bU5XQkR6NmtxaVBPSWFrMlBRRHNMcWpieERzRkRn

  • @ashutoshtripathi8187
    @ashutoshtripathi8187 Před 4 lety

    Hi Sir, Very nice explanation but please help me for below: 1: By default left deep tree mostly choose in explain plan and we can apply hint to change from left to right but what is situation where right deep tree more benefical than left deep tree? 2: How to force optimizer to choose bushy join tree?

  • @Ashish-pk5tc
    @Ashish-pk5tc Před 4 lety

    Very clear explanation..... Examples are very helpful....

  • @niwanshumaheshwari4534

    It's not clear how you convert it in 2NF at 12.01

  • @SHASHANKRUSTAGII
    @SHASHANKRUSTAGII Před 4 lety

    This came in Gate 2019.

  • @SHASHANKRUSTAGII
    @SHASHANKRUSTAGII Před 4 lety

    Best video for GATE 2021

  • @SHASHANKRUSTAGII
    @SHASHANKRUSTAGII Před 4 lety

    This is the best. :) Thanks professor

  • @SHOAIBAKHTAR-mw3xm
    @SHOAIBAKHTAR-mw3xm Před 4 lety

    oye lun k topan a kr writing mujse seek le

  • @vyomgoel4022
    @vyomgoel4022 Před 4 lety

    He explained it to such an extent that I forgot how indexing works in an array. Thanks for degrading my knowledge and wasting my time. :)

  • @yuvethiekasri606
    @yuvethiekasri606 Před 4 lety

    Hi sir...At 11.30 mins.... Here we did not select the other branch ( we have selected only T.bname) , then how is it possible to mention the second branch as "S" in &From' and get the output?

  • @ujjwalsoni1618
    @ujjwalsoni1618 Před 4 lety

    very poor explanation....

  • @manjunathakapilsharma

    How merge passes is calculated?

  • @ArshadAli_
    @ArshadAli_ Před 4 lety

    Thank you sir 👍

  • @k.rajmani1411
    @k.rajmani1411 Před 4 lety

    Awesome video Sir

  • @venkatachaitanyayadla1794

    If it checks for commit record in system log , then why to undo again ?????

  • @snehaelizebeth6146
    @snehaelizebeth6146 Před 4 lety

    Thank you so much sir... Hats off to your effort...!

  • @mishra5732
    @mishra5732 Před 4 lety

    the explaination given are purely abstract, and requires prior understanding of DBMS to understand, it would have been better if more examples and illustration were added to make things easier to understand.

  • @toshendrarustagi9861
    @toshendrarustagi9861 Před 4 lety

    In example, Candidate key is ( id ) only . Then the table is already in 2NF because C. Key is irreducible.

  • @divij6910
    @divij6910 Před 4 lety

    total shit of a lecture, no examples, and everytime there should have been a example he says 'this is easier to understand'

  • @ramyalaxmi928
    @ramyalaxmi928 Před 4 lety

    Sir, How come IX and X are compatible. how can it write

    • @madmax2442
      @madmax2442 Před 3 lety

      They aren't compatible. Sir never said that. Also, it is 'N' in the compatibility matrix.

  • @hemalathasunnapu750
    @hemalathasunnapu750 Před 4 lety

    Every concept has to be explained properly ....... Headings are ok but there is no knowledge inside the video

  • @bablobko
    @bablobko Před 4 lety

    As expected fully theoretical, no examples, and hence disliked.

  • @gautamraja2012
    @gautamraja2012 Před 4 lety

    Didn't get anything

  • @niwanshumaheshwari4534

    Because of him , I started believing in nptel

  • @marimuthumanoj7206
    @marimuthumanoj7206 Před 4 lety

    your lecture is good and cool thank you sir