检索结果-内蒙古大学图书馆

35th ACM SIGMOD Conference

作者： Terlecki, Pawel Bati, Hardik Galindo-Legaria, Cesar Zabback, Peter Microsoft SQL Server Redmond WA 98052 USA

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.

关键词： cardinality estimation conditional data distribution flexible schema multi-tenant application

来源：评论

学校读者我要写书评

暂无评论

SEMANTIC MINING OF DOCUMENTS IN A RELATIONAL DATABASE

SEMANTIC MINING OF DOCUMENTS IN A RELATIONAL DATABASE

引用

International Conference on Knowledge Discovery and Information Retrieval

作者： Mukerjee, Kunal Porter, Todd Gherman, Sorin Microsoft SQL Server RDBMS Redmond WA 98052 USA

ISBN: (纸本)9789898425799

Automatically mining entities, relationships, and semantics from unstructured documents and storing these in relational tables, greatly simplifies and unifies the work flows and user experiences of database products at the Enterprise. This paper describes three linear scale, incremental, and fully automatic semantic mining algorithms that are at the foundation of the new Semantic Platform being released in the next version of sql server. The target workload is large (10 - 100 million) enterprise document corpuses. At these scales, anything short of linear scale and incremental is costly to deploy. These three algorithms give rise to three weighted physical indexes: Tag Index (top keywords in each document);Document Similarity Index (top closely related documents given any document);and Phrase Similarity Index (top semantically related phrases, given any phrase), which are then query-able through the sql interface. The need for specifically creating these three indexes was motivated by observing typical stages of document research, and gap analysis, given current tools and technology at the Enterprise. We describe the mining algorithms and architecture, and outline some compelling user experiences that are enabled by these indexes.

关键词： Semantic mining Documents Full text search sql server

来源：评论

学校读者我要写书评

暂无评论

Filtered indices and their use in flexible schema scenarios

Filtered indices and their use in flexible schema scenarios

引用

24th IEEE International Conference on Data Engineering/ 1st International Workshop on Secure Semantic Web

作者： Acharya, Srini Galindo-Legaria, Cesar Joshi, Milind Krishnaswamy, Babu Stefani, Stefano Terlecki, Pawel Microsoft SQL Server 1 Microsoft Way Redmond WA 98052 USA

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.

关键词： Data handling

来源：评论

学校读者我要写书评

暂无评论

A comprehensive trainable error model for sung music queries

引用

JOURNAL OF ARTIFICIAL INTELLIGENCE RESEARCH 2004年第0期22卷 57-91页

作者： Meek, CJ Birmingham, WP Microsoft Corp SQL Server Redmond WA 98052 USA Grove City Coll Grove City PA 16127 USA

We propose a model for errors in sung queries, a variant of the hidden Markov model (HMM). This is a solution to the problem of identifying the degree of similarity between a (typically error-laden) sung query and a potential target in a database of musical works, an important problem in the field of music information retrieval. Similarity metrics are a critical component of "query-by-humming" (QBH) applications which search audio and multimedia databases for strong matches to oral queries. Our model comprehensively expresses the types of error or variation between target and query: cumulative and noncumulative local errors, transposition, tempo and tempo changes, insertions, deletions and modulation. The model is not only expressive, but automatically trainable, or able to learn and generalize from query examples. We present results of simulations, designed to assess the discriminatory potential of the model, and tests with real sung queries, to demonstrate relevance to real-world applications.

关键词： error model Tempo Crucial components Audio Music multimedia databases Hidden Markov models

来源：评论

学校读者我要写书评

暂无评论

Real-time spatio-temporal analytics using microsoft StreamInsight 10

Real-time spatio-temporal analytics using microsoft StreamIn...

引用

Proceedings of the 18th SIGSPATIAL International Conference on Advances in Geographic Information Systems

作者： Ali, Mohamed Chandramouli, Badrish Raman, Balan S. Katibah, Ed Microsoft SQL Server United States Microsoft Research United States

ISBN: (纸本)9781450304283

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 stream model to handle imperfections in event delivery and define consistency guarantees on the output. This demo highlights the ability of StreamInsight to monitor, analyze and correlate spatio-temporal stream data that is generated by moving objects. The demo scenario is based on the microsoft Shuttle Service where GPS readings are generated and streamed by shuttles as they move around the microsoft main campus in Redmond, WA. The demo presents a set of relational continuous queries as well as various real-time analytics that help improve the efficiency of the shuttle service in terms of the average wait time per passenger and the average daily mileage per shuttle. © 2010 ACM.

关键词： Windows operating system

来源：评论

学校读者我要写书评

暂无评论

An extensible test framework for the microsoft StreamInsight query processor 3

An extensible test framework for the Microsoft StreamInsight...

引用

3rd International Workshop on Testing Database Systems, DBTest 2010

作者： Raizman, Alex Ananthanarayan, Asvin Kirilov, Anton Chandramouli, Badrish Ali, Mohamed Microsoft SQL Server United States Microsoft Research United States

