Abstract
This paper investigates factors such as the use of both attributes and tuples specified in the criteria of a structured query language query and their influence on the response time of a query in a data warehouse environment. To handle queries by using redundant data structures such as materialised views has already been will established by the pioneers in the data warehouse industry. With the availability of very large data storage today, redundant data structures are no longer a big issue. However, an intelligent way of managing materialised views that can lead to fast access of data is the central issue dealt with in this paper.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Agrawal, S., Chaudhuri, S., Narasayya, V.: Automated Selection of Materialized Views and Indexes for SQL Databases. In: Proceedings of the 26th International Conference on Very Large Databases. Morgan Kaufmann, San Francisco (2000)
Bellatreche, L., Karlapalem, K., Mohania, M.: Some Issues in Design of Data Warehouse Systems. In: Becker, S.A. (ed.) Some Issues in Design of Data Warehouse Systems, pp. 125–172. Ideas Group Publishing, Western Hemisphere (2001)
Transaction Processing Performance Council, TPC-H. Available from World Wide Web, http://www.tpc.org/tpch/default.asp (last modified: February 24, 2003)
Ferguson, et al.: An application of data mining for product design. IEE Colloquium on Knowledge Discovery and Data Mining, 5/1–5/5 (1998)
Ogilvie, et al.: Use of data mining techniques in the performance monitoring and optimisation of a thermal power plant. IEE Colloquium on Knowledge Discovery and Data Mining, 7/1–7/4 (1998)
Steele, et al.: Knowledge discovery in medical databases: what factors influence a successful bone marrow transplant for Hodgkin’s disease. IEE Colloquium on Knowledge Discovery and Data Mining, 3/1–3/8 (1998)
Harinarayan, V., Rajaraman, A., Ullman, J.: Implementing Data Cubes Efficiently. ACM Press, New York (1996)
Ross, K.A., Li, Z.: Fast Joins Using Join Indices. The VLDB Journal 8(1), 1–24 (1999)
Claussen, et al.: Exploiting early sorting and early partitioning for decision support query processing. The VLDB Journal 9(3), 190–213 (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Teh, Y.W., Zaitun, A.B. (2004). Data Mining Techniques in Materialised Project and Selection View. In: Liew, KM., Shen, H., See, S., Cai, W., Fan, P., Horiguchi, S. (eds) Parallel and Distributed Computing: Applications and Technologies. PDCAT 2004. Lecture Notes in Computer Science, vol 3320. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30501-9_9
Download citation
DOI: https://doi.org/10.1007/978-3-540-30501-9_9
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-24013-6
Online ISBN: 978-3-540-30501-9
eBook Packages: Computer ScienceComputer Science (R0)