CFP last date
15 May 2024
Reseach Article

Intelligent Generic Statistical Query Mode

by Ali El-matarawy
International Journal of Applied Information Systems
Foundation of Computer Science (FCS), NY, USA
Volume 5 - Number 2
Year of Publication: 2013
Authors: Ali El-matarawy
10.5120/ijais12-450848

Ali El-matarawy . Intelligent Generic Statistical Query Mode. International Journal of Applied Information Systems. 5, 2 ( January 2013), 30-34. DOI=10.5120/ijais12-450848

@article{ 10.5120/ijais12-450848,
author = { Ali El-matarawy },
title = { Intelligent Generic Statistical Query Mode },
journal = { International Journal of Applied Information Systems },
issue_date = { January 2013 },
volume = { 5 },
number = { 2 },
month = { January },
year = { 2013 },
issn = { 2249-0868 },
pages = { 30-34 },
numpages = {9},
url = { https://www.ijais.org/archives/volume5/number2/417-0848/ },
doi = { 10.5120/ijais12-450848 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2023-07-05T16:01:04.781748+05:30
%A Ali El-matarawy
%T Intelligent Generic Statistical Query Mode
%J International Journal of Applied Information Systems
%@ 2249-0868
%V 5
%N 2
%P 30-34
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

This research presents a new generic approach for defining a new query mode which is the intelligent generic statistical query mode for any database application. It is combined with the optimized intelligent generic query mode (IGSQM) for relational database applications. Since it is generic then it can be used in developing any database application without rewriting any source code. It is intelligent in the sense that it submits to user an enormous amount of statistical reports without the need or support of the application developer, actually the total number of those statistical reports depends on the database schema. The Interface of the new approach is very simple in use. The new approach saves time for developing the required statistical reports by the user. The developed applications which exploit the proposed intelligent generic statistical query mode will empower users and improve the quality and efficiency of service provided by those applications. IGSQM can be used widely in scientific statistical researches. 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. Shirley Dowdy, Stanley Weardon, Daniel Chilko, Statistics For Research, Third Edition, John Wiley & Sons, Inc. Publication.
  2. Albert K. W. Yeung, G. Brent Hall, Spatial Database Systems, Design, Implementation and Project Management, Published by Springer
  3. Turban E. , & Aronson J. , (1998), Decision Support Systems and Intelligent Systems, 5th Edition, Prentice Hall, New Jersey, ISBN 0-13-740937-0
  4. 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.
  5. Ali El-Matarwy, "Optimizing the Intelligent Generic Query Mode and its Interface for Relational Database Applications", published in IJAIS journal, December 2012.
  6. Mustafa J. , Marios D. Dikaiakos, MashQL: A Query-by-Diagram Topping SPARQL Towards Semantic Data Mashups, University of Cyprus mjarrar.
  7. Zloof, M. : Query-by-Example: A Data Base Language. IBM Systems Journal, 16(4). 1977.
  8. 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.
  9. Parent, C. , and Spaccapietra, S. : About Complex Entities, Complex Objects and Object-Oriented Data Models. In Proceedings of the IFIP 8. 1 conference. 1989.
  10. 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.
  11. Hofstede, A. , Proper, H. , and van der Weide, T. : Computer Supported Query Formulation in an Evolving Context. In Proceedings of the ADC. 1995.
  12. Bloesch, A. and Halpin, T. : Conceptual Queries usingConQuer–II. In Proceedings of the ER. LNCS, Springer. 1997.
Index Terms

Computer Science
Information Sciences

Keywords

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