Research Report outlining the general database techniques - Essay Example

Comments (0) Cite this document
Summary
General Database Techniques: For Implementing a Large Database General Database Techniques: For Implementing a Large Database What is a database? In their book, Date et al. (2006, p. 11) defined a database as being a “collection of persistent data that is used by the application systems of some given enterprise.” Persistent data is different from other kinds of data because of the fact that when it has been accepted by the Database Management System (DBMS) and entered into the database, a request to the DBMS has to be made explicitly in order to delete it from the database else it cannot be deleted…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.6% of users find it useful
Research Report outlining the general database techniques
Read TextPreview

Extract of sample "Research Report outlining the general database techniques"

Download file to see previous pages 16). When a database is designed, one should make sure that all functions performed by the database are correct and quick. There are some performances issues that arise due to the structure and the design of the database. Hence, it needs to be designed and structured carefully. Large tables in the database need to be identified so that special consideration to these tables can be given in terms of performance. Also the database should be tested by increasing a number of users who access the database in order to check performance. Database performance increases through normalization, database partitioning, using federated database systems and certain hardware considerations such as RAID. Normalization Normalization is a process of removing redundancies of data in a database or in other words it is a technique of producing a set of relations with desirable properties given the data requirements of an enterprise. (Stephens et al., 2008, p. 62). If normalization is not done, then certain anomalies occur which include the insertion anomalies, delete anomalies and update anomalies. Anomalies occur when at one table of a database there has been an occurrence of change either an insertion of a record or deletion of a record or updating the table; however, unaffecting the duplicate records that exist in other tables in relation to that table. The process of normalization is done basically in three steps. The database is brought to its first normal form (1NF). A relation (table, entity) in a database in which the intersection of each row and column contains one and only one value is said to be in 1NF. All relations are supposed to be in 1NF. After 1NF, the relations in a database are brought to the 2NF. A relation that is in its 1NF and all non-primary key fields is fully functionally dependent on the primary key is said to be in 2NF. Then a relation that is in 1NF and 2NF and in which no non-primary key field is transitively dependent on the primary key field is said to be in 3NF. These are the three basic steps that normalize the database. Database Partitioning Through database partitioning, database is broken into small physical units that can be managed independently. In this way, it becomes easier for the designers and operations personnel as the database becomes flexible in data management. Large physical units, on the other hand, cannot be structured, recovered, organized or monitored. Partitioning makes indexing easier and also allows sequential scanning. Through this process, data can be broken up by organization, business unit, region, date and others which help in the desired analysis of data (Connolly and Begg, 2008, p. 119). Through partitioning, the performance of database is enhanced. This is because when database is partitioned, subsets of data are formed. And these subsets can be managed and accessed with efficiency and are useful for analysis. Partitioning also makes the activities of maintenance operations such as defragmentation and index rebuilds. Partitioning mak ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Research Report outlining the general database techniques Essay”, n.d.)
Retrieved from https://studentshare.org/environmental-studies/1422256-research-report-outlining-the-general-database
(Research Report Outlining the General Database Techniques Essay)
https://studentshare.org/environmental-studies/1422256-research-report-outlining-the-general-database.
“Research Report Outlining the General Database Techniques Essay”, n.d. https://studentshare.org/environmental-studies/1422256-research-report-outlining-the-general-database.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Research Report outlining the general database techniques

General Electric Report

...? GENERAL ELECTRIC REPORT Executive Summary The general electric company is one of the highly regarded companies in America and globally. According to the company’s 2011 annual general report, the company had total assets worth $584 billion and a net income of $6.5 billion (Fulton, 2012). The company is considered among the best companies in the world due to products and as well as the profits margins over the recent financial periods. To be specific in this particular case and considering the 2011 rankings, the company attained the sixth position of the best companies in the United States. The General Electric Company also obtained the...
12 Pages(3000 words)Essay

Outlining Policy

...? Running Head: NONDISCRIMINATORY POLICIES Outlining Policy of Introduction The establishment and implementationof good and effective policies is a fundamental need for every public school. There are certain core components of a public school’s structure or operations that must be based on effective and legal procedures and policies not only to ensure work place orderliness but also to create a safe and empowering atmosphere at the work place. In addition, nondiscriminatory practices and policies that would ensure no lawsuits against a public school by the public or its employees and students should be entrenched in such an institution (Ewing et al., 2005). Thus, particularly affected by discrimination lawsuits are...
5 Pages(1250 words)Research Paper

Market Research Techniques & Research Methods

