Designing a distributed database on a local area network: a methodology and decision support system

Local area networks (LANs) are important for an enterprise to hold a competitive edge. Many companies have therefore converted terminal-based computing systems to LAN-based distributed data processing systems. This paper proposes a design methodology for distributed databases connected by a LAN. Two primary objectives of the methodology are: (i) to allocate data files and workload among heterogeneous servers; and (ii) to determine the number of servers to satisfy the response time required for processing each transaction. The file and workload allocation decision is formulated as a nonlinear zero-one integer programming problem. This problem is proven to be NP-complete. A heuristic is developed to solve this problem effectively. A decision support system is implemented and an example is solved to illustrate the practical usefulness of the system. (C) 2000 Elsevier Science B.V. All rights reserved.
Publisher
ELSEVIER SCIENCE BV
Issue Date
2000-02
Language
ENG
Keywords

WORKLOAD ALLOCATION; MULTIPLE SERVERS; COMPUTER-SYSTEMS; LOAD

Citation

INFORMATION AND SOFTWARE TECHNOLOGY, v.42, no.3, pp.171 - 184

ISSN
0950-5849
URI
http://hdl.handle.net/10203/4562
Appears in Collection
KSIM-Journal Papers(저널논문)
  • Hit : 396
  • Download : 8
  • Cited 0 times in thomson ci
This item is cited by other documents in WoS
⊙ Detail Information in WoSⓡClick to seewebofscience_button
⊙ Cited 7 items in WoSClick to see citing articles inrecords_button

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0