OraFAQ Forum: Designer » Entity-Value-Pair vs 3rd Normal Form

Home » Developer & Programmer » Designer » Entity-Value-Pair vs 3rd Normal Form (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Entity-Value-Pair vs 3rd Normal Form [message #560495]

Fri, 13 July 2012 13:30

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

Report message to a moderator

Re: Entity-Value-Pair vs 3rd Normal Form [message #560497 is a reply to message #560495]

Fri, 13 July 2012 13:33

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

AskTom Tuning NAME-VALUE pair architecture application

Regards
Michel

Report message to a moderator

Re: Entity-Value-Pair vs 3rd Normal Form [message #560501 is a reply to message #560497]

Fri, 13 July 2012 13:58

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.

Report message to a moderator

Re: Entity-Value-Pair vs 3rd Normal Form [message #560502 is a reply to message #560501]

Fri, 13 July 2012 14:04

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Refferential Integrities
Next Topic:	capture form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 12:32:27 CDT 2025