Open Access   Article Go Back

DSS Query Optimization and Effect of Input Output / Communication Cost Metrics

M. Sharma1 , G. Singh2 , R. Singh3

  1. Dept. of CSA, DAV University, Jalandhar, India.
  2. Dept. of CS, Guru Nanak Dev University, Amritsar, India.
  3. Dept. of CS, Guru Nanak Dev University, Amritsar, India.

Correspondence should be addressed to: manik_sharma25@yahoo.com.

Section:Research Paper, Product Type: Journal Paper
Volume-5 , Issue-11 , Page no. 198-203, Nov-2017

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v5i11.198203

Online published on Nov 30, 2017

Copyright © M. Sharma, G. Singh, R. Singh . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: M. Sharma, G. Singh, R. Singh, “DSS Query Optimization and Effect of Input Output / Communication Cost Metrics,” International Journal of Computer Sciences and Engineering, Vol.5, Issue.11, pp.198-203, 2017.

MLA Style Citation: M. Sharma, G. Singh, R. Singh "DSS Query Optimization and Effect of Input Output / Communication Cost Metrics." International Journal of Computer Sciences and Engineering 5.11 (2017): 198-203.

APA Style Citation: M. Sharma, G. Singh, R. Singh, (2017). DSS Query Optimization and Effect of Input Output / Communication Cost Metrics. International Journal of Computer Sciences and Engineering, 5(11), 198-203.

BibTex Style Citation:
@article{Sharma_2017,
author = {M. Sharma, G. Singh, R. Singh},
title = {DSS Query Optimization and Effect of Input Output / Communication Cost Metrics},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {11 2017},
volume = {5},
Issue = {11},
month = {11},
year = {2017},
issn = {2347-2693},
pages = {198-203},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=1566},
doi = {https://doi.org/10.26438/ijcse/v5i11.198203}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v5i11.198203}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=1566
TI - DSS Query Optimization and Effect of Input Output / Communication Cost Metrics
T2 - International Journal of Computer Sciences and Engineering
AU - M. Sharma, G. Singh, R. Singh
PY - 2017
DA - 2017/11/30
PB - IJCSE, Indore, INDIA
SP - 198-203
IS - 11
VL - 5
SN - 2347-2693
ER -

VIEWS PDF XML
572 380 downloads 242 downloads
  
  
           

Abstract

Decision Support System (DSS) query is an important type of distributed query. It plays an imperious role in decision making practise. However, it ingest loads of Input Output (I/O), processing and communication assets. Here, a 3-Join DSS query has been optimized using entropy and restricted chromosome based DSS query optimizer (ERC_QO). A study is carried out to inspect the consequences of varying the ratio of I/O and communication costs over Total Costs (total system resources). It is perceived that by plummeting the I/O to communication costs ratio, the communication costs can be more commendably optimized. For a 3-Join DSS query, the communication costs have been reduced by 90% approximately. Moreover, the Total Costs of 3-Join DSS query is abridged by 2%.

Key-Words / Index Term

DSS query, Query Optimization, I/O costs, Communication Costs

References

[1] C. D. French. One Size Fits All- Database Arch. Don’t Work for DSS. ACM SIGMOD Newsletter1995:24-2:449-450.
[2] S. Elnaffar, P. Martin, Is it DSS or OLTP: Automatically identifying DBMS Workload, Journal of Intelligent Information System. 30(3) (2008) 249-271.
[3] M. T. Ozsu, V. Patrick, Principles of Distributed Database System, second ed., Pearson Education (chap. 1–6).
[4] SB Yao, AR Hevener. Query processing in DDS. IEEE Trans. Soft. Eng. 1979;5(3):177–87.
[5] Pelagatti G, S Ceri ,. Allocation of operations in distributed database access. IEEE Trans. Comp. 1982;31(2):119–29.
[6] T. M. Martin, K.H. Lam, Judy I Russel, An Evaluation of Site Selection Algorithms for Distributed Query Processing, The Computer Journal. 33(1) (1990) 61-70.
[7] K. Donald, The State of the Art in Distributed QP, ACM Computing Surveys. 32(4) (2000) 422–469.
[8] M. Sharma, G. Singh, R. Singh. “Design and Analysis of Stochastic DSS Query Optimizer in a Distributed Database System”. Egyptian Informatics Journal. doi:10.1016/j.eij.2015.10.003.
[9] M. Sharma, G. Singh, G. Singh, R. Singh, Analysis of DSS Queries in DDS using Exhaustive and GA, International Journal of Advanced Computing. 36(2) (2013) 1165-1174.
[10] M. Sharma, G. Singh, R. Singh and G Singh. 2015. “Analysis of DSS Queries using Entropy based Restricted Genetic Algorithm”. Applied Mathematics and Information Science. Vol. 9, Issue 5.
[11] M. Sharma. 2013. “Role and Working of GA in Computer Science”. International Journal of Computer Applications and Information Technology. 2013; 2(1): 27-32.
[12] S. Ender, C. Ahmat, An Evolutionary GA for optimization of Distributed Database Queries, The Computer Journal. 54(5) (2011) 717-725.