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: Generic schema design

Re: Generic schema design

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 16 Feb 2006 11:02:50 -0800
Message-ID: <1140116570.467363.10390@g44g2000cwa.googlegroups.com>


I mean that if you use a generic table where one column represents the logical user table then all you need is where col01 = user_logical_table_name [or ID] to find the logical user table rows and since you are using a structure with multiple generic columns to hold data you do not have to pivot multiple rows back into a single row for use in the application.

But depending on how the data is to be accessed by the customer and presented you may not need to pivot the data anyway.

HTH -- Mark D Powell -- Received on Thu Feb 16 2006 - 13:02:50 CST

Original text of this message

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