|Please Help out Me , (Mutilple Schema VS Single Schema ) Most Most Urgent [message #90642]
||Fri, 18 June 2004 08:24
Registered: April 2003
Hope u are best in yu health....
I am flotting a issue to Oracle Database experts
....regrading Mutiple Schema VS Single Schema....
A-9 to 10 Departments..
B-Each Department having Objects appox. 30.
C-Modular Approch is addopted for 9 10 Department (e.g
Personilty Profiles , File Management Sysem etc for
all 9 to 10 Departments).
D-Global Table are designed to support the 9 to 10
E-Huge Data will be stored in database (e.g millions
or trillions data)
F-9 to 10 Department are physical located on LAN with
One server .
G-There may be chance of that One or two department
shiffted to another location.
H-DSS willl be built on 9 to 10 Department.
A- If 9 to 10 Department Table is design in Single
Schema User and Mutiple Roles will be created, that
Roles (assign particular priviliages according the
Department requirements) will be allocated to Mutile
Database Access User .
B-If 9 to 10 Department Indipendlty and physical will
be design in each saprate User (e.g Payroll DB User
with its Schema, HR DBUser with Its Schema).
If Both Upper Given are then
1-What will be CPU Uses:
2-What will be the Disk Uses:
3-What will be Memory User:
4-What will be Resourse Uses:
5-What will be Networking Uses:
6-How Easy or Difficult maintence is case of Upper
NOTE: Please Keep it mind the Both Scnerio for 1 to 5
|Re: Please Help out Me , (Mutilple Schema VS Single Schema ) Most Most Urgent [message #90644 is a reply to message #90642]
||Tue, 22 June 2004 02:04
Registered: June 2004
I think you have posted a huge design problem to a limited user forum so it is why you have not recieve any reply till now! but I can say these ones:
1.use this rule of thumb in design : One application needs One schema logically.so try not to create multiple schemas as you can because in this way your maintenance phase will be easier too.
2.About CPU and disk and memory usage anybody can not give you any reasonable advice via this forum because it is a multi parameter problem so I just suugest you to refer to Oracle user guide and ofcourse if you are using Oracle 10g ,test its management and self-tuning feauters which are so useful.
3.I think you should not consider the nerworking workload now and it is not a DBA specific job(if you are a DBA).Try to design a prototype and when it works then try more to improve its performance.
4.For such a project I suugest you to have some readings in datawarehosing systems that seems the answer to your senario.
-Best wishes and be in touch.
Ashkan Roshanayi -Department of computer engineering ,Sharif University , Tehran , Iran.