{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,25]],"date-time":"2026-03-25T16:11:44Z","timestamp":1774455104645,"version":"3.50.1"},"reference-count":43,"publisher":"Elsevier BV","issue":"5","license":[{"start":{"date-parts":[[2001,7,1]],"date-time":"2001-07-01T00:00:00Z","timestamp":993945600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information Systems"],"published-print":{"date-parts":[[2001,7]]},"DOI":"10.1016\/s0306-4379(01)00025-4","type":"journal-article","created":{"date-parts":[[2002,10,14]],"date-time":"2002-10-14T17:55:05Z","timestamp":1034618105000},"page":"363-381","source":"Crossref","is-referenced-by-count":4,"title":["Detecting redundant materialized views in data warehouse evolution"],"prefix":"10.1016","volume":"26","author":[{"given":"Dimitri","family":"Theodoratos","sequence":"first","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/S0306-4379(01)00025-4_BIB1","series-title":"Building the Data Warehouse","author":"Inmon","year":"1996"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB2","doi-asserted-by":"crossref","unstructured":"J. Widom, Research problems in data warehousing, Proceedings of the Fourth International Conference on Information and Knowledge Management, 1995, pp. 25\u201330.","DOI":"10.1145\/221270.221319"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB3","doi-asserted-by":"crossref","unstructured":"A. Levy, A.O. Mendelson, Y. Sagiv, D. Srivastava, Answering queries using views, Proceedings of the ACM Symposium on Principles of Database Systems, 1995, pp. 95\u2013104.","DOI":"10.1145\/212433.220198"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB4","doi-asserted-by":"crossref","unstructured":"A. Gupta, I.S. Mumick, V.S. Subrahmanian, Maintaining views incrementally, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1993, pp. 157\u2013166.","DOI":"10.1145\/170035.170066"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB5","doi-asserted-by":"crossref","unstructured":"T. Griffin, L. Libkin, Incremental maintenance of views with duplicates, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1995, pp. 328\u2013339.","DOI":"10.1145\/223784.223849"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB6","doi-asserted-by":"crossref","unstructured":"Y. Zhuge, H. Garcia-Molina, J. Hammer, J. Widom, View maintenance in a warehousing environment, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1995, pp. 316\u2013327.","DOI":"10.1145\/223784.223848"},{"issue":"1","key":"10.1016\/S0306-4379(01)00025-4_BIB7","doi-asserted-by":"crossref","first-page":"23","DOI":"10.1145\/42201.42203","article-title":"Multiple query optimization","volume":"13","author":"Sellis","year":"1988","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB8","doi-asserted-by":"crossref","first-page":"197","DOI":"10.1016\/0169-023X(94)90014-0","article-title":"Improvements on a heuristic algorithm for multiple-query optimization","volume":"12","author":"Shim","year":"1994","journal-title":"Data Knowledge Eng."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB9","series-title":"Query Processing in DB Systems","first-page":"191","article-title":"Common subexpression isolation in multiple query optimization","author":"Jarke","year":"1985"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB10","doi-asserted-by":"crossref","unstructured":"K.A. Ross, D. Srivastava, S. Sudarshan, Materialized view maintenance and integrity constraint checking: trading space for time, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1996, pp. 447\u2013458.","DOI":"10.1145\/233269.233361"},{"issue":"3","key":"10.1016\/S0306-4379(01)00025-4_BIB11","doi-asserted-by":"crossref","first-page":"279","DOI":"10.1016\/S0169-023X(99)00029-4","article-title":"Designing data warehouses","volume":"31","author":"Theodoratos","year":"1999","journal-title":"Data Knowledge Eng."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB12","doi-asserted-by":"crossref","unstructured":"A. Gupta, H.V. Jagadish, I.S. Mumick, Data integration using self-maintainable views, Proceedings of the Fifth International Conference on Extending Database Technology, 1996, pp. 140\u2013144.","DOI":"10.1007\/BFb0014149"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB13","doi-asserted-by":"crossref","unstructured":"R. Hull, Gang Zhou, A framework for supporting data integration using the materialized and virtual approaches, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1996, pp. 481\u2013492.","DOI":"10.1145\/233269.233365"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB14","doi-asserted-by":"crossref","unstructured":"D. Quass, A. Gupta, I.S. Mumick, J. Widom, Making views self maintainable for data warehousing, Proceedings of the Fourth International Conference on Parallel and Distributed Information Systems, 1996, pp. 158\u2013169.","DOI":"10.1109\/PDIS.1996.568677"},{"issue":"1","key":"10.1016\/S0306-4379(01)00025-4_BIB15","doi-asserted-by":"crossref","first-page":"7","DOI":"10.1023\/A:1008773527263","article-title":"Incremental design of a data warehouse","volume":"15","author":"Theodoratos","year":"2000","journal-title":"J. Intell. Inform. Systems"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB16","doi-asserted-by":"crossref","unstructured":"S. Chaudhuri, R. Krishnamurthy, S. Potamianos, K. Shim, Optimizing queries with materialized views, Proceedings of the 11th International Conference on Data Engineering, 1995, pp. 190\u2013200.","DOI":"10.1109\/ICDE.1995.380392"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB17","doi-asserted-by":"crossref","unstructured":"A. Segev, W. Fang, Currency-based updates to distributed materialized views, Proceedings of the Sixth International Conference on Data Engineering, 1990, pp. 512\u2013520.","DOI":"10.1109\/ICDE.1990.113505"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB18","unstructured":"D. Theodoratos, M. Bouzeghoub, Data currency quality factors in data warehouse design, Proceedings of the International Workshop on Design and Management of Data Warehouses, Germany, 1999, pp. 15\/1\u201316."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB19","doi-asserted-by":"crossref","DOI":"10.1109\/MC.1986.1663124","article-title":"Principles and techniques in the design of ADMS\u00b1","author":"Roussopoulos","year":"1986","journal-title":"Computer"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB20","doi-asserted-by":"crossref","unstructured":"E. Hanson, A performance analysis of view materialization strategy, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1987, pp. 440\u2013453.","DOI":"10.1145\/38713.38759"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB21","unstructured":"A. Gupta, V. Harinarayan, D. Quass, Aggregate-query processing in data warehousing environments, Proceedings of the 21st International Conference on Very Large Data Bases, 1995, pp. 358\u2013369."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB22","unstructured":"Shaul Dar, H.V. Jagadish, A.Y. Levy, D. Srivastava, Answering SQL queries with aggregation using views, Proceedings of the 22nd International Conference on Very Large Data Bases, 1996, pp. 318\u2013329."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB23","doi-asserted-by":"crossref","unstructured":"A. Gupta, I.S. Mumick, K. Ross, Adapting materialized views after redefinitions, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1995, pp. 211\u2013222.","DOI":"10.1145\/223784.223817"},{"issue":"2","key":"10.1016\/S0306-4379(01)00025-4_BIB24","first-page":"3","article-title":"Maintenance of materialized views: problems, techniques and applications","volume":"18","author":"Gupta","year":"1995","journal-title":"Data Eng."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB25","doi-asserted-by":"crossref","unstructured":"V. Harinarayan, A. Rajaraman, J.D. Ullman, Implementing data cubes efficiently, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1996.","DOI":"10.1145\/233269.233333"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB26","doi-asserted-by":"crossref","unstructured":"H. Gupta, Selection of views to materialize in a data warehouse, Proceedings of the Sixth International Conference on Database Theory, 1997, pp. 98\u2013112.","DOI":"10.1007\/3-540-62222-5_39"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB27","unstructured":"J. Yang, K. Karlapalem, Q. Li, Algorithms for materialized view design in data warehousing environment, Proceedings of the 23rd International Conference on Very Large Data Bases, 1997, pp. 136\u2013145."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB28","doi-asserted-by":"crossref","unstructured":"H. Gupta, I.S. Mumick, Selection of views to materialize under a maintenance cost constraint, Proceedings of the Seventh International Conference on Database Theory, 1999, pp. 453\u2013470.","DOI":"10.1007\/3-540-49257-7_28"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB29","unstructured":"D. Theodoratos, T. Sellis, Data warehouse configuration, Proceedings of the 23rd International Conference on Very Large Data Bases, 1997, pp. 126\u2013135."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB30","doi-asserted-by":"crossref","unstructured":"D. Theodoratos, S. Ligoudistianos, T. Sellis, Designing the global data warehouse with SPJ views, Proceedings of the 11th International Conference on Advanced Information Systems Engineering, Springer, Lecture Notes in Computer Science, Vol. 1626, 1999, pp. 180\u2013194.","DOI":"10.1007\/3-540-48738-7_14"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB31","doi-asserted-by":"crossref","unstructured":"Y. Kotidis, N. Roussopoulos, DynaMat: a dynamic view management system for data warehouses, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1999, pp. 371\u2013382.","DOI":"10.1145\/304182.304215"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB32","doi-asserted-by":"crossref","unstructured":"D. Theodoratos, Detecting redundancy in data warehouse evolution, Proceedings of the 18th International Conference on Conceptual Modeling, Springer Lecture Notes in Computer Science, Vol. 1728, Springer, Berlin, 1999, pp. 340\u2013353.","DOI":"10.1007\/3-540-47866-3_23"},{"issue":"3","key":"10.1016\/S0306-4379(01)00025-4_BIB33","doi-asserted-by":"crossref","first-page":"369","DOI":"10.1145\/68012.68015","article-title":"Updating derived relations: detecting irrelevant and autonomously computable updates","volume":"14","author":"Blakeley","year":"1989","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB34","unstructured":"A.Y. Levy, Y. Sagiv, Queries independent of updates, Proceedings of the 19th International Conference on Very Large Data Bases, 1993, pp. 171\u2013181."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB35","doi-asserted-by":"crossref","unstructured":"J.A. Blakeley, P. Larson, F.W. Tompa, Efficiently updating materialized views, Proceedings of the ACM SIGMOD International Conference on Management of Data, 1986, pp. 61\u201371.","DOI":"10.1145\/16894.16861"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB36","unstructured":"S. Ceri, J. Widom, Deriving production rules for incremental view maintenance, Proceedings of the International Conference on Very Large Data Bases, 1991, pp. 577\u2013589."},{"issue":"2","key":"10.1016\/S0306-4379(01)00025-4_BIB37","doi-asserted-by":"crossref","first-page":"173","DOI":"10.1109\/69.87958","article-title":"Updating distributed materialized views","volume":"1","author":"Segev","year":"1989","journal-title":"IEEE Trans. Knowledge Data Eng."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB38","unstructured":"D. Quass, Maintenance expressions for views with aggregation, Workshop on Materialized Views: Techniques and Applications, 1996, pp. 110\u2013118."},{"issue":"2","key":"10.1016\/S0306-4379(01)00025-4_BIB39","doi-asserted-by":"crossref","first-page":"258","DOI":"10.1145\/319702.319729","article-title":"View indexing in relational databases","volume":"7","author":"Roussopoulos","year":"1982","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB40","doi-asserted-by":"crossref","unstructured":"G. Graefe, W.J. McKenna, The volcano optimizer generator: extensibility and efficient search, Proceedings of the Ninth International Conference on Data Engineering, 1993, pp. 209\u2013217.","DOI":"10.1109\/ICDE.1993.344061"},{"key":"10.1016\/S0306-4379(01)00025-4_BIB41","doi-asserted-by":"crossref","unstructured":"W. Yan, P.-\u00c5. Larson, Performing group-by before join, Proceedings of the 10th International Conference on Data Engineering, 1994, pp. 89\u2013100.","DOI":"10.1109\/ICDE.1994.283001"},{"issue":"2","key":"10.1016\/S0306-4379(01)00025-4_BIB42","doi-asserted-by":"crossref","first-page":"563","DOI":"10.1109\/TSE.1982.235886","article-title":"The logical access path schema of a database","volume":"8","author":"Roussopoulos","year":"1982","journal-title":"IEEE Trans. Software Eng."},{"key":"10.1016\/S0306-4379(01)00025-4_BIB43","unstructured":"M.O. Akinde, M.H. B\u00f6hlen, Constructing GPSJ view graphs, Proceedings of the International Workshop on Design and Management of Data Warehouses, Germany, 1999, pp. 8\/1\u201312."}],"container-title":["Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0306437901000254?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0306437901000254?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2024,12,5]],"date-time":"2024-12-05T11:59:16Z","timestamp":1733399956000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0306437901000254"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2001,7]]},"references-count":43,"journal-issue":{"issue":"5","published-print":{"date-parts":[[2001,7]]}},"alternative-id":["S0306437901000254"],"URL":"https:\/\/doi.org\/10.1016\/s0306-4379(01)00025-4","relation":{},"ISSN":["0306-4379"],"issn-type":[{"value":"0306-4379","type":"print"}],"subject":[],"published":{"date-parts":[[2001,7]]}}}