登录查看更多内容

What are the best data warehousing methodologies?

由人工智能和领英社区提供技术支持

Data warehousing is a process of collecting, integrating, and analyzing data from various sources to support business intelligence, analytics, and reporting. Data warehousing methodologies are the approaches or frameworks that guide the design, development, and maintenance of data warehouses. Choosing the best data warehousing methodology for your project depends on several factors, such as your business goals, data sources, data quality, data volume, data users, and data warehouse architecture. In this article, we will explore some of the most popular and widely used data warehousing methodologies and their advantages and disadvantages.

此文章中的业界达人

由社区从 5 条内容中精选。了解更多

Garvit Arya

Leading Data & Analytics Capabilities @ Google | 40 Under 40 Data Scientist | LinkedIn Top Voice
Marc Beierschoder

AI & Data Leader at Deloitte | Driving Transformation with Cutting-Edge Solutions | Boosting Business Outcomes in ????…
Jignesh Joshi

Database Engineer @ Barclays | Azure, Cloud Computing

1 Kimball Methodology

The Kimball methodology, also known as the dimensional modeling or star schema approach, is one of the oldest and most widely adopted data warehousing methodologies. It was developed by Ralph Kimball and his team in the 1990s and focuses on delivering data to the end users as quickly and efficiently as possible. The Kimball methodology involves designing the data warehouse around the business processes and the key performance indicators (KPIs) that measure them. The data warehouse consists of a series of data marts, each containing a fact table and several dimension tables that describe the attributes of the facts. The data marts are then integrated through conformed dimensions that ensure consistency and compatibility across different business domains. The Kimball methodology is suitable for organizations that need fast and flexible data access, user-friendly data structures, and incremental development.

添加您的观点

Garvit Arya

Leading Data & Analytics Capabilities @ Google | 40 Under 40 Data Scientist | LinkedIn Top Voice
举报内容
I've found the Kimball methodology to be particularly effective for a variety of scenarios: Efficient Analytics: The Kimball methodology excels in scenarios where businesses require swift and efficient data access for analytics. By organizing data marts around business processes and KPIs, organizations can derive actionable insights rapidly. Scalable Solutions: For organizations that anticipate growth and evolving analytical needs, it's incremental development approach proves highly beneficial. User-Centric Design: Incorporating user-friendly data structures, it ensures that end-users can easily navigate and utilize the data warehouse. This empowers them to make informed decisions without facing unnecessary complexity.

已翻译

赞
Marc Beierschoder

AI & Data Leader at Deloitte | Driving Transformation with Cutting-Edge Solutions | Boosting Business Outcomes in ???? | Top Global Tech Influencer
举报内容
The Kimball methodology places a strong emphasis on business processes and Key Performance Indicators (KPIs), aligning the data warehouse directly with business objectives. By focusing on these elements, data is structured and organized to directly address the specific needs and queries of end-users. This approach enables businesses to efficiently monitor and analyze crucial performance indicators, leading to faster and more informed decision-making. Aligning with business processes and KPIs makes the data structure intuitively understandable, facilitating users in gaining valuable insights into their business operations.

已翻译

赞
Jignesh Joshi

Database Engineer @ Barclays | Azure, Cloud Computing
举报内容
The Kimball methodology is a popular approach for designing and developing data warehouses that support business intelligence (BI) and analytics. Some of the benefits of the Kimball methodology are: It is fast to construct as no normalization is involved, which means swift execution of the initial phase of the data warehousing design process. In my experience working with Kimball methodology we construted data warehouse that contains data marts for different financial markets, such as stocks, bonds, commodities, currencies, etc. Each data mart has a fact table that stores the market data and indicators, and several dimension tables that store the attributes of the market data, such as ticker, symbol, exchange, sector, industry, etc.

已翻译

赞

2 Inmon Methodology

The Inmon methodology, also known as the enterprise data warehouse or normalized approach, is another classic and widely used data warehousing methodology. It was developed by Bill Inmon and his team in the 1980s and focuses on creating a single, centralized, and comprehensive data warehouse that serves as the source of truth for the entire organization. The Inmon methodology involves designing the data warehouse around the data sources and the entities and relationships that exist in them. The data warehouse consists of a normalized data model that eliminates data redundancy and ensures data integrity and quality. The normalized data warehouse is then used to feed various data marts that are tailored to specific business needs and use cases. The data marts can be either denormalized or dimensional depending on the requirements of the end users. The Inmon methodology is suitable for organizations that need a consistent and reliable data foundation, a holistic view of the enterprise data, and a long-term data strategy.

