ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Describe the differences between a data warehouse and data mart ?

user-image
تم إضافة السؤال من قبل Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
تاريخ النشر: 2015/01/09
Denny Luyis
من قبل Denny Luyis , Teacher , TWP Translations Ltd

The biggest difference between a data mart and a data warehouse https://www.mighty.digital/blog/data-warehouse-vs-data-mart-know-the-difference is the amount of information they hold. A data mart holds smaller amounts of data than a data warehouse, while a data warehouse stores much larger datasets. Data marts also store a specific subject area. Knowing the difference between a data mart and a data warehouse can help you choose which is right for your company.

Ibrahim Hussein Mayaleh
من قبل Ibrahim Hussein Mayaleh , Sales & Business Consultant and Trainer , Self-employed

Thank you for the invitation, but I know too little about this field

Vinod Jetley
من قبل Vinod Jetley , Assistant General Manager , State Bank of India

Warehouse:

 

Holds multiple subject areas

Holds very detailed information

Works to integrate all data sources

Does not necessarily use a dimensional model but feeds dimensional models.

Data Mart

 

Often holds only one subject area- for example, Finance, or Sales

May hold more summarised data (although many hold full detail)

Concentrates on integrating information from a given subject area or set of source systems

Is built focused on a dimensional model using a star schema

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