Graph · dataset · registered

AdventureWorks OLTP

What the AdventureWorks OLTP sample means: people, customers, employees, sales and purchase orders, products, manufacturing, and inventory. Concepts bind to the pinned ModelSpec; shared concepts reuse the pinned core graph.

draft16 concepts@ c91e06eCC0-1.0 (meanings)MIT (model)

Where it is, what shape it has, what it means. OVDB Directory: where the data is. ModelSpec: its shape. MeaningGraph: what it means.

Provenance

Where it lives

Pinned commitc91e06e9c12380e7709f66ab1e69cf7f858f67c1The registry pins this commit; every concept below is read from it.
Addressmeaning://github.com/demo-db/adventureworks
ModelSpec modelModel: adventureworks — ModelSpec registry model/adventureworks.modelspec.hcl at commit c91e06e · View in CodeGrapher
Depends onMeaningGraph core concepts @ 982916d
Maintainerstrakhimenok

Concepts

What AdventureWorks OLTP defines

Country or region

Country and region names with the source two-letter CountryRegionCode values; codes are not reconciled to a current ISO release.

adventureworks · entity
Employee

People employed in the AdventureWorks organization.

adventureworks · entity
Person

People represented by AdventureWorks person records.

adventureworks · entity
Product

Products and components represented in the AdventureWorks catalog.

adventureworks · entity
Product category

Product categories used in the manufacturing catalog.

adventureworks · entity
Product list price

The catalog list price recorded for a product.

adventureworks · attribute
Purchase order

A request to purchase goods from a vendor.

adventureworks · entity
Purchase order line

One product entry on a purchase order.

adventureworks · entity
Purchase order quantity

Number of product units requested on a purchase order line.

adventureworks · attribute
Purchase order unit price

The unit cost recorded for a purchase order line.

adventureworks · attribute
Sales customer

Customers recorded for AdventureWorks sales.

adventureworks · entity
Sales order

A request to supply goods to a customer, as recorded in a sales order header.

adventureworks · entity
Sales order line

One product entry on an AdventureWorks sales order.

adventureworks · entity
Sales order quantity

Number of product units requested on a sales order line.

adventureworks · attribute
Sales order unit price

The unit price recorded on a sales order line.

adventureworks · attribute
Supplier

Vendors that supply products to AdventureWorks.

adventureworks · entity

Start with meaning

Propose a definition

Describe the meaning first. You can decide where it lives in Git when it is ready to share.

A local JSON draft downloads to your device. Nothing is published.