1 / 17
Télécharger la présentation

Microsoft SQL Server 2000

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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!

More Related