Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: implications of merging 17 tables into 1...

Re: implications of merging 17 tables into 1...

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 27 Jun 2007 20:31:51 +0200
Message-ID: <f5uaej$5fh$3@news2.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

nirav wrote:
> Hi,
>
> We have a data model and part of the applications' functionality is
> there in a group of 17 tables to 20 inter related tables. Now there is
> an initiative to redesign this piece entirely and the architect is
> suggesting just one mega table instead of these 17! What could be the
> pros and cons of this approach?
>
> Does it mean that there will be more self joins for the same table and
> writing queries for getting required data will be more complex?
>
> What would be the right approach to analyze such a proposal?
>
> With thanks,
> Nirav
>

Lemme guess - java development going on?

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD4DBQFGgq0XLw8L4IAs830RAlRlAJ9k7+phdBeLQne5ahf84FOx8LapNgCXXUo6 mefOX+1XPVnX5rPO4qZVdQ==
=qIv4
-----END PGP SIGNATURE----- Received on Wed Jun 27 2007 - 13:31:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US