scroll to top
Stuck on your essay?
Get ideas from this essay and see how your work stacks up
Word Count: 1,545
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 Solectrons which is a major contract manufacturer in the electronic industry data warehouse performance are 1 Completeness Total Complete RecordsiTotal Records Expectedi x Records ExpectediTotal Records in all tables x 100 This metric is supposed to serve the firm better than a simple binary yesno in measuring the weighted average of each table in the data warehouse It also measures the percentage completion during an Extract -Transfer- Load ETL andor 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 HardwareDW size Transfer Rate TR Actual Transfer RateOptimal 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 RateManual 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 usedTotal This metric tracks the usage rate of tables reports and the overall data warehouse to identify any trends andor 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 700AM local time at the sites to which they apply 6 Ticket Cycle Time Average of the number of
@Kibin is a lifesaver for my essay right now!!
- Sandra Slivka, student @ UC Berkeley
Wow, this is the best essay help I've ever received!
- Camvu Pham, student @ U of M
If I'd known about @Kibin in college, I would have gotten much more sleep
- Jen Soust, alumni @ UCLA