We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 November 2024
Reseach Article

Visualization for IBQ Applications

by V. Chandra Shekhar Rao, P. Sammulal
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 164 - Number 8
Year of Publication: 2017
Authors: V. Chandra Shekhar Rao, P. Sammulal
10.5120/ijca2017913719

V. Chandra Shekhar Rao, P. Sammulal . Visualization for IBQ Applications. International Journal of Computer Applications. 164, 8 ( Apr 2017), 42-46. DOI=10.5120/ijca2017913719

@article{ 10.5120/ijca2017913719,
author = { V. Chandra Shekhar Rao, P. Sammulal },
title = { Visualization for IBQ Applications },
journal = { International Journal of Computer Applications },
issue_date = { Apr 2017 },
volume = { 164 },
number = { 8 },
month = { Apr },
year = { 2017 },
issn = { 0975-8887 },
pages = { 42-46 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume164/number8/27507-2017913719/ },
doi = { 10.5120/ijca2017913719 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:10:49.092869+05:30
%A V. Chandra Shekhar Rao
%A P. Sammulal
%T Visualization for IBQ Applications
%J International Journal of Computer Applications
%@ 0975-8887
%V 164
%N 8
%P 42-46
%D 2017
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Iceberg query (IBQ) is a special class of aggregation query which compute aggregations upon user provided threshold (T). In data mining area, efficient evaluation of iceberg queries has been attracted by many researchers due to enormous production of data in industries and commercial sectors. Decision support database and discovery of knowledge related systems mainly compute aggregate values of interesting attributes by handling a big quantity of data in large databases. In literature, different strategies were found for IBQ evaluation, but using compressed bitmap index technique provides efficient strategy among all. In this paper, we propose a new strategy for computing IBQ, which builds a set for each attribute value, contains its occurrences in the attribute column and performs set operations for producing result. An experimentation on synthetic dataset demonstrates our approach is efficient than existing strategies for lower thresholds. We suggested set operations[11] in place of bitwise-AND operations to reduce execution time for different threshold values. And we developed effective GUI for aggregation of Different item pairs

References
  1. Gossen, Tatiana, Marcus Nitsche, and Andreas Nurnberger. "Knowledge journey: A web search interface for young users." Proceedings of the Symposium on Hu man-Co mputer Interaction and Information Retrieval. A CM, 2012.
  2. R. Agrawal, T. Imielinski, and A.N. Swami, “Mining Association Rules between Sets of Items in Large Databases,” Proc. A CM SIGM OD Int’l Conf. Management of Data, pp. 207-216, 1993.
  3. Shneiderman. B and Plaisant. C, “The Eight Golden Rules of Interface Design”, Designing the User Interface: Strategies for Effective Hu man Co mputer Interaction: Fifth Edit ion, Addison- Wesley Publ. Co., MA, Ch.2,Sec 2.3.4, 2010
  4. http://wiki.up.ac.za/ index.php/HCI_research_topics
  5. Bin He, Hu i-I Hsiao, Ziyang Liu, Yu Huang and Yi Chen, “Efficient Iceberg Query Evaluation Using Co mpressed Bit map Index”, IEEE Transactions On Knowledge and Data Engineering, vol 24, issue 9, sept 2011, pp.1570-1589.
  6. Dayal, Nab ilKamel, GunterSchlageter,andKyu-Young Whang, editors,VLDB 2000, Proceedings of 26th International Conference on Very Large Data Bases, September 10-14, 2000, Cairo, Egypt, pages 329–338. Morgan Kaufmann, 2000.
  7. www.w3schools.com/php/default.asp
  8. Scott W. A mbler "User Interface Design Tips, Techniques, and Princip les."
  9. R.C.C. Guntupalli, "User Interface Design-Methods and Qualities of Good User Interface Design", M.Thesis, University West, Sweden, Jun. 2008.
  10. Alan Dix, Janet Finalay, Gregory D. Abowd, Russell Beale "The Hu man, The Co mputer, The Interaction", Hu man Co mputer Interaction, 3rd edition,England,Pearson Publishers, Ch.1-3, pp.11-123, 2004
  11. Rao V.C.S, Sammulal P, “Efficient Iceberg Query Evaluation Using Set Representation”, IEEE Explorer, INDICON, Pune, INDIA, ISBN 978-1-4799-5362-2, December 2014, pp.1-5
Index Terms

Computer Science
Information Sciences

Keywords

Database iceberg query threshold set operations