Open AccessBook
Materialized Views
Rada Chirkova,Jun Yang +1 more
Reads0
Chats0
TLDR
This monograph provides an accessible introduction and reference to materialized views, explains its core ideas, highlights its recent developments, and points out its sometimes subtle connections to other research topics in databases.Abstract:
Materialized views are a natural embodiment of the ideas of precomputation and caching in databases. Instead of computing a query from scratch, a system can use results that have already been computed, stored, and kept in sync with database updates. The ability of materialized views to speed up queries benefits most database applications, ranging from traditional querying and reporting to web database caching, online analytical processing, and data mining. By reducing dependency on the availability of base data, materialized views have also laid much of the foundation for information integration and data warehousing systems. The database tradition of declarative querying distinguishes materialized views from generic applications of precomputation and caching in other contexts, and makes materialized views especially interesting, powerful, and challenging at the same time. Study of materialized views has generated a rich research literature and mature commercial implementations, aimed at providing efficient, effective, automated, and general solutions to the selection, use, and maintenance of materialized views. This monograph provides an accessible introduction and reference to materialized views, explains its core ideas, highlights its recent developments, and points out its sometimes subtle connections to other research topics in databases.read more
Citations
More filters
Book
NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence
Pramod J. Sadalage,Martin Fowler +1 more
TL;DR: NoSQL Distilled shows how to implement evolutionary design with schema migration: an essential technique for applying NoSQL databases and describes how NoSQL is ushering in a new age of Polyglot Persistence, where multiple data-storage worlds coexist, and architects can choose the technology best optimized for each type of data access.
Book ChapterDOI
A native and adaptive approach for unified processing of linked streams and linked data
TL;DR: This paper presents CQELS (Continuous Query Evaluation over Linked Streams), a native and adaptive query processor for unified query processing over linked Stream Data and Linked Data, and demonstrates the efficiency of this approach.
Journal ArticleDOI
Incremental knowledge base construction using DeepDive
TL;DR: This work describes DeepDive, a system that combines database and machine learning ideas to help develop KBC systems, and it presents techniques to make the KBC process more efficient, and proposes two methods for incremental inference, based respectively on sampling and variational techniques.
Posted Content
Incremental Knowledge Base Construction Using DeepDive
TL;DR: This work describes DeepDive, a system that combines database and machine learning ideas to help develop KBC systems, and presents techniques to make the KBC process more efficient, and proposes two methods for incremental inference, based, respectively, on sampling and variational techniques.
Proceedings ArticleDOI
Graph pattern matching revised for social network analysis
TL;DR: This paper presents several revisions of the traditional notions of graph pattern matching to find sensible matches in social networks, and proposes a framework of query preserving graph compression, which retains only information necessary for answering a certain class of queries of users' choice.
References
More filters
Journal Article
Data Mining Concepts and Techniques
TL;DR: Data mining is the search for new, valuable, and nontrivial information in large volumes of data, a cooperative effort of humans and computers that is possible to put data-mining activities into one of two categories: Predictive data mining, which produces the model of the system described by the given data set, or Descriptive data mining which produces new, nontrivials information based on the available data set.
Journal ArticleDOI
The many faces of publish/subscribe
TL;DR: This paper factors out the common denominator underlying these variants: full decoupling of the communicating entities in time, space, and synchronization to better identify commonalities and divergences with traditional interaction paradigms.
Journal ArticleDOI
An overview of data warehousing and OLAP technology
Surajit Chaudhuri,Umeshwar Dayal +1 more
TL;DR: An overview of data warehousing and OLAP technologies, with an emphasis on their new requirements, is provided, based on a tutorial presented at the VLDB Conference, 1996.
Proceedings ArticleDOI
Data integration: a theoretical perspective
TL;DR: The tutorial is focused on some of the theoretical issues that are relevant for data integration: modeling a data integration application, processing queries in data integration, dealing with inconsistent data sources, and reasoning on queries.
Proceedings ArticleDOI
Pig latin: a not-so-foreign language for data processing
TL;DR: A new language called Pig Latin is described, designed to fit in a sweet spot between the declarative style of SQL, and the low-level, procedural style of map-reduce, which is an open-source, Apache-incubator project, and available for general use.