Loading...
You are here:  Home  >  Articles by Michael Blaha  -  Page 2
Latest

Data Warehouse Model: Diffuse Relationships

By   /  October 26, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Enterprise Information Management, Information Management Blogs  /  No Comments

Click here to learn more about author Michael Blaha. A diffuse relationship is one of a group of similar relationships, which broadly apply to entities in a model. We can show them explicitly, but such an approach can become verbose and obscure the deeper content of a model. We coined the term “diffuse relationship” as […]

Read More →
Latest

Beware of Symmetric Relationships

By   /  September 28, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Enterprise Information Management, Information Management Blogs  /  No Comments

Click to learn more about author Michael Blaha. A symmetric relationship is a self-relationship with the same multiplicity and role name on each end. Symmetric relationships are acceptable for conceptual models. But they are problematic for logical and physical models – you should rework the model to eliminate them. An Example For an example, consider […]

Read More →
Latest

A Database Reverse Engineering Case Study

By   /  August 29, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education, Enterprise Information Management, Information Management Blogs, Smart Data Blogs, Smart Data News, Articles, & Education  /  No Comments

Click here to learn more about author Michael Blaha. In a blog last year we discussed database archaeology, which is another name for database reverse engineering. Database reverse engineering is the inverse to normal development. We start with an application and work backwards to understand the software and infer its content. This month we’ll take a […]

Read More →
Latest

Grading Database Quality, Part 2: Database Models

By   /  August 8, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Governance & Data Quality | News & Articles, Data Governance Blogs, Data Modeling Blogs, Data Modeling News, Articles, & Education, Smart Data Blogs, Smart Data News, Articles, & Education  /  No Comments

Click here to learn more about author Michael Blaha. This article is the second in a series of two blogs that present our grading scale for database quality. Read Part 1 here: Grading Database Quality, Part 1: Database Designs. We assign separate grades for the quality of a database design (previous blog) and the underlying model (this […]

Read More →
Latest

Grading Database Quality, Part 1: Database Designs

By   /  July 8, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Governance & Data Quality | News & Articles, Data Governance Blogs, Data Modeling Blogs, Data Modeling News, Articles, & Education, Data Strategy Blogs, Data Strategy News, Articles, & Education, Enterprise Information Management, Information Management Blogs  /  No Comments

While working on database projects, we often find ourselves doing reverse engineering. Reverse engineering is the inverse to normal development. Developers start with an application and work backwards to understand the software and infer its intent. Reverse engineering can apply to a variety of artifacts, such as hardware, programming code, and databases. Our focus here […]

Read More →
Latest

Data Warehouses Should Stage Source Data

By   /  June 15, 2016  /  Big Data Blogs, Big Data News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Enterprise Information Management, Information Management Blogs  /  3 Comments

Click here to learn more about author Michael Blaha. A data warehouse is a database that is dedicated to data analysis and reporting. It combines data from multiple operational applications and provides one location for decision-support data. A warehouse should have one staging table for each source table or file. Warehouse Data Flow As the […]

Read More →
Latest

Documenting Data Models

By   /  May 16, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education  /  No Comments

Click here to learn more about author Michael Blaha. Once you’ve created a data model, how do you document it? You need to deliver the model’s content to others – to business sponsors, other developers, and posterity for purposes that you may not envision. This article looks at options for documenting data models and their […]

Read More →
Latest

Ten Reasons Why Developers Ignore Data Models — Revisited

By   /  April 11, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education  /  No Comments

Click here to learn more about author Michael Blaha. Here is a follow- up on my blog from several months ago on “Ten Reasons Why Developers Ignore Data Models.” Paraphrasing, reader Lawrence Hecht asked via Twitter if there is any way to tell from a schema if the developers had used a data model. A […]

Read More →
Latest

Data Warehouse Model Quality

By   /  March 18, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Governance & Data Quality | News & Articles, Data Governance Blogs, Data Modeling Blogs, Data Modeling News, Articles, & Education  /  No Comments

Click here to learn more about author Michael Blaha. This is the second of a two-part series about data model quality. This blog discusses quality for data warehouses. The prior month’s blog discussed quality for operational applications. Data warehouses have a much different architecture and different business motivations than operational applications. For example, operational applications […]

Read More →
Latest

Operational Data Model Quality

By   /  February 12, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Governance & Data Quality | News & Articles, Data Governance Blogs, Data Modeling Blogs, Data Modeling News, Articles, & Education  /  No Comments

Click to learn more about author Michael Blaha. Quality is an underappreciated aspect of data models. The purpose of a model is not just to capture the business requirements, but also to represent them well. A high quality model lessens the complexity of development, reduces the likelihood of bugs, and enhances the ability of a […]

Read More →