Greetings,
I have a question about "the best" approach to deal with lookup
tables(employees, sections, etc..) that show up again and again in
many database (HR, Inventory, CRM ) of an enterprise with Oracle DB
servers.
Should a separate database be created to include such lookup tables
and have that database referenced on the front-end with the main
database of the application whenever needed; Or have these tables
created in databases, thus, one ends up with duplicate lookup tables,
more or less.
Interms of performance, scalablity and all issues of Oracle GP DB
design??
Any urls, books to help.
MTIA,
Grawsha
Received on Tue Aug 14 2007 - 21:48:07 CDT
