Improving Database Performance{1}


by Eric H
Summary
In this article it began with the author writing about the effect database has on any business that uses computers. The primary function of a database is to provide timely and reliable information that supports the daily operations of an organization, and a important measure of database is the time required to perform the basic operations of retrieval, as organizations are trying to minimize the time spent to retrieve data(Alsultanny, Y. 2010). As the internet grows bigger at a rapid pace, internet applications and other complex and complicated application systems brings a major challenge related to query optimization. As the database size grow, it could potentially slow down query execution dramatically(Alsultanny, Y. 2010).

Compression is used in database when it have grown large enough to create a strain on system storage capacity. A good compression techniques allowed transferring more data for a given bandwidth and efficient storage costs. it also allowed better utilization of bandwidth for data transfer(Alsultanny, Y. 2010). Many databases do not require a lot of updates, but it does need to focus on storage costs and transfer costs.

When there are large amount of relational tables, it requires the system to spend a significant amount of query processing time which cause slow down. One of the way to solve this is to partition relational tables either through vertical or horizontal partitioning.
Horizontal partitioning breaks down a relational table into smaller pieces, and they sort them why range of values of given attribute or combination of attributes and its called a partition key. It reduces the total number of read operations(Alsultanny, Y. 2010). Vertical partitioning splits a relational table into a number of pieces, and replicate a primary key in each partition, it reduces the average length to minimizes the total number of read and write operations.

Reflection
This article relates to our lectures because it talks about primary key, relational tables, and also the performance of a database. The main focus of this article is talking about partitioning, and compression. I feel if these are unitized correctly it can save companies a lot of money in trying to storage and mine big data. And it also benefits the consumers, as database becomes more efficient we can access to files, documents, music, video etc much fastest. I am looking forward t learning more about increasing performance in databases.

Citation

Alsultanny, Y. (2010). Database management and partitioning to improve database processing performance. Journal of Database Marketing & Customer Strategy Management, 17(3-4), 271-276. doi:10.1057/dbm.2010.14. http://0-search.proquest.com.opac.library.csupomona.edu/docview/817412195/abstract?accountid=10357