Semantic enrichment: the first phase of relational database migration

Abdelsalam Maatuk; Akhtar Ali; Nick Rossiter

doi:10.1007/978-90-481-3658-2_65

Semantic enrichment: the first phase of relational database migration

Abdelsalam Maatuk, Akhtar Ali, Nick Rossiter

Computer and Information Sciences Department

Research output: Contribution to conference › Paper › peer-review

14 Citations (Scopus)

Abstract

Semantic enrichment is a process of analyzing and examining a database to capture its structure and definitions at a higher level of meaning. This is done by enhancing a representation of an existing database’s structure in order to make hidden semantics explicit. In contrast to other approaches, we present an approach that takes an existing relational database as input, obtains a copy of its meta data and enriches it with as much semantics as possible, and constructs an enhanced Relational Schema Representation (RSR). Based on RSR, a Canonical Data Model (CDM) is generated,which captures essential characteristics of target databases (i.e., object-based and XML) suitable for migration. We have developed an algorithm for generating CDM from an enhanced relational representation of an input relational database.A prototype has been implemented and experimental results are reported.

Original language	English
DOIs	https://doi.org/10.1007/978-90-481-3658-2_65
Publication status	Published - 2009
Event	International Joint Conferences on Computer, Information and Systems Sciences and Engineering (CISSE '08) - University of Bridgeport, Connecticut, USA Duration: 1 Jan 2009 → … http://capitadiscovery.co.uk/northumbria-ac/items/1488373

Conference

Conference	International Joint Conferences on Computer, Information and Systems Sciences and Engineering (CISSE '08)
Period	1/01/09 → …
Internet address	http://capitadiscovery.co.uk/northumbria-ac/items/1488373

Access to Document

10.1007/978-90-481-3658-2_65

Cite this

@conference{cdd14bb4de9b4eb3be78bb4cb70da7a5,

title = "Semantic enrichment: the first phase of relational database migration",

abstract = "Semantic enrichment is a process of analyzing and examining a database to capture its structure and definitions at a higher level of meaning. This is done by enhancing a representation of an existing database{\textquoteright}s structure in order to make hidden semantics explicit. In contrast to other approaches, we present an approach that takes an existing relational database as input, obtains a copy of its meta data and enriches it with as much semantics as possible, and constructs an enhanced Relational Schema Representation (RSR). Based on RSR, a Canonical Data Model (CDM) is generated,which captures essential characteristics of target databases (i.e., object-based and XML) suitable for migration. We have developed an algorithm for generating CDM from an enhanced relational representation of an input relational database.A prototype has been implemented and experimental results are reported.",

author = "Abdelsalam Maatuk and Akhtar Ali and Nick Rossiter",

year = "2009",

doi = "10.1007/978-90-481-3658-2_65",

language = "English",

note = "International Joint Conferences on Computer, Information and Systems Sciences and Engineering (CISSE '08) ; Conference date: 01-01-2009",

url = "http://capitadiscovery.co.uk/northumbria-ac/items/1488373",

}

TY - CONF

T1 - Semantic enrichment: the first phase of relational database migration

AU - Maatuk, Abdelsalam

AU - Ali, Akhtar

AU - Rossiter, Nick

PY - 2009

Y1 - 2009

N2 - Semantic enrichment is a process of analyzing and examining a database to capture its structure and definitions at a higher level of meaning. This is done by enhancing a representation of an existing database’s structure in order to make hidden semantics explicit. In contrast to other approaches, we present an approach that takes an existing relational database as input, obtains a copy of its meta data and enriches it with as much semantics as possible, and constructs an enhanced Relational Schema Representation (RSR). Based on RSR, a Canonical Data Model (CDM) is generated,which captures essential characteristics of target databases (i.e., object-based and XML) suitable for migration. We have developed an algorithm for generating CDM from an enhanced relational representation of an input relational database.A prototype has been implemented and experimental results are reported.

AB - Semantic enrichment is a process of analyzing and examining a database to capture its structure and definitions at a higher level of meaning. This is done by enhancing a representation of an existing database’s structure in order to make hidden semantics explicit. In contrast to other approaches, we present an approach that takes an existing relational database as input, obtains a copy of its meta data and enriches it with as much semantics as possible, and constructs an enhanced Relational Schema Representation (RSR). Based on RSR, a Canonical Data Model (CDM) is generated,which captures essential characteristics of target databases (i.e., object-based and XML) suitable for migration. We have developed an algorithm for generating CDM from an enhanced relational representation of an input relational database.A prototype has been implemented and experimental results are reported.

U2 - 10.1007/978-90-481-3658-2_65

DO - 10.1007/978-90-481-3658-2_65

M3 - Paper

T2 - International Joint Conferences on Computer, Information and Systems Sciences and Engineering (CISSE '08)

Y2 - 1 January 2009

ER -

Semantic enrichment: the first phase of relational database migration

Abstract

Conference

Access to Document

Fingerprint

Cite this