b-tree
Choose Mysql engine for processing a big "type-value" table
My task is to delete all entities that were not affected during an operation from the database. I created a separate table which have two columns, first represets the name of the table and second is t[详细]
2023-02-06 09:35 分类:问答Storing a large number of objects that belong to a list
I am using rails and have the following scenario:Users have_many lists and each list contains a number of words with each wor开发者_Python百科d having its own definition.The list show view shows all t[详细]
2023-02-06 07:50 分类:问答How btree is stored on disc?
I know how to impl开发者_如何学JAVAement btree in memory, but not clear about how to store btree in disc. I think there are two major difference:[详细]
2023-02-04 12:55 分类:问答innodb data structure
I believe I understand how the INNODB structures the table (by using clustered btree indexes=PK and the leafs containing the rows themselves). Secondary indexes using the same principle (btree cluster[详细]
2023-02-03 20:12 分类:问答How to find the number of levels in a B-tree [duplicate]
This question already has an answer here: Closed 11 years ago. Possible Duplicate: Segmentation fault in btree implementation[详细]
2023-02-03 07:41 分类:问答How to change a HEAP/MEMORY MySQL table's indexes from HASH to BTREE?
I hav开发者_高级运维e a MySQL table with the HEAP/MEMORY storage type that was converted from MyISAM.The indexes were automatically converted to HASH, but I need them to be BTREE.How do I change them[详细]
2023-02-02 11:14 分类:问答bsddb and reprepro (berkeley) database
I\'m trying to read the database files created by reprepro. I don\'t have that much experience with bdb, so I might be confused here, but it looks like th开发者_JAVA技巧e database is layered in some w[详细]
2023-02-02 07:09 分类:问答B+ Tree Insertion - Theoretical Question
I have been trying to know how B+ Tree works and been trying to solve the examples. In one such document listed here, in the Example 1 given on page 8. It describes a B+ tree construction, wh开发者_[详细]
2023-01-29 12:34 分类:问答How are internal nodes in a innodb b-tree physically stored?
How are non-leaf b-tree nodes physically represented in innodb? Recall that a b-tree (more specifically a b+tree) has both leaf nodes and non-leaf nodes. In a b+tree all the leaf nodes sit below a tr[详细]
2023-01-28 00:40 分类:问答inorder traversal of a b-tree (c++)
I\'m working on a b-tree (or is it BTree?) for a class I\'m current taking. I have most of it implement correctly (I think). However, I\'m having trouble nailing down an inorder traversal. Here\'s my[详细]
2023-01-27 18:11 分类:问答