Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Oracle Database Architecture
hitesh187
post May 2 2017, 12:44 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 2-May 17
Member No.: 51,947



We need a suggestion on creating Oracle database for below scenario.

Suppose It is required to implement multiple B2C insurance products(for e.g., motor insurance, health and travel insurance etc..) where end user can get the quote and buy an insurance online through web application. There are some master data which can be same for all different products and need to be shared across products.

How should we design the database in Oracle 12c for this scenario? Should we create single database(single SID) containing all products data or should we create multiple database on same server(multiple SID) where one database represent one product? What can be the pros and cons of both the design?
Go to the top of the page
 
+Quote Post
burleson
post May 2 2017, 08:41 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,566
Joined: 26-January 04
Member No.: 13



Hi Hitesh, and welcome to the forum!

>> How should we design the database in Oracle 12c for this scenario?

Keep it simple!

Place all data under a single SID.

I see no benefit in segregating the data onto multiple databases . . .




--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
hitesh187
post May 3 2017, 06:10 AM
Post #3


Newbie
*

Group: Members
Posts: 2
Joined: 2-May 17
Member No.: 51,947



Thanks a lot Donald K. Burleson.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 17th October 2017 - 10:15 AM