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/).