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

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

Redundancy in Databases

...| Week 4 Assignment 4Kristi OrdIntroduction to Database Management SystemsProfessor Cheryl MayberryJuly 24, 2012 | | | | | | A simple database is often a lot better for managing your data than a flat file system such as Microsoft Excel or Works. Microsoft Access is the ideal solution for most small to medium businesses to manage their data. Beyond Access there is Microsoft SQL Server for larger enterprise data applications. There are many advantages of using a database management system. A user interface can be designed with built in reports and queries to make use of the system more intuitive and easier to learn. The data is available to multiple users simultaneously for adding, editing and updating. Databases are a lot more efficient when dealing with large amounts of data particularly if the data is relational. Data quality and integrity can be maintained through constraints and relationships reducing errors and duplication. Your data is highly available and can easily be queried and analyzed to gain better understanding of your business and customers. Access will export tables and queries to a multitude of formats should you want to work with your data in Excel or similar. ODBC databases such as Access are easier to integrate and link in with other data systems to allow cross system reporting and querying. Access databases can be scaled fairly easily to larger database solutions such as Microsoft SQL server if your data needs grow. The flat file...

Words: 562 - Pages: 3

Disk Redundancy Research

...NT1230 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......

Words: 352 - Pages: 2

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...

Words: 736 - Pages: 3

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

...1. What does RAID stand for? Redundant Array of Independent Disks. Source: Steadfast.com 2. When would use RAID? When experiencing disk IO issues, where applications are waiting on the disk to perform tasks. It also provides additional 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...

Words: 1073 - Pages: 5

Disk Redundancy Research

...Disk Redundancy Research The term RAID stands for Redundant Array of Independent Disks. RAID is used for storage in the operating system. As the levels of RAID get higher the disk, split and mirror the information and store it in the operating system. • RAID 0- RAID 0 provides no redundancy, on the other hand you this type of RAID allows you to improve your performance by using multiple disks. With RAID 0 your computers data writes the information onto a hard disk and splits it across two or more hard drives evenly. • RAID 1- With RAID 1 two disks are configured to mirror each other. With this should something happen to one disk you will have that mirrored up-to-date copy • RAID 5- RAID 5 takes three disks to be used. This type of RAID uses what is called stripping to divide the data across all the hard drives, with this process it also has an additional parity data divided across all disks. With this process if one of the hard drives fails the user will not lose any of their data. • RAID 6-This type of RAID is very similar to RAID 5 but offers a parity block, with two parity block for each bit of data stripped across the disk. With RAID 6 you have less storage space than RAID 5 but that is only because RAID 6 offers users with additional protection from data loss. 4. RAID 0 is still of great use because it still improves the performance of your operating system. This can be used by people who are big into gaming. 5. I think that RAID 1 would be the most expensive...

Words: 437 - Pages: 2

Disk Redundancy Research

...1. RAID – redundant array of independent disks; originally redundant array of inexpensive disks. 2. You can use RAID for improved fault tolerance on all of the server hard drives. 3. A. RAID 0 - This technique has striping but no redundancy of data. It offers the best performance but no fault-tolerance. B. RAID 1 - This type is also known as disk mirroring and consists of at least two drives that duplicate the storage of data. There is no striping. Read performance is improved since either disk can be read at the same time. Write performance is the same as for single disk storage. RAID-1 provides the best performance and the best fault-tolerance in a multi-user system. C. RAID 5 - stores parity information but not redundant data (but parity information can be used to reconstruct data). RAID-5 requires at least three and usually five disks for the array. It's best for multi-user systems in which performance is not critical or which do few write operations. D. RAID 6 - This type is similar to RAID-5 but includes a second parity scheme that is distributed across different drives and thus offers extremely high fault- and drive-failure tolerance. 4. RAID 0 – Fast performance without providing fault-tolerance 5. RAID 1 - can be expensive because it requires at least two drives in order to duplicate the storage. People utilize it because of 100% redundancy guaranteeing no lost data 6. It really depends on the reason I would need RAID. If I ran a business...

Words: 386 - Pages: 2

Disk Redundancy Research

...1. What does RAID stand for? RAID stands for Redundant Array of Inexpensive Drives. That is the original term. The latest is Redundant Array of Independent Disks. 1 2. When would we 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...

Words: 746 - Pages: 3

Disk Redundancy Research

... 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 allows multiple read and write operations to occur at the same time. This makes for a very fast read operation, and a moderately fast write operation. There is still protection in case of disk failure, but it isn’t done through redundancy. Data can be rebuilt from parity information stored on all of the disks. d. RAID 6 This is building on the features of RAID 5, with an additional parity scheme saved to the disks to allow for increased protection against data loss. Requiring at least four disks to operate, this offers protection against double disk failure. 4. Why is RAID 0 of any use if it offers no redundancy? Even though RAID 0 offers no redundancy and thus no protection against data loss, it provides a performance boost with multiple read and write operations carried out simultaneously. 5. Why do you think RAID 1 can be the most expensive? Why would people utilize it if it’s so costly? RAID 1 would cost the most because you have to purchase double the number of disks to get the same amount of space. For example if you want a 500 TB drive and want to use RAID 1, you would have to purchase two 500 TB drives. People still choose to use this because of the 100% redundancy protection against data loss and it is the simplest of RAID levels to implement. UNIT 2...

Words: 855 - Pages: 4

Disk Redundancy Research

...Unit 2 Problem Set 1. Unit 2 Problems Knowledge Assessment Knowledge Assessment 1. By default, Windows 7 standard users are permitted to install Plug and Play devices only if their drivers are Digitally Signed. 2. The debilitating condition in which files are stored as clusters scattered all over a disk is called. Fragmentation. 3. The file system included in Windows 7 that is specifically designed for use on flash drives is called exFAT32. 4. Technically speaking, you create partitions on basic disks and volumes on dynamic disks. 5. In Windows 7, the FAT32 file system is limited to volumes no larger than 32 gigabytes. 6. The digital signature of a driver consists of a Checksum that is appended to the driver itself before publication. 7. To create a fourth primary partition on a basic disk, you must use the Disk Management utility. 8. To extend or shrink a partition on a basic disk, you must be a member of the Backup Operator or Administrators group. 9. The default partition style used by Windows 7 on an x86 computer is MBR. 10. All digitally signed drivers have undergone Windows Hardware Quality Labs (WHQL) testing. True / False Circle T if the statement is true or F if the statement is false. T F 1. There is no way to create a fourth primary partition on a basic disk in Windows 7. T F 2. Striped volumes provide greater fault tolerance than simple volumes. T F 3. All dynamic disks have only one partition on them. T F 4. By......

Words: 380 - 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

...Date: 09-22-2015 Course: NT 1230 (Clients – Server Networking-1) Unit 2. 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...

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