SUMMARY
With SQL Server 2000, users have an excellent, streamlined database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications. The white paper that this article references provides brief overviews of the improvements that Microsoft made to SQL Server 7.0. In SQL Server 2000, users have a fully-integrated Extensible Markup Language (XML) environment, a new data mining feature in Analysis Services, and enhanced repository technology with Meta Data Services.
The Analysis Services that Microsoft SQL Server 2000 includes significantly enhance the capabilities of the OLAP Services component that was introduced in SQL Server version 7.0. Analysis Services introduces data mining, which users can use to discover information in OLAP cubes and relational databases. In this white paper, learn how SQL Server 2000 improves security controls, enhances client connectivity, and makes real-time data analysis possible.
Microsoft SQL Server 2000 Meta Data Services extends and renames the former repository component known as Microsoft Repository. Learn how Meta Data Services extends repository technology with the introduction of a new browser for viewing data in a repository database, new XML interchange support, and new repository engine features.
To view this white paper, visit the following Microsoft Web site:
Included in this document:
What's New in Microsoft SQL Server 2000
- Relational Database Enhancements
- XML Integration of Relational Data
- Graphical Administration Enhancements
- Replication Enhancements
- Data Transformation Services Enhancements
- Analysis Services Enhancements
- Meta Data Services Enhancements
- English Query Enhancements
- Documentation Enhancements
What's New in Analysis Services
- Cube Enhancements
- Dimension Enhancements
- Data Mining Enhancements
- Security Enhancements
- Client Connectivity Enhancements in PivotTable Service
- Other Enhancements
What's New in Meta Data Services
- Meta Data Browser Enhancement
- XML Encoding Enhancements
- Repository Engine Programming Enhancements
- Repository Engine Modeling Enhancements