tags:

views:

103

answers:

2
Q: 

What algorithms do RDBMS use?

What are the main algorithms used in RDMBS ?

+4  A: 

The most common is

B-Tree

http://en.wikipedia.org/wiki/B-tree

Unknown  2009-08-14 05:59:19
+2  A: 

A very complex topic. B-tree is just one of the algorithms; it is a binary algorithm used to find records quickly.

Here are some others: http://en.wikipedia.org/wiki/Category:Database_algorithms

SQLite is a good database to study because the code base is very small and much easier to understand than the bigger ones.

Robert Harvey  2009-08-14 06:01:58
SQLite sidesteps the whole concurrency issue that makes the bigger ones big. That might be a plus if you only want to know how the data lookup works. But to really understand modern databases you'll need to know what MVCC and write-ahead logging are.
Ants Aasma  2009-08-14 06:31:30

related questions

How do I find the Excel column name that corresponds to a given integer?
Calculating a cutting list with the least amount of off cut waste.
Red-Black Trees
How to maintain a recursive invariant in a MySQL database?
RFC calculation in Java need help with algorithm
Best word wrap algorithm?
How do you separate game logic from display?
Most effective way for float and double comparison
Choosing a multiplier for a (string) hash function
Optimizing a search algorithm in C
Find the best combination from a given set of multiple sets
What "already invented" algorithm did you invent?
Designing a Calendar system like Google Calendar
How to overload std::swap()
Looking for algorithm that reverses the sprintf() function output
Merge Sort a Linked List
Puzzle: Find largest rectangle (maximal rectangle problem)
graph serialization
Peak detection of measured signal
Big O, how do you calculate/approximate it?
What problems can be solved, or tackled more easily, using graphs and trees?
Followup: "Sorting" colors by distinctiveness
Efficiently get sorted sums of a sorted list
Function for creating color wheels
Fastest way to get value of pi