data-model-patterns
data-model-patterns copied to clipboard
A collection of data models that provide solutions to common problems in database design.
Data Model Patterns
A collection of data models that provide solutions to common problems in database design.
Conceptual Data Models
Subject Area: Asset
Asset

Tangible Asset

Documentation Item

Subject Area: Location
Location

Subject Area: Party
Party

Individual

Organisation

Subject Area: Role
Role - Architype

Component Role

Party Role

Dimensional Models
Hierarchy - Architype

Customer, Location, Account, Time - Hierarchy Diagram

Credits
The Conceptual Data Models were prepared using the community edition of the ERwin Data Modeler.
Note: The community edition of ERwin is limited to 25 model objects, to address this limitation each subject area (e.g., Party, Location, Product) model is located in a separate '.erwin' file.
Feedback
All feature requests, pull requests, feedback, etc., are welcome.
License
This work is licensed under a [Creative Commons Attribution 4.0 International License] (http://creativecommons.org/licenses/by/4.0/).