Post Profile






Beware of Symmetric Relationships

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 […] The post Beware of Symmetric Relationships appeared first on DATAVERSITY.
read more

share
See more about: Michael Blaha

Related Posts


Data Warehouse Model Quality

Technology : SemanticWeb.com

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 applica...

Data Warehouses Should Stage Source Data

Technology : SemanticWeb.com

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-sup...

Operational Data Model Quality

Technology : SemanticWeb.com

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 les...

Documenting Data Models

Technology : SemanticWeb.com

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 th...

More Database Design Errors – Confusion with Many-to-Many Relationships

Technology : SemanticWeb.com

by Michael Blaha My last blog addressed primary key and foreign key errors. Now let’s look at errors with many-to-many relationships. A many-to-many relationship is an intersection of two entities. A person may own stock in multiple...

Comments


Copyright © 2016 Regator, LLC