Re: DB Architecture Questions (for joe celko)

Question about the celko approach....
Take a simple user table for an example. In this case, if the only
"valid" unique identifier is the email address instead of a user_id,
the Celko's approach would have you use the email address as the
foreign key.....isn't a seek by a non-numerical value more expensive
than a numerical one??

Also, regarding the DAL.....access to methods are controlled within
the application layer. The DBA Team writes the ad-hoc queries (so they
are optimized) and send to the application architects to integrate
into the DAL. Because the DB model is based of the Business object
model, we know which columns are being used etc and we get full IDE
support (intellisense, reflection, dependancy check, compile-time
protection).

Regarding the statement about using SP because it's easier to quickly
fix a bug.....in an enterprise environment, you never "quickly" fix a
bug. Everything is documented and has to go through a CMI request and
tested etc.
.

Loading