Loading...
You are here:  Home  >  Data Education  >  Data Modeling News, Articles, & Education  >  Data Modeling Blogs
Latest

Database Reflections: Ten Things to Consider

By   /  January 9, 2017  /  Big Data Blogs, Big Data News, Articles, & Education, Data Architecture Blogs, Data Architecture News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Data Strategy Blogs, Data Strategy News, Articles, & Education, Database Blogs, Database News, Articles, & Education, Enterprise Information Management, Information Management Blogs  /  No Comments

Click here to learn more about author Michael Blaha. I’m going to do something different this month and reflect on some observations of the IT industry. My comments will focus on database-related topics. This is a smattering of ideas that is not intended to be comprehensive. I’m hoping that this article will stimulate dialogue. I […]

Read More →
Latest

Visual Normalization – Use the Power of the Dependencies

By   /  December 14, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  No Comments

Click to learn more about author Thomas Frisendal. One of the major contributions of Dr. Ted Codd’s relational model is the focus on the importance of functional dependencies. In fact, normalization is driven by a modeler’s desire for a relation where strict functional dependency applies across all the binary relations between the designated primary key and […]

Read More →
Latest

Be Careful with Derived Data

By   /  December 5, 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  /  2 Comments

Click here to learn more about author Michael Blaha. We often perform database reverse engineering as part of our consulting work. We have found that it’s common for databases to contain derived data. Derived data is data that can be computed from other base data. Often, the storing of derived data is a mistake and […]

Read More →
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

Data Modeling: Why Not 3D?

By   /  October 19, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Data Science Blogs, Data Science News, Articles, & Education  /  2 Comments

Click here to learn more about author Thomas Frisendal. Data Models are meant to communicate structure of information to recipients, who need to understand it. But who are these recipients? In fact, they are human beings. Given that, we should choose our means of communication to be the most effective that we can find. Other […]

Read More →
Latest

Efficient Machine Learning in H2O with R and Python, Part 1

By   /  October 5, 2016  /  BI / Data Science Blogs, BI / Data Science News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Smart Data Blogs, Smart Data News, Articles, & Education  /  No Comments

Click to learn more about author Steve Miller. One of the major benefits of working with R and Python for analytics is that there’re always new and freely-available treats from their vibrant open source ecosystems. And now more and more, data scientists are able to reap the benefits of working with data in R, Python […]

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 →