Metrics that should be developed to measure the performance of a data warehouse in the following environments: 1) health care, 2) retail and 3) pharma.
In most of the Database guide papers, eight performance-based metrics were used to communicate areas of concern to the data warehousing vendor. Also, the ninth one was developed as a weighted average measure using four of the eight metrics, which were deemed the most critical to the organization assessing data warehouse performance to determine how the vendor stacked up relative to data quality and systems quality.
The nine metrics that were developed to measure Solectron's, which is a major contract manufacturer in the electronic industry, data warehouse performance are;
1. Completeness
Total Complete = [((#Recordsi)/(Total #Records Expectedi) x (#Records Expectedi/Total #Records in all tables)) x 100.
This metric is supposed to serve the firm better than a simple binary yes/no in measuring the weighted average of each table in the data warehouse. It also measures the percentage completion during an Extract -Transfer- Load (ETL) and/or refresh process. This metric also, and helps identify any possible SQL problems within a particular table.
2. Connectivity
Response Time = #Users x (RTD% + TR%)
Where Run Time Duration (RTD) in minutes = Hardware/DW size
Transfer Rate (TR) = Actual Transfer Rate/Optimal Transfer Rate
This metric measures connectivity by enabling the firm to identify and isolate underlying issues
including ISP transfer rates, data sources, and hardware issues.
3. Data Integrity
Data Quality Tool Rate/Manual = % Accuracy
This metric measures the avoidance of the tedious, resource intensive method done in the past.
4. Usage Data from the Data Warehouse
Usage Rate on Data = Most frequently used/Total
This metric tracks the usage rate of tables, reports, and the overall data warehouse to identify any trends and/or problems that may occur, particularly during peak operating times.
5. On-Time delivery
This current metric is defined as: tables are on time if they are delivered by 7:00AM...
More Computer Science
essays:
The Basics of Computers
... formally known as the central processing unit (CPU), has the electronic circuitry that manipulates input data into the information as required. The central processing unit actually ...
Silicon Science: The Job of a System Analyst
... the following areas: computer engineering, computer information systems, computer science, data processing, information science, and technical engineering (Wisconsin Career Information System ...
"Peer-to-Peer File Sharing Networks" This paper outlines the history of P2P file sharing networks such as Napster, Gnutella and Kazaa, and discusses their impact on society and the music industry.
... complete anonymity. Liability for copyright infringement no longer falls on the creators of the software, but the individual users instead. As of July 2006, the Recording Industry ... however, there are a few ways for confidential files or data to get on to the network, even without having a ...
Keeping Your Business Running in the event of a criminal attack: Prevention, Protection & Continuity measures
... industry surveys, it is predicted that there will be 794 million people online throughout the world by 2009 (Vacca, 2005, p5). This represents a huge amount of data ...
Computer Crime, discusses the proposition that computer crime has increased dramatically over the last 10 years.
... Much of known computer crime has consisted of entering false data into computers. This method of computer crime is simpler and ... a 'pseudo-virus,' called a worm. People in the computer industry do not agree on the distinctions between worms and viruses ...
The challenge of Implementing Capability Maturity Model (CMM) in Pakistan Software Industry
... Even the clients were able to appreciate the difference of quality before and after CMM certification [4]. CMM, in Pakistan software industry is best implemented as a preventive cure - the proactive approach ...
History of peer-to-peer file sharing. Technology to prevent it, and the future of it.
... the controversies that surrounded it were focused specifically towards the music industry, but recently the focus has significantly broadened. The creation of ... growth of local storage resources allows PC users to store data in multigigabyte storage facilities, something unthinkable only a few years ...
The needs of input, output, storage communication devices to computer processing cycle
... supports the FlexPower connector technology that accepts power from both industry-standard and SATA power supplies. The WD Caviar Hard Drive's hot-plug support promotes system design flexibility, data availability, and serviceability, while its backplane compatibility promotes expandability and ...