Which database is best for the data warehouses?

Relational database (RDBMS). This database allows you to store detailed, consolidated, and company-wide data. It is based out on the design of “Star schema” and it is established by the various data marts that are integrated through dimensions and confirmed facts.
However, the best database software for the data warehouses will depend on your requirements.