We help IT Professionals succeed at work.
Get Started

DYNAMIC DATABASE DESIGN

3,004 Views
Last Modified: 2013-11-24
Hi,

Hi,

I have a big question about database design. I have some products to keep their properties in database. But there is not a exact template of this products. Some could have 50 fields of property and some have 4 or 5 field of property. And by the time user could add new properties to any product or could delete some of the fields from a product. What could be the best solution.. here I got some but could not think which could be better.

1. Having a template table and store products templates here. By relating them to the real value table got the problem. You can see this will get many inner joins.
2. Hard code to the admin panel and give rights to user to create, alter table.
3. Insert xml as text field in to the database but this time sql still confusing.

Is there an other solution. The solution can be outof the relational database models. But I want to know which will be best.
not: the database will heavily used in the future.  

thanks as now.
Comment
Watch Question
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This problem has been solved!
Unlock 21 Answers and 22 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE