RE: Single Code Table or Separate Code tables dilemma

at last i convinced my duhvelopers to go for individual tables.

> -----Original Message-----
> From: Steve Orr [mailto:sorr_at_arzoo.com]
> Sent: Thursday, March 22, 2001 5:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single Code Table or Separate Code tables dilemma
>
>
> Regarding "lookup" or validation tables and more complex
> "rules" tables...
> do they ALL go into your master code table? For instance,
> what about a "code
> table" for all valid U.S. zip codes? Do they go into your
> master code table?

we r in the process for defining country--->state/province--->city and airports tables. there would be another 30-40 masters and all in different tables :-) sweet smell of victory

> State abbreviations too? What about valid city/state/zip code
> combinations
> which you can get from the U.S.P.O.? At what point are
> validation/lookup/rules data not in the master code table and
> how do you
> decide?

i blive every logical entity should hv its seperate physical presence. but then every solution is an "Engineering Compromise". So i wont mind some give and take. but its fun to have an occasional fight with a duhveloper.

> The code table technique may be fine for smaller apps
> but couldn't
> it become unwieldy for larger apps with 5000+ tables? Of
> which 1-3000 would
> be "lookup/validation tables?" Do Oracle ERP or SAP ERP apps do this?
> Curious.

check out PSAPOOLD tablespace in
http://www.oreilly.com/catalog/sapadm/chapter/ch01.html#18406

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  INET: MandarG_at_gsr-inc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).