Research is Our Business

The goal of the NSERC Business Intelligence Network is to create an innovation platform for pre-competitive research in Business Intelligence in Canada. NSERC BIN aims to enhance Canadian business competitiveness through the development of intelligent data management and decision-making solutions. Business Intelligence has to move from the silos of finance, accounting, marketing, customer care and inventory management to become an integral part of business operations, driving business decisions using information sources across the entire corporation. Complex organizations are in need of knowledge-management solutions that are more comprehensive than the existing patchwork of data and content management systems currently available. There is a critical need for a business knowledge management architecture where corporate objectives, processes, metadata, and data are linked through organizational and operational objectives.

The NSERC BIN research team consists of 15 investigators at seven universities (University of Alberta, University of British Columbia, Carleton University, Dalhousie University, University of Ottawa, University of Toronto, and University of Waterloo). Investigators are working in partnership with researchers at a number of organizations including SAP Canada Inc., IBM Canada Limited, iAnywhere Solutions Canada Ltd., Palomino System Innovations Inc. and Zerofootprint.

Inconsistency Handling in Datawarehouses and Multidimensional Databases

Multidimensional Databases (MDDBs) are subject to special semantic constraints that are not found in classical relational databases. This is the case, for example, of constraints on the navigational and summarizability properties of the database. This project investigates several problems around data quality and data cleaning in multidimensional databases, and datawarehouses in particular, that are caused by violations of those constraints.

Continued

Rachel Pottinger

Rachel is an Assistant Professor in the Department of Computer Science at the University of British Columbia. Her research centers on both how data can be managed in situations where there are multiple databases and how to manage data that is curently  not well supported by databases.

Learn more