Solved

SQL Database Design Best Practice

Posted on 2011-03-18
2
220 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

733 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