Data Redundancy

In: Computers and Technology

Submitted By jellybean14
Words 409
Pages 2
Can a database contain two identical records without a negative effect on the integrity of the database? Why or why not?
Data redundancy is a situation that occurs within database systems and involves the unintentional creation of duplicated data that is not necessary to the function of the database. While redundancy is often a desirable trait in some situations, this is not true when it comes to the function of a database. The presence of duplicated data can often have an adverse effect on the function of the system, resulting in returning information in response to system queries that is less than helpful. One of the key functions of data management identification of duplicated data and the removal of those duplications (Tatum, 2015).
The potential for data redundancy is found in just about any type of database program. Programs that are considered flat, such as spreadsheets, and rely on manual entry of data are particularly susceptible to the duplication of information that may lead to complications when it comes to retrieving the information desired. Relational style databases, such as sales contact databases, often include processes that help to minimize the chances for unintentional duplication, such as the creation of two different contact files on the same contact associated with the same company. Even with the use of system checks to help reduce the incidence of data redundancy, there is still the potential for issues to occur, making it necessary to periodically engage in the task of data cleanup within a database (Tatum, 2015).
At best, data redundancy means that the database is littered with information that is not essential but poses no real threat to the ability to find the data when and as needed. At worst, the presence of the duplicated data slows down the essential functions of the database and can complicate the process of using the database to…...

Similar Documents

Disk Redundancy Research

...Unit 2. Assignment 1. Disk Redundancy Research 1. What does RAID stand for? Redundant Array of Independent Disk 2. When would we use Raid? To divide and replicate data into physical drives. 3. Define the following types of RAID: a. RAID 0-is simply data striped over several disks. This gives a performance advantage, as it is possible to read parts of a file in parallel. However not only is there no data protection, it is actually less reliable than a single disk, as all the data is lost if a single disk in the array stripe fails. b. RAID 1-is data mirroring. Two copies of the data are held on two physical disks, and the data is always identical. RAID1 has a performance advantage, as reads can come from either disk, and is simple to implement. However, it is expensive, as twice as many disks are needed to store the data. c. RAID 5-data is written in blocks onto data disks, and parity is generated and rotated around the data disks. Good general performance, and reasonably cheap to implement. Used extensively for general data. d. RAID 6-is growing in popularity as it is seen as the best way to guarantee data integrity as it uses double parity. It was originally used in SUN V2X devices, where there are a lot of disks in a RAID array, and so a higher chance of multiple failures. RAID6 as implemented by SUN does not have a write overhead, as the data is always written out to a different block. 4. Why is RAID 0 of any use if it offers no redundancy? Fast performs and......

Words: 352 - Pages: 2

Disk Redundancy

...into a logical unit. Data is distributed across the drives in one of several ways called "RAID levels", depending on what level of redundancy and performance (via parallel communication) is required. Marketers representing industry RAID manufacturers later attempted to reinvent the term to describe a redundant array of independent disks as a means of dissociating a low-cost expectation from RAID technology. RAID is now used as an umbrella term for computer data storage schemes that can divide and replicate data among multiple physical drives. The physical drives are said to be in a RAID array, which is accessed by the operating system as one single drive. The different schemes or architectures are named by the word RAID followed by a number (e.g., RAID 0, RAID 1). Each scheme provides a different balance between two key goals: increase data reliability and increase input/output performance. 2. When would we use RAID? RAID is extremely useful if reliability and data redundancy are important to you. Even if you take backups, you will need to take the time to restore those backups and those backups could be hours or days old, resulting in data loss. RAID allows you to survive a drive loss without data loss and in many cases without any downtime. RAID is also useful if you are having disk IO issues, where applications are waiting on the disk to perform tasks. Going with RAID will provide you additional throughput by allowing you to read and write data from multiple......

Words: 855 - Pages: 4

Disk Redundancy Research

