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: Limit of 1050 columns for ANSI joins

Re: Limit of 1050 columns for ANSI joins

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Wed, 7 Jun 2006 14:56:13 -0700
Message-ID: <9YHhg.11425$KB.1288@fed1read08>


"joel garry" <joel-garry_at_home.com> wrote in message news:1149717213.193786.227110_at_f6g2000cwb.googlegroups.com...
>
> Andreas Sheriff wrote:
>
> >
> > The app is an online survey management system and it stores all
responses in
> > one table:
> >
> > questionresponses:
> > ...
> > takerid
> > questionid
> > choiceid
> > choicetext
> > ...
> >
> > Many self joins have to be made to do online reporting and exporting
data
> > from this table; hence the magnificent ANSI join.
> > Materialized views may help, but I'm using Standard Edition.
> >
> > One solution that I proposed was to create (a) separate table(s) for
each
> > survey's responses, with each column being a response. Sure, it's DDL
> > everytime someone creates a survey, but that doesn't happen as often as
> > someone taking a survey or doing online analysis. Separate tables would
> > eliminate the need for magnificent ANSI self joins and speed up the
> > application.
> >
> > --
> >
> > Andreas Sheriff
> > Oracle 9i Certified Professional
> > Oracle 10g Certified Professional
> > Oracle 9i Certified PL/SQL Developer
> > ----
> > "If you don't eat your meat, you cannot have any pudding.
> > "How can you have any pudding, if you don't eat your meat?"
>
> Andreas, if you don't start normalizing, we'll send you to your room
> with no supper at all!
>
> jg
> --
> @home.com is bogus.
> Witness the man who raves at the wall
> Making the shape of his question to heaven
> Whether the sun will fall in the evening
> Will he remember the lesson of giving
> Set the controls for the heart of the sun
> The heart of the sun
> The heart of the sun
>

Silly,

The tables are normalized.

The dynamic nature of a survey prevents standard normalization for the responses, though.

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.
Received on Wed Jun 07 2006 - 16:56:13 CDT

Original text of this message

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