This white paper examines deployment and integration of Microsoft Hyper-V and Microsoft SQL Server solutions on EMC VPLEXTM storage federation systems. Details of integration with VPLEX systems are documented with practical examples for storage and database administrators.

In this paper, we review the past work and discuss the future of integration of data mining and relational database systems. We also discuss support for integration in Microsoft SQL Server 2000.

Microsoft SQL Server spatial libraries contain several components that handle geometrical and geographical data types. With advances in geo-sensing technologies, there has been an increasing demand for geospatial streaming applications. Microsoft SQL Server StreamInsight (StreamInsight, for brevity) is a platform for developing and deploying streaming applications that run continuous queries ov...

We present an overview of the embeddability features of SQL Anywhere, a full-function relational database system designed for frontline business environments with minimal administration. SQL Anywhere supports features common to enterprise-class database management systems, such as intra-query parallelism, materialized views, OLAP functionality, stored procedures, triggers, and hot failover. SQL...

We describe a largely complete and efficient XQuery to SQL translation for XML publishing. Our translation supports the entire XQuery language, except for functions, if statements and upwards navigation axes. The system has three important properties. First, it preserves the correct XQuery semantics. This is accomplished by first translating XQuery into core-XQuery, using a complete XQuery impl...

One weakness of SQL has been its inability to express certain classes of queries, e.g., iterative queries and database schema-independent queries. Fixes to this problem generally involve embedding SQL in a more expressive language. Re ection|the ability of a language to encode arbitrary programs and evaluate these encodings during execution|can provide a seamless, natural solution. In database ...

MTCache is a prototype mid-tier database caching solution for SQL Server that transparently offloads part of the query workload from a backend server to front-end servers. The goal is to improve system throughput and scalability but without requiring application changes. This paper outlines the architecture of MTCache and highlights several of its key features: modeling of data as materialized ...

The release of SAS Scalable Performance Data Server 4.4 included SQL planner and execution optimizations for star schemas. This paper will cover important areas relevant to the SAS Scalable Performance Data Server star schema support: 1. basic concepts behind the star schema 2. overview of customer needs for star schemas 3. how the query is rewritten to enhance performance 4. limitation of the ...