Filters








156,476 Hits in 6.3 sec

EFFICIENT APPROACH FOR VIEW SELECTION FOR DATA WAREHOUSE USING TREE MINING AND EVOLUTIONARY COMPUTATION

Atul Thakare, Parag Deshpande
2018 Computer Science  
The experimental results show that the proposed method is successful in recommending a solution that is fairly close to an optimal solution.  ...  The selection of a proper set of views to materialize plays an important role in database performance.  ...  Conclusion In this paper, we considered the problem of selecting views to optimize the aggregate queries so that the sum of the query evaluation and view maintenance costs for workload queries can be minimized  ... 
doi:10.7494/csci.2018.19.4.3006 fatcat:rq3djpx6s5duza7y7kwm6fnoia

Incremental maintenance of views with duplicates

Timothy Griffin, Leonid Libkin
1995 Proceedings of the 1995 ACM SIGMOD international conference on Management of data - SIGMOD '95  
We study the problem of e cient maintenance of materialized views that may contain duplicates.  ...  Unlike most work on the view maintenance problem that is based on an algorithmic approach, our approach is algebraic and based on equational reasoning.  ...  We would like to thank Rick Hull for directing our attention to some of the relevant literature, Inderpal Mumick for his very helpful discussions, and Doug McIlroy and Jon Riecke for their careful reading  ... 
doi:10.1145/223784.223849 dblp:conf/sigmod/GriffinL95 fatcat:ag2reyq53vec5n7sp4hcyssbtu

Applying evolutionary algorithms to materialized view selection in a data warehouse

J.-T. Horng, Y.-J. Chang, B.-J. Liu
2003 Soft Computing - A Fusion of Foundations, Methodologies and Applications  
The view-selection problem addresses to select a fittest set of materialized views from a variety of MVPPs 0 forms a challenge in data warehouse research.  ...  In this paper, we present genetic algorithm to choose materialized views. We also use experiments to demonstrate the power of our approach.  ...  The results of the previous work of the study is shown in 0. We further identify the weakness of our previous study and then solve the problem using the genetic approach.  ... 
doi:10.1007/s00500-002-0243-1 fatcat:efmscxuwyvfqhfs5lsdvv4lixm

Multi-Objective Big Data View Materialization using MOGA

2022 International Journal of Applied Metaheuristic Computing  
Materialization of views for Big data is one of the ways to enhance the efficiency of processing of the data.  ...  In this paper, Big data view selection problem is addressed, as a bi-objective optimization problem, using Multi-objective genetic algorithm.  ...  the remaining m objectives (where, m can be any value from 1 to n-1) The dominated count of a solution is the count of the solutions that dominate it.  ... 
doi:10.4018/ijamc.292499 fatcat:rfnxvae6qzfkdedrdhdrpxssi4

Incremental Maintenance of Materialized XQuery Views

