OpenBOM’s Data Model, Revisions, and CAD Files

Oleg Shilovitsky
Oleg Shilovitsky
3 August, 2021 | 2 min for reading
OpenBOM’s Data Model, Revisions, and CAD Files

One of the frequently asked questions by customers is, how can OpenBOM help manage revisions and lifecycle of objects? 

In my blog post today I’m going to provide a synergy of materials explaining how OpenBOM’s flexible data model can be used to create a record of files and more specifically CAD files. I’ll also be discussing how the data in CAD files are managed as part of a bigger multi-disciplinary data set and how OpenBOM helps to track revisions of the data and files as well. 

Flexible Data Model – File Properties, Items, and Structure

The foundation of OpenBOM is a flexible data model. Check out OpenBOM’s online documentation which gives you a detailed description of the data model, what is an item (reference), catalogs, product structures, and how files can be stored in item (reference) or BOM (instance) properties. 

In a nutshell, OpenBOM is using the following data objects – item, BOM to manage the data records. A flexible number of properties can be added to the item to manage multiple files attached. Although you can also add files to item instance records (BOMs), I will omit this description for simplicity.Multi-Disciplinary Data Structure  

The flexibility of OpenBOM’s data model allows you to easily organize a multi-disciplinary data structure by creating hierarchical relationships between items of different types. In the picture below, I illustrate how a schematic structure contains top Product Items and 3 sub-items each for MCAD structure, ECAD structure, and Software BOM.Item Revisions and Product Structure 

Another dimension of the data model is management of revisions. When you create a data structure, it is created in the so-called “Latest” or “Work-in-progress” model. This is a status in which the data can be changed (based on your access level, of course). Once you finish editing a specific item data, you can create revisions (immutable records of the item data for each revision. These revision records are preserved and OpenBOM allows you to create an unlimited track of historical records. OpenBOM manages immutable records for both items and BOM (relationships). OpenBOM data graph keeps track of relationships between different revisions, so you can also get the right structure for each item revision.Conclusion 

OpenBOM flexible data model provides a robust way to manage a specific CAD structure (eg. MCAD, PCB, etc.) and also a bigger scope of the data such as higher-level structures of components assemblies, systems including electronic design, software components, and others. A universal identification system (based on a Part Number) allows you to identify any type of item and connect multiple files to each record. Item revision mechanism allows you to keep track of changes, preserve the history of each item as well as relationships between Item revisions. 

Want to learn more about OpenBOM’s data model and revision control? Then, REGISTER FOR FREE and start your 14-day trial and explore OpenBOM today. 

Best, Oleg

Related Posts

Also on OpenBOM

4 6
14 August, 2026

Excel is a natural lifeblood of every organization. We have “love and hate” relationships with Excel at OpenBOM. While we...

13 August, 2026

Seamless integration with design tools was always the main goal of OpenBOM. As such we’re expanding our integration with PCB...

13 August, 2026

Some of the most valuable product improvements are not new capabilities. They are the removal of repetition. Adding items to...

12 August, 2026

The demand for API usage has been growing dramatically in the last year. There are two observations here – an...

12 August, 2026

BOM Review started with a simple premise: catch data problems before they travel downstream to purchasing, manufacturing, and release. The...

11 August, 2026

Welcome to the OpenBOM August 2026 update! The August 2026 update brings important improvements across BOM validation, Public API access,...

6 August, 2026

I had a conversation with Rob Ferrone earlier this week and we decided to publish it. Rob spent 25 years...

5 August, 2026

Every company that validates a bill of materials produces two things. The first is the corrected BOM. Missing quantities filled...

4 August, 2026

The most dangerous request in a PLM implementation is not “can we import our Excel files?” Of course you can....

To the top