添加您的观点

3 Data Vault Methodology

The Data Vault methodology, also known as the hybrid approach, is a relatively new and emerging data warehousing methodology. It was developed by Dan Linstedt and his team in the 2000s and focuses on creating a scalable, agile, and resilient data warehouse that can handle complex and changing data environments. The Data Vault methodology involves designing the data warehouse around the data history and the auditability and traceability of the data. The data warehouse consists of a three-layered data model that includes hubs, links, and satellites. Hubs store the unique identifiers of the business entities, links store the associations between the entities, and satellites store the attributes and histories of the entities and associations. The Data Vault methodology is suitable for organizations that need a flexible and adaptive data architecture, a high-performance and parallelizable data loading process, and a historical and auditable data record.

添加您的观点

Marc Beierschoder

AI & Data Leader at Deloitte | Driving Transformation with Cutting-Edge Solutions | Boosting Business Outcomes in ???? | Top Global Tech Influencer
举报内容
Die Data Vault-Methode wird für ihre hohe Flexibilit?t in dynamischen Datenumgebungen gesch?tzt. Diese Flexibilit?t kann jedoch zu einer Herausforderung in Bezug auf Standardisierung führen. Ein Fehlen klar definierter Standards kann in einem Data Vault-System zu Inkonsistenzen führen, was die Datenintegrit?t und die Effizienz der Datenverwaltung beeintr?chtigen kann. Dieser Mangel an Standardisierung kann insbesondere in gro?en Teams oder bei der Integration verschiedener Datenquellen zu Schwierigkeiten führen, da unterschiedliche Interpretationen und Implementierungen der Data Vault-Prinzipien m?glich sind. Eine sorgf?ltige Planung und klare Richtlinien sind daher entscheidend, um diese Herausforderungen zu bew?ltigen.

已翻译

赞

4 Agile Methodology

The Agile methodology, also known as the iterative or incremental approach, is not a specific data warehousing methodology, but rather a general philosophy or mindset that can be applied to any data warehousing methodology. It was inspired by the agile software development principles and practices and focuses on delivering value to the end users in short and frequent iterations. The Agile methodology involves designing the data warehouse around the user stories and the feedback loops that validate them. The data warehouse consists of a series of sprints, each delivering a potentially shippable increment of the data warehouse functionality. The sprints are planned, executed, and reviewed in collaboration with the end users and the stakeholders. The Agile methodology is suitable for organizations that need a responsive and collaborative data development process, a continuous and incremental data delivery process, and a user-centric and value-driven data solution.

添加您的观点

Marc Beierschoder

AI & Data Leader at Deloitte | Driving Transformation with Cutting-Edge Solutions | Boosting Business Outcomes in ???? | Top Global Tech Influencer
举报内容
Die kontinuierlichen ?nderungen und Anpassungen, die ein zentraler Bestandteil der agilen Methodik sind, k?nnen zu einer überlastung der Ressourcen führen. In einem Umfeld, das st?ndigen Wandel und schnelle Iterationen priorisiert, kann es schwierig sein, ein Gleichgewicht zwischen Innovation und Stabilit?t zu finden. Dies kann besonders herausfordernd sein, wenn Teams versuchen, sich an neue Anforderungen anzupassen, w?hrend sie gleichzeitig den laufenden Betrieb aufrechterhalten. Diese überlastung kann zu Ermüdung bei den Mitarbeitern führen und die Qualit?t der Arbeit beeintr?chtigen, was insbesondere in Projekten mit komplexen oder gro?en Data Warehousing-Initiativen kritisch werden kann.

已翻译

赞

5 Here’s what else to consider

This is a space to share examples, stories, or insights that don’t fit into any of the previous sections. What else would you like to add?

添加您的观点

Data Warehousing

+ 关注

给文章评分

我们借助人工智能创建了此文章。您认为这篇文章怎么样？

很棒不太好

举报此文章

查看全部

What are the best data warehousing methodologies?

1

2

3

4

5

1 Kimball Methodology

2 Inmon Methodology

3 Data Vault Methodology

4 Agile Methodology

5 Here’s what else to consider

Data Warehousing

给文章评分

感谢您的反馈

更多Data Warehousing相关文章

更多相关阅读内容

What are the best data warehousing methodologies?

1

2

3

4

5

1 Kimball Methodology

2 Inmon Methodology

3 Data Vault Methodology

4 Agile Methodology

5 Here’s what else to consider

Data Warehousing

给文章评分

感谢您的反馈

查看其他技能