Asee peer logo

Generic Data Mining Application

Download Paper |

Conference

2001 Annual Conference

Location

Albuquerque, New Mexico

Publication Date

June 24, 2001

Start Date

June 24, 2001

End Date

June 27, 2001

ISSN

2153-5965

Page Count

8

Page Numbers

6.518.1 - 6.518.8

DOI

10.18260/1-2--9302

Permanent URL

https://peer.asee.org/9302

Download Count

375

Request a correction

Paper Authors

author page

Binaya Acharya

author page

Bruce Segee

Download Paper |

Abstract

Using instrumentation and automated data collection technologies, it is possible to accumulate large amount of data. This data can be efficiently stored, sorted and retrieved using database software. However, processing data collected in a factory or in a research application can be time consuming and tedious. Sometimes, similar processing needs to be done to spot trends or relationship in the data. The Instrumentation Research Laboratory at the University of Maine developed a Generic Data Mining Application. This application uses the queries in a database via ODBC or OLEDB and processes the data appropriately. Upon initialization, the application uses a special query to identify queries that are available and the type of processing to be performed. For example, a query may return data suitable for creating a Bar Chart. Other queries may return data for populating a spreadsheet. The application creates a menu of choices for the user based on available queries. When a user makes a selection, the appropriate query is run to retrieve data. In the case where the data is to be used in a bar graph, the results from the query are loaded into an Excel worksheet using OLE and are used to create the appropriate graph. Other cases similarly use OLE to handle the data plotting and manipulation. The result is an application whose functionality is automatically extended whenever a new query is added to the database. The application does not need to be recompiled to make use of this functionality.

Acharya, B., & Segee, B. (2001, June), Generic Data Mining Application Paper presented at 2001 Annual Conference, Albuquerque, New Mexico. 10.18260/1-2--9302

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2001 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015