This demo presents the ongoing effort to meld the stream query processing capabilities of microsoft StreamInsight with the visualization capabilities of the WorldWide Telescope. This effort provides visualization oppo...
详细信息
This demo presents the ongoing effort to meld the stream query processing capabilities of microsoft StreamInsight with the visualization capabilities of the WorldWide Telescope. This effort provides visualization oppo...
详细信息
This demo presents the ongoing effort to meld the stream query processing capabilities of microsoft StreamInsight with the visualization capabilities of the WorldWide Telescope. This effort provides visualization opportunities to manage, analyze, and process real-time information that is of spatio-temporal nature. The demo scenario is based on detecting, tracking and predicting interesting patterns over historical logs and real-time feeds of earthquake data.
microsoft StreamInsight (StreamInsight, for brevity) is a platform for developing and deploying streaming applications that run continuous queries over high-rate streaming events. StreamInsight adopts a temporal strea...
详细信息
microsoft StreamInsight (StreamInsight, for brevity) is a platform for developing and deploying streaming applications. StreamInsight adopts a deterministic stream model that leverages a temporal algebra as the underl...
详细信息
Column statistics are an important element of cardinality estimation frameworks. More accurate estimates allow the optimizer of a RDBMS to generate better plans and improve the overall system's efficiency. This pa...
详细信息
ISBN:
(纸本)9781605585543
Column statistics are an important element of cardinality estimation frameworks. More accurate estimates allow the optimizer of a RDBMS to generate better plans and improve the overall system's efficiency. This paper introduces filtered statistics, which model value distribution over a set of rows restricted by a predicate. This feature, available in microsoft sql server, can be used to handle column correlation, as well as focus on interesting data ranges. In particular, it fits well for scenarios with logical subtables, like flexible schema or multi-tenant applications. Integration with the existing cardinality estimation infrastructure is presented.
In this demo, we present the microsoft Complex Event Processing (CEP) server, microsoft CEP for short. microsoft CEP is an event stream processing system featured by its declarative query language and its multiple con...
详细信息
In this demo, we present the microsoft Complex Event Processing (CEP) server, microsoft CEP for short. microsoft CEP is an event stream processing system featured by its declarative query language and its multiple consistency levels of stream query processing. Query composability, query fusing, and operator sharing are key features in the microsoft CEP query processor. Moreover, the debugging and supportability tools of microsoft CEP provide visibility of system internals to users. Web click analysis has been crucial to behavior-based online marketing. Streams of web click events provide a typical workload for a CEP server. Meanwhile, a CEP server with its processing capabilities plays a key role in web click analysis. This demo highlights the features of microsoft CEP under a workload of web click events.
Testing a query language is a complex and challenging task. A tester must determine the representative subset of queries which must be tested from an infinite set of valid queries. Once the representative set of queri...
详细信息
ISBN:
(纸本)9781605582337
Testing a query language is a complex and challenging task. A tester must determine the representative subset of queries which must be tested from an infinite set of valid queries. Once the representative set of queries is determined, they then face the task of verifying the results returned when the queries are executed. In this paper, we describe the following four verification approaches we have used to test Entity sql (esql) queries: QueryBuilder, Query Mutations, Reverse Query Processing, and a Baseline Framework. We provide a general overview of each of the verification techniques, and where relevant we provide a description of the specific implementation details used to test esql. We also provide our observations about each of the verification techniques. Copyright 2008 ACM.
With enterprise-class database systems like microsoft sql server, changing mission-critical components such as the relational database engine pose significant challenges to the engineering teams involved. This is beca...
详细信息
ISBN:
(纸本)9781605582337
With enterprise-class database systems like microsoft sql server, changing mission-critical components such as the relational database engine pose significant challenges to the engineering teams involved. This is because customers carefully configure, tune, and test applications and the underlying database system for their specific scenario to ensure they achieve desirable performance. This situation poses particular challenges for developing and extending existing database components of high complexity such as relational query processing where a change to a policy or heuristics may adversely affect performance of a customer workload [1]. Mitigating risk of regressions through a variety of testing and validation techniques during development is essential for the database system engineering team. In this paper, we present a case study to demonstrate the challenges of testing an extension to the query processor in microsoft sql server 2008 targeted at improved query performance for star join queries [2], We discuss the unique range of problem spaces which must be addressed, and present an overview of the variety of techniques that are used to provide a high level of quality. Our main contribution is an iterative process of interleaved development and performance test phases using customer workloads to quantify performance improvement and to limit regressions. We present our experiences with this approach and explore some future opportunities with the hope that they will encourage discussion and additional research in the area of query processor architecture and testing. Copyright 2008 ACM.
Efficient and convenient handling of heterogeneous data is a current challenge for data management systems. In this paper, we discuss several common relational approaches to represent heterogeneity and argue for a des...
详细信息
ISBN:
(纸本)9781424418367
Efficient and convenient handling of heterogeneous data is a current challenge for data management systems. In this paper, we discuss several common relational approaches to represent heterogeneity and argue for a design based on a single wide-table, referred to as a flexible schema. For this scenario, we focus on partial indexation and its support for efficient data storage and processing. Filtered indices provide partial indexation functionality in the microsoft sql server product. We describe here the implementation of this feature, including index utilization in queries, index maintenance and query parameterization issues. Our performance experiments validate the expected benefits of the approach in our implementation.
Cross feature testing is a generic term that refers to testing one or more features together. In this paper, we discuss what cross feature testing in a database system specifically entails. We will identify and explai...
详细信息
ISBN:
(纸本)9781605582337
Cross feature testing is a generic term that refers to testing one or more features together. In this paper, we discuss what cross feature testing in a database system specifically entails. We will identify and explain some of the dependencies amongst feature interactions and how they are categorized. We also review some of the problem symptoms that can occur from cross feature failures. Some strategies to address these issues as they relate to the database are also discussed, but a thorough analysis of any cross feature test solutions is beyond the scope of this paper the goal of which is to provide a basis for future dialog on this topic. Copyright 2008 ACM.
暂无评论