DATABASE ALLOCATION IN A DISTRIBUTED ENVIRONMENT - INCORPORATING A CONCURRENCY-CONTROL MECHANISM AND QUEUING COSTS

被引:18
作者
RAM, S [1 ]
NARASIMHAN, S [1 ]
机构
[1] GEORGIA INST TECHNOL,SCH MANAGEMENT,ATLANTA,GA 30332
关键词
DISTRIBUTED DATABASE SYSTEMS; CONCURRENCY CONTROL; FILE ALLOCATION; LAGRANGIAN RELAXATION; NETWORK DESIGN;
D O I
10.1287/mnsc.40.8.969
中图分类号
C93 [管理学];
学科分类号
12 ; 1201 ; 1202 ; 120202 ;
摘要
This research investigates the problem of allocating database fragments across a set of computers connected by a communication network. A mathematical model is presented to aid designers in the development of distributed database systems. The model takes into account the pattern of usage of the databases, communication costs in the network, delays due to queuing of data requests, costs for maintaining consistency among the various copies of a database, and storage costs. A solution procedure based on Lagrangian relaxation is proposed to solve the model. Computational results are reported along with several useful observations. The model is applicable to organizations that are considering migration from a centralized to a distributed computing environment.
引用
收藏
页码:969 / 983
页数:15
相关论文
共 48 条
[11]  
CERI S, 1984, DATABASE ENG, P46
[12]  
CHANDY M, 1977, 3RD P INT C VER LARG, P105
[13]   OPTIMAL FILE ALLOCATION IN A MULTIPLE COMPUTER SYSTEM [J].
CHU, WW .
IEEE TRANSACTIONS ON COMPUTERS, 1969, C 18 (10) :885-&
[14]  
Ciciani B., 1990, IEEE Transactions on Knowledge and Data Engineering, V2, P247, DOI 10.1109/69.54723
[15]  
ELAM J, 1979, DISTRIBUTED DATABASE, V2, P115
[16]  
ELMASRI R, 1989, FUNDAMENTALS DATABAS
[17]  
ESWARAN KP, 1974, INFORMATION PROCESSI, V74, P304
[18]   THE LAGRANGIAN-RELAXATION METHOD FOR SOLVING INTEGER PROGRAMMING-PROBLEMS [J].
FISHER, ML .
MANAGEMENT SCIENCE, 1981, 27 (01) :1-18
[19]   AN APPLICATIONS ORIENTED GUIDE TO LAGRANGIAN-RELAXATION [J].
FISHER, ML .
INTERFACES, 1985, 15 (02) :10-21
[20]  
Garey MR., 1979, COMPUTERS INTRACTABI