Global Distribution Analysis Using Database Access Kit

Download this example as a Mathematica notebook.

Northwind is the example database that ships with Microsoft Access. It contains the business data for a fictional gourmet food company with worldwide sales. In this example, we connect to the database using Database Access Kit, collect some summary information on the inventory, and take a look at the global distribution of customers.

Accessing the Database

Assuming that Northwind.mdb is already known to the ODBC control panel, you can just load the Database Access Kit application package into Mathematica, open the database, and assign a name to it.

DataSourceTables lists the available data tables in Northwind.

DataSourceDataTypes gives the types used in the database.

Getting Basic Information

By leaving out DataSourceEvaluate, you can verify how Mathematica assembles the SQL command from Mathematica functions.

The next command uses this SQLSelect function to read in the first product.

Let's see which products are less than eight dollars.

ProductName	UnitPrice
Konbu	6.`
Guaraná Fantástica	4.5`
Geitost	2.5`
Filo Mix	7.`
Tourtière	7.45`
Rhönbräu Klosterbier	7.75`

This result is identical to the one obtained by passing the SQL command directly.

Konbu	6.`
Guaraná Fantástica	4.5`
Geitost	2.5`
Filo Mix	7.`
Tourtière	7.45`
Rhönbräu Klosterbier	7.75`

The following calculates the value of the complete inventory at retail prices.

Load the package Graphics`Graphics`. Now you can create a bar chart of the number of items at hand.

World Logistics

The next command queries where the company has been shipping products.

Load the package WorldPlot` to display the result graphically.

Color the countries that Northwind ships to in red, other countries in light gray.

   shadefunc[country_] :=
       If[MemberQ[shipcountries, country],
          RGBColor[1,0,0],GrayLevel[0.6]]

   WorldPlot[{World, shadefunc}];