Database Performance Tuning

1067 Words3 Pages
bulb-icon

Recommended: Research paper on normalization in dbms

Database Performance Tuning - Techniques and Consideration

Introduction

System performance is one of the most critical issues faced by companies dealing with vast amounts of data. Companies use database systems and their applications to store, retrieve and handle this data.

Almost all commercial database systems available today are designed to provide a high level of performance to its users. Nonetheless, Database Performance Tuning for large volumes of data is an arduous task. Even minor changes can bring about a substantial impact (positive or negative) on the performance of the system (KOCH, 2014).

This white paper identifies some of the considerations and techniques which can significantly improve the performance of the systems handling large amounts of data.

Literature Review

There are a lot of causes that degrade the performance of a database system. Some of the most common causes can be one or a combination of the following issues:

1. Hardware Problems: These might include limited amount of available disk space on the server or clients, older client operating systems, slow processing speed of client or server, detected and undetected viruses on a client or server machine, network issues, excessive network traffic, network bottlenecks, or database traffic. (Troubleshooting Guide: Known causes of slow database performance, 2014).

2. Poor Database Application Design: A poor database design can lead to severe performance issues. An application which uses large tables (e.g. table with 100000 rows and 100 columns), ill-formed and un-optimized queries, improper use of database connections and so on.

The database application design can be improved in a number of ways as described below:

a. Normalize Database De...

... middle of paper ...

...Five Simple Database Design Performance Tips. Retrieved from Experienced DB2 Consulting and Training: http://davebeulke.com/big-data-five-simple-database-design-performance-tips/

2. Bhandari, S. (2014, April 11). Reasons for Slow Database Performance. Retrieved from DZone: http://java.dzone.com/articles/reasons-slow-database

3. Dilman, M., Hu, W., Loaiza, J., & Jernigan, K. (2014, April 11). Guide for Developing High-Performance. Retrieved from An Oracle White Paper: http://www.oracle.com/technetwork/database/performance/perf-guide-wp-final-133229.pdf

4. KOCH, R. (2014, April 11). SQL Database Tuning for Developers. Retrieved from toptal: http://www.toptal.com/sql/sql-database-tuning-for-developers

5. Troubleshooting Guide: Known causes of slow database performance. (2014, April 11). Retrieved from IBM: http://www-01.ibm.com/support/docview.wss?uid=swg21174563

Show More
Related

  • Nt1330 Unit 3 Data Analytics

    738 Words  | 2 Pages

    The next project deliverable is a robust, modernized database and data warehouse design. The company collects large amounts of website data and uses this data to analyze it for the company’s customers. This document will provide an overview of the new data warehouse along with the type of database design that has been selected for the data warehouse. Included in the appendix of this document is a graphical depiction of the logical design of the

    Read More

  • psychology 101

    1038 Words  | 3 Pages

    things that are affect poor performance or when something is not working properly. The same diagnosis

    Read More

  • An Analysis Of The Strengths And Weaknesses Of The Big Six Database Servers

    1711 Words  | 4 Pages

    In 1991 I performed a thorough evaluation and comparison of the four major DBMSs at the time: Informix, Ingres, Oracle, and Sybase. This comparison was done for a client building a huge distributed database application, currently in its second phase of d evelopment, with the first phase running successfully country-wide. At that stage, the distinguishing criteria were query optimizers, triggers, views, and support for distributed databases. Some products had these features, but some others' marketing per sonnel were just talking about them. For example, declarative integrity was a "future" that was at that stage only being phased into most of the DBMS products. It was relatively straightforward to draw up a checklist and fill it in with "yes" and "no" in the various columns.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.

    Read More

  • Financial Analysis of Oracle Corp

    2599 Words  | 6 Pages

    In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.

    Read More

  • Google File Systems (GFS) and Big Data Technologies (Non-Relational Databases)

    695 Words  | 2 Pages

    The system should be able to support large streaming reads and also support for concurrent large appends to the same file.

    Read More

  • Privacy and Security Issues in Data Mining

    1885 Words  | 4 Pages

    [7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.

    Read More

  • Difference Between Paralell and Cloud Databases

    1154 Words  | 3 Pages

    There are several differences between cloud and parallel database which include load sharing, joins, query optimization, route scheduling and resource optimization.

    Read More

  • Computer Performance Monitoring

    1641 Words  | 4 Pages

    Regular performance monitoring ensures that administrators always have up-to-date information about how their servers are operating. When administrators have performance data for their systems that cover several activities and loads, they can define a range of measurements that represent normal performance levels under typical operating conditions for each server. This baseline provides a reference point that makes it easier to spot problems when, or before they occur. In addition, when troubleshooting system problems, performance data gives information about the behavior of the various system resources at the time the problem occurs.

    Read More

  • Data Input, Output, Storage And Access Methods

    1240 Words  | 3 Pages

    Data Input, Output, Storage and Access Methods. The purpose of this paper is to highlight some best practices for data input and output. In addition, this paper will highlight appropriate uses of various storage means. Lastly, it will address the effect certain components of a computer have on its overall speed.

    Read More

  • Exascale Computer Case Study

    2952 Words  | 6 Pages

    As we all know that Exascale computers runs million processors which generates data at a rate of terabytes per second. It is impossible to store data generated at such a rate. Methods like dynamic reduction of data by summarization, subset selection, and more sophisticated dynamic pattern identification methods will be necessary to reduce the volume of data. And also the reduced volume needs to be stored at the same rate which it is generated in order to proceed without interruption. This requirement will present new challenges for the movement of data from one super computer to the local and remote storage systems. Data distribution have to be integrated into the data generation phase. This issue of large scale data movement will become more acute as very large datasets and subsets are shared by large scientific communities, this situation requires a large amount of data to be replicated or moved from production to the analysis machines which are sometimes in wide area. While network technology is greatly improved with the introduction of optical connectivity the transmission of large volumes of data will encounter transient failure and automatic recovery tools will be necessary. Another fundamental requirement is the automatic allocation, use and release of storage space. Replicated data cannot be left

    Read More

  • Essay on Mathematics - The True Universal Language

    554 Words  | 2 Pages

    My past projects centered around analyzing, formulating and delivering solutions in every stage of providing Microsoft-format software for major Fortune500 companies.  I have also designed a database system (implemented in SQL Server) and developed front end applications in Visual C++ and Visual Basic that used ODBC and DAO to access the server.  This work piqued my interest in doing research in the field of database systems, and I started to think more analytically about the limitations of relational databases.  I became interested in object-oriented databases, particularly their flexibility and their ability to meet the requirements of more complex structures.   In my graduate studies, I plan to focus my research on optimizing queries and improving the performance of complex systems such as image, engineering, or scientific database systems.

    Read More

  • Database

    761 Words  | 2 Pages

    Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.

    Read More

  • Case Study on Google

    1113 Words  | 3 Pages

    It simplifies the storage and processing of large amounts of data, eases the deployment and operation of large-scale global products and services, and automates much of the administration of large-scale clusters of computers.

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.

    Read More

More about Database Performance Tuning

Open Document