ISBN: (纸本)9781450301909

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 underlying basis for processing long-running continuous queries. In most streaming applications, continuous query processing demands the ability to cope with high input rates that are characterized by imperfections in event delivery (i.e., incomplete or out-of-order data). StreamInsight is architected to handle imperfections in event delivery, to generate real-time low-latency output, and to provide correctness guarantees on the resultant output. On one hand, streaming operators are similar to their well-understood relational counterparts - with a precise algebra as the basis of their behavior. On the other hand, streaming operators are unique in their non-blocking nature, which guarantees low-latency and incremental result delivery. While our deterministic temporal algebra paves the way towards easier testing of the streaming system, one unique challenge is that as the field evolves with more customers adopting streaming solutions, the semantics, behavior, and variety of operators is constantly under churn. This paper overviews the test framework for the StreamInsight query processor and highlights the challenges in verifying the functional correctness of its operators. The paper discusses the extensibility and the reusability of the proposed streaming test infrastructure, as the research and industrial communities address new and constantly evolving challenges in stream query processing. © 2010 ACM.

关键词： Algebra

来源：评论

学校读者我要写书评

暂无评论

Web services & relational databases

引用

DR DOBBS JOURNAL 2004年第4期29卷 S1-S4页

作者： Vaschillo, A Microsoft SQL Server

microsoft's sql server Web Services Toolkit (WSTK), which is used to build web services for relational databases, is discussed. The toolkit allows construction of XML views of relational data stored in sql server and query/update the relational data through these views. Users can then request this data as XML, and WSTK retrieves relational rowsets from the database, converting them to XML hierarchies on-the-fly transparently to users. The sql server Web Services Toolkit lets developers access databases using programming models that are natural to client-side programming languages, allowing databases to be easily converted into web services.

关键词： Computer software

来源：评论

学校读者我要写书评

暂无评论

Building Data Mining solutions with OLE DB for DM and XML for Analysis

Building Data Mining solutions with OLE DB for DM and XML fo...

引用

作者： Tang, Zhaohui Maclennan, Jamie Kim, Peter Pyungchul Microsoft SQL Server Data Mining One Microsoft Way Redmond WA 98007

A data mining component is included in microsoft sql server 2000 and sql server 2005, one of the most popular DBMSs. This gives a push for data mining technologies to move from a niche towards the mainstream. Apart from a few algorithms, the main contribution of sql server Data Mining is the implementation of OLE DB for Data Mining. OLE DB for Data mining is an industrial standard led by microsoft and supported by a number of ISVs. It leverages two existing relational technologies: sql and OLE DB. It defines a sql language for data mining based on a relational concept. More recently, microsoft, Hyperion, SAS and a few other BI vendors formed the XML for Analysis Council. XML for Analysis covers both OLAP and Data Mining. The goal is to allow consumer applications to query various BI packages from different platforms. This paper gives an overview of OLE DB for Data Mining and XML for Analysis. It also shows how to build data mining application using these APIs.

关键词： Data mining

来源：评论

学校读者我要写书评

暂无评论

Cross feature testing in database systems

Cross feature testing in database systems

引用

1st International Workshop on Testing Database Systems, DBTest 2008

作者： Hsueh, Sung Ranasaria, Arvind Microsoft SQL Server Microsoft Corp. One Microsoft Way Redmond WA 98052 United States

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.

关键词： Database systems

来源：评论

学校读者我要写书评

暂无评论

Automatic plan choice validation using performance statistics

Automatic plan choice validation using performance statistic...

引用

1st International Workshop on Testing Database Systems, DBTest 2008

作者： Gosalia, Ashit Zhang, Xin Microsoft SQL Server Microsoft Corp. One Microsoft Way Redmond WA 98052 United States

ISBN: (纸本)9781605582337

The query optimizer models data distribution and access paths to make the optimal plan choice for a given query. Sometimes the plan selection is poor because of modeling limitations, outdated statistics, incorrect optimization heuristics, etc. Hence it is useful to examine the plan choice made by the optimizer from an execution perspective and to impose validation rules on the actual execution plan to evaluate plan suitability. This approach treats the optimizer as a black box. The plan validation is based on the queries and data instead of the optimizer implementation details. This paper describes {XPC}, a rule-based tool for microsoft sql server [1] that helps users and developers achieve a better understanding of plan performance. We apply ideas similar to code profilers [2] to examine plan execution performance along with heuristic rules to the actual execution profile and probe for inefficiencies. This paper describes the overview and implementation of {XPC} and presents rules showing how {XPC} is useful in targeting plan performance issues. Copyright 2008 ACM.

关键词： Data warehouses

来源：评论

学校读者我要写书评

暂无评论

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

请选择保存的检索档案：

请选择收藏分类：

通借通还

建议与咨询 留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

请选择保存的检索档案： 新增检索档案 确定 取消

请选择收藏分类： 新增自定义分类 确定 取消

通借通还

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

请选择保存的检索档案：

请选择收藏分类：