Extending oracle SQL to mine clusters in databases

العناوين الأخرى

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

مقدم أطروحة جامعية

al-Abbudi, Ahmad Abd al-Hasan Hamdan

مشرف أطروحة جامعية

al-Khafaji, Husayn Kitan

أعضاء اللجنة

Hamad, Makkiyah K.
Khalid, Lamia H.

الجامعة

جامعة بغداد

الكلية

كلية العلوم

القسم الأكاديمي

قسم علوم الحاسبات

دولة الجامعة

العراق

الدرجة العلمية

ماجستير

تاريخ الدرجة العلمية

2004

الملخص الإنجليزي

-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.

التخصصات الرئيسية

تكنولوجيا المعلومات وعلم الحاسوب

عدد الصفحات

76

قائمة المحتويات

• APA
• MLA
• AMA

لغة النص

الإنجليزية

نوع البيانات

رسائل جامعية

رقم السجل

BIM-604651