| Technology |
Capabilities |
| Data Warehousing |
| Analysis
(OLAP) Services |
Perform
rapid, sophisticated analysis on large and
complex data sets using multi-dimensional
storage. |
| Closed-Loop
Analysis |
Take
analysis one step further with OLAP actions,
allowing results to drive next steps in the
business process. |
| Data Mining |
Discover
patterns and trends with data mining, and
make predictions about future trends in your
business. |
| Data Transformation
Services |
Automate
routines that extract, transform, and load
data from heterogeneous sources. |
| Data Warehousing
Alliance |
Choose
among broad offerings from third-party analysis
tools vendors that extend Analysis Services
functionality. |
| English Query |
Enable
your users to pose questions in English instead
of using multi dimensional expressions (MDX). |
| Indexed Views |
Gain
performance from your existing hardware by
storing query results and reducing response
times. |
| Meta Data Services |
Increase
developer productivity and reduce administrative
overhead by sharing meta data among different
tools and environments, using standard information
models. |
| Office 2000
Integration |
Use
Pivot Table Services in Microsoft Excel to
enhance your data analysis. |
| OLAP Flexibility |
Use
multiple dimension types for flexible business
analysis. |
| Web-Enabled
Analysis |
Analyze
data from remote OLAP cubes that are Web accessible. |
| Enterprise
Data Management |
| Clickstream
Analysis |
Gain
a deep understanding of online customer behavior,
so that you can make better business decisions.
|
| Distributed
Partitioned Views |
Partition
your workload among multiple servers for additional
scalability. |
| Full Text Search
|
Use
and manage both your structured and unstructured
data, including searching through Microsoft
Office documents. |
| High Availability |
Maximize
the availability of your business applications
with log shipping, online backups, and failover
clusters. |
| Improved Developer
Productivity |
User-defined
functions, cascading referential integrity,
and the integrated Transact SQL (T-SQL) debugger
allow you to reuse code to simplify the development
process. |
| Integration
with Microsoft Windows Server System™—Microsoft
BizTalk and Microsoft Commerce Server |
SQL
Server 2000, in conjunction with other Microsoft
Server products, provides even more power
for your e-business. |
| Rich XML Support |
Simplify
the integration of your back-end systems and
data transfer across firewalls using XML. |
| Security |
Ensure
your applications are secure in any networked
environment, with role-based security and
file and network encryption. |
| Simplified Database
Administration |
Automatic
tuning and maintenance features enable administrators
to focus on other critical tasks. |
| VI SAN |
Improve
your overall system performance with built-in
support for a virtual system area network
(VI SAN). |
| Web Access to
Data |
Connect
to your SQL Server 2000 databases and OLAP
cubes flexibly, by using the Web with no additional
programming. |
| Web and Application
Hosting |
Have
your e-commerce solution hosted by a third
party, with SQL Server 2000 support for multiple
instances. |
| Line of
Business |
| Analysis (OLAP)
Services |
Perform
rapid, sophisticated analysis on large and
complex data sets using multi-dimensional
storage. |
| Application
Hosting |
With
multi-instance support, SQL Server enables
you to take full advantage of your hardware
investments so that multiple applications
can be run on a single server, or outsourced.
|
| Extend Applications |
Support
for access by devices, such as Microsoft Windows®
CE handheld units, provides broader access
to applications and extends your user base.
|
| High Availability |
Maximize
the availability of your business applications
with log shipping, online backups, and failover
clusters. |
| Replication |
With
SQL Server 2000 you can implement merge, transactional,
and snapshot replication with heterogeneous
systems. |
| Scalability |
Scale
your applications up to 32 CPUs and 64 gigabytes
(GB) RAM. SQL Server 2000 has demonstrated
record-breaking performance that you can leverage.
|
| Security |
Ensure
your applications are secure in any networked
environment, with role-based security and
file and network encryption. |
| Simplified Database
Administration |
Automatic
tuning and maintenance features enable administrators
to focus on other critical tasks. |
| VI SAN |
Improve
your overall system performance with built-in
support for a virtual system area network
(VI SAN). |
| Web Access to
Data |
Connect
to your SQL Server 2000 databases and OLAP
cubes flexibly, by using the Web with no additional
programming. |
| XML |
XML
support allows your data to be easily stored
for use by Web applications. |