NDLI logo
  • Content
  • Similar Resources
  • Metadata
  • Cite This
  • Log-in
  • Fullscreen
Log-in
Do not have an account? Register Now
Forgot your password? Account recovery
  1. Proceedings of the 9th ACM international workshop on Data warehousing and OLAP (DOLAP '06)
  2. Computing closest common subexpressions for view selection problems
Loading...

Please wait, while we are loading the content...

Formal specification and optimization of ETL scenarios
Enhanced mining of association rules from data cubes
Building a web warehouse for accessibility data
Designing ETL processes using semantic web technologies
Research in data warehouse modeling and design: dead or alive?
HYPE: mining hierarchical sequential patterns
Designing what-if analysis: towards a methodology
Computing closest common subexpressions for view selection problems
A study on workload-aware wavelet synopses for point and range-sum queries
Triple-driven data modeling methodology in data warehousing: a case study
Towards a logical multidimensional model for spatial data warehousing and OLAP
Pre-aggregation with probability distributions
Heuristic design of property maps

Similar Documents

...
Re-Optimization MVPP Using Common Subexpression for Materialized View Selection

Article

...
Constructing search spaces for materialized view selection

Article

...
Common subexpression processing in multiple-query processing (1998).

...
Materialized view selection and maintenance using multi-query optimization (2001)

...
Accommodating scalability in warehouse view selection problem using partial combined cube lattice*.

Article

...
Designing the Global Data Warehouse with SPJ Views (1999)

Article

...
Designing the Global Data Warehouse with SPJ Views (1999)

Article

...
Common-subexpression elimination of conditional expressions (2001).

...
Exploiting common subexpressions for cloud query processing.

Article

Computing closest common subexpressions for view selection problems

Content Provider ACM Digital Library
Author Xu, Wugang Zuzarte, Calisto Theodoratos, Dimitri
Abstract Selecting a set of views for materialization is a required task in many current database and data warehousing applications including the design of a data warehouse, and the maintenance of multiple materialized views. The selected views can be materialized permanently or transiently depending on the specific view selection problem. The view selection algorithms are expensive due to the size of the search space of the problem.In this paper we propose an approach for generating candidate views for materialization for view selection problems based on the definition of the input queries. We also provide rewritings of the input queries using the generated candidate views. In generating candidate views, we do not apply costbased techniques but we try to maximize the operations in the views. Subsequently, view selection algorithms can exploit problem dependent cost functions to choose among the generated candidate views. Our approach is not restricted to a specific view selection problem. Compared to a previous one, it generates views that involve more relation occurrences (or operations) and can reduce the size of the search space which can be very large. We implement our approach and we report some experimental evaluation with comparison to previous works.
Starting Page 75
Ending Page 82
Page Count 8
File Format PDF
ISBN 1595935304
DOI 10.1145/1183512.1183527
Language English
Publisher Association for Computing Machinery (ACM)
Publisher Date 2006-11-10
Publisher Place New York
Access Restriction Subscribed
Subject Keyword Common subexpression Query graph View selection Data warehouse
Content Type Text
Resource Type Article
  • About
  • Disclaimer
  • Feedback
  • Sponsor
  • Contact
  • Chat with Us
About National Digital Library of India (NDLI)
NDLI logo

National Digital Library of India (NDLI) is a virtual repository of learning resources which is not just a repository with search/browse facilities but provides a host of services for the learner community. It is sponsored and mentored by Ministry of Education, Government of India, through its National Mission on Education through Information and Communication Technology (NMEICT). Filtered and federated searching is employed to facilitate focused searching so that learners can find the right resource with least effort and in minimum time. NDLI provides user group-specific services such as Examination Preparatory for School and College students and job aspirants. Services for Researchers and general learners are also provided. NDLI is designed to hold content of any language and provides interface support for 10 most widely used Indian languages. It is built to provide support for all academic levels including researchers and life-long learners, all disciplines, all popular forms of access devices and differently-abled learners. It is designed to enable people to learn and prepare from best practices from all over the world and to facilitate researchers to perform inter-linked exploration from multiple sources. It is developed, operated and maintained from Indian Institute of Technology Kharagpur.

Learn more about this project from here.

Disclaimer

NDLI is a conglomeration of freely available or institutionally contributed or donated or publisher managed contents. Almost all these contents are hosted and accessed from respective sources. The responsibility for authenticity, relevance, completeness, accuracy, reliability and suitability of these contents rests with the respective organization and NDLI has no responsibility or liability for these. Every effort is made to keep the NDLI portal up and running smoothly unless there are some unavoidable technical issues.

Feedback

Sponsor

Ministry of Education, through its National Mission on Education through Information and Communication Technology (NMEICT), has sponsored and funded the National Digital Library of India (NDLI) project.

Contact National Digital Library of India
Central Library (ISO-9001:2015 Certified)
Indian Institute of Technology Kharagpur
Kharagpur, West Bengal, India | PIN - 721302
See location in the Map
03222 282435
Mail: support@ndl.gov.in
Sl. Authority Responsibilities Communication Details
1 Ministry of Education (GoI),
Department of Higher Education
Sanctioning Authority https://www.education.gov.in/ict-initiatives
2 Indian Institute of Technology Kharagpur Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project https://www.iitkgp.ac.in
3 National Digital Library of India Office, Indian Institute of Technology Kharagpur The administrative and infrastructural headquarters of the project Dr. B. Sutradhar  bsutra@ndl.gov.in
4 Project PI / Joint PI Principal Investigator and Joint Principal Investigators of the project Dr. B. Sutradhar  bsutra@ndl.gov.in
Prof. Saswat Chakrabarti  will be added soon
5 Website/Portal (Helpdesk) Queries regarding NDLI and its services support@ndl.gov.in
6 Contents and Copyright Issues Queries related to content curation and copyright issues content@ndl.gov.in
7 National Digital Library of India Club (NDLI Club) Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach clubsupport@ndl.gov.in
8 Digital Preservation Centre (DPC) Assistance with digitizing and archiving copyright-free printed books dpc@ndl.gov.in
9 IDR Setup or Support Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops idr@ndl.gov.in
I will try my best to help you...
Cite this Content
Loading...