Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Special Interest Groups
  3. Independent Developers
  4. Exploring File Structure: Understanding B and B+ Trees in DBMS

Exploring File Structure: Understanding B and B+ Trees in DBMS

Scheduled Pinned Locked Moved Unsolved Independent Developers
6 Posts 5 Posters 941 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Sachin Bhatt
    wrote on 27 Jan 2024, 00:49 last edited by
    #1

    I'm now absorbed in the complexities of file structure, namely B and B+ trees, in the context of database management systems. Despite my best efforts, I am having difficulty understanding these core ideas and how to use them to properly organize data.

    -- Example of file structure using B and B+ trees in DBMS
    CREATE TABLE Employee (
        id INT,
        name VARCHAR(50),
        PRIMARY KEY (id)
    );
    
    

    I'm not looking for a quick fix, but rather a thorough grasp of how file structures, notably B and B+ trees, function within the framework of a DBMS. What are the most prevalent mistakes and misunderstandings to be mindful of while working with file structures in DBMS? Could you also share any tips or best practices for using B and B+ trees to organize and retrieve data effectively?
    Your knowledge, supplemented with actual examples and explanations, would be really helpful in improving my grasp of file structures in DBMS. Let's work together to go further into the complexities of B and B+ trees and their importance in database administration.

    J 1 Reply Last reply 27 Jan 2024, 12:56
    0
    • S Sachin Bhatt
      27 Jan 2024, 00:49

      I'm now absorbed in the complexities of file structure, namely B and B+ trees, in the context of database management systems. Despite my best efforts, I am having difficulty understanding these core ideas and how to use them to properly organize data.

      -- Example of file structure using B and B+ trees in DBMS
      CREATE TABLE Employee (
          id INT,
          name VARCHAR(50),
          PRIMARY KEY (id)
      );
      
      

      I'm not looking for a quick fix, but rather a thorough grasp of how file structures, notably B and B+ trees, function within the framework of a DBMS. What are the most prevalent mistakes and misunderstandings to be mindful of while working with file structures in DBMS? Could you also share any tips or best practices for using B and B+ trees to organize and retrieve data effectively?
      Your knowledge, supplemented with actual examples and explanations, would be really helpful in improving my grasp of file structures in DBMS. Let's work together to go further into the complexities of B and B+ trees and their importance in database administration.

      J Offline
      J Offline
      JonB
      wrote on 27 Jan 2024, 12:56 last edited by JonB
      #2

      @Sachin-Bhatt
      Hi. You are of course welcome to ask whatever questions in this forum. However, looking at this and all your previous posts none of your questions have anything to do with Qt. So, in the politest way, why do you come here to ask or discuss this?

      Your knowledge, supplemented with actual examples and explanations, would be really helpful in improving my grasp of file structures in DBMS. Let's work together to go further into the complexities of B and B+ trees and their importance in database administration.

      But people here are interested in Qt. Relatively speaking, nobody here is interested in DBMS file structures or B trees or database administration. If someone else has a particular interest in these you might get an answer, but why don't you go to a forum for database development or file structures or similar? Surely that would be more directly useful to you.

      T 1 Reply Last reply 28 Jan 2024, 11:32
      0
      • J JonB
        27 Jan 2024, 12:56

        @Sachin-Bhatt
        Hi. You are of course welcome to ask whatever questions in this forum. However, looking at this and all your previous posts none of your questions have anything to do with Qt. So, in the politest way, why do you come here to ask or discuss this?

        Your knowledge, supplemented with actual examples and explanations, would be really helpful in improving my grasp of file structures in DBMS. Let's work together to go further into the complexities of B and B+ trees and their importance in database administration.

        But people here are interested in Qt. Relatively speaking, nobody here is interested in DBMS file structures or B trees or database administration. If someone else has a particular interest in these you might get an answer, but why don't you go to a forum for database development or file structures or similar? Surely that would be more directly useful to you.

        T Offline
        T Offline
        TomZ
        wrote on 28 Jan 2024, 11:32 last edited by
        #3

        @JonB hard to choose between trolling and homework assignment. I'll stick to AI bot.

        S 1 Reply Last reply 18 Feb 2024, 11:46
        0
        • T TomZ
          28 Jan 2024, 11:32

          @JonB hard to choose between trolling and homework assignment. I'll stick to AI bot.

          S Offline
          S Offline
          Sachin Bhatt
          wrote on 18 Feb 2024, 11:46 last edited by
          #4

          @TomZ Oh no no, I just starting learning my mistake for asking here.

          J 1 Reply Last reply 18 Feb 2024, 11:52
          0
          • S Sachin Bhatt
            18 Feb 2024, 11:46

            @TomZ Oh no no, I just starting learning my mistake for asking here.

            J Offline
            J Offline
            JonB
            wrote on 18 Feb 2024, 11:52 last edited by
            #5

            @Sachin-Bhatt
            It's not a problem, you can ask whatever you wish. And sometimes you will get answers if it's not Qt. Just (a) you didn't get any! and (b) I think your question is so specific/detailed that you need/might be better in a specialist, dedicated forum for this one.

            1 Reply Last reply
            0
            • H Offline
              H Offline
              henrydynamo
              wrote on 6 Mar 2025, 12:13 last edited by
              #6
              This post is deleted!
              1 Reply Last reply
              0

              • Login

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Users
              • Groups
              • Search
              • Get Qt Extensions
              • Unsolved