Extending oracle SQL to mine clusters in databases

Other Title(s)

توسيع لغة الاستعلام المهيكل لنظام أوراكل لتعدين العناقيد في قواعد البيانات

Dissertant

al-Abbudi, Ahmad Abd al-Hasan Hamdan

Thesis advisor

al-Khafaji, Husayn Kitan

Comitee Members

Hamad, Makkiyah K.
Khalid, Lamia H.

University

University of Baghdad

Faculty

College of Science

Department

Department of Computer Science

University Country

Iraq

Degree

Master

Degree Date

2004

English Abstract

-discover patterns and relationships in data that may be used to make valid predictions. The mined datasets are often in relational format, while most mining systems do not use relational DBMS; they have a loose connection with database.

Thus, they miss the opportunity to leverage the database technology developed in the last couple of decades.

Furthermore, the data mining systems emerged to serve mining goals, that is, until now there is no integral system can answer mining queries and traditional queries, i.e.

SQL.

In this project, an integral system is built by extending SQL language with a set of new statements and functions, which can be used to discover clusters in database table, and answer traditional SQL queries.

This proposed system is implemented by using Oracle DBMS, to avoid the problem of loosing connection of data mining with DBMS.

This research is accomplished according to many theoretical and systematic steps such as: 1) Extending the BNF of SQL to cluster databases. 2) Designing a translator to the extended BNF. 3) Implementing k-means clustering algorithm. 4) Designing and implementing many reporting interfaces to display the mined clusters. MSQL can be executed under windows 98, windows Me, windows XP or windows 2000 by using Oracle 8i or later versions such as Oracle 9i.

Main Subjects

Information Technology and Computer Science

No. of Pages

76

Table of Contents

• APA
• MLA
• AMA

Language

English

Data Type

Arab Theses

Record ID

BIM-604651