Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a pretty trivial questions in data warehouse,

I know we use Dimensional data model to construct data marts and use Relational data model in staging area.

What data model technique we use to store data in central data warehouse? Can we use both? Which is most commonly used? We have RDBMS for relational database model, what is the database used for dimensional modelling?

share|improve this question

closed as too broad by Mark Storey-Smith, Max Vernon, RolandoMySQLDBA, Paul White, Kin Nov 8 '13 at 22:24

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Saying your question is "pretty trivial" makes me not want to look at the rest of your question. Have you done any research; do you have specific concerns or problems? –  Max Vernon Nov 7 '13 at 17:45
    
Well there are "benchmarks" out there but sure i will believe NoSQL (mongodb) will outperform an RDBMS with one user but how will mongodb scale if more users connect? RDBMS are build to handle multiple users and this is proven for many years.. –  Raymond Nijland Nov 7 '13 at 19:05

1 Answer 1

up vote 2 down vote accepted

The point of a data mart / warehouse is to facilitate analysis for non-DBAs. The relational model is wonderful for transactional databases to speed writes integrally, but is harder to understand for non-DBAs.

A data warehouse is a collection of data marts, or can act as a central data mart. If you are going to use dimensional modelling in your data marts (as you should), then you should use it in your warehouse as well.

You will find that most companies use regular RDBMSs (say, Oracle, SQL Server, Postgres) for their data warehouse, though you probably want one that supports materialized views and easy table partitioning. Some companies use columnar databases (say, MonetDB) or NoSQL databases (say, HBase) as well.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.