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 → …

Fingerprint

Wages
Industry

ASJC Scopus subject areas

  • Engineering(all)

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

Negotiation in organizational DSS using extended relational views. / Ramirez, Richard G.; Moser, Kathleen A.; Kulkarni, Uday.

Proceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993. IEEE Computer Society, 1993. p. 677-686 284250 (Proceedings of the Annual Hawaii International Conference on System Sciences; Vol. 4).

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

Ramirez, RG, Moser, KA & Kulkarni, U 1993, Negotiation in organizational DSS using extended relational views. in Proceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993., 284250, Proceedings of the Annual Hawaii International Conference on System Sciences, vol. 4, IEEE Computer Society, pp. 677-686, 26th Hawaii International Conference on System Sciences, HICSS 1993, Wailea, United States, 1/8/93. https://doi.org/10.1109/HICSS.1993.284250
Ramirez RG, Moser KA, Kulkarni U. Negotiation in organizational DSS using extended relational views. In Proceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993. IEEE Computer Society. 1993. p. 677-686. 284250. (Proceedings of the Annual Hawaii International Conference on System Sciences). https://doi.org/10.1109/HICSS.1993.284250
Ramirez, Richard G. ; Moser, Kathleen A. ; Kulkarni, Uday. / Negotiation in organizational DSS using extended relational views. Proceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993. IEEE Computer Society, 1993. pp. 677-686 (Proceedings of the Annual Hawaii International Conference on System Sciences).
@inproceedings{75b571e4ca5c45bba6dacac762d46675,
title = "Negotiation in organizational DSS using extended relational views",
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.",
author = "Ramirez, {Richard G.} and Moser, {Kathleen A.} and Uday Kulkarni",
year = "1993",
month = "1",
day = "1",
doi = "10.1109/HICSS.1993.284250",
language = "English (US)",
series = "Proceedings of the Annual Hawaii International Conference on System Sciences",
publisher = "IEEE Computer Society",
pages = "677--686",
booktitle = "Proceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993",

}

TY - GEN

T1 - Negotiation in organizational DSS using extended relational views

AU - Ramirez, Richard G.

AU - Moser, Kathleen A.

AU - Kulkarni, Uday

PY - 1993/1/1

Y1 - 1993/1/1

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=85063438179&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85063438179&partnerID=8YFLogxK

U2 - 10.1109/HICSS.1993.284250

DO - 10.1109/HICSS.1993.284250

M3 - Conference contribution

AN - SCOPUS:85063438179

T3 - Proceedings of the Annual Hawaii International Conference on System Sciences

SP - 677

EP - 686

BT - Proceedings of the 26th Hawaii International Conference on System Sciences, HICSS 1993

PB - IEEE Computer Society

ER -