| Splitting Oracle database into two [message #449094] |
Fri, 26 March 2010 10:47  |
lokimisc
Messages: 101
Registered: February 2008
|
Senior Member |
|
|
Aim: Architecture change in existing application
Domain: Health Care
Background: There are 2 application ( Front end: one in oracle forms - deals with accounts module and another in some legacy application - deals with patient, clinical and diagnose module) using and sharing the same Oracle 9i database.
Patient related modules are moved into another database ( java as a front end, oracle 10g as backend ) which is normalized - eliminating duplicate tables and column, also its tables and columns names are not matching with existing (patient)system.
Now the requirement is making the existing application related only to Accounts module ( having complicated business logic written in packages ) to work as it is without changing the code, design drastically.
Questions:
1. Now how best this task can be completed without affecting existing Accounts system drastically ( with minimal changes )?
2. what are the possible best approach to achieve this ?
3. what are the best way for communicating the 2 DB in this scenario ( may be creating synonym, views etc ) ?
4. What are challenges that needs to be addressed ?
Any recommendation, suggestion and solution will be very much appreciated.
Thanks and Regards
Lokesh
[Updated on: Fri, 26 March 2010 11:09] Report message to a moderator |
|
|
|
| Re: Splitting Oracle database into two [message #449204 is a reply to message #449094] |
Sat, 27 March 2010 17:23  |
gregor
Messages: 86
Registered: March 2010
Location: Germany
|
Member |
|
|
Hi lokimisc ,
i don't excatly understand all aspects of your question,
there for
i tell sth about features of ORACLE forms:
- FORMS can connect to different Databases
(in your case Oracle-Databases ( ODCD databases
is an other story)):
1.) -Create a Database-link
- create a (public) synonym for the databaselink .
- create a (public) synonym for the extern Table
- point the forms Block to this Synonym
2. Dynamic Version)
- Forms an switch the table query is based on
for example, in the PRE-Query_trigger using,
SET_Block_PROPERTY( 'BLOKXY',tablesoucre,
newtable_via_db_link)
3. Stating a Form you can connect an other databases.
Use: on_logon-trigger
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
