Wednesday, May 2, 2012
02:10 PM - 03:00 PM
Dr. Everest provides a synthesis of his experiences in gathering database design requirements through interviews and conducting database design project meetings. He shares his best practices - what he has found to work and what doesn't work. Reflecting on the lessons learned yields a set of best practices which should be considered by anyone attempting to lead a database design project.
- Interviews vs. facilitated group sessions
- Picking the users to interview or invite to the table
- Preparations before the interviews or before the meetings
- Accelerated (one meeting possibly over several days, e.g., JAD) vs. extended series of meetings
- Findings of an experiment which compared the two approaches to group sessions
- Lessons learned
- Highlighting the best practices
Dr. Everest is Professor Emeritus of MIS and Database in the Carlson School of Management at the University of Minnesota. With early "retirement," he continues to teach Advanced Data Modeling as an adjunct. His Ph.D. dissertation at the University of Pennsylvania Wharton School entitled "Managing Corporate Data Resources" became the text from McGraw-Hill, "Database Management: Objectives, System Functions, and Administration" in 1986.
Gordon has been teaching all about databases, data modeling, database management systems, data(base) administration, dimensional modeling, and data warehousing since he joined the university in 1970. Students learn the theory of databases and gain practical experience with real data modeling projects, with hands-on use of data modeling tools and DBMSs. Besides teaching about databases, he has helped many organizations do data modeling and design their databases. Actually doing it informs his teaching and presentations.