Back to search

University of British Columbia

Query processor for the conceptual integration modeling framework

Abstract

dc:description

A data warehouse is a giant information pot made by integrating data from different data sources. Its schema can easily become complicated in order to hold all historical data. This complexity can confuse end users. The Conceptual Integration Modeling (CIM) framework was proposed to bridge the gap between users and the schema by adding a user-defined conceptual layer. This thesis aims to fulfill the query processor component in the CIM framework. Traditional query languages like SQL require a relatively tough learning curve, which is too dynamic for business users. Instead we propose a new CIM query language and a query interface to work with the visual representation of the CIM framework. This query interface only focuses on user needs and hides unnecessary implementation details to the back end. Thus, it is easy for business users to pose queries. In addition, we also do some optimization on the query processor by selecting views to materialize. Our proposed algorithm can achieve the lower performance bound of 46.7% of the optimal solution.

Degree

thesis:*
Name thesis:degree_name
Master of Science - MSc
Level thesis:degree_level
master's
Discipline thesis:degree_discipline
Computer Science
Grantor dc:publisher
University of British Columbia
Year dc:date
2012

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Chen, Zhaohong

Rights

dc:rights
Statement dc:rights
  • Attribution-NonCommercial-NoDerivatives 4.0 International
Language dc:language
eng

Identifiers

dc:identifier.*
Handle dc:identifier
http://hdl.handle.net/2429/40276

Chain of custody

source
Harvested from
University of British Columbia
Base URL
circle.library.ubc.ca/oai/request
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Chen, Zhaohong. Query processor for the conceptual integration modeling framework. master's thesis, University of British Columbia, 2012. http://hdl.handle.net/2429/40276