...Disk Redundancy Research • What does RAID stand for? Redundant array of independent disks • When would we use RAID? When need of advanced storage schemes are needed. Whether it is better performance, reliability and extra redundancy. • Define the following types of RAID: • RAID 0 – Block-level striping without parity or mirroring • RAID 1 – Mirroring without parity or striping • RAID 5 – Block-level striping with distributed parity • RAID 6 – Block-level striping with double distributed parity. (Basically extended RAID 5) • Why is RAID 0 of any use if it offers no redundancy? Best if used in a High bandwidth need. video and picture editing, etc. • Why do you think that RAID 1 can be the most expensive? Why would people utilize it if it’s so costly? Because its disk overhead requires the drives to always be running. Its 100% redundancy provides a guarantee that no data will be lost. • If you, as a home computer user, were to purchase a form of RAID, which would you choose and why? It all depends on what purpose I would choose to use a RAID for. If I was implementing a type of high traffic situation I would use RAID 5, RAID 0 in any high speed situation, and RAID 1 if high availability is needed. • What is the difference between software RAID and hardware RAID? Hardware raid is where a controller built into the motherboard or an Add-in card is used to populate the raid. Software raid is where you use the program available to your operating system or a 3rd...

Words: 269 - Pages: 2

Disk Redundancy Research

...Disk Redundancy Research RAID stands for Redundant Array of Inexpensive (or Independent) Discs. A RAID system uses redundancy - meaning that data is written in more than one place - to keep data safe. RAID is extremely useful if reliability and data redundancy are important to you. Even if you take backups, you will need to take the time to restore those backups and those backups could be hours or days old, resulting in data loss. RAID allows you to survive a drive loss without data loss and in many cases without any downtime. RAID is also useful if you are having disk IO issues, where applications are waiting on the disk to perform tasks. Going with RAID will provide you additional throughput by allowing you to read and write data from multiple drives instead of a single drive. Additionally, if you go with hardware RAID, the hardware RAID card will include additional memory to be used as cache, reducing the strain put on the physical hardware and increase overall performance. RAID Level 0 RAID Level 0 provides no redundancy. RAID Level 0 splits or stripes the data across drives, resulting in higher data throughput. Since no redundant information is stored, performance is very good, but the failure of any disk in the array results in complete data loss. Level 0 is only used to increase disk performance. RAID Level 1 RAID Level 1 is usually referred to as mirroring. A Level 1 array provides redundancy by duplicating all the data from one drive on a second drive so...

Words: 736 - Pages: 3

Disk Redundancy

...Disk Redundancy Research Disk Redundancy Research • What does RAID stand for? Redundant array of independent disks • When would we use RAID? When need of advanced storage schemes are needed. Whether it is better performance, reliability and extra redundancy. • Define the following types of RAID: • RAID 0 – Block-level striping without parity or mirroring • RAID 1 – Mirroring without parity or striping • RAID 5 – Block-level striping with distributed parity • RAID 6 – Block-level striping with double distributed parity. (Basically extended RAID 5) • Why is RAID 0 of any use if it offers no redundancy? Best if used in a High bandwidth need. video and picture editing, etc. • Why do you think that RAID 1 can be the most expensive? Why would people utilize it if it’s so costly? Because its disk overhead requires the drives to always be running. Its 100% redundancy provides a guarantee that no data will be lost. • If you, as a home computer user, were to purchase a form of RAID, which would you choose and why? It all depends on what purpose I would choose to use a RAID for. If I was implementing a type of high traffic situation I would use RAID 5, RAID 0 in any high speed situation, and RAID 1 if high availability is needed. • What is the difference between software RAID and hardware RAID? Hardware raid is where a controller built into the motherboard or an Add-in card is used to populate the raid. Software raid is where you use the program available to your......

Words: 272 - Pages: 2

Nt1230 Disk Redundancy

