Database Recommendations

If you are deploying a reasonably large environment for Data Relationship Management or Data Relationship Governance, I recommend following industry best practices for your database server:


  • Provision as much RAM as possible
  • Locate the servers close together with a low-latency high-bandwidth network
  • Place the temp database, index files, and data files on separate storage partitions.
    • If possible you can even split tables onto separate partitions; the transaction history and global/local property value tables are good candidates.
  • Use high-bandwidth storage (such as fiber-channel) as many in parallel as you can
  • Use Solid State disks

If you haven't guessed, the them is to spread the disk load onto as many separate SSDs as you can, then to pair the SSDs into stripes behind high-bandwidth links. You might be surprised at how much this can affect your database performance for all applications, not just DRM.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Writing about Oracle Hyperion Data Relationship Management

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today