Database Workstation
 

Hi,

I am looking forward to assemble a workstation for my Database. The basic requirement is Oracle database, Linux. The database size is 7 TB. I wanted a system that can speedily process the data and queries.

I planned following system:-

Dual Intel Xeon E5-2620 v3
64 GB (16 GB x 4) DDR4 Memory
8 TB (2 x 4 TB WD Re WD4000FYYZ)
Intel Dual-P Board S2600CW2R
Cooler Master HAF 912 Combat
Cooler Master RS750-AMAAG1-UK

But still I think the system can be more better per value of amount that I can spend.

I am not an expert on database applications, but I can share my 2 cents:

The Xeon E5-2620 v4 is the current version of the processor you had in mind. it has 2 additional cores and costs about the same as the v3 version.
Memory: you get 8 memory channels in total with two of these CPUs so you need 8 DIMMs. 8x8GB will get you the same amount of RAM but more performance in bandwidth-dependent scenarios. Dont forget that you need DDR4-2133 reg ECC.
The motherboard you picked has an SSI-EEB form factor which is similar to the E-ATX standard. So you need a case that can hold E-ATX motherboards. As far as I can tell, your current case is only compatible with ATX and smaller form factors. I would recommend the Nanoxia deep silence 5.
Similar problem with the PSU: Dual-CPU motherboards need an additional 8-pin EPS power connector that your current PSU doesn't seem to have. I would recommend the Bequiet Dark Power Pro P11 550W for your setup.

Now since I am not an expert I can only rely on guesses and second-hand knowledge from here on: Mechanical HDDs might be the bottleneck of your database server. Using SSDs instead should significantly increase performance. However, since you probably can not use consumer SSDs for this application this might turn out to be quite expensive. It will be necessary to discuss this issue with experts in the field of database applications. Maybe it would be even better to use a single-CPU setup and spend the savings on faster I/O devices.