Negotiation in organizational DSS using extended relational views

Richard G. Ramirez, Kathleen A. Moser, Uday Kulkarni

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Negotiation between groups is an iterative process in which each group's position is compared against the adversary's position and modified until an agreement is reached Often, as when negotiating salary and benefits between a company and a union, or a budget between a state agency and its legislature, all parties draw from a common body of information as a starting point As the negotiation proceeds, the positions change and converge to an agreement. We present a new approach to views in relational databases that supports the negotiation process and monitors incremental changes in the groups' positions. The common body of information is stored in a relational database. A view augmented with a differential file is called em independently-updated view (IUV). Each group has a different IUV that corresponds to its particular position in the negotiation. An IUV can be updated without any restriction on the type of view, nature of updates to the view, or updatability of the database. Updates are stored in the differential file. To allow IUVs on dynamic databases, a mechanism is described that maintains consistency between the database and the IUV. We present the architecture of IUVs and their manipulation. Procedures for detecting and resolving inconsistencies between the IUVs and the database are also presented Finally, a performance analysis of IUVs is summarized Results indicate that IUV overhead is low compared to the benefits obtained.

Original languageEnglish (US)
Title of host publicationProceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993
PublisherIEEE Computer Society
Pages677-686
Number of pages10
ISBN (Electronic)0818632305
DOIs
StatePublished - Jan 1 1993
Event26th Hawaii International Conference on System Sciences, HICSS 1993 - Wailea, United States
Duration: Jan 8 1993 → …

Publication series

NameProceedings of the Annual Hawaii International Conference on System Sciences
Volume4
ISSN (Print)1530-1605

Conference

Conference26th Hawaii International Conference on System Sciences, HICSS 1993
CountryUnited States
CityWailea
Period1/8/93 → …

ASJC Scopus subject areas

  • Engineering(all)

Fingerprint Dive into the research topics of 'Negotiation in organizational DSS using extended relational views'. Together they form a unique fingerprint.

  • Cite this

    Ramirez, R. G., Moser, K. A., & Kulkarni, U. (1993). Negotiation in organizational DSS using extended relational views. In Proceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993 (pp. 677-686). [284250] (Proceedings of the Annual Hawaii International Conference on System Sciences; Vol. 4). IEEE Computer Society. https://doi.org/10.1109/HICSS.1993.284250