Sample Databases



 

Decision Support Systems
by Vicki L. Sauter

 
Web-based Vehicle Info
DSS Web Links
Table of Contents
Current News
Sauter's Home Page
Suggestions
 

© John Wiley & Sons

  One of the major challenges facing any developer of DSS today is how to ensure a system provides access to valuable information decision makers need while shielding decision makers from extraneous and irrelevant data. While we can provide guidance to new developers how to achieve this goal, no one ever appreciates the problem as a problem until he or she experiences it.

When I teach DSS, my students develop systems. The topic is the choice of a vehicle, including the choice of whether to purchase or lease the vehicle and whether to acquire a used or new vehicle. Students must develop a decision support system to help any user make the decisions about a vehicle. That is, the system must be able to take into consideration a variety of viewpoints in making the choice. For example, some people select vehicles solely on the basis of cost issues. Other people consider performance. Still others consider only aesthetic issues. Their systems must allow the individual choice in the selection of criteria and assistance in evaluating those criteria. The systems should support the evaluation of vehicles, but should not make the selection of the vehicle.

To facilitate this exercise, I provide students with many databases, and allow them to select which ones they will use, and how they will use them in their projects. Students are allowed to ignore the databases, use them as they are or to reconstitute them as is appropriate for their own systems. In addition, they are required to create (often fabricate) a database of their own, and use some information from the Web. The only catch is that they must justify how and why they use them.

I have provided information about the databases from 1993, 1994, 1995 and some general information I use below that you can also use. Please remember, these are not intended to be optimally strucutred, all enclusive or in any other way a normative view of how the databases should be constructed.


All New Vehicle Data

Download All Data Sets (the datasets are zipped; you will need to run *.exe after downloading to unzip them)
LOTUS *.wk1 format
dBASE *.dbf format
EXCEL *.xls format
ACCESS *.mdb format

1993 New Vehicle Data
View Data Descriptions (this option allows you to download individual databases)
View Database Structure (this option allows you to download individual databases)
Download All 1993 Data Sets (the datasets are zipped; you will need to run *.exe after downloading to unzip them)
All formats
LOTUS *.wk1 format
dBASE *.dbf format
EXCEL *.xls format
ACCESS *.mdb format

1994 New Vehicle Data
View Data Descriptions (this option allows you to download individual databases)
View Database Structure (this option allows you to download individual databases)
Download All 1994 Data Sets (the datasets are zipped; you will need to run *.exe after downloading to unzip them)
All formats
LOTUS *.wk1 format
dBASE *.dbf format
EXCEL *.xls format
ACCESS *.mdb format

1995 New Vehicle Data
View Data Descriptions (this option allows you to download individual databases)
View Database Structure (this option allows you to download individual databases)
Download All 1995 Data Sets (the datasets are zipped; you will need to run *.exe after downloading to unzip them)
All formats
LOTUS *.wk1 format
dBASE *.dbf format
EXCEL *.xls format
ACCESS *.mdb format

Other Vehicle Data
View Data Descriptions (this option allows you to download individual databases)
View Database Structure (this option allows you to download individual databases)
Download All Other Data Sets (the datasets are zipped; you will need to run *.exe after downloading to unzip them)
All formats
LOTUS *.wk1 format
dBASE *.dbf format
EXCEL *.xls format
ACCESS *.mdb format



Page Owner: Professor Sauter (Vicki.Sauter@umsl.edu)