BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 12, Problem 15RQ
Textbook Problem
59 views

Describe the three data fragmentation strategies. Give some examples of each.

Program Plan Intro

Data fragmentation:

Data fragmentation permits to divide a single object into more than one segments or fragments.

  • That single object might be “user database” or “system database”, or table.
  • Store each and every fragment at any site across the network.

Explanation of Solution

Different types of data fragmentation strategies:

There are three types of data fragmentation strategies. They are,

  • Horizontal fragmentation
  • Vertical fragmentation
  • Mixed fragmentation

Horizontal fragmentation:

  • The horizontal fragmentation permits to divide relations into fragment of tuples (row).
  • Each and every fragment is stored at different node with unique rows. But unique rows have same attributes.
  • Let us consider the example:
    • In EMPLOYEE table, employee working at different LOCATION like XXX, YYY, and soon.
    • This type of fragment helps to access the data quickly with the concept of distributed database that divides the EMPLOYEE table into horizontally depends on LOCATION.
    • This will help to give the row wise data from EMPLOYEE table based on particular LOCATION.

Vertical fragmentation:

  • The vertical fragmentation permits to divide relations into fragment of attributes (column).
  • Each and every fragment is stored at different node with unique columns with exclusion of key column...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
Explain the differences among data, information, and a database.

Database Systems: Design, Implementation, & Management

What system is the predecessor of almost all modern multiuser systems?

Principles of Information Security (MindTap Course List)

What are three benefits of precision grinding?

Precision Machining Technology (MindTap Course List)

Explain what is meant by object-oriented syntax.

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Define a use case and a use case diagram, and prepare a sample of each.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

As with processors, manufacturers state the clock speed for a bus in hertz. (300)

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

What file must be accessed in order to analyze SNMP logs?

Network+ Guide to Networks (MindTap Course List)

What is the purpose of preheating metal before it is welded?

Welding: Principles and Applications (MindTap Course List)