Can NoSQL be used in data warehouse?

Question

Data warehouse is one of such potential areas, so this paper is devoted to creating of NoSQL- based DW using document-based NoSQL data stores. The first chapter describes classical DWs and identifies benefits to be expected if using NoSQL technologies instead of RDBMS.

Can a data warehouse be NoSQL?

The paper describes processes of creation and production of data warehouse using a NoSQL data mart and outlines requirements for technology necessary for such processes. The research is based on practical experience when implementing NoSQL data marts with MongoDB and Clusterpoint DB.

Is MongoDB good for data warehouse?

In many cases, the MongoDB data platform provides enough support for analytics that a data warehouse or a data lake is not required. Some of the features that MongoDB provides to support analytics include: A powerful aggregation pipeline that allows for data to be aggregated and analyzed in real time.

When should NoSQL not be used?

You should also avoid NoSQL if your application needs run-time flexibility. If consistency is a must and if there aren't going to be any large-scale changes in terms of the data volume, then going with the SQL database is a better option.

Can you use NoSQL for structured data?

Flexibility: NoSQL databases generally provide flexible schemas that enable faster and more iterative development. The flexible data model makes NoSQL databases ideal for semi-structured and unstructured data.

Expert · Answer