...MARKET RESEARCH TECHNIQUES & RESEARCH METHODS Marriott International (Degree for which this dissertation is being submitted) Submitted in part fulfillment of the Date of Submission 1. Introduction of selected organization: Marriott International Marriott International (Marriott) prides itself for its global operator and franchiser of hotels and related lodging facilities. As of 2005, it has a wide range of lodging properties in the UK and Ireland and internationally, accounting to more than 2,700 lodging properties. Its key business is the lodging business where the company develops, operates, and franchises hotels and corporate housing properties. It has a wide range of...
16 Pages(4000 words)Case Study

Research Techniques

...article titled "Overview of Basic Methods to Collect Information," he discussed different methods that can be used to conduct research on marketing techniques. Carter McNamara in one article "General Guidelines for Conducting Interviews" discussed how to conduct interviews effectively to get valid information about the experiences of the clients on the particular programme and to get the feed back effectively. In another article by Carter McNamara titled "Basics of Conducting Focus Groups" he gave suggestions on how to conduct focus groups effectively and how to get the information from the focus groups and the tips to get the information effectively. an article by "Infospan..Inc" the...
4 Pages(1000 words)Essay

Outlining

...Chapter 4 Socialization I. Socialization: A Significant Human Process The process of the acquisition of knowledge, values, morals and beliefs of an individual from others is called socialization. Socialization is a continuous process because individuals, as they mature still need to learn new things in order to survive (Schaefer, 1995) A. Nurture: The Negative Effect of Isolation Researchers are emphasizing the significance of early socialization experiences for individuals who are reared in more normal environments. It is now accepted that it is not sufficient to address merely the newborn’s physical needs; parents and other concerned individuals should also devote themselves in the children’s social development (ibid)....
10 Pages(2500 words)Essay

IT Database Research

...Your full February 24, Database Security Requirements Physical security involves measures taken to ensure security of workforce, system devices and equipment, resources, documents and sensitive information stored on physical media (like hardware programs and networks) from damaging proceedings like unauthorized access, fire, espionage, burglary, theft, vandalism, accidental loss or intentional crime that could cause severe harm to an activity, organization or establishment. 2. One may want to separate server roles if there is a lot of asynchronous activity going on such as “imports, workflows or plugins” (Microsoft Dynamics), and one wants these activities not to create long backlogs which may hinder with the operation of...
4 Pages(1000 words)Research Paper

Research techniques and approaches

...Research Techniques and Approaches By: METHODOLOGY Research design The study will adopt descriptive survey as a method of collecting information by using a standardized form of interview schedule and administering a questionnaire to a sample of individuals. The study will use both qualitative and quantitative approaches. This will be appropriate variable in collecting and summarizing data that will be used in analyzing data about different perceptions towards trends in fashion. As a result, the qualitative and quantitative research methods will ensure reliability and credibility of the results. Method of data collection Measure: For the purpose of carrying out primary...
1 Pages(250 words)PowerPoint Presentation

Research database -fall incident

...Research Database -Fall Incident affiliation Research Database Assignment Form A brief of the topic of interest Topic: Fall incident The fall incident is a subject, which encompasses the accidental occurrences in hospitals another health centers. The fall incident usually occurs due to failure of the various patients to take utmost good care when walking within the environs of the centers. On the other hand, the authorities can also be ignorant of the conditions of the health centers hence leaving the poor conditions to be the proximate cause for the fall incidents. Title of source: Nursing research: reading, using, and creating evidence Location of...
3 Pages(750 words)Essay

Outlining serves

...Outlining serves Having the outline in place helped me overcome the initial blocks encountered in writing. The outline serves as a brainstorming tool that helped me develop ideas as to what I need to write about. It helped in clarifying thoughts as well. It helped me develop specific arguments backed up by strong arguments. The outlines helped in breaking down the writing into its main ideas with supporting details. The outline helped in the identification of weaknesses in the argument. It helped in realizing where the supporting details to the main idea were insufficient. The outline was of great importance in tracking points that were...
1 Pages(250 words)Coursework

General Stored website report

...to be practiced. This has generally made it really easy to even reach a new wide range of clients that do not have access to PC systems. Electronic commerce has generally made shopping really easy for all. This report is to help measure up and investigate client response to some of the renowned General stores websites analyzing their First Impression, recognition, value proposition and differentiation, (Homepage), Search ability and discoverability of our products, (search engines), Delectability. Product Selection and Comparison, (production information), simple and secure purchase process, (purchase or buying cart) and their Mobile apps. These stores include John...
8 Pages(2000 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Research Report outlining the general database techniques for FREE!

Contact Us