Update

Expert Database System for Converting Unfit Query to Standard SQL Query

Author: Laith R. Flaih
Computer Science Department,Cihan University-Erbil
DOI:http://dx.doi.org/10.24086/cuesj.v1n2a9

Abstract

Today, the integration of Expert System (ES) and Database Management System (DBMS) is an emerging research area that is expected to become one of the most important application development products. The proposed system characterized a new class of computer systems to be called Expert Database System (EDS) which is a combination of two systems. They are the Database system and Expert system.

This research considers that the database contains a lot of data, which is used by a large number of users with different computer education levels. It is a fact that the DBMS is always strict in query execution that the unfit query for a simple reason would be rejected, this rejection affects communication momentum and user disappointment by not having the desired data. The proposed system aims to prevent rejection of unfit query that is entered by the user through preparing it for optimization it so that it is in a simple correct form which is accepted by the DBMS.

Keywords: Expert System, DBMS, SQL, Database

References

Beynon-Davies, P. (1991) Expert Database Systems A Gentle Introduction. UK: McGRAW-HILL Book Company.

Din, A.I. (1994) Structured Query Language (SQL) A Practical Introduction. NCC Blackwell.

Elmasri, R., Navathe, S. B. (2007) Fundamentals of Database System. Fifth Edition, UK: (Addison Wesley) Pearson Education

Giarratano, J. & Riley, G. (1998) Expert Systems Principles and Programmings. Third Edition, Boston: PWS Publishing Company.

Jarke, M. & Koch, J. (1984) Query Optimization in Database System, Computing Surveys, 16(2).

Leondes, C.T. ( 2002) Expert Systems, Academic Press.

Luger, G.F. (2009) Artificial Intelligence Structures and Strategies For complex Problem Solving. Sixth Edition,UK: ( Addison Wesley) Pearson Education.

Rob, P. & Coronel, C. (2007) Database Systems: Design, Implementation, and Management.  Seventh Edition, USA: Thomson Course Technology.

Shannon, C. E. (1955) A chess playing machine. In The World of Mathematics, Vol. 4 (J. R. Newman,Ed.). New York: Simon and Schuster.

Turban, E., Aronson, J. E. & Liang, T.P. (2005) Decision Support System and Intelligent Systems, Seventh Edition, UK: (Prentice Hall) Pearson Education

 Zainvi, S. F. (2017) How To Use Structured Query Language (SQL).

Full Text

 

About admin

Check Also

Vol. 1, No. 2, ِAugust 2017 Cihan University-Erbil Scientific Journal

  Contents (Articles in English Language) Article Pages Expert Database System for Converting Unfit Query …

Leave a Reply

Your email address will not be published. Required fields are marked *