Comment on page
Overview - UDM
An overview of the Universal Data Model
The universal data mode (UDM) is an approach to data modeling that combines tables when they have many or most fields in common. A popular use is the Party Model. This combines Person table with a Company table, since many of the fields are duplicated between the two.
While several people have written about the Universal Data Model, the implementation in Trayse Inventory is primarily influenced by the book, The Data Model Resource Book, Revised Edition, Volume 1 by Len Silverston.
The Data Model Resource Book Vol. 1 by Len Silverston
Trayse Inventory does not use the Party Model, but it does combine the following tables:
- COMPANY
- Customers
- Vendors
- ORDER
- Purchase Orders
- Estimate Orders
- Sales Orders
- Invoice Orders
- Return Orders
- Transfer Orders
- ORDER LINE
- Line items for the order tables listed above.
See the knowledge base Trayse Software Naming Conventions for a description of object name conventions.