ppt课件- t b s q l server internet database（ 服务器网络数据库）.pptVIP

Tom Barclay Jim Gray, Don Slutz, Greg Smith, many others Microsoft Research Scaleup - Big Database Build a 1 TB SQL Server database Data must be 1 TB Unencumbered Interesting to everyone everywhere And not offensive to anyone anywhere Loaded 1.1 M place names from Encarta World Atlas 1 M Sq Km from USGS (1 meter resolution) 2 M Sq Km from Russian Space agency (2 m) Will be on web (world’s largest atlas) Sell images with commerce server. What’s a Terabyte? 1 Terabyte 1,000,000,000 business letters 150 miles of book shelf 100,000,000 book pages 15 miles of book shelf 50,000,000 FAX images 7 miles of book shelf 10,000,000 TV pictures (mpeg) 10 days of video 4,000 LandSat images 16 earth images (100m) Library of Congress (in ASCII) is 25 TB 1980: 200 M$ of disc 10,000 discs 5 M$ of tape silo 10,000 tapes 1998: 100 k$ of magnetic disc 60 discs 50 K$ nearline tape 30 tapes Terror Byte !! Some Other Terror-Byte Databases TerraServer Sloan Digital Sky Survey: 40 TB raw, 2 TB cooked EOS/DIS (picture of planet each week) 15 PB by 2007 Federal Reserve Clearing house: images of checks 15 PB by 2006 (7 year history) Nuclear Stockpile Stewardship Program 10 Exabytes (???!!) TerraServer is: An on-line demo and sales tool directed at IT customers and ISVs A test of the Sphinx VLDB features: Load performance Online Backup/Restore Query Performance A “cool 90s app” Image and Text data Web-lication Electronic Commerce Application Requirements BIG —1 TB of data. PUBLIC — available on the world wide web. INTERESTING — to a wide audience ACCESSIBLE — using standard browsers (IE, Netscape) REAL — a real application (users can buy imagery) FREE —cannot require NDA or money to access FAST — impress customers for BackOffice, StorageWorks EASY — Inexpensive to develop,