Developing A Characterization Of Business Intelligence Workloads For Sizing New Database Systems

Topics:
Business Intelligence
Tags:
Business Intelligence,
Tools & Techniques,
Software,
Queen,
Pricing,
Marketing,
Management,
Enterprise Software,
Databases,
Database System,
...
Source:
Queen's University

FREE Registration is required

Overview: Computer system sizing involves estimating the amount of hardware resources needed to support a new workload not yet deployed in a production environment. In order to determine the type and quantity of resources required, a methodology is required for describing the new workload. In this paper, we discuss the sizing process for database management systems and describe an analysis for characterizing Business Intelligence (BI) workloads, using the Transaction Processing Performance Council (TPC-H) benchmark as our workload basis. The characterization yields four general classes of queries, each with different characteristics. Our approach for sizing a BI application's database tier quantifies a new BI workload in terms of the response time goals and mix of the different query classes obtained from the characterization analysis.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format: PDF | Size: 397KB | Date: Nov 2004 | Pages: 7

People who downloaded this item also downloaded

Top results from Business Intelligence

Case Study Orthopedic Center to Grow 30 Percent and Boost Productivity With Online Services
Case Study Jeweler Moves to Online Services to Boost Productivity and Cut Costs by 90 Percent
Webcast Business Productivity Online Suite - Highly Secure and Reliable Cloud Services
White Paper Surviving and Thriving in the Customer-Driven Age
White Paper Managing a growing threat: An Executive's Guide to Web Application Security

» View all Business Intelligence listings

advertisement
advertisement
  • Click Here
  • Click Here
  • Click Here
advertisement

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this directory, you become a member of BNET. In addition, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a directory registrant, you will receive a complimentary subscription to the BNET member newsletter, The BNET Report. You can unsubscribe from this newsletter at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).