Downloads
25 million rows, almost no disk

Manufacturer Orders (big data)

A manufacturer's order history: 25 million order lines to wholesalers, retail chains and retailers, plus a three-level bill of materials and a customer hierarchy. On SQL Server it is a compressed columnstore table; on MariaDB the same rows are computed on the fly, so nothing large sits on disk.

mfgordersSQL ServerMariaDB 9 tables
order_linesdim_customerdim_productbomdim_plant

Read the guide

Big data: manufacturer orders (mfgorders): 25 million order lines from a manufacturer to wholesalers and retailers, stored as compressed columnstore on SQL Server and computed on the fly on MariaDB; plus a bill of materials.

Good for

Querying very large tablesColumnstore and batch modeBill of materials and hierarchiesAggregations for Power BI

Questions to try

  • Who are the top customers and what share do they hold?
  • What does a finished good cost to build?
  • How do monthly sales trend by plant?
  • How much faster is columnstore?

Write each as a query in the SQL editor, or ask an AI assistant to walk you through it.

Connect to it

Server learnsql.cpetoday.com,1433, database mfgorders, in Excel or Power BI (Import mode) or DBeaver. These tables are in the dbo schema, so once you have picked the database you can use plain names such as bom.

Download the Excel connection (.odc)

How to use it: download the file and open it. Excel opens it as a connection to mfgorders and asks for the SQL Server username and password from your CPE Today course. The file holds no password. The first table is selected by default, and you can pick others from the Data window. Setup details for other tools are on Connect.

Tables (9)

Click a table to preview it in the Playground.

← All databases