Change search
ReferencesLink to record
Permanent link

Direct link
The Customized Database Fragmentation Technique in Distributed Database Systems: A case Study
Jönköping University, School of Engineering, JTH, Computer and Electrical Engineering. (Information Engineering)
Jönköping University, School of Engineering, JTH, Computer and Electrical Engineering. (Information Engineering)
2012 (English)Independent thesis Advanced level (degree of Master (Two Years)), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

In current age, various companies are using a centralized database system for dailybusiness transactions in different domains. Some critical issues have been observedrelated to the complexity, maintenance, performance and communication cost of datain centralized data repository for query processing, according to the demand of endusersfrom different locations. So, different enterprises are striving to implementefficient distributed database systems in their business environments for scalability.The distributed database architecture covers different factors such as transparentmanagement system, replication, fragmentation and allocation etc. This dissertationfocuses on database fragmentation and techniques which are useful for performingdatabase fragmentation.

The objective of this research is to investigate efficient algorithm and technique fordatabase fragmentation in distributed environment. We proposed a customized ISUD(Insert, Select, Update, Delete) technique after comparative study of the best suitabletechniques, which is selected for implementation purpose. The functionality of thecustomized ISUD technique helps to get the precedence of the attribute of a relationhorizontally in database from various sites or location.

The practical objective of this dissertation is to design the architecture and develop,implement customized ISUD (Insert, Select, Update, Delete) user interface, and to testthe selected algorithm or technique by using the interface. We used C#.Net as adevelopment tool. This user interface accepts ISUD frequency as an input andproduces ALP (attribute location precedence) values as output. We have incorporateddesign science research (DSR) method for customized ISUD technique development.This customized ISUD technique can be considered as a foundation to implementhorizontal database fragmentation in distributed environment, so that the databaseadministrator can take a proper decision for allocating the fragmented data to varioussites at initial state of distributed database design.

Place, publisher, year, edition, pages
2012. , 71 p.
Keyword [en]
Distributed database, Database Fragmentation, Attribute Locality precedence, Customized ISUD.
National Category
Engineering and Technology
URN: urn:nbn:se:hj:diva-18539OAI: diva2:534993
, jonkoping (English)
Available from: 2012-06-25 Created: 2012-06-19 Last updated: 2012-06-25Bibliographically approved

Open Access in DiVA

The Customized Database Fragmentation Technique in Distributed Database Systems(1534 kB)2502 downloads
File information
File name FULLTEXT01.pdfFile size 1534 kBChecksum SHA-512
Type fulltextMimetype application/pdf

By organisation
JTH, Computer and Electrical Engineering
Engineering and Technology

Search outside of DiVA

GoogleGoogle Scholar
Total: 2502 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

Total: 296 hits
ReferencesLink to record
Permanent link

Direct link