Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Pizza Example

Re: Pizza Example

From: Laconic2 <laconic2_at_comcast.net>
Date: Tue, 6 Apr 2004 10:02:49 -0400
Message-ID: <uKmdnV6OPvHCJe_dRVn-sQ@comcast.com>


> Or, at the design stage, you simply accept the fact that length is
> variable, and expect your database to be clever enough to cope :-)

Very good point. In fact a good DBMS will apply compression to save space, with no information loss. And, in general, the time saved by saving space will be more than the time expended in compression/decompression. And, when odd cases occur, the DBA can tell the DBMS what to do.

However, there are some situations where variable length data is unacceptable design, and not for reasons that can be hidden inside the DBMS. Other writers have given several examples in this thread. Received on Tue Apr 06 2004 - 09:02:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US