SQL Server 2000 from Microsoft
THE data management platform enterprise-class business applications!
OVERVIEW
Business today demands a different kind of data management solution. Performance, scalability, and reliability are essential, but businesses now expect more from their key IT investments.
SQL Server 2000 exceeds dependability requirements and provides innovative capabilities that increase employee effectiveness, integrate heterogeneous IT ecosystems, and maximize capital and operating budgets. SQL Server 2000 provides the enterprise data management platform your organization needs to adapt quickly in a fast-changing environment.
With the lowest implementation and maintenance costs in the industry, SQL Server 2000 delivers rapid return on your data management investment. SQL Server 2000 supports the rapid development of enterprise-class business applications that can give your company a critical competitive advantage.
Benchmarked for scalability, speed, and performance, SQL Server 2000 is a fully enterprise-class database product, providing core support for Extensible Markup Language (XML) and Internet queries.
Easy-to-Use Business Intelligence (BI) Tools
Through rich data analysis and data mining capabilities that integrate with familiar applications such as Microsoft Office, SQL Server 2000 enables you to provide all of your employees with critical, timely business information tailored to their specific information needs. Every copy of SQL Server 2000 ships with a suite of BI services.
Self-Tuning and Management Capabilities
Revolutionary self-tuning and dynamic self-configuring features optimize database performance, while management tools automate standard activities. Graphical tools and wizards simplify setup, database design, and performance monitoring, allowing database administrators to focus on meeting strategic business needs.
Data Management Applications and Services
Unlike its competitors, SQL Server 2000 provides a powerful and comprehensive data management platform. Every software license includes extensive management and development tools, a powerful extraction, transformation, and loading (ETL) tool, business intelligence and analysis services, and new capabilities such as Notification Services. The result is the best overall business value available.
Available editions include: Enterprise (64-bit) Edition, Enterprise Edition and Standard Edition
ENTERPRISE EDITION (64-bit)
The Enterprise Edition (64-bit) provides the most scalable data platform to take advantage of the class of Intel Itanium-based servers. Addressing more memory than any other edition of SQL Server, it scales to the performance levels required to support the largest Data warehousing and analysis applications, ecommerce websites and Enterprise business systems. Supporting up to 8 nodes in failover clustering, SQL Server 2000 Enterprise Edition (64-bit) provides a high level of reliability and availability for your mission-critical applications.
ENTERPRISE EDITION
The Enterprise Edition includes the complete set of SQL Server data management and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites, Enterprise Online Transaction Processing (OLTP) systems and Data Warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition.
There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident:
- Scalability
- Availability/uptime
- Performance
- Advanced analysis
STANDARD EDITION
The Standard edition is an affordable option for small and medium-sized organizations. It includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition.
Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition:
- Data Transformation Services (DTS)
- Replication (snapshot, transactional, and merge)
- Full-Text Search
- English Query
- Stored procedure development and debugging tools
- SQL Profiling and performance analysis tools
KEY TECHNOLOGIES
The key technologies included in SQL Server 2000 include:
- Business Intelligence and Data Warehousing: Use your data to make better decisions with SQL Server 2000 Analysis Services. OLAP, data mining, and data warehousing tools are included at no extra cost
- Data Transformation Services (DTS): With DTS you can automate processes to extract, transform and load data from heterogeneous sources.
- MSDE: Develop applications that can scale seamlessly from portable computers to multiprocessor clusters with this embeddable, redistributable local data store.
- Replication: Implement merge, transactional, and snapshot replication with heterogeneous systems.
- SQL Server 2000 CE: Extend enterprise data management capabilities to mobile devices.
- SQL Server 2000 Enterprise Edition (64-bit): Reach new heights in scalability with the 64-bit database built to take advantage of hardware enhancements of the 64-bit platform.
- SQL Server 2000 Notification Services: Develop and deploy scalable Web applications that deliver personalized, timely information updates to a variety of mobile devices.
- SQL Server 2000 Reporting Services: Get a comprehensive solution for creating, managing, and delivering both traditional, paper-oriented reports and interactive, Web-based reports.
- XML: Build Web services to transform and integrate data across the enterprise to connect with partners and customers.
SQL Server 2000 from Microsoft
|
