Home » Developer & Programmer » Designer » Entity-Value-Pair vs 3rd Normal Form (Oracle 10g)
Entity-Value-Pair vs 3rd Normal Form [message #560495] Fri, 13 July 2012 13:30 Go to next message
Sanju2012
Messages: 2
Registered: July 2012
Junior Member
Hi All,

I am strugling in designing the database table for online Portal.

Just to simplify, requirements are to store Customer Id, Customer Name, Date of birth, and 60 flags (0 or 1).

Application team is looking for flexibility in adding the flags as they may need to add flags frequently.

One option is one table with 70 flag columns.
Other option is use Key-Value pair.

Also, these flags will be updated for a customer and expected volume in this table is around 3.5 million records.

Can you please advise what is the best way to design the table? Query performance is main consideration as it is online portal.

Thanks for you help!

Sanju
Re: Entity-Value-Pair vs 3rd Normal Form [message #560497 is a reply to message #560495] Fri, 13 July 2012 13:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AskTom Tuning NAME-VALUE pair architecture application

Regards
Michel
Re: Entity-Value-Pair vs 3rd Normal Form [message #560501 is a reply to message #560497] Fri, 13 July 2012 13:58 Go to previous messageGo to next message
Sanju2012
Messages: 2
Registered: July 2012
Junior Member
Thanks Michel for prompt reply. In my case all the columns are flags 0 or 1 with same datatype. So do you think Name-Value pair will be better option.
Re: Entity-Value-Pair vs 3rd Normal Form [message #560502 is a reply to message #560501] Fri, 13 July 2012 14:04 Go to previous message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, I don't think so.
There are several other threads on AskTom just search for "Entity-Value-Pair".

Regards
Michel
Previous Topic: Refferential Integrities
Next Topic: capture form
Goto Forum:
  


Current Time: Sat Nov 22 10:47:02 CST 2014

Total time taken to generate the page: 0.08724 seconds