0

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?

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

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. 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
2

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.

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