Database Optimization Essay

1219 words - 5 pages

Database optimization is something, that while may go unnoticed, is very important a very important for saving time and CPU usage. In attempting queries on the math database downloaded form stackexchange. A query is an expression written in a programming language, in this case SQL, that is used for data look up in a database. Stackexchange is a large compressed file that contains a record of all the forums from the website stackoverflow.com. I specifically used the math files since they are one of the largest files in size and serve as a perfect example for why database optimization, and finding efficient SQL queries is important. I have noticed that complicated queries can be optimized to make for faster, more complete results. With the size of the files that I was using to create my database each being any where from 30 megabytes to 600 megabytes, which inserted a few hundred thousand lines of data into my tables, even simple queries, such as “SELECT * FROM posts”, that normally take less than a second to run were taking as long as 10 or 15 seconds. From experimentation and research, the best way speed up queries are, knowing you database, being specific, and using techniques, such as indexes.
Matthias Jarke and Jurgen Koch's paper Query Optimization in Database Systems also displayes the continued importance of finding way to make efficient queries when using a database system. “Efficient methods of processinf unanticipated queries are a crucial prerequisite for the success of generalized database management systems.”( Query Optimization in Database Systems) The paper also explains the importance of knowing the database and what you are searching for. Also explained is the importance of finding alternate ways to make a query, such has eliminating unnecessary look ups. Also explained in the paper is reasons why fast, efficient queries are so important. A big reason for this is due the “communication cost”, “storage cost”, and “computation cost”. The communication cost is the time it takes to transmit the data from site to site.(Query Optimization in Database Systems) The storage cost is the “cost of occupying secondary memory storage and buffers over time.”( Query Optimization in Database Systems) Finnaly the computation cost is the time that the central processing unit is being used. ( Query Optimization in Database Systems) To sum it up query optimization is important so that these costs can be reduced as much as possible even as the amount of data increases.
Using the schema: users id integer, name text, rep, integer, about text) posts( id integer, title text, owner_id text, post_id, created text) com(comment_id integer, post_id integer, comment_text text, user_id integer), I ran a query “SELECT COUNT(post_id), created FROM posts GROUP BY created” to get a count of how many posts were made and on what days. This took anywhere from five to ten seconds to run which is a pretty good amount of time. The problem with the query is that it is...

Find Another Essay On Database optimization

mysql on ec2 vs rds Essay

1549 words - 7 pages experts to analyze which option provides high query throughput and performance. The vanilla MySQL over EC2 without RAID0 gives very sub-average performance. MySQL hosted over EC2 with EBS Raid 0, proper optimization and adjusted MySQL parameters produces optimal performance and results. But it fails visibly when it comes to multi-threads where the query throughput of an optimized and a vanilla database don’t differ significantly. But that is not

Database Management System Diagram Essay

592 words - 3 pages  Database program that is a software system that store the database information. It organizes, manages incoming data and provides ways for the data to be modified or extracted by users or other programs.  Is a device interposed between a potential user of information and information collection itself for a given information problem, the purpose of the system is to capture wanted items and to filter out unwanted items.  Structured data

Important Cyber Monday Preparations to do in your Online Store

