Oracle-L: Best way to handle data of different setups in same application

From: Abdul Aleem <dmit_at_beaconhouse.edu.pk>
Date: Tue, 04 Mar 2003 05:18:39 -0800
Message-ID: <F001.0055F608.20030304051839@fatcity.com>

Hi,

Now that URGENT! applications are in place, we do not have much pressure from our management so we can do some real planning of our database.

I would much appreciate if you could give your expert opinion.

TIA! Aleem

We are going to start with General Ledger as our first (hoped to be) planned application. The GL will handle 4-5 different setups (sort of sister concerns), different setup means different chart of account. I am sure that you understand that the application otherwise is exactly the same. The average size of a years data of each setup is around 150MB.

Next we would have other similar applications for example payroll and HR. All these application will have some tables sharing data with each other. Like for example the financial year table, the table holding company's and sister concerns' information etc. Eventually there would be 10-15 such applications. Number of users of each application would be 2 to 10. There is a possibility of web deployment of these applications, in case one of the setups needs to operate from a different location thus changes its office.

The broad picture that I have in mind is: Use different table space and data files for each application (feel that if one gives problem will not affect other applications) Create a user for common tables (shared amongst multiple applications) and use public synonyms for these tables with appropriate rights. Create a user for each of the application to host data of all setups. The application will use the same username/password to connect to the database ON_LOGON Trigger. The user privileges will be maintained by the application.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Abdul Aleem
INET: dmit_at_beaconhouse.edu.pk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Tue Mar 04 2003 - 07:18:39 CST