Chapter 3
Methodology and Design
3.1 Introduction
I used general methodology for my performance evaluation. I performed testing on two database systems and compare them with different criteria of performance measurements to find out the best one in terms of usability and efficiency. Two databases that I have used for the evaluation purpose are Microsoft SQL Server Management Studio 2012 and Oracle 10 g. I used different type of data to be run on both of them. Firstly I used datasets of different size found on web and secondly I extract data from specific website through data scrapping using C# .net Framework 4.5. I designed different database schemas that refers to the organization of tables and data which defines the relationship between
…show more content…
It is important to evaluate these measures to determine the system’s scalability, reliability and workload. I have used several measures to compare the performance of Microsoft SQL Server 2012 and Oracle Database 10g. In my evaluation the measures used to test the performance are as follows.
Execution time
Estimated I/O Cost
Estimated CPU Cost
Total Subtree
…show more content…
Workload depends on the requests made by the application and users of the system. It is concerned with the resources that has been consumed within the database system for instance datasets, database structures etc. In the process of performance evaluation increasing and decreasing of workloads in the database ultimately shows the actual performance of the database system.
3.2.4 Execution time
Execution time is the time in which single instruction given to a system is being executed. Fundamentally execution time is described as the time taken by one transaction to complete. In database system when we run a single query in the system, time taken by a query to give result is the execution time of the query. In my performance evaluation I run different type of queries on both the databases I have used and compare the execution time of query.
3.2.5 Estimated I/O Cost
Estimated I/O cost is the cost estimation which gives relative values used to represent whether operation given is I/O intensive. When parsing queries the query optimizer of the database used as comparative tool which assign values to estimated I/O to determine the costs of operation. It shows that the larger the value produced by the estimated I/O while executing the query the more is the cost intensive process of query
\subsection{computing model} the computation of each tash $A$ of a user node can be either performed locally or offloaded to a cloudlet. the total local computing time equal \begin{equation} T_l=\frac{M}{c_u} \end{equation} each task A requested by user u and offloaded to any active cloudlet experience a total computing delay that consist of the task transmission delay $t_r$, and cloudlet computing time as follows \begin{equation} T_c= t_e+t_g+t_r \end{equation} where, $t_r=\frac{L_a}{R_u(t)}$. Moreover, $R_u(t)=\beta\log(1+\frac{P_u}{N_o})$ is the user transmission data rate, and $L_a$ is the length of the user transmission packet.
In 4th chapter I learned about CPU and other aspects related to it such as RISC and CISC.CPU stands for central processing unit and it is very suitable name for it as it processes the instructions that it gathers from files. Following diagrams explain the basic architecture of CPU: CPU performance is given by the fundamental law: Thus, CPU performance is dependent upon Instruction Count, CPI (Cycles per instruction) and Clock cycle time. And all three are affected by the instruction set architecture. Instruction Count CPI Clock Program x Compiler x x Instruction Set Architecture x x x Microarchitecture
In developing a database, one of the first things one must know is how the database(DB) will be used within the organization. Seconda,y what type of data will be required to develop the database and how it will enhance productivity and reliability to the organization. All the information is gathered in the first phase of the database life cycle, which is planning. In the planning phase, you are gathering information on the need, cost and feasibility of the database within the organization. Also within this phase you would look to see if there are databases within the organization that can meet the requirements.
• The four major systems each have its own database and interfaces had to be built for them to all communicate with each other. This is caused information to show in multiple formats and is difficult to reconcile. Providing accurate reports for banking and government regulators is very challenging.
Unit 9, Lesson 9: Digital Business Cards and Brochures 54.12— Define data mining. 54.13— Identify basic tools and techniques of data mining. 54.14— Explain the use of data mining in Customer Relationship Management (CRM). 54.15—Identify ethical issues of data mining. Lesson Intro Reading 9.9: Activity 9.9: ____________________________________________________________________________ Unit 9, Lesson 10: Digital Business Cards and Brochures 55.01—Publicize e-commerce site through non-Internet means such as mail, press release, broadcast media, print media, and specialty advertising.
A spend analysis evaluates spending to keep costs down. The advantages of a spend analysis is that it contains detailed files on what a company buys, how much they spend, and who they buy from. By conducting a spend analysis the controller can consolidate purchases in order to increase buying volume with a smaller number of preferred suppliers. Although this analysis can be used to reduce cost it does have one disadvantage. Spend analysis do not account for nonfinancial questions behind purchasing decisions.
Introduction The Department of Veteran Affairs (VA), in accordance with the Government Performance Results Act (GPRA) of 2010, in partnership with the Office of Management and Budget (OMB) has committed to making the VA performance more transparent and accessible. In order to achieve the strategic goals, objectives of the VA and the nested goals of Veterans Benefits Administration (VBA), the Undersecretary for Benefits (USB) has directed implementation of an initiative with the goal of eliminating the use of the current End Product (EP) code system as a method of tracking the workload within VBA. Business Case Currently, VBA Manual 21-4, dated July 24, 2015 prescribes the use of an End Product (EP) system to facilitate accurate control
Based on benchmarking of the team, what are the key components to consider for your organization in a homeland security assessment? Why? I think before we go into this question that it is imperative that a definition of benchmark be given. A simple definition of benchmark is nothing more than this, to benchmark is to compare performance against a standard (Azevedo, Newman, & Pungiluppi, 2010).
The two factors that demonstrate that the traditional system may produce estimates that are different than that of the unit cost are high overheads and indirect cost
The information or data that needs to be stored could relate to personal employee information that would need to be password protected so only the relevant people can gain access. Only if date if stored in a procedural manner can it be easily retrieved. This can also help if an external body needs to gain access to records for example auditors. Describe the features of different types of systems used for storage and retrieval of information. There are many different ways in which you can store and retrieve information; the main purpose of storing any information is for easy retrieval in the future when it is
Computers permit large amounts of data to be stored, either on the computer's hard disk or in portable diskettes. Data Manipulation and Processing Data manipulation and processing are performed to obtain useful information from data previously entered into the system. Data manipulation embraces two types of operations: operations needed to remove errors and update current data sets and operations using analytical techniques to answer specific questions formulated by the user. The manipulation process can range from the simple overlay of two or more maps to a complex extraction of disparate pieces of information from a wide variety of sources. Data Output Data output refers to the display or presentation of data employing commonly used output formats that include maps, graphs, reports, tables, and charts, either as a hard-copy, as an image on the screen, or as a text file that can be carried into other software programs for further analysis.
Time management in the military Eddie White DI Page Time management in the military Time management is very important as any organization or individual who want to achieve his/her goals must strictly observe time. Time management requires someone to prioritize some tasks in some way; one should label some tasks as more imp01iant than others. The key factor in effective time management is usually accuracy because when you have accurate model of reality you are in a position to determine which task is more important than other. You can only realize the real gains in time management at the top but not at the bottom. Inaccurate understanding of reality can make your missions, goals and your projects to be meaningless
Web Server: a) Current usage and statistics of cluster b) Web Service for registering password c) Internal Web Page for user list - for Grid FTP 2. DU Server as Head Node: a) Head node and compute nodes b) License Server for MATLAB compute nodes c) Scripts for copying data to SQL Server about user jobs 3. SQL Server a) Lookup Table for users (used from Web Server and Head node) b) Data stored from DU server. 4. Proxy Server 5.
As compared to other databases this database has a slow extraction of results thus making it a slower database. 2. Memory space: The database uses tables having rows and columns which consumes a lot of physical memory which becomes a disadvantage of the database. P a g e 2 | 5 3.
Performance Management Performance management according to --- is a function that that embraces activities such as articulated goal setting, uninterrupted progress reassessment, regular communication and feedback, as well as coaching for better performance. Likewise, it involves execution of employee development plans and rewarding accomplishments. In other words, performance management focuses on improving employee performance along with effort via a process that supports employees to get personal and professional fulfilment by a feel of purposeful contribution. In organisations, management is responsible for meeting organisational objectives through the involvement of others; through evaluating the performance of systems and human resources.