CFP last date
15 November 2024
Reseach Article

Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications

by Ali El-matarawy
International Journal of Applied Information Systems
Foundation of Computer Science (FCS), NY, USA
Volume 4 - Number 6
Year of Publication: 2012
Authors: Ali El-matarawy
10.5120/ijais12-450776

Ali El-matarawy . Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications. International Journal of Applied Information Systems. 4, 6 ( December 2012), 40-43. DOI=10.5120/ijais12-450776

@article{ 10.5120/ijais12-450776,
author = { Ali El-matarawy },
title = { Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications },
journal = { International Journal of Applied Information Systems },
issue_date = { December 2012 },
volume = { 4 },
number = { 6 },
month = { December },
year = { 2012 },
issn = { 2249-0868 },
pages = { 40-43 },
numpages = {9},
url = { https://www.ijais.org/archives/volume4/number6/365-0776/ },
doi = { 10.5120/ijais12-450776 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2023-07-05T10:47:34.773263+05:30
%A Ali El-matarawy
%T Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications
%J International Journal of Applied Information Systems
%@ 2249-0868
%V 4
%N 6
%P 40-43
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

This research presents an optimization for generic query mode for any database application. It is an enhancement for a previously research "Improving the Query Mode and its Interface for Relational Database Applications". The research improved its intelligence more than expected. In the previous research the algorithm was intelligent in the sense that it answers most of the possible queries or questions that may arise in the user's mind without the need or support of the application developer but there was a restriction for that which is the user can't query about any computed field. This research added this feature to the algorithm regardless the depth of the computed field. The meaning of the depth of the computed field is how many times of the computed field in an equation needs to be transformed so that it contains no computed fields. It has been implemented using PowerBuilder (release 11. 5) as a front end tool and Adaptive Server Anywhere (one of Sybase products) as a database engine. This research describes the design of the optimized intelligent generic query mode and its interface.

References
  1. Albert K. W. Yeung, G. Brent Hall, Spatial Database Systems, Design, Implementation and Project Management, Published by Springer
  2. Turban E. , & Aronson J. , (1998), Decision Support Systems and Intelligent Systems, 5th Ed'n, Prentice Hall, New Jersey, ISBN 0-13-740937-0
  3. Ali El-Matarwy, Improving the Query Mode and its Interface for Relational Database Applications, First National Symposium on Information Technology, journal 2005, King Saud University faculty of Computer Science Information System.
  4. Database Management Systems, Solutions manual, Third Edition, Raghu Ramakrishnan, University of Wisconsin, Madison, WI, USA, Johannes Gehrke, Cornell University, Ithaca, NY, USA and Jeff Derstadt, Scott Selikoff, and Lin Zhu, Cornell University, Ithaca, NY, USA.
  5. Mustafa J. , Marios D. Dikaiakos, MashQL: A Query-by-Diagram Topping SPARQL Towards Semantic Data Mashups, University of Cyprus mjarrar.
  6. Zloof, M. : Query-by-Example: A Data Base Language. IBM Systems Journal, 16(4). 1977.
  7. Czejdo, B. , Elmasri, R. , Rusinkiewicz, M. , and Embley, D. :An algebraic language for graphical query formulation using an EER model. In Proceedings of the ACM Conference on Computer Science. 1987.
  8. Parent, C. , and Spaccapietra, S. : About Complex Entities, Complex Objects and Object-Oriented Data Models. In Proceedings of the IFIP 8. 1 conference. 1989.
  9. De Troyer, O. , Meersman, R. , and Verlinden, P. : RIDL on the CRIS Case: A Workbench for NIAM. In Proceedings of the IFIP. 8. 1 Conference. 1988.
  10. Hofstede, A. , Proper, H. , and van der Weide, T. : Computer Supported Query Formulation in an Evolving Context. In Proceedings of the ADC. 1995.
  11. Bloesch, A. and Halpin, T. : Conceptual Queries usingConQuer–II. In Proceedings of the ER. LNCS, Springer. 1997.
  12. Schwabe D. , Rossi G. and Barbosa D. J. Systematic Hypermedia Application Design with OOHDM. Proc. ACM Conference on Hypertext. pp. 166. 1996.
  13. Paolini P. and Fraternali P. A Model-Driven Development of Web Applications: the Autoweb System . ACM Transactions on Office Information Systems, 2000, Vol. 18, Number 4.
Index Terms

Computer Science
Information Sciences

Keywords

Query mode entry mode relational database applications optimizing query mode generic query mode intelligent query mode database field computed field