...Assignment 1 Disk Redundancy Research 1.) What does RAID stand for? RAID stands for either redundant array of independent disks or redundant array of inexpensive disks. (Natarajan, 2010) 2.) When would we use RAID? You would use RAID when you have a lot of important data that you are constantly changing and need to back up often. 3.) Define the following types of RAID: a.) RAID 0: RAID 0 has striped blocks and has no redundancy (no mirror or parity). RAID 0 must have at least two disks. (Natarajan, 2010) b.) RAID 1: RAID 1 has mirrored blocks and has the best performance of the four because it isn’t striped like RAID 0 and has no parity. Also like RAID 0 RAID 1 needs to have a minimum of two disks. (Natarajan, 2010) c.) RAID 5: RAID 5 has striped blocks like RAID 0 but unlike a, b, and c RAID 5 has distributed parity and needs a minimum of three disks. (Natarajan, 2010) d.) RAID 6: RAID 6 is RAID 5 except when making RAID 6 they added another strip to deal with RAID 5’s major drawback it was useless after two disks went down. (Murrel, 2007) 4.) Why is RAID 0 of any use if it offers no redundancy? Even though RAID 0 offers no redundancy it still backs up all of your data, and has the best performance as well as the fastest bandwidth. 5.) Why do you think that RAID 1 can be the most expensive? Why would people utilize it if it’s so costly? RAID 1 is the most expensive because its disk overhead requires all of its drives to be running. Its 100% redundancy means......

Words: 388 - Pages: 2

Disk Redundancy

...1. What does RAID stand for? RAID stands for Redundant Array of Independent disks. 2. When would we use RAID? RAID is a technology that is used to increase the performance and/or reliability of data storage. 3. Define the following types of RAID: RAID 0- RAID 0 has striped blocks and has no redundancy. RAID 0 must have at least two disks. RAID 1- RAID 1 has mirrored blocks and has the best performance of the four and has no parity. RAID 1 needs to have a minimum of two disks. RAID 5- RAID 5 is a hybrid of RAID 0 and RAID 1. RAID 5 has distributed parity and needs a minimum of three disks. RAID 6- RAID 6 is RAID 5 except when making RAID 6 they added another strip to deal with RAID 5’s major drawback it was useless after two disks went down. 4. Why is RAID 0 of any use if it offers no redundancy? It can be used to improve performance or create large logical disks out of multiple physical disks. 5. Why do you think that RAID 1 can be the most expensive? Why would people utilize it if it’s so costly? RAID 1 is the most expensive because its disk overhead requires all of its drives to be running. Its 100% redundancy means that no data will be lost. 6. If you, as a home computer user, were to purchase a form of RAID, which would you choose and why? It all depends on what purpose I would need to use RAID for. If had a type of high traffic situation I would use RAID 5, RAID 0 with a high speed situation, and RAID 1 if I needed high availability. 7. What is the......

Words: 343 - Pages: 2

Disk Redundancy

...throughput by allowing you to read and write data from multiple drives instead a single drive. Source: Steadfast.com 3. Define the following types of RAID: RAID 0 (Striping) - RAID 0 is taking any number of disks and striping data across all of them. This will greatly increase speeds, as you're reading and writing from multiple disks at a time. An individual file can then use the speed and capacity of all the drives of the array. The downside to RAID 0 though is that it is NOT redundant, the loss of any individual disk will cause complete data loss. I would not recommend ever using RAID 0 in a server environment. You can use it for cache or other purposes where speed is important and reliability/data loss does not matter at all, but it should not be used for anything other than that. As an example, with the 5% annual failure rate of drives, if you have a 6 disk RAID 0 array you've increased your risk of data loss to nearly 27%. RAID 1 (Mirroring) - RAID 1 is generally used with a pair of disks, though could be done with more, and would identically mirror/copy the data equally across all the drives in the array. The point of RAID 1 is primarily for redundancy, as you can completely lose a drive, but still stay up and running off the additional drive(s). You can then rebuild the array to a new drive off of the other drive with little to no downtime. RAID 1 also gives you the additional benefit of increased read performance as data can be read off any of the drives in......

Words: 1073 - Pages: 5

Disk Redundancy Research

