A heuristic approach to selecting views for materialization

Abstract

SUMMARYXML data warehouses are becoming more popular as data is harvested from the web or as output from web services. As these warehouses tend to grow significantly over time, various techniques for expediting queries have been developed. One such technique is to materialize some or all of the queries in advance of query processing. These views are then subject to change either when underlying data changes or view definitions themselves are modified by users. The work in this paper focuses on changes to view definitions or view adaptation as it is known. Our approach is to segment the materialized view into fragments to minimize the effect of view changes. One crucial aspect to this approach is how to select the best fragments for materialization. In this paper, we introduce a new approach to selecting fragments based on heuristics derived from costs associated with the view graph. Copyright © 2013 John Wiley & Sons, Ltd.

Mapping longitudinal studies to risk factors in an ontology for dementia

“…Instead, this forms part of current research building upon the optimization strategies presented in Liu and colleagues. 27,28 While only a brief description of the In-MINDD ontology was discussed here, it has evolved from the initial ontology in Roantree et al 14 and is now stable to the point where it is used as a foundation for the profiler and support forum cloud-based apps. This forms part of a second stream of current research 13 where cloud-based medical data are anonymized.…”

“…While our ontology also provides an opportunity for interoperability across clinical studies and for an XMLbased integration with online clinical data, we do not present a discussion here. Instead this forms part of current research building upon the optimization strategies presented in [14,15]. While only a brief description of the In-MINDD Ontology was discussed here, it has evolved from the initial ontology in [28] and is now stable to the point where it is used as a foundation for the Profiler and Support Forum Cloud-based apps.…”

Representative Sample Extraction from Web Data Streams

“…These processing tasks include acquisition and interpretation, transformation, integration, and analysis or machine learning of data from sensors, devices, vehicles etc. There have been a number of approaches to building smart city applications [5] and to cluster or integrate query graphs on smart city data [10,12]. Decision makers who use smart city applications require OLAP type services to generate the datasets from a warehouse upon which they make their decision.…”

Generating cubes from smart city web data

“…Enhancing data warehouses with web generated XML data was presented in [15] but again, the schema design (facts and dimensions) was driven by existing enterprise databases. In [8], the authors provide an efficient cube maintenance system based on relational data and this was extended for XML data in [17]. While this work can potentially integrate multiple XML cubes, it is based on a static cube and query set while our approach is to manage new and updating datasets coming from smart city sources.…”