Global ETD Search
Search theses and dissertations gathered from participating repositories worldwide. Every result links back to the library that holds it. No account is needed.
Results
Showing 1 to 20 of 32 for “"Materialized views"”.
-
Automatic physical database design : recommending materialized views
… while focusing on the problem of selecting materialized views for improving the performance of a database system. We first address the satisfiability and implication problems for mixed arithmetic constraints. The results are used to support the construction of a search space for view …
-
Using materialized views for answering graph pattern queries
… the generation of these results. Methods using materialized graph pattern views are developed to improve the efficiency of graph pattern query evaluation. A view is materialized as a summary graph, which compactly records all the homomorphisms of the view to the data graph. View usability is …
-
ViewDF: a Flexible Framework for Incremental View Maintenance in Stream Data Warehouses
… to improve the responsiveness of the systems. Materialized views are critical in large-scale data warehouses due to their ability to speed up queries. Thus an SDW maintains layers of materialized views. Materialized view maintenance in SDW systems introduces new challenges. However, some of the …
-
Query answering using views for XML
The problem of answering query using views is to find efficient methods of answering a query using a set of previously materialized views over the database, rather than accessing the database. As XML becomes the standard of data representation and exchange over the internet, the problem has …
-
Automatic Physical Design for XML Databases
… employ physical structures such as indexes and materialized views to improve query performance, potentially by orders of magnitude. It is therefore important for a database administrator to choose the appropriate configuration of these physical structures (i.e., the appropriate physical design) …
-
Global aggregate view selection in a peer warehousing system
Selecting views to materialize is one of the most important decisions to make when designing a data warehouse. In a peer data warehouse design, this problem is more difficult than in a centralized data warehouse design since the costs of global communication, data transfer, and data transformation …
-
Supporting data consistency in concurrent process execution with assurance points and invariants
… by an invariant evaluation web service that uses materialized views for more efficient re-evaluation of invariant conditions. This research includes a performance analysis of the invariant evaluation Web Service, illustrating the benefits of using materialized views. The strength of the invariant …
-
Developing a Rapid Urban Forest Assessment System for Sustainable City Greenification
… R-tree candidate pruning with cascading materialized views, enabling sub-second city-level queries, while a SuperCluster index paired with Voronoi tessellation supports interactive map visualization. Deployed on AWS, RUFA provides urban foresters, planners, and researchers with RUFA …
-
Data Layout Recommendation for Big Data Systems via Large Language Models
… Our system supports both base tables and materialized views, enabling performance recovery in queries that regress under global physical design. Experimental results on the DSB workload show that LayZ outperforms heuristic and existing layout strategies, improving query performance by up …
-
Αποθηκευμένες όψεις για κατατακτήριες ερωτήσεις με άνω όριο αποτελεσμάτων: επεξεργασία ερωτήσεων, ενημέρωση και ομοιότητα
… of top-k queries through the exploitation of materialized top-k views. In addition, we study the problem of capturing the distance function that best complies with human perception for finding the similarity between two data collections of multidimensional points under the form of OLAP cubes. …
-
XML Query optimization
… query minimization and query answering using views. For query minimization, prior work has focused on minimizing TPQs corresponding to the XPath semantics, with or without constraints. We present a study on the minimization of TPQs with a richer class of constraints. In this thesis, we also …
-
Data coordination
… exact relationships between the two. Using materialized views to maintain state, we give an overall approach for coordinating sets of updates from B to C through view differencing and view update translation. We adopt ideas from data exchange and incomplete information to generate the set of …
-
A Meta-Data Vault Approach for Evolutionary Integration of Big Data Sets: Case Study Using the NCBI Database for Genetic Variation
… used to load data into the data warehouse and materialized views to deliver data to end-users. To test our solution, we have used big data sets from the biomedical field, for each modification of the data source schema, we outline the changes that need to be made to the EDW, the data marts and …
-
Efficient peer-to-peer data management
… queries using a set of precomputed queries (materialized views). We have developed a peer-to-peer platform, called ViP2P (views in peer-to-peer) that gives to the users the opportunity to publish their XML documents and to specify views over these documents using a tree pattern language. …
-
Semantics and efficient evaluation of partial tree-pattern queries on XML
… of techniques for answering TPQs using materialized views. Non-main-memory XML query evaluation can be done in two modes (which also define two evaluation models). In the first mode, data is preprocessed and indexes, called inverted lists, are built for it. In the second mode, data are …
-
Update-Aware Information Extraction
… recommend that extracted relations be treated as materialized views over the document database. Because extraction is expensive, maintaining extracted relations in the presence of frequent document updates comes at a high execution cost. We propose a practical framework to effectively update …
-
Development of new data partitioning and allocation algorithms for query optimization of distributed data warehouse systems
… data, contrary to redundant techniques like materialized views and indexes. The warehouse partitioning problem is concerned with determining the set of dimension tables to be partitioned and using them to generate the fact table fragments. In this work an enhanced grouping algorithm that …
-
Equivalence of Queries with Nested Aggregation
… minimization, view flattening, rewriting over materialized views, various semantic optimizations that exploit schema dependencies, federated query processing and other forms of data integration—requires proving that the final executed query is equivalent to the original user query. Hence, …
-
Online Physical Design And Materialization in Scalable Data Management
… investigating: (1) partition and re-partition materialized views to honor the access patterns of non-update workloads; and (2) allocate data dynamically between streaming engines and analytical engines in a federated system for hybrid workloads consisting of data ingestion, transactions, and …
-
Collaborative Data Sharing with Mappings and Provenance
… and with the problem of optimizing queries using materialized views. Finally, we show that semiring annotations also make sense for XML and nested relational data, paving the way towards a future extension of CDSS to these richer data models.
Page 1 of 2