Review of Major Commercial DBMSs - Database Design and Development: An Essential Guide for IT Professionals - page 697

Desktop Engine (MSDE). A redistributable version of the SQL Server relational
database engine, ideal for software developers to include in their applications
that use SQL Server to store data. Does not include any graphical manage-
ment tools, nor any analysis capabilities such as OLAP, data mining, and data
warehousing.

Highlights of Certain Significant Features

Distributed Partitioned Views Partitioning of workload among multiple servers

for additional scalability.

High Availability Enhanced availability of business applications with the use of
log shipping, online backups, and failover clusters.

Full Text Search Management of structured and unstructured data, including
searching through Microsoft Office documents.

Developer Productivity Provision of user-defined functions, cascading referen-
tial integrity, and reuse of code through the integrated Transact SQL debugger.

XML Support Simplification of the integration of back-end systems and data
transfer across firewalls using XML.

Security Provision of role-based security and file and network encryption.

Web Access and Hosting Connection to SQL Server 2000 databases and OLAP
cubes flexibly and ability for third-party hosting e-commerce solution with support
of multiple instances.

Application Hosting Provision of multi-instance support to take full advantage
of hardware investment so that multiple applications can be run on a single
server.

Data Replication Ability to implement merge, transactional, and snapshot repli-
cation with heterogeneous systems.

Database Administration Simplified data administration with automatic tuning

and maintenance features.

Indexed Views Provision for performance improvement from existing hardware
by storing query results.

Data Warehousing Support Provision of metadata services and data transfor-

mation services (DTS).

Advanced Querying and Analysis Inclusion of English Query, OLAP services,
closed-loop analysis, data mining, Web-enabled analysis, and clickstream analysis.