Hi,

I have a complex legacy application with around 30 tables which is in
need of re-factoring, as there are tables with lots of nulls. I've
partially managed to achieve this so that my queries mostly return
correct information. But there are some circumstances where duplicate
data is returned, suggesting my data model is not quite correct.

I haven't included either db schema or queries here due to the likely
length of the posting, but would initially like to ask if this is the
right forum to request with MySQL database design, or is there an
alternative forum. It is of course not a MySQL-specific question, and
would be applicable to any relational db. Thanks.
--
Richard Jones

Hi,

On Wed, Apr 2, 2008 at 5:10 PM, Richard Jones <ra.jones@dpw.clara.co.uk> wrote:
> Hi,
>
> I have a complex legacy application with around 30 tables which is in need
> of re-factoring, as there are tables with lots of nulls. I've partially
> managed to achieve this so that my queries mostly return correct
> information. But there are some circumstances where duplicate data is
> returned, suggesting my data model is not quite correct.
>
> I haven't included either db schema or queries here due to the likely
> length of the posting, but would initially like to ask if this is the right
> forum to request with MySQL database design, or is there an alternative
> forum. It is of course not a MySQL-specific question, and would be
> applicable to any relational db. Thanks.

This is a fine place to ask such questions.

(In general you can just ask first, and people will tell you if you're
off-topic).

Regards
Baron

--

Baron Schwartz, Senior Consultant, Percona Inc.
Tel: +1 888 401 3401 ext 507
24/7 Emergency Line +1 888 401 3401 ext 911
Our Services: http://www.percona.com/services.html
Our Blog: http://www.mysqlperformanceblog.com/

Baron Schwartz wrote:
> Hi,

> This is a fine place to ask such questions.
>
> (In general you can just ask first, and people will tell you if you're
> off-topic).
>

OK, thanks - I've posted the details to a new subject earlier today but
it doesn't seem to have showed up yet.
--
Richard Jones