Automatic Database Clustering: Issues and Algorithms

Journal Title: INTERNATIONAL JOURNAL OF COMPUTER TRENDS & TECHNOLOGY - Year 2014, Vol 10, Issue 4

Abstract

Clustering is the process of grouping of data, where the grouping is established by finding similarities between data based on their characteristics. Such groups are termed as Clusters. Clustering is an unsupervised learning problem that group objects based upon distance or similarity. While a lot of work has been published on clustering of data on storage medium, little has been done about automating this process. There should be an automatic and dynamic database clustering technique that will dynamically re-cluster a database with little intervention of a database administrator (DBA) and maintain an acceptable query response time at all times. A good physical clustering of data on disk is essential to reducing the number of disk I/Os in response to a query whether clustering is implemented by itself or coupled with indexing, parallelism, or buffering. In this paper we describe the issues faced when designing an automatic and dynamic database clustering technique for relational databases.. A comparative study of clustering algorithms across two different data items is performed here. The performance of the various clustering algorithms is compared based on the time taken to form the estimated clusters. The experimental results of various clustering algorithms to form clusters are depicted as a graph.

Authors and Affiliations

Sakshi Kumar , Mahesh Singh , Sunil Sharma

Keywords

Related Articles

Facilitating Document Annotation Using Content & Querying Value

Collections of huge, large textual data contains significant amount of structured information, which remains hidden in unstructured text. Relevant information is always difficult to find in these documents. In this paper...

Depth Sensor Based Skeletal Tracking Evaluation for Fall Detection Systems

Falls are very common in elderly due to various physical constraints. Since falls may cause serious injury and even death, fall detection systems are very important, especially when the victim is alone at home or is unab...

An Effective Cloud Service Reservation Through Negotiation

When making reservations for Cloud services, the consumer should provide with price and time slot for the service. The provider gives the price and time slot which are available, then the particular service will be provi...

A Review of Cyber Attack Classification Technique Based on Data Mining and Neural Network Approach

Cyber attack detection and classification is major challenge for web and network security. The increasing data traffic in network and web invites multiple cyber attack. The dynamic nature and large number of attribute of...

LSSVM-ABC Algorithm for Stock Price prediction

In this paper, Artificial Bee Colony (ABC) algorithm which inspired from the behavior of honey bees swarm is presented. ABC is a stochastic population-based evolutionary algorithm for problem solving. ABC algorithm, whic...

Download PDF file
  • EP ID EP94232
  • DOI -
  • Views 88
  • Downloads 0

How To Cite

Sakshi Kumar, Mahesh Singh, Sunil Sharma (2014). Automatic Database Clustering: Issues and Algorithms. INTERNATIONAL JOURNAL OF COMPUTER TRENDS & TECHNOLOGY, 10(4), 208-213. https://europub.co.uk./articles/-A-94232