This is a summary of a poster session presented at the 1993 CAUSE Annual Conference held in San Diego, California, December 7-10. It is the intellectual property of the author(s) and may not be published without permission. Disseminating the material otherwise is permitted, provided that the author(s) and the original presentation of the 
paper at CAUSE93 are acknowledged. 


  DELIVERING AN OPTIMIZED REPORTING DATABASE FOR UNIVERSITY 
                        ADVANCEMENT 

A Poster Session Pesentation for CAUSE '93

San Diego, CA

December 8, 1993

Presented by
Donna K. Freddolino, MSU
Michiel Westerkamp, BSR


SESSION ABSTRACT:

Institutional Advancement offices are notoriously demanding 
consumers of systems support.  For Michigan State and many 
other comprehensive public institutions, today's high 
political profile fundraising campaigns share center stage 
with mandated institutional budget reductions.  How do you 
deliver cost competitive alumni/development information 
system capabilities while concurrently improving the 
effectiveness of fund-raising staff?

One solution implemented at MSU has been to create and 
populate a subset alumni/development database on a 
minicomputer located in the advance- ment offices.  
Advancement staff perform both standardized and ad hoc 
retrievals in a client/server environment using off-the-shelf 
reporting facilities and applications developed with 
PowerBuilder against a Sybase database optimized for 
analytical reporting needs.  This presentation will describe 
the internal pressures which lead us to implement this 
solution, and the cooperative arrangements between Business 
Systems Resources (BSR) and MSU.  Acquisition and maintenance 
costs, comparative metrics for report development and query 
performance and user satisfaction improvements will be 
highlighted.  An online presentation of the most commonly 
used techniques for capital campaign prospect management 
reporting and prospect segmentation queries will be provided.



Donna Freddolino                     Michiel Westerkamp
Director of Administrative Services  Vice President
Michigan State University Develop.   Business Systems 
Resources
4700 S. Hagadorn Rd., Ste. 220       1000 Winter St., Ste. 
1200
East Lansing, MI 48823               Waltham, MA  02154
(517) 355-8257                       (617) 890-2105
Email: ALU47@MSU.EDU                 Email:
                                    Westerkamp@MU3100.BSR.COM

Date Revised: 02/27/94 (bdz)