Database Design Best Practice help

From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Mon, 28 Jan 2013 10:03:16 +0100
Message-ID: <51063ED4.7000009_at_sferacarta.com>



Hi all,

I have a question about database design best pratice.

In my db I have about one hundred tables like this:

code
description

To avoid to have a so great number of similar tables in the db I wonder if it is a good idea to unify all these tables in one big table like this:

id
code
table_ name
description

The advantages are:

  1. only one table in the db instead of 100
  2. only one controller to manage the table

Could this be a way to enhance db performance? Is there any negative point that I don't see?

Thanks for any comments.

j

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 28 2013 - 10:03:16 CET

Original text of this message