Seventh Asia-Pacific Software Engineering Conference (APSEC'00)
Pragmatic data modelling and design for end users
Singapore
December 05-December 08
ISBN: 0-7695-0915-0
C. Churcher, Appl. Comput. Math. & Stat. Group, Lincoln Univ., Canterbury, New Zealand
T. McLennan, Appl. Comput. Math. & Stat. Group, Lincoln Univ., Canterbury, New Zealand
A. McKinnon, Appl. Comput. Math. & Stat. Group, Lincoln Univ., Canterbury, New Zealand
Many people are dependent on desktop end user tools such as spreadsheets and databases to manage their data. While they may have the technical skills to set up data repositories, many end users lack the analysis skills to design data models which reflect their often deceptively complex requirements. We advocate that a comprehensive data model should always be developed, with expert help, so that the end user can feel confident the subtleties of the data are fully understood. We then suggest that some pragmatic decisions can be made to simplify the model so that the end user can retain control over setting up and maintaining the application.
Index Terms:
data models; database management systems; systems analysis; data modelling; system design; desktop end user tools; spreadsheets; databases; data repositories
Citation:
C. Churcher, T. McLennan, A. McKinnon, "Pragmatic data modelling and design for end users," apsec, pp.120, Seventh Asia-Pacific Software Engineering Conference (APSEC'00), 2000