Sun Apr 11 15:26:22 EDT 2010
Databases and Normalization
Some DB questions from the complete noob. Suppose I have a relation
where all the variables are strings. What do you call the operation
that replaces unique strings by identifiers, and creates a new
relation between the identifiers and the strings?
The reason to do so would be to reduce storage requirements and reduce
query computations, i.e. an identifier could be a 32bit or 64bit
number, instead of a larger string key.
In a functional store this would be object sharing by using pointers.
Is this indexing? ORM?