Home » SQL & PL/SQL » SQL & PL/SQL » Design Question
Design Question [message #237537] Mon, 14 May 2007 16:31 Go to next message
lowcash75
Messages: 67
Registered: February 2006
Member
I have a configuration table in which I want to store configuration related data. So some of the data in the Column will be timeout values, dates, names, and large text (> 4000)

Would you recommend just to use a CLOB column to store all these values??

Any suggestions?
Re: Design Question [message #237538 is a reply to message #237537] Mon, 14 May 2007 16:40 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Would you recommend just to use a CLOB column to store all these values??
NO!
>Any suggestions?
Use GOOGLE or similar to find a book on Third Normal Form.
The read & learn how to design tables using 3rd Normal Form.
Re: Design Question [message #237725 is a reply to message #237538] Tue, 15 May 2007 09:29 Go to previous messageGo to next message
lowcash75
Messages: 67
Registered: February 2006
Member
Maybe I wasn't clear.

Columns: Col1 varchar2(100)
Col2 CLOB?? <-----Should I make this a CLOB
datatype???
Col1 Col2
---- ----
Version 1.5
Build Dt 05/14/2007
Build Desc abc.... <----The data for this row in
Col2 could be greater than
4000 character
Re: Design Question [message #237737 is a reply to message #237725] Tue, 15 May 2007 09:55 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think the answer is clear.
Don't mix up data in a same column.
Normalisation is that each column is atomic that is does not contain several data.
Create several columns with ONE value in each.

Regards
Michel
Previous Topic: Indexing tables
Next Topic: Table update generates large amount of Rollback
Goto Forum:
  


Current Time: Sun Dec 04 10:46:16 CST 2016

Total time taken to generate the page: 0.06291 seconds