Skip to main content
SpringerLink
Log in

Data Mining Techniques in Materialised Project and Selection View

  • Conference paper
Parallel and Distributed Computing: Applications and Technologies (PDCAT 2004)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 3320))

  • 779 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

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)

    Google Scholar 

  • 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)

    Google Scholar 

  • 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)

    Google Scholar 

  • 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)

    Google Scholar 

  • 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)

    Google Scholar 

  • Harinarayan, V., Rajaraman, A., Ullman, J.: Implementing Data Cubes Efficiently. ACM Press, New York (1996)

    Google Scholar 

  • Ross, K.A., Li, Z.: Fast Joins Using Join Indices. The VLDB Journal 8(1), 1–24 (1999)

    Article  Google Scholar 

  • Claussen, et al.: Exploiting early sorting and early partitioning for decision support query processing. The VLDB Journal 9(3), 190–213 (2000)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Faculty of Computer Science and Information Technology, University of Malaya, 50603, Kuala Lumpur, Malaysia

    Ying Wah Teh & Abu Bakar Zaitun

Authors
  1. Ying Wah Teh
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Abu Bakar Zaitun
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Nanyang Centre for Supercomputing and Visualisation School of Mechanical and Production Engineering, Nanyang Technological University, 50 Nanyang Avenue, 639 798, Singapore

    Kim-Meow Liew

  2. School of Computer Science, The University of Adelaide,  

    Hong Shen

  3. Asia Pacific Science and Technology Center, Sun Microsystems Inc., 50 Nanyang Avenue, N3-1c-10, 639798, Singapore

    Simon See

  4. School of Computer Engineering, Nanyang Technological University, 639798, Singapore

    Wentong Cai

  5. Southwest Jiaotong University,  

    Pingzhi Fan

  6. Tohoku University ,  

    Susumu Horiguchi

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation