Canada Spends Logo

Explore our Budget 2026 analysis

Grant: Discovery Grants Program - Individual

Memorial University of Newfoundland

$15,000.00

Information use in database integration processes

FY 2012-13

Summary
Database integration is an increasingly important research area: Information systems development requires integrating existing systems and their databases; data warehousing requires the integration of data from multiple transaction processing systems for decision support; electronic business between organizations requires the integration of trade partners' business data for efficient business processes and communication; inter-agency information sharing in e-government requires integration of citizen data. Thus, improvements in database integration techniques have a wide range of applications and can benefit a variety of users. Database integration is a process with multiple steps, leading from the identification of the databases to the testing of the integrated system. The central step of this process is the identification of database elements that are similar to each other. This step is called schema matching. Human users perceive schema matching methods as successful when they match database elements according to the same similarity criteria that the users would apply. Many automatic software-supported schema matching methods have been proposed, using a range of different notions of similarity. However, existing research has paid little attention to empirical work: There is little knowledge of how human data integrators judge the similarity of database elements. A recent study has shown that a ""one-size-fits-all"" approach does not apply and that human notions of similarity are strongly affected by the database integration context. The proposed research is a study to systematically examine how human database integrators carry out schema matching. It will identify how context influences the schema matching process and outcomes. This knowledge will then be applied to implement a context-aware schema matching method. Context information is important to schema matching, but has been neglected by existing research. The use of context information in schema matching can have benefits to research and practice in areas such as information systems development, data warehousing, e-commerce, and e-government.
Program
Discovery Grants Program - Individual
Location
Newfoundland and Labrador, Canada
Recipient Type
Academia
Type
Grant
Source
NSERC's Awards Data

As published

Application id
355569-2008
Name nom
Evermann, Jorg
Department département
Business Administration, Faculty of
Organization id
89
Institution établissement
Memorial University of Newfoundland
Province en
Newfoundland and Labrador
Province fr
Terre-Neuve-et-Labrador
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2012
Competition year année de concours
2008
Award amount
15000
Program id
RGPIN
Program name en
Discovery Grants Program - Individual
Program name fr
Programme de subventions à la découverte - individuelles
Group en
Discovery grants programs
Group fr
Programmes de subventions à la découverte
Committee code
330
Committee name en
Computing and Information Sciences - A
Committee name fr
Informatique - A
Area of application code
802
Area of application group en
Information and communication services
Area of application group fr
Services d'information et de télécommunications
Area of application en
Information systems and technology
Area of application fr
Systèmes d'information et technologie de l'information
Research subject code
2711
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Database management
Research subject fr
Gestion de bases de données
Partie
5
Nb partie
5
Application title
Information use in database integration processes
Keyword
NSERC
Application summary
Database integration is an increasingly important research area: Information systems development requires integrating existing systems and their databases; data warehousing requires the integration of data from multiple transaction processing systems for decision support; electronic business between organizations requires the integration of trade partners' business data for efficient business processes and communication; inter-agency information sharing in e-government requires integration of citizen data. Thus, improvements in database integration techniques have a wide range of applications and can benefit a variety of users. Database integration is a process with multiple steps, leading from the identification of the databases to the testing of the integrated system. The central step of this process is the identification of database elements that are similar to each other. This step is called schema matching. Human users perceive schema matching methods as successful when they match database elements according to the same similarity criteria that the users would apply. Many automatic software-supported schema matching methods have been proposed, using a range of different notions of similarity. However, existing research has paid little attention to empirical work: There is little knowledge of how human data integrators judge the similarity of database elements. A recent study has shown that a ""one-size-fits-all"" approach does not apply and that human notions of similarity are strongly affected by the database integration context. The proposed research is a study to systematically examine how human database integrators carry out schema matching. It will identify how context influences the schema matching process and outcomes. This knowledge will then be applied to implement a context-aware schema matching method. Context information is important to schema matching, but has been neglected by existing research. The use of context information in schema matching can have benefits to research and practice in areas such as information systems development, data warehousing, e-commerce, and e-government.