...use RAID? RAID is used as enhanced storage space, storing the same data in different places. Thus redundancy. 2 3. Define the types of RAID’s? a) RAID 0: This technique uses the Striping technique but has no redundancy. It has no fault tolerance. It offers very good performance though. Good for a backup. RAID 0 can be on home computers.2,3 b) RAID 1: This RAID uses Disk Mirroring. It also uses 2 drives that duplicate the storage of data. There’s no striping. The read performance has been improved since either disk can be read. RAID 1 gives the best performance and fault tolerance. It can be on home computers. 2,3 c) RAID 5: This RAID stores Parity information, but not redundant data. It has a rotating Parity Array, addressing the write limitation in RAID 4. It uses 3 sometimes 5 disks for the array. This RAID is best used for multi-user systems in which performance is not critical. Parity is used to protect the data, so if one hard drive dies, the information that was on that particular drive will be on at least another drive.2,3 d) RAID 6: This RAID is similar to RAID 5, but includes a second Parity Scheme that’s distributed across different drives giving high fault and drive failure tolerance.3 4. Why is RAID 0 of any use if it offers no redundancy? RAID 0 works something like a RAID 5 but only without parity. The data is evenly striped across 2 or more disks. It has good speed and a lot of data storage, which is a plus. But if that drive should fail, better......

Words: 746 - Pages: 3

Disk Redundancy Research

...Independent Disks. 2. When would you use RAID? Having data on multiple disks helps ensure against data loss in case of a drive failure. If one of the drives fails most levels of RAID allow the user to just replace that one drive while not losing any data. Having multiple drives also allows multiple read and write operations to be going on at the same time, which increases performance. 3. Define the following types of RAID: a. RAID 0 Using two or more disks, RAID 0 utilizes a striped disk array with data broken down and written part to each disk. This increases performance since multiple input / output operations can be carried out at the same time. RAID 0, unlike the other levels of RAID, does not provide any protection against data loss. If one drive goes down, all of the data will be corrupted. b. RAID 1 RAID 1 requires two or more disks to operate, it organizes data into mirrored pairs. When data is written to one of the drives in a mirrored pair, it is automatically written to both drives. That way if one of the two drives fails the user just needs to replace that one drive. It also provides an increase in performance since two read operations can be performed at the same time. Only one write can be performed at a time since the data must be written to both drives. UNIT 2 ASSIGNMENT 1 3 c. RAID 5 Three disks are needed to implement RAID 5, which uses a rotating parity array to store data striped across all available disks. This......

Words: 855 - Pages: 4

Data Redundancy

...Why or why not? Data redundancy is a situation that occurs within database systems and involves the unintentional creation of duplicated data that is not necessary to the function of the database. While redundancy is often a desirable trait in some situations, this is not true when it comes to the function of a database. The presence of duplicated data can often have an adverse effect on the function of the system, resulting in returning information in response to system queries that is less than helpful. One of the key functions of data management identification of duplicated data and the removal of those duplications (Tatum, 2015). The potential for data redundancy is found in just about any type of database program. Programs that are considered flat, such as spreadsheets, and rely on manual entry of data are particularly susceptible to the duplication of information that may lead to complications when it comes to retrieving the information desired. Relational style databases, such as sales contact databases, often include processes that help to minimize the chances for unintentional duplication, such as the creation of two different contact files on the same contact associated with the same company. Even with the use of system checks to help reduce the incidence of data redundancy, there is still the potential for issues to occur, making it necessary to periodically engage in the task of data cleanup within a database (Tatum, 2015). At best, data redundancy means that......

Words: 409 - Pages: 2

Unit 2 Disk Redundancy

...Unit 2. Assignment 1. Disk Redundancy Research 1. What does RAID stand for? Raid stands for Redundant Array of Independent Disks 2. When would we use RAID? You would use RAID to combine multiple hard drives. 3. Define the following types of RAID: a. RAID 0 RAID 0 increases performance and splits data evenly between 2 drives b. RAID 1 RAID 1 mirrors both drives. c. RAID 5 RAID 5 uses 3 drives and uses striping to divide across all drives with additional parity data divided across all disks. d. RAID 6 RAID 6 is similar to RAID 5 but adds an additional parity block to each drive writing 2 parity blocks for each bit of data striped across the disks. 4. Why is RAID 0 of any use if it offers no redundancy? Because it splits the data evenly among the 2 hard drives 5. Why do you think that RAID 1 can be the most expensive? Why would people utilize it if it’s so costly? Because you will run out of space faster but you will always have a copy of your data if 1 of the drives ever fails. 6. If you, as a home computer user, were to purchase a form of RAID, which would you choose and why? I think I would try RAID 10 since it has the ability to use the advantages of RAID 1 and 0 I will have the mirroring on my secondary disks and no redundancy. 7. What is the difference between software RAID and hardware RAID? Hardware has a specially built controller to that handles the drives and costs more and the software has no specialized hardware is needed....

