Abstract
In this paper, a resource allocation system is modeled with relational database technology. To allocate resources through a negotiation-based system, two steps of pre-allocation and negotiated allocation have been modeled with a join procedure for two relations. These relations represent the requirements for experiential nursing practice and the availability of such experience at hospitals, respectively.
The first step was implemented through a new join operation called α-Distance Join. After the first step, some nursing departments and some hospitals have fully satisfied requirements or fully utilized availability. Other nursing department and hospitals have partial or no satisfaction of requirements or availability, respectively.
The second step was implemented through a custom-designed implementation of a user-interface that provides coordinated negotiation among the nodes involved in the system. With the customized interface and join operation, an off-the-shelf or packaged database management system is used. Through this interface, nursing departments and hospitals negotiate until potentially all demands and availability are totally satisfied. This negotiation takes place without face-to-face meetings but with complete knowledge of the entire situation by all parties. This provides the potential for complete fulfillment of nursing experience requirements and total utilization of hospital experience availability.
Similar content being viewed by others
References
Adil, G. K., D. Rajamani, and D. Strong. (1997). “Assignment Allocation and Simulated Annealing Algorithms for Cell Formation,” IIE Transactions 29, 53–67.
Athanassopoulos, A. D. (1998). “Decision Support for target-Based Resource Allocation of Public Services in Multiunit and Multilevel Systems,” Management Science 44, 173–187.
Balakrishnan, A., R. L. Francis, and S. J. Grotzinger. (1996). “Bottleneck Resource Allocation in Manufacturing,” Management Science 42, 1611–1625.
Chai, D. K., and D. C. Ho. (1998). “A Multiple Criteria Decision Model for Resource Allocation: A Case Study in an Electric Utility,” INFOR 36, 151–160.
Conlon, S. P., B. J. Reithel, M. W. Aiken, and A. I. Shirani. (1994). “A Natural Language Processing Based Group Decision Support System,” Decision Support Systems 12, 181–188.
Furugori, N. W., Jin, H. Ogata, and Y. Yano. (1994). “Computer Supported Environment for Common Exploitation of Personal Information,” Computers & Industrial Engineering 27, 189–192.
Gong, D., M. Gen, G. Yamazaki, and W. Xu. (1996). “Neural Network Approach for Allocation with Capacity,” Computers & Industrial Engineering 31, 849–854.
Graf, L., M. Hemmasi, and K. C. Strong. (1996). “Strategic Analysis for Resource Allocation Decisions in Health Care Organizations,” Journal of Managerial Issues 8, 92–107.
Gupta, S. (1989). “Modeling Integrative Multiple Issue Bargaining,” Management Science 35, 788–806.
Jarke, M. (1986). “Knowledge Sharing and Negotiation Support in Multiperson Decision Support Systems,” Decision Support Systems 21, 93–102.
Jarke, M., M. T. Jelassi, and M. F. Shakun. (1987). “MEDIATOR: Towards a Negotiation Support Systems,” European Journal of Operational Research 31, 314–334.
Jelassi, M. T., and A. Faroughi. (1989). “Negotiation Support Systems: An Overview of Design Issues and Existing Software,” Decision Support Systems 5, 167–181.
John, R. I., and S. C. Bennett. (1997). “The Use of Fuzzy Sets for Resource Allocation in an Advance Request Vehicle Brokerage System-A Case Study,” Journal of the Operational Research Society 48, 117–123.
Kim, S. H., S. H. Choic, and B. S. Ahn. (1998). “Interactive Group Decision Process with Evolutionary Database,” Decision Support Systems 23, 333–345.
Kooros, S. K., and B. L. McManis. (1998). “A Multiattribute Optimization Model for Strategic Investment Decisions,” Canadian Journal of Administrative Sciences 15, 152–164.
Motro, A. (1990). “Extending the Relational Database Model to Support Goal Queries,” Proceedings From the First International Conference in Expert Database Systems, Benjamin-Cummings Publishing, 129–150.
Mumpower, J. L. (1991). “The Judgement Policies of Negotiators and the Structure of Negotiation Problems,” Management Science 37, 1304–1324.
Neale, M. A., and M. H. Bazerman. (1991). Cognition and Rationality in Negotiation, New York: The Free Press.
Ngwenyama, O. K., N. Bryson, and A. Mobolurin. (1996). “Supporting Facilitation in Group Support Systems: Techniques for Analyzing Consensus Relevant Data,” Decision Support Systems 16, 155–168.
Nussbaum, M., M. Sepulveda, M. Singer, and E. Laval. (1998). “An Architecture for Solving Sequencing and Resource Allocation Problems Using Approximation Methods,” Journal of the Operational Research Society 49, 52–65.
Schmidt, R. L. (1996). “A Stochastic Optimization Model to Improve production planning and R&D Resource Allocation in Biopharmaceutical production processes,” Management Science 42, 603–617.
Sebenius, J. K. (1992). “Negotiation Analysis: A Characterization and Review,” Management Science 38, 18–38.
Stinnett. A. A., and A. D. Paltiel. (1996). “Mathematical Programming for the Efficient Allocation of Health Care Resources,” Journal of Health Economics 15, 641–653.
Sycara, K.P. (1990). “Negotiation Planning: An AI Approach,” European Journal of Operational Research 46, 216–234.
Sycara, K.P. (1991). “Problem Restructuring in Negotiation,” Management Science 37, 1248–1268.
Thanassoulis, E. (1996). “A Data Envelopment Analysis Approach to Clustering Operating Units for Resource Allocation Purposes,” Omega 24, 463–476.
Vissers, J. M. H. (1998). “Patient Flow-Based Allocation of Inpatient Resources: A Case Study,” European Journal of Operational Research 105, 356–370.
Wagner, F. G., J. A. Brody, D. S. Ladd, and J. S. Beard. (1996). “Sawtimber Valuation and Sawlog Allocation through Simulation of Temple-Inland Sawmills,” Interfaces 26, 3–8.
Wiley, V. D., R. F. Decro, and J. A. Jackson. (1998). “Optimization Analysis for Design and Planning of Multi-Project Programs,” European Journal of Operational Research 107, 492–506.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Hashemi, R.R., Le Blanc, L.A. Resource Allocation through Negotiation and Compromise: A Database Approach. Group Decision and Negotiation 9, 325–345 (2000). https://doi.org/10.1023/A:1008714120334
Issue Date:
DOI: https://doi.org/10.1023/A:1008714120334