Volume 14, Issue 3 (12-2017)                   JSDP 2017, 14(3): 113-126 | Back to browse issues page


XML Persian Abstract Print


Shahid Rajaee Teacher Training University
Abstract:   (4673 Views)

Data warehouse is a repository of integrated data that is collected from various sources. Data warehouse has a capability of maintaining data from various sources in its view form. So, the view should be maintained and updated during changes of sources. Since the increase in updates may cause costly overhead, it is necessary to update views with high accuracy. Optimal Delta Evaluation method is one of the incremental view maintenance method that can maintain materialized views efficiently in the data warehouse environment. This method is one of the incremental view maintenance grouping methods. In this method incremental maintenance expression is divided into groups, as a result access to some repeated relations is minimized. As a final result, Optimal Delta Evaluation method can minimize the total accesses to relations. The algorithm proposed in this paper, is the combination of optimal Delta Evaluation with Cuckoo heuristic Algorithm that reduces maintenance time of views and thus speeds up this process. Cuckoo optimization algorithm begins with an initial population. Trying to survive the Cuckoo makes the base to optimize the algorithm. The results show that the Cuckoo algorithm is faster in order to update its incremental views compared with previous methods.
 

Full-Text [PDF 4335 kb]   (1991 Downloads)    
Type of Study: Research | Subject: Paper
Received: 2015/11/20 | Accepted: 2016/10/29 | Published: 2018/01/29 | ePublished: 2018/01/29