793 words - 4 pages before the cyber Monday shopping rush. This is crucial as it helps managers check if the site can hold a high influx of traffic. It is important to work closely with website hosting company in this phase. Prior to testing, it is important to undertake database optimization. In addition, you need to make logs cleanup from file system, database, apache and mysql configuration, optimization and site speed optimization. (More information at http

Relational Database Management System

1093 words - 4 pages Relational Database Management System Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used

Relational and Object-oriented Database Management Systems

2226 words - 9 pages Relational and Object-oriented Database Management Systems A database is a “shared collection of logically related data designed to meet the information needs of multiple users in an organization” (Hoffer 709). Databases contain data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Databases allows multiple users in an organization to easily access, manage, store, and update data when

Oracle Databases Rational Database Management System

598 words - 2 pages OracleDatabase Management Systems can be found everywhere inside and outside the workplace. For example, Database Management Systems at work would include inventory systems, flight reservation systems and computerized library systems. Outside the workplace one would find DBMS's such as an Automated Teller Machine or ATM. DBMS's have become a very important part of everyday business not just because of their effectiveness, but also their

1. What Are The Two Or Three Main Features Of Google That Led To Its Success As The Number One Search Engine And What Features Should Its Competitors Add To Overtake Google As The Top Search Engine?

1415 words - 6 pages In this era of information research and management, there is an Internet Search Engine (ISE) that stands above the rest. Google has been the number one ISE for many years because of its speed, size of database and simplicity. In the business world and at the personal level everyone looks for efficiency to enhance time management and increase profits.Google's competitors must enlarge to their databases, while maintaining the quality of their

The DEC case

2118 words - 8 pages "current computer system" of DEC Systems which is as the following:The main network is a wide-area network (WAN), with each distribution warehouse being linked to a single central database via a dedicated land telephone line. Each warehouse itself runs a local-area network (LAN) with a server maintaining up-to-date files for that location. The central database is updated from each warehouse every three hours on average. Update is hindered by the low

Benefits of Management Information Systems

596 words - 3 pages objectives for the optimization of the enterprises assets. Some of the most conjoint Enterprise components include those for artifact planning, dispersal, bookkeeping, publicizing, funding and Human Resource. The rudimentary objective is to deliver one chief repository for all information that is public by all the various gears of the Enterprise resource facets in order to smooth the flow of data crosswise within organization. A Database system

the importance of client-server computing for the computerized accounting system

1024 words - 4 pages Untitled Introduction Magnificent Music, a CD and DVD retailer, consider expanding its business to other capital cities in Australia out of Melbourne. It prefers a centralized database and client-server system in order to operate the stores effectively and efficiently. This report mainly focuses on two aspects, the importance of the client server computing and how the client server architecture achieves the goal. Importance of

A review to cloud computing modeling,simulations and testing techniques

1707 words - 7 pages accordingly) and provider (to meet the Service-Level Agreement (SLA) with the minimum amount of resources and cost) perspective. They used two penalty (overprovision and underprovision) approaches to measure imperfections in the elasticity for database system. [3] have discussed the optimization problem by analyzing the mathematical relationship between the SLA which specifies service and number of servers with their running frequencies to optimize

Similar Essays

The Changing Role Of The Database Administrator

1145 words - 5 pages database, more and more responsibility fell on the DBA. With the emergence of the relational database management system (RDBMS), we are now beginning to see a change in the database administrator's role.(Mullins 1995)The design of data access routines in relational database demands extra participation from programmers. The database administrator simply checks the system's optimization choice, because technology is responsible for building access

Deductive Databases Essay

891 words - 4 pages Wang. The support of blobs in query formulation and query results in our graph database is done by Xuede~\cite{xuede}. The translation from an XML formatted query to a CORAL query program is done by Liqian~\cite{liqian}. The linkage between MySQL data repository and the CORAL runtime workspace is done by Guang~\cite{guang}. \end{itemize} \item Extensively evaluation of the effectiveness of CORAL optimization techniques on visual query

Difference Between Paralell And Cloud Databases

687 words - 3 pages the best route for the application. However, according to evolving technology, it is possible to hybrid the cloud and parallel database to fulfill the requirement of applications but today’s distributive environment, different other parameter ascertain the optimum use of resources. There are several differences between cloud and parallel database which include load sharing, joins, query optimization, route scheduling and resource optimization

Analysis Of Database Management And Information Retrieval Systems

1932 words - 8 pages data and whiles the system buffers are the temporary location for storing and manipulating the data. Reading and writing of the data is performed at System buffers. As for the functions of DBMS, it is a query processing (SQL) and optimization, query optimization determines the optimum strategy for a query execution. Then, security control, DBMS have includes a prevent of unauthorized access to the database. Data Integrity in DBMS includes