Abstract
Semanticenrichment 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 targetdatabases(i.e., object-based and XML) suitablefor migration.We have developed an algorithm for generatingCDM from an enhanced relational representation of an input relational database.Aprototype has been implementedandexperimentalresultsare reported.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
A.Abelló,M.Oliva,M. E.Rodríguezand F.Saltor,The Syntax of BLOOM99 Schemas, TR LSI-99-34-R Dept LSI,1999.
R.Alhajj,”Extracting theextendedentity-relationshipmodel from alegacyrelationaldatabase,”Inf. Syst.vol.28,pp.597–618, 2003.
M.Andersson, “Extracting anentityrelationshipschema from arelationaldatabase throughreverseengineering,” in13thint.conf. on the ERapproach,pp.403–419, 1994.
M. Carey,et al.,”TheBUCKYobject-relational benchmark,”SIGMOD Rec, vol. 26,pp. 135–146, 1997.
M.Castellanos,F.Saltorand M.García-Solaco, “Semanticallyenrichingrelationaldatabases into anobjectorientedsemanticmodel,” inDEXA,pp.125–134, 1994.
R.Chiang,T.Barronand V. C.Storey,”Reverseengineering ofrelationaldatabases: Extraction of an EERmodel from a relationaldatabase,”Data Knowl. Eng, vol.12, pp.107–142, 1994.
R. Chiang, T. Barron and V. C. Storey, “A framework for the design and evaluation of reverse engineering methods for relational databases,”Data Knowl. Eng., vol. 21, pp. 57–77, 1996.
G.Dobbie,X.Wu,T.Lingand M.Lee,ORA-SS: Object-Relationship-Attribute Model for Semistructured Data,TR 21/00 National University of Singapore,2001.
W.Du,M.Li,L.Tokand W.Ling, “XML structures forrelational data,”WISE, vol.1, pp.151–160, 2001.
C. Fahrner and G. Vossen, “A survey of database design transformations based on the Entity-Relationship model,”Data Knowl.Eng.,vol. 15,pp. 213–250,1995.
J.Fongand S. K.Cheung, “Translatingrelationalschema into XML schema definition withdata semanticpreservation and XSDgraph,”Inf. & Soft. Tech., vol. 47, pp.437–4622005.
U.Hohensteinand V.Plesser, “Semanticenrichment: A firststep to providedatabase interoperability,”WorkshopFderierte Datenbanken,pp.3–17, 1996.
A. Maatuk,M.A. Ali, and N. Rossiter,”Relational database migration: A perspective,” inDEXA, vol. 5181, pp. 676–6832008.
A. Maatuk,M.A. Ali, and N. Rossiter,Relational database migration:AnEvaluation,Technical report,http://computing.unn.ac.uk/staff/cgma2/papers/Migper.pdf, 2008.
A. Maatuk,M.A. Ali, and N. Rossiter, “An integrated approach to relational database migration,” inIC-ICT2008, 6 pp, in press,http://computing.unn.ac.uk/staff/cgma2/papers/icict08.pdf, 2008.
A. Maatuk, M. A. Ali, and N. Rossiter,Aframeworkfor relational database migration,Technical report,http://computing.unn.ac.uk/staff/cgma2/papers/RDBM.pdf,2008.
E.Marcos,B.Velaand J. M.Cavero, “Extending UML forobjectrelationaldatabase design,”in4th int.conf. on theunifiedmodelinglanguage, vol.2185, pp.225–239, 2001.
W. J.Premerlaniand M. R.Blaha, “Anapproach for reverseengineering ofrelationaldatabases,”Commun. ACM, vol.37, pp.42–49, 1994.
F.Saltor, M.Castellanosand M.García-Solaco “Suitability of datamodels ascanonicalmodels for federateddatabases,”SIGMOD,vol.20,pp.44–48, 1991.
B.Vela and E. Marcos, “Extending UML to represent XML schemas,”CAiSEshort paper proceedings, 2003.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer Science+Business Media B.V.
About this paper
Cite this paper
Abdelsalam Maatuk, M., Ali, A., Rossiter, N. (2010). Semantic Enrichment: The First Phase of Relational Database Migration. In: Sobh, T. (eds) Innovations and Advances in Computer Sciences and Engineering. Springer, Dordrecht. https://doi.org/10.1007/978-90-481-3658-2_65
Download citation
DOI: https://doi.org/10.1007/978-90-481-3658-2_65
Published:
Publisher Name: Springer, Dordrecht
Print ISBN: 978-90-481-3657-5
Online ISBN: 978-90-481-3658-2
eBook Packages: EngineeringEngineering (R0)