|
Features:
- XML stored procedure support
- XML update grams
- Large memory and SMP support
- Integrated data mining, full text search, English (natural
language) Query
- Indexed (materialized) views and integrated visual studio
graphical tools
Product Description
SQL Server 2000 is a fully Web-enabled database product,
providing core support for XML and the ability to query across
the Internet and beyond the firewall. Its features include
a data-mining feature called Analysis Services, which lets
anyone with SQL and Microsoft Visual Basic programming experience
use OLAP tools to create custom analysis applications. Using
a middle-tier server, SQL Server 2000 can perform complex
analyses on large volumes of data with exceptional data-retrieval
performance. Two new features, linked OLAP cubes and HTTP
access to cubes, offer powerful data analysis over the Web.
In addition to enabling you to extend your analysis capabilities
to partners outside the firewall, these features deliver new
value by creating opportunities to sell access to your database
to new customers over the Web.
SQL Server 2000 extends your e-commerce functionality through
rich support for XML, easy Web access to database information,
and powerful analysis tools, coupled with high availability
and tight security. This means that Web developers can access
data using XML without having to do complex programming, and
database administrators can manipulate data easily in XML
format using Transaction SQL (T-SQL) and stored procedures.
Secure HTTP database connectivity ensures that data can be
queried--even by relatively inexperienced users--through a
URL and intuitive user interfaces. SQL Server 2000 also makes
querying from the Web relatively easy. The enhanced English
Query tool allows developers to build natural, English-language
interfaces to SQL Server in Microsoft Visual Studio. In addition,
English Query can now generate Multidimensional Extensions
(MDX) to query against OLAP cubes.
|
Windows
NT / 2000