Solved

SQL Database Design Best Practice

Posted on 2011-03-18
2
221 Views
Last Modified: 2012-05-11
Hi, I'm designing a database for a project and need to make it as versatile as possible as there may be many changes to the data structure stored in future. I've decided to use name/value pairs for storing parameters instead of extra columns. e.g.:

Tables:
Reports
ReportDetails

Columns:
Reports.ID, Reports.Name, Reports.Desc etc
ReportDetails.ID, ReportDetails.ReportID, ReportDetails.ParameterName, ReportDetails.ParameterValue

This structure enables the storing of any new report type including its new parameters without changing the DB structure.

Is there a downside to this approach?
0
Comment
Question by:DamoD0
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
Bawer earned 500 total points
ID: 35165039
i personally recommend that its not required to put many columns in a single table, the structure you have created for two table is fare enough, and there will be no downside so far
0
 

Author Comment

by:DamoD0
ID: 35169706
Thanks, makes sense.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question