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?