CS411 - Large Database and Query Tuning-April_1_2011

CS411 - Large Database and Query Tuning-April_1_2011 -...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2011, The Board of Trustees of the Large Databases in the Real World: Tips and Tricks for Performance Tuning Michael Wonderlich Associate Director for Business Intelligence Architecture Administrative Information Technology Services mcwonder@uillinois.edu CS 411 Database Systems AITS-Decision Support Definition of Decision Support Data warehousing, business intelligence, and information management Mission Support customers in colleges and departments Support management, planning, and strategic decision- making Supply information solutions and services Accomplished by Excellence in DW and BI practices Integration: requirements, data, delivery AITS-Decision Support Services provided Nightly ETL updates DW/BI performance Capacity planning Technology upgrades Security design Data quality Data education Tool training Metadata AITS-Decision Support Job Roles Subject Area Expert Business Analyst Data Warehouse Designer ETL Developer Business Intelligence Spet Loading the Data Warehouse 2011, The Board of Trustees of the Center of the World - Data Warehouse (DW) Total Tables: 753 2011, The Board of Trustees of the Enterprise Data Warehouse (EDW) 677 tables Data Mart(s) 76 tables Code Tables 29% (218) History Tables 21% (158, 29 are code tables) Truncate/Reload 60-65% Incremental 35-40% Size of Tables (in rows) Rows % (rnd) # of Tbls 100M-175M 0.3 2 10M-99M 5 35 1-9M 18 136 500K-999K 9 66 100K-499K 11 86 10K-99K 15 115 1-9999 42 313 # of DW Source Tables 711 # of Rows 1,567,536,662 # of Intermediate Tables 44 # of Rows 2,115,617,779 6 2011, The Board of Trustees of the 2 4 6 8 10 12 EDW Size (GB) Business Intelligence Business intelligence ( BI ) refers to skills, technologies, applications and practices used to help a business acquire a better understanding of its commercial context. Business intelligence may also refer to the collected information itself. BI applications provide historical, current, and predictive views of business operations. Common functions of business intelligence applications are reporting, OLAP, analytics, data mining, business performance management, benchmarks, text mining, and predictive analytics. Business intelligence often aims to support better business decision- making. Thus a BI system can be called a decision support system (DSS) 2011, The Board of Trustees of the Information Delivery 2011, The Board of Trustees of the Low High High Dashboards Reports EDW Queries Analytics 9 Level of Query Flexibility 2011, The Board of Trustees of the...
View Full Document

Page1 / 75

CS411 - Large Database and Query Tuning-April_1_2011 -...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online