Final Report
Abstract
Acknowledgement
Table of Contents
1.
2.
3.
Chapter 1
Introduction
My project is based on Performance Evaluation of Databases. Basically testing and analyzing the system performance, usability, reliability and measures of different database systems using many kind of SQL queries and statement then compare the result and finding out which one is better in terms of performance and optimization techniques. For the evaluation purpose I have used two database systems, they are Microsoft SQL server management 2012 and Oracle database 10g. I need to evaluate the performance by running some set of queries on both of the systems which I used for my evaluation purpose and have to
…show more content…
Predominantly evaluation performance is being done to determine how fast and reliable database system can execute and process queries to give optimize results.
1.1 Objective
My objective of the project is to determine which database management system gives better, efficient and optimize results after the performance evaluation techniques applied to that specific database system. In my project I have used Microsoft SQL server 2012 and Oracle 10 g databases. I need to effectuate which one is best to use efficiently according to different specific measures and perspective of databases.
Current trend in the world of information technology is that relatively every organization is managing tens of petabyte of data. There are large proportion of data which need to be store and managed in database. So there is immense requirement of efficient and reliable database management system. Database systems need to be constructed in high reliability methods and techniques in terms of their functionalities and design. System Performance is an analytical metric that must need great output for an effective database system. Complex database system is outrageous and difficult to analyze so performance evaluation is very important concern since databases are one of the most compelling affair in today’s business revolution.
Chapter 2
Background Research
Database System is one of the most important concern in the field of Informational technology. It contains the most reliable
Database tools and technologies affected the business processes and decision making by a great extent. The most important benefit of the database is to change unstructured information into structured information, and allow users to analysis the data stored into different tables with the help of queries. Before database, all the information used to stored into paper and other unstructured computer programs, due to which getting required information process was very slow. Due to database, all the
A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.
There are several important steps to consider when designing a database, as a well-designed database should be deployed and not only support the accuracy and integrity of business information but also avoid redundant data and assist with has enterprise level reporting tasked. If we analyze the
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 paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.
This paper will discuss and make comparisons on the markets top Database Management Systems (DBMS) currently available. The paper includes a table for side-by-side comparisons of feature sets and other factors required when making decisions on which DBMS to purchase and implement in a business. While this may not be a complete list of all available DBMS systems it will include important discussions on aspects required when evaluating any major application / system choice.
Databases have long been known around the office water cooler as costly, important, difficult, and multifaceted. Looking at many history timelines and the patterns of computer information technology companies; the database is getting frowned upon. The Database implementation is getting old and showing wear and tear. Every company has data, whether its how many hot dogs they are buying and whom is purchasing to what speed internet should be available in which areas. It just depends on the company’s profit and goals. Since, data is so important how is it stored and kept. Companies are using databases to store their important information that they will later make use of.
In business, database has critical role in Customer Management, Inventory Tracking, Personnel Database and Analysis.
Briefly explain following designing requirements that are required when designing the Hardware and Software infrastructure:
Performance is the primary characteristic of database systems that can use to select best solution for the system.High performance relate with quality, amount and depth of analysis. High performance helps to reduce cost.Upgrading to a quicker software package will permit an organization avoid adding further nodes to application continues to scale.
The success of the database and data warehouse (DW) project really depends on the quality of data. If data quality is not good enough, the information will logically be unreliable when the business users retrieve it from the database/DW environment. Good quality of data will be useful for the decision maker to make the right decision, gain more trust and make the organization more efficient. In contrast, the bad quality of data will drive the decision maker to make a wrong decision.
It is essential for database to perform as maximized as possible to enable the largest possibilities to process workloads. However, performance bottlenecks would be in a range of common problems as a virtue towards several factors. Major influences to performance in databases are workload, throughput and resources. Workload defines how heavy system commands are in a given time which would largely endure poor performance that also added factor to consider of the overall capabilities of the computer to process all data, thus speed and efficiency define a huge role of a throughput. Further, factor of resources, which
Implementing a DBMS system within any organization large or small requires proper planning, analyzing files and shared drives and a knowledgeable DBA (Database Administrator, in-depth knowledge of DBMS architecture. Using a DBMS to store and manage data comes with advantages, but also overhead. One of the biggest advantages of using a DBMS is that it lets end users and application programmers access and use the same data while managing data integrity. Data is better protected and maintained when it can be shared using a DBMS instead of creating new iterations of the same data stored in new files for every new application. The DBMS provides a central store of data that can be accessed by multiple users in a controlled manner.
So far in this chapter we have been discussing database systems from the point of view of the architecture in Fig. 2.3. In this section we offer a slightly different perspective on the subject.
A database management system or DBMS is a certain type of system software, which is used for the creation, and management of databases. A DBMS serves for multiple purposes but is mainly used to provide users and programmers with a systematic way to retrieve, create, manage, and update data. A DBMS serves as an interface between data and its end user, making sure that data is consistently organized and remains easily accessible to users. DBMS’s are vital to several aspects of our technological world and are responsible for the data organization of several thriving industries in this world including banking, airlines, wealth management, manufacturers, credit card companies, and telecommunications. A DBMS is useful for providing a view of data that can be accessed by multiple users, from multiple locations at one time. A DBMS can act as a filter and can limit what a user sees and also sets limits on how that user can view data. Users and programmers are free from having to determine where the data is physically located or on what type of storage media it resides because the DBMS simply deals with all requests. The DBMS can give both logical and physical data independence, which means that it can protect its users or applications from needing to know where data is stored.