References
1. [1] Sabbagh Gol. R, and Daneshpour. N. An Improved View Selection Algorithm in Data Warehouses by Finding Frequent Queries. Journal of Signal and Data Processing, vol 14, no. 1, pp. 29-40, 1396.
2. [2] Almazyad A.S,.and siddiqui. m. k, Incremental View Maintenance: An Algorithmic Approach. International Journal of Electrical & Computer Sciences IJECS-IJENS 01/2010; Vol: 10:16.may 2014
3. [3] Ghosh. P, Sen, S. Dynamic Incremental Maintenance Of Materialize View based on attribute affinity. International Conference on Data Science & Engineering (ICDSE), 2014.
4. [4] Mohapatra. A, Genesereth. M. Incremental Maintenance Of Aggregate View. Foundations of Information and Knowledge Systems. Volume 8367 of the series Lecture Notes in Computer Science, 2014, pp 399-414.
5. [5] Katsis. Y. Ong. K.W, Papakonstantinou. Y, Zhao. K, "Utilizing IDs to Accelerate Incremental View Maintenance", Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data [DOI:10.1145/2723372.2750546]
6. [6] Nikolic. M. ElSeidy. M, Koch. C, "LINVIEW: incremental view maintenance for complex analytical queries", June 2014 SIGMOD '14: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data [DOI:10.1145/2588555.2610519]
7. [7] Yi. V.h, Xu. w.h, and taochen. Y, Novel Back Propagation Optimization by Cuckoo Search Algorithm. ScientificWorldJournal: 878262, 2014.
8. [8] Larson. P, Zhou. J, and Elmongui. H. G, Lazy Maintenance of Materialized Views. In Proceedings of the 33rd International conference on Very Large data bases Vienna,2007.
9. [9] Luo. G, Naughton. J.f, Ellmannand. C, Watzke. M, A comparison of three methods for join view maintenance in parallel RDBMS, Proceedings of ICDE Conference, pp. 177–188, 2003.
10. [10] Zhang.X, Ding. L, and Rundensteiner. A, Parallel multisource viewmaintenance. the VLDB Journal, 13(1):22-48, January 2004.
11. [11] Koch. M, An Applied Data Matching Methodology Master's Thesis, University of Kaiserslautern, December 2010.
12. [12] Palpanas. T, Sidle. R, Cochrane. R and Pirahesh. H, Incremental maintenance for non-distributive aggregate functions, pp. 802–813, Proceedings of VLDB Conference, 2002. [DOI:10.1016/B978-155860869-6/50076-7]
13. [13] Rundensteiner. E.A,and Chen. S GPIVOT: efficient incremental maintenance of complex,pp, 552–563 ROLAP views, Proceedings of ICDE Conference, 2005.
14. [14] Wang. S Qin. B, and Du. X. Effective Maintenance of Materialized Views inPeerData Management Systems, Proceedings of the First International Conference on Semantics, Knowledge, 0-7695-2534-2/05 © IEEE.2006.
15. [15] Zhuge. Y, Molina. H. G, and Wiener. J Consistency algorithms for multi-source warehouse view maintenance. Journal of Distributed and Parallel Databases, pages 7–40,Jan. 2007.
16. [16] Ismail. R.M Maintenance of materialized views over peer-to-peer datawarehouse architecture, Computer Engineering & Systems (ICCES),.Page(s): 312 - 318 .IEEE Conference Publications, 2011.
17. [17] Jin. X, Liao. H, An incremental maintenance method for XQuery materialized view.Mechatronic Science, Electric Engineering and Computer (MEC), International Conference on IEEE.2011. [DOI:10.1109/MEC.2011.6025584]
18. [18] Huangand. X, Chen.Q, A maintainable model ofmaterialized view based on datawarehouse,Mechatronic Science, Electric Engineering and Computer (MEC), 2011 International Conference , Page(s): 1974 - 1977 .IEEE Conference Publications, 2011.
19. [19] Dattaand. S,.Chaki.D.N,An Architectureto Maintain Materialized View in Cloud Computing Environment for OLAP ProcessingComputing Sciences (ICCS), Page(s): 360 - 365 .IEEE Conference Publications.InternationalConferenceon2012.
20. [20] Jainand. H, and Gosain. A, A comprehensive study of view maintenance approaches in data warehousing evolution. ACM SIGSOFT Software Engineering Notes archive. Volume 37 Issue 5, September 2012
21. [21] Jörg. T and Behrend. A, Optimized Incremental ETL Jobs for Maintaining Data Warehouses In: Proc. IDEAS, pp. 216-224 2010.
22. [22] Gupta. A, Folkert. N, Witkowski. A, Subrmanian. S, Bellamkonda.S, Shankar.S, Bozgaya.T and Sheng.L, "Opt imisingRegresh Set of Materialized View". Proceedings of VLDB Conference, Norway, 2005.
23. [23] Almazyad A.S, siddiqui. m. k Ahmad. Y, Kan. Z, A Incremental view Maintenance Approach Using Version Store in Warehousing Environment. Computer Science and Engineering. WCSE 09 Second International Workshop on Volume :1.Dol: 10.1109/WCSE. 2009.
24. [24] Zhou. L and.Geng.Q. H, The minimum Incremental Maintenance of Materialize View in Data Warehouse2nd International Asia Conference on Informatics in Control. © IEEE, 2010
25. [25] Yeung. H, Gary, C, and Gruver.W A, Multiagent Immediate Incremental View Maintenance for Data Warehouses. for Data Warehouses. IEEE TRANSACTIONS ON SYSTEMS, MARCH 2005.
26. [26] Zhuge.Y,Molina. H G, Hammer. J, and Widom. J, View maintenance in a warehousing environment. In Proceedings of SIGMOD, pages 316--327, May 1995. https://doi.org/10.1145/568271.223848 [DOI:10.1145/223784.223848]
27. [27] Zhuge. Y,Molina. H. G, Hammer. J, and Wiener.J. L, The strobe algorithms for multi-source warehouse consistency. In Proceedings of the Fourth International Conference on Parallel and Distributed Information Systems, pages 146- 157, December 1996. [DOI:10.1109/PDIS.1996.568676]
28. [28] Agrawal. D, Abbadi. A. E, Singh. A, and Yurek. T, Efficient view maintenance at data warehouses. In Proceedings of SIGMOD, pages 417-427, May 1997 [DOI:10.1145/253260.253355]
29. [29] Zhang. X, Yangand. L, Wang. D, Incremental View Maintenance Based on Data Source Compensation in Data Warehouses. International Conference on Computer Application and System ModelingICCASM 2010.
30. [30] Lee. K. Y, Son. J. H, and Kim. M, "Reducing the cost of accessing relations in incremental view maintenance", Decision Support Systems 43 512–526, 2007. [DOI:10.1016/j.dss.2006.11.006]
31. [31] Liu.B, and Rundensteiner. E.A, Finkel.D, Maintaining large update batches by restructuring and grouping.Informatio Systems 32 621–639.www.elsevier.com /locate/infosys, 2007.
32. [32] He. H, Xie.J, Yangand. J, Yu. H, Asymmetric Batch Incremental View Maintenance.Browse Conference Publications. Data Engineering, ICDE .IEEE, 2005.
33. [33] Zhou. J, Larson.P, and Elmongui. H.G, Lazy Maintenance of Materialized Views. In Proceedings of the 33rd International conference on Very Large data bases,Vienna, Austria, 2007
34. [34] Rajabioun.R, "Cuckoo Optimization Algorithm". Control and Intelligent Processing Center of Excellence ( CIPCE ), Scool of Electrical and Computer Engineering, University of Tehran, Tehran, Iran. J o u r n a l h o m e p a g e : www.elsevier.com Applied Soft Computing 11 (2011) 5508-5518. [DOI:10.1016/j.asoc.2011.05.008]
35. [35] Esmonde. W, G.kanagaraj. L and ponnambalam. S.G, PCB Drill Path Optimization by Combinatorial Cuckoo Search Algorithm .The Scientific World Journal,Volume2014.Data Science & Engineering (ICDSE).Incremental Conference on Dol:10.1109/ICDSE. 2014.
36. [36] Buruzs. A, Hatwagner. M F, and Pozna. R C, Advanced Learning of Fuzzy Cognitive Maps of Waste Management by Bacterial Algorithm. 978-1-4799-0348-1/13/$31.00 ©IEEE, 2013
37. [37] Y. ujang, Yi . Renjie He.A Novel Artificial Bee Colony Algorithm Intelligent Human-Machine Systems and Cybernetics (IHMSC), 2014 Sixth International Conference on Volume: 1 DOI: 10.1109/IHMSC.2014.73 Publication Year: 2014 . [DOI:10.1109/IHMSC.2014.73]
38. [38] Yang. J, Yi. K, Yu, H, Xia. G, Chen. Y, Efficient maintenance of materialized top-k views, Proceedings of the ICDE Conference, 2003, pp. 189–200.
39. [39] Griffin. T, and Libkin.L, Incremental maintenance of views with duplicates. In Proc. SIGMOD, 2007.
40. [40] Gupta. A, Mumick.I. S, and Subrahmanian. V. S, Maintaining Views incrementally, Proceeding of ACM SIGMOD Conference, pp.157-166, 1993
41. [41] Jörg. T and Dessloch.S, View Maintenance using Partial Deltas In: Proc. BTW, LNI P - 180, pp. 287-306 March 2011.
42. [42] Karimi Mosadegh A, and Daneshpour N. Incremental View Maintenance Cost Reduction in Data Warehouses using Meta Heuristic Algorithms. In Proceedings of the 3rd International Conference on Present and Future Information, 2014.

Rights and permissions
Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.