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

Cited 10 time in webofscience Cited 0 time in scopus
  • Hit : 700
  • Download : 41
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
English
Article Type
Article
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
MT-Journal Papers(저널논문)
Files in This Item
This item is cited by other documents in WoS
⊙ Detail Information in WoSⓡ Click to see webofscience_button
⊙ Cited 10 items in WoS Click to see citing articles in records_button

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0