Google scholar arxiv informatics ads IJAIS publications are indexed with Google Scholar, NASA ADS, Informatics et. al.

Call for Paper


March Edition 2023

International Journal of Applied Information Systems solicits high quality original research papers for the March 2023 Edition of the journal. The last date of research paper submission is February 15, 2023.

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

Ali El-matarawy Published in Information Systems

International Journal of Applied Information Systems
Year of Publication: 2012
© 2012 by IJAIS Journal
Authors Ali El-matarawy
Download full text
  1. Ali El-matarawy. Article: Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications. International Journal of Applied Information Systems 4(6):40-43, December 2012. BibTeX

    	author = "Ali El-matarawy",
    	title = "Article: Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications",
    	journal = "International Journal of Applied Information Systems",
    	year = 2012,
    	volume = 4,
    	number = 6,
    	pages = "40-43",
    	month = "December",
    	note = "Published by Foundation of Computer Science, New York, USA"


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.


  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.


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