Algorithms for materialized view design in data warehousing environment