answersLogoWhite

0


Best Answer

Horizontal Fragmentation splits tables by rows. It differs from Vertical Fragmentation in that the relationship between key columns and non-key columns remains the same. The content of the tables differ by key value.

Horizontal Fragmentation is the classic distributed data base design approach. For example, you only allow customer data for the western region to enter the database in the Los Angeles office. The customer data for the eastern region can only be entered in the New York office's database. The Rule of Reconstruction dictates that no overlaps can be allowed by key content. In this case customers cannot be shared for update between the Eastern and Western offices.

Cheenu Gawri

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Derived horizontal fragmentation and mixed fragmentation?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the advantages of horizontal fragmentation?

To speed up queries


Is thrombocytes a white blood cell?

Thrombocytes are platelets, derived from fragmentation of megakaryocytes. They are not white blood cells.


What two types of fragmentation can arise on a hard disk drive?

Fisk fragmentation, and A.I.R.Y fragmentation.


Explain internal external fragmentation give the best suted solution to the fragmentation?

explain fragmentation?


The term Balkanization refers to?

Balkanization refers to the fragmentation or division of a region or state into smaller, often hostile, independent entities based on ethnic, religious, or political differences. The term is derived from the historical conflicts and rivalries in the Balkan Peninsula in southeastern Europe.


What type of fragmentation is there in paging and why?

external fragmentation use in paging


Is relocatable Dynamic Memory external or internal fragmentation?

external fragmentation


Can amoeba reproduce by fragmentation?

Yes, amoebas can reproduce by fragmentation. During fragmentation, the amoeba divides into two or more parts, each of which develops into a new individual.


What are some examples of fragmentation?

Fragmentation in computer science can refer to physical fragmentation (when files and data are scattered across a disk) or memory fragmentation (when memory becomes divided into small unusable chunks). Fragmentation in ecosystems can occur when habitat patches become isolated, affecting the movement and survival of species. Fragmentation in society can be seen through the segregation of communities or the division of resources based on socioeconomic status.


What is the defention of fragmentation?

Fragmentation refers to the splitting or breaking up of something into smaller parts or pieces. In computing, fragmentation often refers to the scattering of data or files across a storage device, which can slow down access times and performance.


Which of the following is a binary opposite of Unity. A emotion B big narrative C fragmentation D reason?

Fragmentation is the binary opposite of Unity. Unity represents wholeness, oneness, and cohesion, while fragmentation signifies division, separation, and disintegration.


How would you explain fragmentation and reassembly?

Fragmentation is breaking apart. Reassembly is putting back together.