Previous
MSDN Webcast: Creating Analytical Multidimensional Expression (MDX) Queries (Level 200)
White Papers General-purpose tools can create standard MultiDimensional Expressions (MDX) queries. In order to develop a custom application that answers serious business questions, developers need to be able to create effective, analytical MDX queries.
[December 31, 2008, 0:00]
Quick Reference: Microsoft Access Queries
White Papers This handy laminated chart will help Access users of all skill levels learn how to create effective queries. If your organization is like most, its business decisions are largely driven by the data it collects.
[September 4, 2009, 1:21]
MSDN Webcast: Creating Custom Client Applications Using ADOMD.NET and MDX Queries (Level 200)
White Papers This webcast guides the attendee through the process of using ADOMD.NET and MultiDimensional Expression (MDX) queries to create a client application. Often, to get the desired user interface experience for the Microsoft SQL Server 2005-based...
[December 31, 2008, 0:00]
Adaptive Processing of Top-k Queries in XML
White Papers The ability to compute top-k matches to XML queries is gaining importance due to the increasing number of large XML repositories. This paper proposes an architecture and adaptive algorithms for efficiently computing top-k matches to XML queries.
[November 2, 2008, 23:00]
XPlainer: Visual Explanations of XPath Queries
White Papers This paper provides a complete formalization for explanation queries based on the semantics of XPath. This enables the use of XPath engines for the evaluation of explanation queries. This paper describes a tool that uses XPlainer queries to provide...
[June 20, 2007, 1:00]
SQL Server 2005 Runs Faster Ad Hoc Queries for Microsoft IT Sales Analysis Support
White Papers Developers have found they can develop solutions 60 percent faster using Service Broker instead of SQL jobs to manage queries, and that Table Partitioning provides users with a 30 to 40 percent boost in query-processing speed.
[February 23, 2007, 0:00]
Programming ADO to Execute SQLXML Queries
White Papers The objective of this webcast is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries.
[October 6, 2006, 0:00]
Structured Materialized Views for XML Queries
White Papers The performance of XML database queries can be greatly enhanced by rewriting them using materialized views. This paper studies the problem of rewriting a query using materialized views, where both the query and the views are described by a tree...
[January 3, 2009, 0:00]
Privacy-Preserving Verification of Aggregate Queries on Outsourced Databases
White Papers The authors approach this question in the context of outsourced databases, where a data owner delegates the ability to answer users' queries to a service provider, and distrustful users may desire to verify the integrity of responses to their...
[November 7, 2007, 0:00]
How to Join Queries Across Multiple Platforms
White Papers The new Quest Software tech brief, "How to Join Queries Across Multiple Platforms," discusses how to: Write one statement that queries and joins data from multiple sources Whether you work in an environment with a single database platform or...
[May 6, 2009, 12:00]
Supporting Aggregate Queries Over Ad-Hoc Wireless Sensor Networks
White Papers As has been noted in the sensor network literature, aggregation is important as a data-reduction tool; networking approaches, however, have focused on application specific solutions, whereas the in-network aggregation approach is driven by a...
[April 3, 2009, 1:22]
Working With Multiple-Table Queries in Access
White Papers Being able to query and work with data from multiple tables requires some front-end planning to set up the tables correctly, and this paper helps to design databases to make such queries possible. Most database applications store their information...
[November 1, 2006, 0:00]
Efficient Evaluation of Generalized Path Pattern Queries on XML Data
White Papers This paper focuses on the efficient evaluation of partial path queries, a generalization of path pattern queries. They show that partial path queries can be represented as rooted dags for which a topological ordering of the nodes exists.
[November 25, 2008, 23:00]
Mastering XML DB Queries in Oracle Database 10g Release 2
White Papers With rapidly multiplying volumes of XML data, XML queries can no longer be carried out by building resource-hungry DOM trees in memory for functional evaluation of XML documents. Using structured storage of XML documents along with XPath- and...
[January 30, 2009, 8:43]
Rewriting Nested XML Queries Using Nested Views
White Papers This paper presents and analyze an algorithm for equivalent rewriting of XQuery queries using XQuery views, which is complete for a large class of XQueries featuring nested FLWR blocks, XML construction and join equalities by value and identity.
[November 2, 2008, 23:00]
Building Queries Visually
White Papers Using point-and-click actions in the Connections Navigator display, one can quickly view the same data that certain manually entered queries retrieve. Drag-and-drop capabilities and the query builder both help one build complex queries more quickly...
[March 29, 2008, 0:01]
Static Checking of Dynamically Generated Queries in Database Applications
White Papers Many data-intensive applications dynamically construct queries in response to client requests and execute them. Java servlets, e.g.can create string representations of SQL queries and then send the queries, using JDBC, to a database server for...
[September 8, 2006, 0:00]
Customize database queries and their presentation using views in PostgreSQL
White Papers This customization is accomplished in PostgreSQL by creating pre-defined SQL queries, which are stored in the database and can be re-used as and when needed. This download walks you through the necessary queries and commands to show you how to...
[May 25, 2006, 3:17]
Firewall Queries
White Papers An effective way to assist humans in understanding and analyzing the function of a firewall is by issuing firewall queries. Firewalls are crucial elements in network security, and have been widely deployed in most businesses and institutions for...
[August 28, 2009, 1:24]
Not an issue, the System queries downloaded files
Talkback This is not a security issue on a Mac because while Safari doesn't ask permission before downloading an application, the System queries any executable downloaded from the internet before opening it, including an offer to take you to the web site...
[May 18, 2008, 18:13]
