Journal of Engineering and Applied Sciences

Year: 2017
Volume: 12
Issue: 12 SI
Page No. 9436 - 9439

Materialized View Based Data Warehouse Optimization

Authors : Ashwini A. Rangari and A.R. Raipurkar

References

Bellatreche, L., M. Schneider, H. Lorinquer and M. Mohania, 2004. Bringing together partitioning, materialized views and indexes to optimize performance of relational data warehouses. Proceedings of the 6th International Conference on Data Warehousing and Knowledge Discovery (DaWaK’04), September 1-3, 2004, Springer, Zaragoza, Spain, pp: 15-25.

Colby, L.S., A. Kawaguchi, D.F. Lieuwen, I.S. Mumick and K.A. Ross, 1997. Supporting multiple view maintenance policies. Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data, May 11-15, 1997, ACM, Tucson, Arizona, ISBN:0-89791-911-4, pp: 405-416.

Golab, L., T. Johnson and V. Shkapenyuk, 2009. Scheduling updates in a real-time stream warehouse. Proceedings of the 2009 IEEE 25th International Conference on Data Engineering (ICDE'09), March 29-April 2, 2009, IEEE, Shanghai, China, ISBN:978-1-4244-3422-0, pp: 1207-1210.

Hamdi, I., E. Bouazizi and J. Feki, 2014. Dynamic management of materialized views in real-time data warehouses. Proceedings of the 6th International Conference on Soft Computing and Pattern Recognition (SoCPaR’14), August 11-14, 2014, IEEE, Tunis, Tunisia, ISBN:978-1-4799-5935-8, pp: 168-173.

Hanson, E.N., 1987. A performance analysis of view materialization strategies. Proceedings of the 1987 ACM SIGMOD International Conference on Management of Data Vol. 16, May 27-29, 1987, ACM, San Francisco, California, ISBN:0-89791-236-5, pp: 440-453.

Harinarayan, V., A. Rajaraman and J. Ullman, 1996. Implementing data cubes efficiently. ACM SIGMOD Record, 25: 205-216.
CrossRef  |  

Hung, M.C., M.L. Huang, D.L. Yang and N.L. Hsueh, 2007. Efficient approaches for materialized views selection in a data warehouse. Inf. Sci., 177: 1333-1348.
Direct Link  |  

Kotidis, Y. and N. Roussopoulos, 1999. DynaMat: A dynamic view management system for data warehouses. Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data, May 31-June 03, 1999, ACM, Philadelphia, Pennsylvania, ISBN:1-58113-084-8, pp: 371-382.

Leng, F., Y. Bao, G. Yu, J. Shi and X. Cai, 2011. Requirement-based query and update scheduling in real-time data warehouses. Proceedings of the 12th International Conference on Web-Age Information Management (WAIM’11), September 14-16, 2011, Springer, Wuhan, China, pp: 379-389.

Nasir, J.A., M.A. Pasha and M.K. Shahzad, 2005. ESCM: Entity-subject conceptual modeling for data warehouse. Asia J. Inform. Technol., 4: 1093-1097.
Direct Link  |  

Ross, K.A., D. Srivastava and S. Sudarshan, 1996. Materialized view maintenance and integrity constraint checking: Trading space for time. Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, June 04-06, 1996, ACM, Montreal, Quebec, Canada, ISBN:0-89791-794-4, pp: 447-458.

Yeung, G.C. and W.A. Gruver, 2005. Multiagent immediate incremental view maintenance for data warehouses. IEEE. Trans. Syst. Man Cybern. Part A Syst. Hum., 35: 305-310.
CrossRef  |  Direct Link  |  

Zhou, L., Q. Shi and H. Geng, 2010. The minimum incremental maintenance of materialized views in data warehouse. Proceedings of the 2nd International Asia Conference on Informatics in Control, Automation and Robotics (CAR’10) Vol. 3, March 6-7, 2010, IEEE, Wuhan, China, ISBN:978-1-4244-5192-0, pp: 220-223.

Design and power by Medwell Web Development Team. © Medwell Publishing 2024 All Rights Reserved