Microsoft SQL Server 2000

1. Microsoft SQL Server 2000 Cheng Ji November 3, 2003

2. Agenda • Overview • History • Features • Competitive comparison • Designing Databases • Internet XML support • Weakness • Futures • Summary

3. History of SQL Server • December 1992, SQL Server for Windows NT beta • September 1993, SQL Server 4.2 • June 1995, SQL Server 6.0 • April 1996, SQL Server 6.5 • November 1998, SQL Server 7.0 • August 2000, SQL Server 2000 • February 2002, SQL Server 2000 Enterprise Edition (64-bit) • 2003 Next generation: “YuKon” [1].

4. Features of SQL Server 2000 • Data WareHousing • Data Transforming Service • Data Mining • The Microsoft Decision Trees Algorithm • The Microsoft Clustering Algorithm • Analysis (OLAP) Services

5. Features of SQL Server 2000 • E-Commerce • Rich XML Support • Web Access to Data • Clickstream Analysis • High Availability • Online Backups • Log Shipping • Failover Clustering • Security • Certified under the U.S. government's C2-level security certification

6. Features of SQL Server 2000 • Line of Business • Simplified Database Administration • Scalability • Virtual Interface System Area Network (VI SAN)

7. Competitive comparison Source: Microsoft Corporation

8. Price comparison Basic Database Server Source: Microsoft Corporation [4]

9. T-SQL vs. PL/SQL Source: Database Journal

10. Database Interface Database Engine Client Application Open Data Service Net Library Net Library Client SQL Server Designing Databases- Architecture

11. Creating Database using T-SQL CREATE DATABASE logical_database_name ON PRIMARY (NAME = logical_file_name, FILENAME = ' path\file_name', SIZE = size, MAXSIZE = maxsize, FILEGROWTH = filegrowth_increment) LOG ON (NAME = logical_file_name, FILENAME = ' path\file_name', SIZE = size, MAXSIZE = maxsize, FILEGROWTH = filegrowth_increment)

12. Internet and XML support • Rich XML Support • Query relational database with XPath • Query relational database with SQL and return XML results • Update relational data as if it was XML • Load huge XML files into existing SQL Server 2000 database, converting them to relational data • Query your SQL Server via URLs from your Web Browser of Web application • Access SQL Server XML functionality via .NET Managed Classes

13. Weakness • Only support Windows-based platform. • T-SQL is not strong. • Security holes.

14. Future • Enhancement of XML support • XML type –Cross Domain query • Web Service • Remove the requirement of IIS. • Support .Net technology • Improve business intelligence platform.

15. Summary • What can SQL server do? • Competitive Comparison. • Designing Database • Internet XML support • What’s next for SQL server 2000?

16. Reference [1]Microsoft Corporation.2002. SQL Server History. Retrieved November 1st, 2003 from http://www.microsoft.com/sql/evaluation/anniversary/timeline.asp [2]Microsoft Corporation.2003. Features. Retrieved November 1st, 2003 from http://www.microsoft.com/sql/evaluation/features/byfunction/default.asp [3]D’Hers T. & Vickery S., 2003, Comparing Business Intelligence Platforms. Retrieved November 1st, 2003 from http://www.microsoft.com/sql/evaluation/compare/OLAP_comparison.doc [4]Microsoft Corporation. 2003. Oracle9i and SQL Server 2000 Price Comparison. Retrieved November 1st, 2003 from http://www.microsoft.com/sql/evaluation/compare/pricecomparison.asp [5]Microsoft Corporation. 2003. Microsoft SQLServer 2000 Database Design. [6]Vaas L.. 2003. What's Next for SQL Server? Retrieved November 1st, 2003 from http://www.eweek.com/article2/0,4149,1300797,00.asp [7]Microsoft Corporation. 2003. SQLXML and XML Mapping Technologies. Retrieved November 1st, 2003 from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_ExcelSQLXML.asp [8]Database Journal. 2003. The comparison of SQL Server 2000 with Oracle 9i. Retrieved November 1st, 2003 from http://www.databasejournal.com/features/mssql/article.php/10894_2170201_2`

17. Thanks!