UDM Repository Overview

Universal Data Models Repository of Re-Usable Common and Industry Logical Data Models and Data Warehouse Designs

Universal Data Models offers a comprehensive data model repository of over 200 data models and data warehouse designs. There are both common (to all industries) and specific industry models in both 3rd normal form data models and star schemas.

The common models cover subject data areas for:

    • People, organizations, parties, roles, relationships and contact management
    • Products, goods, services, inventory control, pricing, costing
    • Orders, agreements, requirements, quotes and RFPs
    • Shipments, receipts, inventory issuances, routing, shipping documents, and logistics
    • Work requirements, work efforts, project management, time and expense tracking
    • Invoicing, accounts receivable, accounts payable and banking
    • Accounting, budgeting, asset management
    • Human resources, position fulfillment and tracking, compensation, benefits, payroll, skills tracking, performance and termination

The specific industry models include comprehensive data models and star schemas for the following industries:

These models have full documentation not only in the repository but also in the best selling The Data Model Resource Book, Volumes 1 and 2 (Wiley, 2001), enabling people using this repository to completely understanding the data model design choices, alternatives and example data that could be used to populate the models.

This repository has proven data model and data warehouse constructs which Len Silverston, author of the best-selling The Data Model Resource Book, has personally developed together with some of the leading data model experts in the industry. Universal Data Models, LLC has successfully implemented these models in a great variety of small, medium and large organizations, helping them to build solid data architectures and saving tremendous amounts of time and money in the process.

The repository contains the latest changes and enhancements to the models that have been published in the books. Additionally, there are new models such as models for performance management and demand/supply planning that have been added to the repository.

Data objects stored in the repository include entities, entity definitions, attributes, attribute definitions, attribute characteristics (size, types, constraints, etc.), unique identifiers, relationships, domains, tables, table definitions, columns, column definitions, column characteristics (size, type, constraints), primary keys, indexes, and database constraints.

The Universal Data Model Repository is in ERwin format as well as ER/Studio format and has all the required elements to generate SQL immediately for the models included in the repository. Alternatively, one can make modifications to the data objects contained in the repository and generate new SQL, customized for your own organization.

PDF Version


Request Information

To learn more about the Universal Data Model Repository, e-mail us or call