I work in Data Warehousing and Business Intelligence area. I am trying to understand how a data warehouse can be designed in MongoDB. I read several white papers published on MongoDB site on this topic and saw that it is possible to model a typical data warehouse in Mongo and source BI reports from it. However, I would like to get deeper understanding and hence was wondering if anyone could share a sample data warehouse model of how usual star schema facts and dimensions kind of model be designed optimally in MongoDB.
--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.
For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user...@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/8dddce36-f5c1-4bb6-b250-5d06d40125ed%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
I am trying to understand how a data warehouse can be designed in MongoDB.
Hi Neha,
A data warehouse by definition is a large store of data accumulated from a wide range of sources, and generally used to guide management decisions. The data can be stored in relational or non-relational database depending on the company’s software ecosystems and use cases. i.e. data extract-transform-load (ETL) platform, reporting tools, or analytics platform, etc.
Data in MongoDB has a flexible schema, you can and should model the data schema for the benefit of your analytics and reporting applications - see also Domain-driven design. Due to the variations of data warehouse ecosystems and environments out there, an effective data schema would be a per case basis.
You may find MongoDB Data Warehouse: Time series and device history data medtronic - transcript a useful resource.
If you or your company has an existing BI platform that expects fixed schemas and tabular data, MongoDB Enterprise Advanced v3.2+ provides MongoDB Connector for Business Intelligence (BI). The connector allows you to visualise your data using existing relational BI tools such as Tableau, Qlik, SAP Business Objects, etc.
You can download and evaluate the BI connector from MongoDB Connector for BI. If you are interested for more information about MongoDB Enterprise Advanced, feel free to send me a private message and I can request a MongoDB Account Executive to reach out to you.
In the same field as data warehousing, below you can find resources related to MongoDB as a data lake, a method of storing data in various schemas and structural forms:
Best regards,
Wan.