M. El-Sayed, E.A. Rundensteiner, M. Mani
2006 22nd International Conference on Data Engineering (ICDE'06)  
Our solution is the first to enable the maintenance of a large class of XQuery views including XPath expressions, FLWOR expressions, and Element Constructors.  ...  This dissertation proposes a comprehensive solution for the general problem of maintaining materialized XQuery views.  ...  [BLT86] proposed a differential solution that was focused on the view maintenance problem of SPJ views.  ... 
doi:10.1109/icde.2006.80 dblp:conf/icde/El-SayedRM06 fatcat:gb6ngzxjgberzfpnjkj6zkptze

Neighbor-based pattern detection for windows over streaming data

Di Yang, Elke A. Rundensteiner, Matthew O. Ward
2009 Proceedings of the 12th International Conference on Extending Database Technology Advances in Database Technology - EDBT '09  
This work tackles this problem by developing the first solution for incremental detection of neighbor-based patterns specific to sliding window scenarios.  ...  Our solution achieves minimal CPU utilization, while still keeping the memory utilization linear in the number of objects in the window.  ...  Finally, the combination of the "view prediction" technique and a proposed hybrid neighborship maintenance mechanism leads to an ideal solution Extra-N, achieving both linear memory consumption and the  ... 
doi:10.1145/1516360.1516422 dblp:conf/edbt/YangRW09 fatcat:4bdrh36vgvdm5bnbutkrqywku4

Rolling Stock Rostering Optimization Under Maintenance Constraints

Giovanni Luca Giacco, Andrea D'Ariano, Dario Pacciarelli
2014 Journal of Intelligent Transportation Systems / Taylor & Francis  
In our formulation, a rostering solution is viewed as a minimal cost Hamiltonian cycle in a graph with service pairings, empty runs and short-term maintenance tasks.  ...  This is a key problem in railway rostering planning that requires to cover a given set of services and maintenance works with a minimum amount of rolling stock units.  ...  In conclusions, the rostering problem can be viewed as the problem of finding a minimum cost Hamiltonian cycle in G with additional constraints related to the implementation of maintenance tasks.  ... 
doi:10.1080/15472450.2013.801712 fatcat:tc4hsdp3pvadxh6az55dnrv43y

Predictive Maintenance of Cash Dispenser Using a Cognitive Prioritization Model

Archana Dixit, Amol B. Mahamun
2021 Tehnički glasnik  
The model not only predicts failure score for the devices to be serviced, but it also reduces the service miss impact for the prediction windows.  ...  It also helps reduce maintenance cost, travel cost, labour cost, downtime, repair duration and increase meantime between failures (MTBF) of individual components.  ...  Finally, Section 7 concludes this paper by throwing light on the plausible approaches that could be leveraged in the future to make this Predictive maintenance solution more robust.  ... 
doi:10.31803/tg-20210205105921 fatcat:genzrdehcjfv7l7ggt3iahiufi

Consistent Cache Maintenance for Database Driven Websites [chapter]

Paweł Leszczyński, Krzysztof Stencel
2010 Lecture Notes in Computer Science  
Caching data helps to resolve a problem of a database scalability, however it introduces an additional problem of a consistency maintenance.  ...  We are going to develop an existing caching model for an automatic consistency maintenance of the cached data and data stored in a database.  ...  The problem of maintaining cached data up to date is difficult and known for a long time from a materialized view maintenance.  ... 
doi:10.1007/978-3-642-16985-4_58 fatcat:dj3wmzrt5fdcxmsy4wzoibwgo4

Framework for Passenger Seat Availability Using Face Detection in Passenger Bus [article]

Khawar Islam, Uzma Afzal
2020 arXiv   pre-print
We believe our results have the potential to address traffic management concerns and assist passengers to save their valuable time  ...  We propose a Face Detection based Framework (FDF) to determine passenger seat availability in a camera-equipped bus through face detection which is based on background subtraction to count empty, filled  ...  This research also provides a cheaper solution to count ridership on a daily basis, high security and low-cost maintenance.  ... 
arXiv:2007.05906v1 fatcat:wj6c3buhdfedfc53oiyniebhhi

Incremental maintenance of views with duplicates

Timothy Griffin, Leonid Libkin
1995 SIGMOD record  
We study the problem of e cient maintenance of materialized views that may contain duplicates.  ...  Unlike most work on the view maintenance problem that is based on an algorithmic approach, our approach is algebraic and based on equational reasoning.  ...  We w ould like to thank Rick Hull for directing our attention to some of the relevant literature, Inderpal Mumick for his very helpful discussions, and Doug McIlroy and Jon Riecke for their careful reading  ... 
doi:10.1145/568271.223849 fatcat:6iucervjnnff5aabkrbly4kqly

KTV-Tree: Interactive Top-K Aggregation on Dynamic Large Dataset in the Cloud

Yuzhe Tang, Ling Liu, Junichi Tatemura, Hakan Hacigumus
2015 2015 IEEE 35th International Conference on Distributed Computing Systems Workshops  
Experiments are performed for evaluating the effectiveness of our solutions, in terms of query accuracy, costs and maintenance overhead.  ...  A segment treebased structure is adopted to organize the views in a hierarchical manner. A suite of protocols are proposed for incrementally maintaining the views.  ...  Acknowledgments The first and last authors are partially supported by grants from NSF CISE NetSE, NSF CyberTrust, an IBM SUR grant, an IBM faculty award, and a grant from Intel Research Council.  ... 
doi:10.1109/icdcsw.2015.32 dblp:conf/icdcsw/TangLTH15 fatcat:4selowu3grezle6a3salcedogy

Solar Panel Dual Management System

Mr. Sumant Khetan, Mr. Akshay Irkar, Mr. Akash Kanase | Mr. Akash Karne | Prof. Anand V. Sutar
2018 International Journal of Trend in Scientific Research and Development  
of soil deposited on panel which can decrease the power upto certain level but the company or organization has to pay the cleaner for his visit.  ...  But due to pollution there is wastage of energy i.e. due to deposition of soil on solar panel .so there is always need to clean the solar panel in fixed days. but some time there is no desirable amount  ...  So there is a need for smart solution to tackle those problems.  ... 
doi:10.31142/ijtsrd11041 fatcat:yu3v6f5tive2xotp7ysauqpbuu

Stale view cleaning

Sanjay Krishnan, Jiannan Wang, Michael J. Franklin, Ken Goldberg, Tim Kraska
2015 Proceedings of the VLDB Endowment  
When new records arrive at a high rate, it is infeasible to continuously update (maintain) MVs and a common solution is to defer maintenance by batching updates together.  ...  We propose Stale View Cleaning (SVC) which addresses this problem from a data cleaning perspective.  ...  This research is supported in part by NSF CISE Expeditions Award CCF-1139158, LBNL Award 7076018, and DARPA XData Award FA8750-12-2-0331, and gifts from Amazon Web Services, Google, SAP, The Thomas and  ... 
doi:10.14778/2824032.2824037 fatcat:tpawrsfs6ne4zk6vysqgtorod4

Incremental Maintenance of Aggregate Views [chapter]

Abhijeet Mohapatra, Michael Genesereth
2014 Lecture Notes in Computer Science  
to prior view maintenance techniques.  ...  For other types of aggregate views, CReaM updates the view in no more time than that is required by prior view maintenance techniques to update the view.  ...  The problem of incremental view maintenance is closely related to the problem of self-maintainability [11, 12, 17, 19] .  ... 
doi:10.1007/978-3-319-04939-7_20 fatcat:ncpdw6nycjhfrage26s6ij4vva
« Previous Showing results 1 — 15 out of 156,476 results