Albuquerque, New Mexico
June 24, 2001
June 24, 2001
June 27, 2001
2153-5965
8
6.518.1 - 6.518.8
10.18260/1-2--9302
https://peer.asee.org/9302
405
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