Understanding and overcoming Database Design conflicts - Research Paper Example

?RESEARCH PROJECT: UNDERSTANDING AND OVERCOMING DATABASE DESIGN CONFLICTS Research Project Understanding and overcoming Database Design conflicts Author Author Affiliation Date Table of Contents Introduction 3 Database Design Background 3 Technical Description 4 Need of Accuracy for Database Design 4 Database Design Goals 5 Assessing Purpose of Database 5 Three Main Conflicts 6 Uniqueness Conflict 6 Delete Conflicts 6 Update Conflicts 7 Comparisons 7 Problems due to Poor Database Design 7 Parameters of Effective Database Design 8 Recommendations 9 Conflict Resolution 9 Mitigating of Conflicts 9 Recognizing our Data and System Needs 9 Avoiding Conflicts 10 Primary Site and Dynamic Site Ownership Data Models 11 Avoiding Uniqueness Conflicts 11 Avoiding Delete Conflicts 11 Avoiding Update Conflicts 12 Avoiding Ordering Conflicts 12 Conclusion 12 References 13 Introduction People think database design is a simple topic, but in actual fact it is a very complicated subject. In view of the fact that a correctly planned database arrangement is a design of a company, or a number of "things" in the actual world. Thus, similar to their physical model equivalents, data models facilitate them to obtain responses concerning the information that structure the objects being formed. In addition, queries that require answers decide that which details require being stored competently in the data model. In a relational database data is stored in different tables in place of placing all data in one large table. Moreover, in the relational model, data is typically arranged in tables that encompass the attributes that each record has the similar number of information; each field holds the similar type of particulars in every record; there is simply single entry for every fact; two records cannot hold the similar data; the sequence of the records as well as fields is not significant (Betz, 1999), (Gilfillan, 2002) and (TOPBits, 2010). In fulfilling database design objectives we can face a lot of conflicts and issues. The basic aim of this paper is to assess these conflicts and issues and afterward suggest several mitigation policies for such issues. This research will mainly analyze three types of goals which can be conflicting to one another and impossible for all companies to solve all three. Database Design Background An accurately designed database offers the users means of access to the latest, correct data and information. For the reason that an accurate design is necessary in attaining an organization’s objectives in functioning with a database, spending the time necessary to proficiently discover the standards of high-quality design seems sensible. Finally, we are a great deal more promising to finish up with a database that convenes our requirements as well as is able to simply hold changes or modifications in data. Moreover, in database design process, system developers judge a lot of issues all through the design stage, for instance, how to produce an user-friendly interface, how to effectively normalize the data, and various other issues. However, without an uncertainty, one of the database developer's most significant objectives is to assure the correctness of the data (Microsoft Corporation., 2011), (Cgarvey, 2003) and (Hoffer, Prescott, & McFadden, 2007). Technical Description Need of Accuracy for Database Design Correct design is vital to the functions of a dependable and well-organized information structure of a business. At the present the technology of microcomputer is so sophisticated that the influence of a meager design can not humiliate as early as in the past; though, while the issues come into view they could be rather harsh. The blueprint of a database has to perform by means of the technique data is stored as well as how that data is connected. In addition, the design procedure is carried out besides user decides precisely what information should be stored as well as how it should be taken back. Moreover, the more cautiously we design, the improved the physical database convenes users' requirements. In the whole procedure of designing a system, a designer needs to recognize user requirements from a range of perspectives (Betz, 1999). Database Design Goals A number of standards outline the process of database design and development. The initial standard is that duplicate information (it is also recognized as unneeded data) is appalling, since it wastes space as well as raises the probability of mistakes and contradictions. In this scenario, the next goal or rule is that the completeness and accuracy of data and information is significant. If a database holds wrong data and information, the reports that get information from that database will as well present wrong data and information. Thus, decisions that will be taken on the basis of those reports will also be wrong (Microsoft Corporation., 2011). Assessing Purpose of Database In order to resolve potential issues and conflicts in a database system, it is necessary to determine the purpose of the database. It is an excellent idea to record the principle of the database; its functions, how database will be used, as well as who will utilize it. For a small arrangement of database intended for a small company or business, for instance, we may note down something easy similar to "the client database holds a directory of clients information intended for the function of generating mailings as well as various types of reports." If the database system is more complicated or is employed by a lot of people, as frequently happen in a business arrangement, the idea could simply be a part otherwise more should comprise when as well as how every individual will utilize the arrangement of database. The plan is to have a fine developed task statement that could be passed on to all through the design procedure. In this scenario, including such a statement will facilitate the users to pay attention on their objectives when they develop judgments or decisions (Microsoft Corporation., 2011). Three Main Conflicts There are three categories of database design conflicts that we can come across in a logical database setting. These conflicts can be uniqueness, update and delete conflicts. However, Oracle Corporation says that its database system design facilitates to keep away from these kinds of conflicts. I have presented below these three main conflicts: (Oracle Corporation. , 1999) Uniqueness Conflict A uniqueness conflict happens when the duplication of a row tries to disobey entity integrity, like that PRIMARY KEY or else UNIQUE restraint. For instance, we can imagine that what can occur when two database operations or transactions are initiated from two dissimilar places and every place inserting a row into an individual table model by means of the similar primary key value. In this scenario, replication of the database operations or transactions gives birth to uniqueness conflict (Oracle Corporation. , 1999) . Delete Conflicts A delete conflict happens when two database operations or transactions are created from diverse places, by means of one operation removing a row and one more operation updating or else deleting the similar database row, for the reason that in this scenario the row does not be seem to be moreover deleted or updated (Oracle Corporation. , 1999). Update Conflicts An update conflict happens when the duplication of an update to a database row clashes with an additional update to the similar row. This type of Update conflicts is able to occur when two operations or transactions are initiated from dissimilar places, update the similar row at almost the similar moment (Oracle Corporation. , 1999). Comparisons Problems due to Poor Database Design In case of existence of above listed conflicts we can face some of the possible issues those are listed below: (Microsoft Corporation., 2011), (Davidson, 2007) and (Oracle Corporation. , 1999) A lot of unexpected problems can come into view themselves as an effect of poor database design The database designed on wrong design cannot work correctly Data in the database can be inaccurate or unreliable The performance of completed database can be ruined. Database system flexibility can be vanished. Date stored in the database could be dirty or spoiled Poor database will offer poor reporting for business Ineffective decisions will be made on basis of poor reporting Database can take more space Long query response time Conflicts among transactions Danger of losing transactions Less effective decision support in case of poor quality of data Less effective business support Missing and unreliable information Parameters of Effective Database Design In order to design better database system developers need to take care of some of the prime issues regarding database design. Below are some factors those need to be assessed in order to formulate an effective database design: (Microsoft Corporation., 2011) and (Oracle Corporation. , 1999) Initially we need to split our data along with information into topic-based tables to decrease surplus data Then we need to offer Access by means of the information it needs to link the data plus information in the tables jointly as desirable. After that we need to assist, support as well as make sure the correctness and reliability of our information that we are going to store in database. The main factor is about holding our data processing as well as reporting requirements. Recommendations Conflict Resolution Database issues like duplication conflicts can happen in a duplication situation that allows simultaneous revisions to the similar data at numerous places. For instance, when two database operations or transactions initiating from diverse places update the similar row at almost the similar moment, a conflict could take place. However, when we organize a duplication situation, we have to think whether duplication conflicts are able to take place. If our system design authorizes duplication conflicts as well as a conflict takes place, the system data does not meet in anticipation of the conflict is determined in a number of techniques. In broad-spectrum, our primary option should for all time be to plan or design a replicated setting that reduces the likelihood of conflicts. In this scenario, a lot of methods and tools are available that can be used to avoid conflicts in the entire or a huge proportion of the data that is simulated. Though, a lot of applications need that a number of proportions of data be updateable at numerous places at several times. So if this is the scenario, we have to tackle the likelihood of duplication conflicts (Oracle Corporation. , 1999). Mitigating of Conflicts Recognizing our Data and System Needs The moment we design some kind of database application and its sustaining database, it is important that we recognize the needs of the application previous to we start to construct the database or the system itself. For instance, every application ought to be section-wise, by means of noticeably described functional limits as well as needs (like that shipping, order-entry, invoicing, and various others). Moreover, we should normalize database data to decrease the quantity of hidden dependencies among units in the intended application structure (Oracle Corporation. , 1999). For the fundamental database design development, there are extra necessities that we have to examine when creating a database that perform functions in a replication circumstances. In this scenario, we should begin thinking about the wide-ranging necessities of the applications that will operate through the duplicated data. For instance, a number of database applications might work in a proper way with read-only characteristics, and as an effect, are able to keep away from the likelihood of replication conflicts in general. Other applications may need that the majority of the replicated data is read-only as well as a little portions of the data (for instance, one or two tables or yet one or two columns in a particular table) be renewable or updateable at the entire duplication places. In this scenario, we have to decide how to resolve replication clashes as they happen thus the reliability of replicated data turns out to be intact (Oracle Corporation. , 1999), (Schwartz, 1997) and (BludeClaw Database Design, 2010). Avoiding Conflicts Although Oracle offers dominant techniques for providing data conflicts solutions, however, one of the uppermost preferences when developing and designing a replicated database, should be to keep away from data conflicts (Oracle Corporation. , 1999) and (Microsoft Corporation., 2011). Primary Site and Dynamic Site Ownership Data Models One method that we can employ to avoid the likelihood of replication conflicts is to restrict the amount of places in the system by means of concurrent update right to the replicated data. In this scenario, two replicated database data rights paradigms uphold this technique: are dynamic site ownership and primary site ownership (Oracle Corporation. , 1999) and (Microsoft Corporation., 2011). Avoiding Uniqueness Conflicts It is fairly simple to arrange a replication setting to stop the likelihood of uniqueness conflicts. For instance, we are able to produce successions at every place so that every succession at every place produces a commonly restricted group of succession numbers. This solution, though, can turn out to be challenging since the amount of places augment or the amount of entries in the duplicated table increases (Oracle Corporation. , 1999) and (Microsoft Corporation., 2011). Avoiding Delete Conflicts In case of database system the delete conflicts ought to forever be evaded in all replicated data circumstances. Generally, applications that are used inside a shared and asynchronous ownership data paradigm should not erase rows by means of DELETE commands. In its place, applications should signify rows intended for removal and after that organize the system to now and again clean reasonably removed rows by means of technical replication (Oracle Corporation. , 1999) and (Microsoft Corporation., 2011). Avoiding Update Conflicts After attempting to remove the likelihood of uniqueness and delete conflicts in a duplication system, we should as well attempt to restrict the amount of update conflicts that are likely to occur. Though, in a shared ownership data paradigm, update conflicts could not be taken out in all the situations. On the other hand, if we are not able to avoid the update conflicts, we have to recognize accurately what kind of replication conflicts are probable as well as afterward make up the system to determine conflicts as they happen (Oracle Corporation. , 1999) and (Microsoft Corporation., 2011). Avoiding Ordering Conflicts It is most excellent practice to keep away from or routinely determine ordering conflicts. For instance, we should choose conflict decision techniques that make sure union in multi-master designs wherever ordering conflicts are likely to take place (Oracle Corporation. , 1999) and (Microsoft Corporation., 2011). Conclusion This paper has presented comprehensive analysis of three types of goals which can be conflicting to one another. After that I have discussed the conflicts those can come out from these goals. I have also discussed some of the main types of database design conflicts those can make the database extremely problematic. In the last I have presented the mitigation framework for these conflicts. I hope this research will offer a better insight of the database conflicts. References Betz, J. (1999, February 14). Introduction to Database Design. Retrieved February 15, 2011, from Information Technology Website: http://www.schools.ash.org.au/olshc/infotech/dbdesign.htm BludeClaw Database Design. (2010). Databae Replication in MS Access. Retrieved February 11, 2011, from http://www.blueclaw-db.com/broad_interest/database-replication.htm Cgarvey. (2003, May 19). Ensure data integrity with proper database design. Retrieved February 12, 2011, from TechRepublic.com: http://www.techrepublic.com/article/ensure-data-integrity-with-proper-database-design/5034793 Davidson, L. (2007, February 26). Ten Common Database Design Mistakes. Retrieved February 14, 2011, from Simple-Talk.com: http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/ Gilfillan, I. (2002, June 24). Introduction to Relational Databases. Retrieved February 14, 2011, from Database Journal: http://www.databasejournal.com/sqletc/article.php/1469521/Introduction-to-Relational-Databases.htm Hoffer, J. A., Prescott, M. B., & McFadden, F. R. (2007). Modern Database Management, Eighth Edition. Pearson Education, Inc. Microsoft Corporation. (2011). Database design basics. Retrieved February 13, 2011, from http://office.microsoft.com/en-us/access-help/database-design-basics-HA001224247.aspx Oracle Corporation. . (1999). Conflict Resolution Concepts & Architecture. Retrieved February 11, 2011, from http://www.cs.bris.ac.uk/maintain/OracleDocs/server.816/a76959/conflict.htm Schwartz, D. (1997). Database support for conflict detection in a computer-supported cooperative work environment. Database Engineering and Applications Symposium, 1997. IDEAS '97. Proceedings. (pp. 240-249). Montreal, Que., Canada: IEEE. TOPBits. (2010). Relational Database. Retrieved February 13, 2011, from http://www.tech-faq.com/relational-database.html Read More