Words: 281 - Pages: 2

Disk Redundancy

...Assignment 1. Disk Redundancy Research 1. RAID is Redundant Array of Inexpensive Drives is a method for creating a faster or safer single logical hard disk drive from two or more physical drives. RAID arrays have been common for years on servers using SCSI-interface drives. However, a number of recent systems feature ATA RAID or SATA RAID host adapters on the motherboard. 2. When would we use RAID? RAID is best used when to increase the performance and or reliability of data storage 3. Types of RAID definitions? a. RAID Level 0 (RAID 0)—Two drives are treated as a single drive, with both drives used to simultaneously store different portions of the same file. This method of data storage is called striping. Striping boosts performance, but if either drive fails, all data is lost. Don’t use striping for data drives. b. RAID Level 1 (RAID 1)—Two drives are treated as mirrors of each other; changes to the contents of one drive are immediately reflected on the other drive. This method of data storage is called mirroring. Mirroring provides a built-in backup method and provides faster read performance than a single drive. Suitable for use with program and data drives. c. RAID Level 0+1 (RAID 10)—Four drives combine striping plus mirroring for extra speed plus better reliability. Suitable for use with program and data drives. d. RAID Level 5 (RAID 5)—Three or more drives are treated as a logical array, and parity information (used to recover data in......

Words: 557 - Pages: 3

Redundancy

...FAO: Operations Manager Proposed Redundancies A redundancy situation has arisen within the organisation due to a downturn in the volume of business. We anticipate that this will include 5 employee's from within your team. The following will assist you in the redundancy process: Legal Requirements We need to ensure compliance with the following legal requirements. If we do not there is a possibility of an employee applying to an employment tribunal for a protective award. Consultation – You will need to carry out meaningful individual consultations with all affected employees over a 15 day consultation period. This includes two meetings in which you will discuss reasons for redundancy, the number of employees affected, how they will be selected and how redundancy payments will be calculated. The purpose of redundancy consultation is to allow employees and managers to share problems and to examine the options. This results in them working better together in the redundancy process and reduces uncertainty. Legally we do not have to perform collective consultation as under 20 redundancies are to take place. Fairly select employees – Employees need to be selected fairly for redundancy. According to Acas, 'The Criteria must be consistently applied and be objective, fair and consistent'. This can be achieved by using our criteria matrix which is based upon skills, work standard, attendance and disciplinary records. You will need to score employees on all of......

Words: 977 - Pages: 4

Redundancy

...What is redundancy? Redundancy is not defined in the Employment Relations Act 2000 (“ERA”) but the commonly accepted definition today is that from the Labour Relations Act 1987. Section 184(5) of the Act defined redundancy as: … a situation where…[a] worker’s employment is terminated by the employer, the termination being attributable, wholly or mainly, to the fact that the position filled by that worker is, or will become, superfluous to the needs of the employer… The emphasis in the definition, and in the case law since redundancy has been a feature of New Zealand’s employment law jurisprudence, is on the position rather than the worker who occupies the position. The common law accepts the right of the employer to determine the structure of the business and, therefore, to make positions redundant subject to any redundancies being genuine and carried out in a fair and reasonable manner (G N Hale and Son Ltd v Wellington Caretakers etc IUOW) [1]. The ERA has overlaid this management prerogative with a statutory obligation to act in good faith, including specifically in relation to consultation over changes to the business (section 4(4)(c)), any proposal to contract out or sell or transfer all or part of the business (section 4(4)(d)) and making employees redundant (section 4(4)(e)). Acting in good faith means, amongst other things, where the employer is proposing to make a decision that could mean an employee’s employment is terminated, giving relevant employees......

Words: 2610 - Pages: 11