0.全球 大型数据库 ( 37 ).ppt

Who Am I? Outline Statistics Sources Classifying Large Databases What’s a Large Database ? Data Warehouses VS. Data Marts What’s Driving the Growth of Large Data Warehouses ? What’s Driving the Growth of Large Data Warehouses ? World’s Largest DSS Systems Large DSS Systems World’s Largest DSS Systems -- Windows World’s Largest DSS Systems -- By Peak Workload World’s Largest OLTP Systems World’s Largest OLTP Systems -- Unix -- Windows World’s Largest OLTP Systems -- By Number of Rows ? DBMS Licensing Costs Open Source (MySQL, PostgreSQL) SQL Server 2000 DB2 UDB Oracle Teradata Database pricing varies by the options selected and by the deal an IT organization cuts with the vendor. Your mileage may vary! Biggest DSS Systems $$$$$ Biggest OLTP Systems TCO ? + Low-cost SQL Server supports the biggest OLTP systems -- Pressure on Teradata to keep its niche + Open Source DBMSs have a role but it’s not “Top Ten” databases $ DW Labor Costs ? 2002 S Like TCO, Labor Costs may be an un-measurable … Figures applicable across sites ? Every vendor claims lowest labor costs “Terabytes per DBA” may be non-linear! 1 or 2 DBAs for a 24/7 site ? Development staff will be larger than Maintenance staff Your mileage will vary Multi- Machine Mixed Systems 45 Linux w/ MySQL servers (Transactional updates) EWeek, 2/23/04 Sabre / Travelocity 17 Himalaya Non-stop w/ Master database (Fare look-up and routing) Multi- Machine Mixed Systems Omaha Steaks 17 Linux w/ MySQL servers (Shopping cart) (Transactional updates) * 50,000 to 68,000 daily sessions * 1 year in Production / 8 Million sessions ISeries DB2 EWeek 2003 * Howard Fosdick (630)-279-4286 (C) 2004 FCI World’s Largest Databases Hands-on DBA (and SA) for … Oracle, DB2, SQL Server Unix, Linux, Windows Founder IDUG, MWDUG, CAMP Author, Speaker Independent Contractor (630)-279-4286 hfosdick@ 1. What’s a “Big Database” 2. DSS 3.