Contact Us
Sign In / Sign Up for FREE
Go to advanced search...

Research Report outlining the general database techniques - Essay Example

Comments (0) Cite this document
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 paper File format: .doc, available for editing
GRAB THE BEST PAPER92.9% of users find it useful
Research Report outlining the general database techniques
Read Text Preview

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 pages Read More
Cite this document
  • APA
  • MLA
(“Research Report outlining the general database techniques Essay”, n.d.)
Retrieved from
(Research Report Outlining the General Database Techniques Essay)
“Research Report Outlining the General Database Techniques Essay”, n.d.
  • 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


12 Pages (3000 words) Essay

Management of Software Projects -2

12 Pages (3000 words) Essay

The European Central Bank

5 Pages (1250 words) Essay

The Los Angeles Art Scene

7 Pages (1750 words) Assignment

Methodological Approach in a Quantitative Research

... data more patients have to be interviewed for gathering reliable data. The objective is to find out the impact of occupational therapy on self-management and status of people. Issues concerning sampling techniques: Since this is a quantitative technique sampling is very much essential for conducting the research. The major issue here is to select the best sample. “Surveys are the primary method of quantitative researchresearch with some claim to statistical accuracy.” (Quantitative research 1996- 2004). There is no clear-cut rule in order to select the best sample for the research. Determination of the sample size is also another issue in front of the researcher. The sample size that can give best result is upon the discretion...
9 Pages (2250 words) Report

Provisions for Gas, Electricity, and Water Markets

The traditional regulation relied on the static concept of competition in which the perfectly competitive markets are in equilibrium and, when that equilibrium is disturbed, move to equilibrium. This traditional approach has been eschewed in most of the British privatised utilities. However, it has a crucial problem. It requires the would-be regulator to identify the outcome of a perfectly competitive market which is impossible therefore the approach has no firm anchor and leads on to arbitrary regulation (on opinions).

At the time of privatisation, the traditional approach was already in some disrepute and the founding fathers of British regulation were searching for another anchor and, in particular, a means of regul...
9 Pages (2250 words) Report

Investment Appraisal and Management Control

... it as a decision making tool (Bott, 2008). Companies mainly invest, with the assumption that the investment will yield future income streams. Thus investment appraisal is assessing these income streams against the cost of investing (Ware, 1992). Management need to be extremely careful whilst making the decision since all investments that are made have an affect on the revenue of the company, hence management have to be very careful since these investments are generally very large and not easily reversible. 2. Types of Investment Appraisal: There are different techniques using which an investment can be financially justified. Methods to generate, review, analyze, select, and implement long-term investment proposals are listed below...
14 Pages (3500 words) Report

Outlining Explicit Learning Objectives and Outcomes for Teachers and Students

Explicit learning is presented by teaching the specific concepts individually and mastery occurs then after. The main key in such a mode of teaching is being highly structured in every activity that is undertaken inside the classroom can be considered as part of the organization of the technique. One of the defining features of the technique is the fact that the teacher commonly points out the part of the lesson where they are in, thus, the term used is explicit teaching (Boyles, 2002).
The explicit form of teaching can be considered to fit lessons that are considered to introduce certain concepts, ideas or skills that are needed to be learned and that the students have low familiarity or experience with. For that matter, the...
10 Pages (2500 words) Report

The Federal-Aid Highway Act of 1956

Neither did this act increase the federal share to be borne of the expenses of the construction nor did it provide special funding for the project. The states had already completed about 6,500 miles of the allocated improvements when President Dwight D. Eisenhower took office in January 1953. For a period two years from 1954 to 1956, the congress had faced failure on several occasions in passing a national highway bill which would provide means to fund the interstate system. The focus was on the issue of how the expenses would be shared between the federal government and the states. Eisenhower having been in the army knew the importance of constructing well-designed roads to national security. In his address delivered in the State...
15 Pages (3750 words) Report

Explaining White-Collar Crime through Sykes and Matzas Neutralization Techniques and Mertons Anomie

Modern criminology indicates that the term is of no limitation by referencing to types of crime, which could be enumerated as a crime by the time of the offense, by the type of offender, and by organizational culture (Cote 2002, p. 202). White-collar crimes are generally not associated with poverty or pathologies relating to it. The legal definition of crime is viewed as the only definition of crime, in which the behavior being examined is punishable by law (Sutherland 1949, p. 84).

Sutherland (1949, p. 84) claims that persons belonging to the upper socioeconomic class are involved in such criminal behavior, which is characterized as different from the criminal behavior in which the lower socioeconomic class engage in p...
11 Pages (2750 words) Report

Organizational Consultant for We Make Widgets, Inc

... We have been asked, in our capa as organizational consultants, to help We Make Widgets, Inc solve some work-life balance problems prevalent among its top leadership. With this end in mind, we study some popular literature to understand the basics of work-life balance. It is followed by the summary of our suggestions to the company. Introduction Work-life balance is variously interpreted by different people. To some, work-life balance is doing a job, where work is a means to support life, while to others it means to be in an employment where stress is kept in manageable limits. Broadly, it means to arrive at a ‘fit’ or have the right combination of professional requirements and other aspects of life including parenting... We have been...
6 Pages (1500 words) Report

Critical Review of General Electric

... vision of technical leadership are services, customer focus, growth platforms and globalization. Each of them are linked ultimately to maintaining the technical leadership that G.E. is widely famous for. The company invests aggressively in research and development to create technical breakthroughs that redefine markets, bring higher margins and bring new products and designs to the consumer. Its obsession with innovation is the fear that todays innovations will become commodities next year that will erode profit margins and wipe out its technological advantages. Its services sector is more on after-sales service in the areas of power generation, locomotion, flight and delivery of medical imaging equipment. The idea is to help...
12 Pages (3000 words) Report
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