A dissertation submitted in partial fulfillment of the requirements for the degree of doctor of philosophy in computer science

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

البحث في جمود قواعد البيانات الموزعة اعتمادا على مستوى الحقل

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

Maabirah, Khalid Salih Salah

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

al-Hammami, Ala

أعضاء اللجنة

Atum, Jalal Yusuf
al-Zughul, Fawwaz
al-Ani, Sad

الجامعة

جامعة عمان العربية

الكلية

كلية العلوم الحاسوبية و المعلوماتية

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

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

دولة الجامعة

الأردن

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

دكتوراه

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

2008

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

The use of a database is increasing day by day; it has become the core of most applications.

Also the number of users is growing in an unexpected way, and the information must be available in an efficient and reliable way to satisfy user requirements and to cover the increasing needs.

Because the database has the ability to work in a multi user environment, there must be a technique to preserve the data contained in the databases.

Locking database items are the most popular.

Distributed databases may contain huge data, and several hundreds or even several thousands users over the connected sites.

This research suggests a method to increase the availability of data, by reducing the size of lockable entities.

This can be done by increasing the granularity hierarchy tree one more level down at the attributes to allow several transactions to access the same row simultaneously.

A simulation program was implemented to show and compare the system behavior at the field level locking approach.

The experimental results proved that using attribute level locking will decrease the competition for acquiring the data and increases the concurrency control for the Database (Centralized or Distributed).

Also the suggested level increases the database performance and decreases deadlock occurrences.

The discussion presented shows that the system at field level locking behaves much better than at row level locking in both environments (centralized and distributed), because multiple transactions can process the same database row simultaneously, which decreases the mean service time as well as the mean waiting time.

At the same time, more transaction executes on field level than row level locking before the systems begins thrashing, which means that the field level locking works better on a heavy work load than systems at row level locking.

Key words: Centralized Database, Distributed Database, Locking, Attribute Level, Database Deadlocks, Concurrency Control, and Performance

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

الرياضيات

عدد الصفحات

107

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

• APA
• MLA
• AMA

لغة النص

الإنجليزية

نوع البيانات

رسائل جامعية

رقم السجل

BIM-528537