The materialization of views promotes the reduction of multidimensional queries’s execution time. However, this materialization has an associated cost that may exceed the cost constraints of a given environment, characterizing the view selection problem (VSP). VSP consists in selecting the best views given a certain cost threshold. Several solutions have been proposed in the literature to try a...

The most effective technique to enhance performances of multidimensional databases consists in materializing redundant aggregates called views. In the classical approach to materialization, each view includes all and only the measures of the cube it aggregates. In this paper we investigate the benefits of materializing views in vertical fragments, aimed at minimizing the workload response time....

several techniques exist to select and materialize a proper set of data in a suitable structure that manage the queries submitted to the online analytical processing systems. these techniques are called view management techniques, which consist of three research areas: 1) view selection to materialize, 2) query processing and rewriting using the materialized views, and 3) maintaining materializ...

A global Data warehouse (DW) integrates data from multiple distributed heterogeneous databases and other information sources. A global DW can be abstractly seen as a set of materialized views. The selection of views for materialization in a DW is an important decision in the implementation of a DW. Current commercial products do not provide tools for automatic DW design. In this paper we provid...

Big Data query systems represent data in a columnar format for fast, selective access, and in some cases (e.g. Apache Drill), perform calculations directly on the columnar data without row materialization, avoiding runtime costs. However, many analysis procedures cannot be easily or efficiently expressed as SQL. In High Energy Physics, the majority of data processing requires nested loops with ...

The main idea in this paper is to show how flexible processes can be designed by combining generic process templates and business rules. At run time we first instantiate a process by applying rules to specific case data and using a materialization algorithm. The customized process instance is then executed in an existing workflow engine. We present an architecture and also give an algorithm for...

View materialization has been shown to ameliorate the scalability problem of data-intensiveweb servers. However, unlike data warehouses which are off-line during updates, most web servers maintain their back-end databases online and perform updates concurrently with user accesses. In such environments, the selection of views to materialize must be performed online; both performance and data fre...

There is currently great interest in building information mediators that can integrate information from multiple data sources such as database systems or Web sources. An issue in building information mediators is how to make them responsive given the high response time for retrieving data from the data sources being integrated, which are databases or Web servers residing remotely. We present an...

Abstract In this paper, we present extensions to the MultiView object-oriented database view system that improve its ability to integrate electronic computer-aided design (ECAD) tools. Using an object-preserving algebra as the view definition language, the MultiView system supports data transformations to suit the needs of individual tools. However, an object-preserving algebra alone is not pow...