Abstract
This paper chronicles database redesign projects at two separate laboratory departments that test human specimens with many similar methods and tasks. Both departments had earlier purchased the same software package to support the daily laboratory testing and administrative operation. Our objective was to replace the flat file data heap with a modern database while preserving the original software’s strengths. This paper describes briefly the laboratory routine, our Structured Query Language (SQL) redesign concept, the outcome of the redesign project, and some lessons learned.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Degoulet, P., Phister, B., Fieschi, M., 1996, „Introduction to Clinical Informatics (Computers in Health Care)“. Springer-Verlag, Berlin.
Drazen, E.L., Metzger, J.B., Ritter, J.L., Schneider, M.K., 1994. „Patient Care Information Systems Successful Design and Implementation.“ Springer-Verlag, Berlin.
Fagan, M., Perreault, L.E., 1990, “The Future of Computer Applications in Health Care.” In (Medical informatics: Computer Applications in Health Care.)” In Shortliffe, E.H., et al. 1990, Addison-Wesley.
Shortliffe, E.H., Perreault, L.E., Wierhold, G., Fagan, L.M., eds., 1990, „Medical Informatics: Computer Applications in Health Care.“ Addison-Wesley, New York.
Willard, K.E., Hallgren, J.H., Connelly, D.P., 1999, „W3 Based Medical Information Systems vs Custom Client Server Applications.“ University of Minnesota Hospital and Clinic Proceedings Web Site: http://www.ncsa.uiuc.edu/SDG/IT94/Proceedings/MedTrack/willard/UMHC_www/UMHC_www_paper.html
Wojtkowski, W.G., Wojtkowski, W., Wrycza, S., Zupancic, J., eds., 1997, „Systems Development Methods for the Next Century.“ Plenum Press, New York.
The following articles all appear in „Patient Care Information Systems Successful Design and Implementation.“ Springer-Verlag, Berlin, (Drazen, E.L., et al. 1994).
Drazen, E.L., 1994 „Physician’s and Nurses’ Acceptance of Computers.“ In Drazen, E.L., et al., Springer-Verlag, pp. 31–50.
Metzger, J.B., 1994, „The Potential Contributions of Patient Information Systems.“ InDrazen, E.L., et al., Springer-Verlag, pp. 1–30.
Metzger, J.B., Teich, J.M., 1994, „Designing acceptable Patient Care Systems.“ In Drazen, E.L., et al., Springer-Verlag, pp.83–132.
Metzger, J.B., Marwaha, S., 1994, „Redefining the Patient Care Information System.“ In Drazen, E.L., et al., Springer-Verlag, pp. 187–212.
The following articles all appear in „Systems Development Methods for the Next Century.“ Plenum Press, New York, (Wojtkowski et al. 1997):
Cheung, K.S., Chow, K.O., Cheung, T.Y., 1997, „A Feature-Based Approach for Consistent Object-Oriented Requirements Specification.“ In Wojtkowski et al., Plenum Press, pp. 31–38.
Eriksson, I., Nissen, H.-E., 1997, „Information Systems for Responsible Actors: Basic Concepts for Understanding and Action.“ In Wojtkowski et al., Plenum Press, pp. 391–408.
Fritzgerald, B., 1997, „System Development Methodlogies: Toime to Advance the Clock,“ In Wojtkowski et al., Plenum Press, pp. 127–140
Kirikova, M., Grundspenkis, J., 1997, „Organisational Defenses in Requirements Engineering.“ In Wojtkowski et al., Plenum Press, pp. 227–240.
Kirveennummi, M., 1997, „Objectives and Reality: User Participation in Information System Development.“ In Wojtkowski et al., Plenum Press, pp. 115–126.
Krogh, B., 1997, „Modelling the Dynamics of Cooperative Work Arrangements.“ In Wojtkowski et al., Plenum Press, pp. 61–74.
Nagasundaram, M., 1997. „Creativity, Group Support Systems, and Systems Development.“ In Wojtkowski et al., Plenum Press, pp. 39–48.
Paetau, P., 1997, „Use of Object-Orientation for Information Systems Development in Software Companies in Finland: A Proposal for Study.“ In Wojtkowski et al., Plenum Press, pp. 23–30.
Post, H.A., van der Rijst, N.B.J., 1997, „A Dynamic Approach in Information System Development.“ In Wojtkowski et al., Plenum Press, pp. 545–558.
Pereira, R.E., 1997, „Organizational Impact of Component-Based Systems Development“. In Wojtkowski et aI. 1997, Plenum Press, pp. 241–257.
Shaw, T., Pereira, R.E., 1997, „The Sources of Power between Information System Developers and End Users: A Resource Dependence Perspective.“ In Wojtkowski et al. 1997, Plenum Press, pp. 463–471.
Vogel, D., van Genuchten, M., Rodgers, T., 1997, „Team Support for Software Development.“ In Wojtkowski et al., Plenum Press, pp. 49–60.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer Science+Business Media New York
About this chapter
Cite this chapter
Aus, H.M., Haucke, M., Steimer, A. (1999). The Challenge: Providing an Information System for a Clinical Laboratory. In: Wojtkowski, W., Wojtkowski, W.G., Wrycza, S., Zupančič, J. (eds) Systems Development Methods for Databases, Enterprise Modeling, and Workflow Management. Springer, Boston, MA. https://doi.org/10.1007/978-1-4615-4261-2_25
Download citation
DOI: https://doi.org/10.1007/978-1-4615-4261-2_25
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4613-6913-4
Online ISBN: 978-1-4615-4261-2
eBook Packages: Springer Book Archive