The Schema Mapper: An Expert System that Determines the Least Cost Physical File Structure in a Database Management System

The Schema Mapper: An Expert System that Determines the Least Cost Physical File Structure in a Database Management System

Scott J. Lloyd (Eastern Illinois University, USA) and Geoffery Steinberg (Kent State University, USA)
Copyright: © 1997 |Pages: 7
DOI: 10.4018/jdm.1997040102

Abstract

This paper discusses the importance of matching the physical file structure of a database with the different types of user transaction requests that the database management software must process. Different physical file structures and user transaction types are explained and interaction between them is discussed and shown. The Schema Mapper, a model based expert system first assures stable transaction processes using Statistical Process Control methods. It then forecasts the frequency and response time of each type of database user transaction requests leading to the choice of file structure that should minimize total system response time. An experiment is presented which demonstrates The Schema Mapper’s performance during five days of simulated transactions. Experimental results are summarized and presented as evidence of the effectiveness of this expert system. Conclusions and extensions are then offered.

Complete Article List

Search this Journal:
Reset
Open Access Articles
Volume 30: 4 Issues (2019): Forthcoming, Available for Pre-Order
Volume 29: 4 Issues (2018): 2 Released, 2 Forthcoming
Volume 28: 4 Issues (2017)
Volume 27: 4 Issues (2016)
Volume 26: 4 Issues (2015)
Volume 25: 4 Issues (2014)
Volume 24: 4 Issues (2013)
Volume 23: 4 Issues (2012)
Volume 22: 4 Issues (2011)
Volume 21: 4 Issues (2010)
Volume 20: 4 Issues (2009)
Volume 19: 4 Issues (2008)
Volume 18: 4 Issues (2007)
Volume 17: 4 Issues (2006)
Volume 16: 4 Issues (2005)
Volume 15: 4 Issues (2004)
Volume 14: 4 Issues (2003)
Volume 13: 4 Issues (2002)
Volume 12: 4 Issues (2001)
Volume 11: 4 Issues (2000)
Volume 10: 4 Issues (1999)
Volume 9: 4 Issues (1998)
Volume 8: 4 Issues (1997)
Volume 7: 4 Issues (1996)
Volume 6: 4 Issues (1995)
Volume 5: 4 Issues (1994)
Volume 4: 4 Issues (1993)
Volume 3: 4 Issues (1992)
Volume 2: 4 Issues (1991)
Volume 1: 2 Issues (1990)
View Complete Journal Contents Listing