Skip to main content

Semantic Enrichment: The First Phase of Relational Database Migration

  • Conference paper
  • First Online:
Innovations and Advances in Computer Sciences and Engineering

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. A.Abelló,M.Oliva,M. E.Rodríguezand F.Saltor,The Syntax of BLOOM99 Schemas, TR LSI-99-34-R Dept LSI,1999.

    Google Scholar 

  2. R.Alhajj,”Extracting theextendedentity-relationshipmodel from alegacyrelationaldatabase,”Inf. Syst.vol.28,pp.597–618, 2003.

    Article  MATH  Google Scholar 

  3. M.Andersson, “Extracting anentityrelationshipschema from arelationaldatabase throughreverseengineering,” in13thint.conf. on the ERapproach,pp.403–419, 1994.

    Google Scholar 

  4. M. Carey,et al.,”TheBUCKYobject-relational benchmark,”SIGMOD Rec, vol. 26,pp. 135–146, 1997.

    Article  Google Scholar 

  5. M.Castellanos,F.Saltorand M.García-Solaco, “Semanticallyenrichingrelationaldatabases into anobjectorientedsemanticmodel,” inDEXA,pp.125–134, 1994.

    Google Scholar 

  6. 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.

    Article  Google Scholar 

  7. 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.

    Article  MATH  Google Scholar 

  8. 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.

    Google Scholar 

  9. W.Du,M.Li,L.Tokand W.Ling, “XML structures forrelational data,”WISE, vol.1, pp.151–160, 2001.

    Google Scholar 

  10. 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.

    Article  MATH  Google Scholar 

  11. J.Fongand S. K.Cheung, “Translatingrelationalschema into XML schema definition withdata semanticpreservation and XSDgraph,”Inf. & Soft. Tech., vol. 47, pp.437–4622005.

    Article  Google Scholar 

  12. U.Hohensteinand V.Plesser, “Semanticenrichment: A firststep to providedatabase interoperability,”WorkshopFderierte Datenbanken,pp.3–17, 1996.

    Google Scholar 

  13. A. Maatuk,M.A. Ali, and N. Rossiter,”Relational database migration: A perspective,” inDEXA, vol. 5181, pp. 676–6832008.

    Google Scholar 

  14. 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.

  15. 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.

  16. 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.

  17. E.Marcos,B.Velaand J. M.Cavero, “Extending UML forobjectrelationaldatabase design,”in4th int.conf. on theunifiedmodelinglanguage, vol.2185, pp.225–239, 2001.

    Google Scholar 

  18. W. J.Premerlaniand M. R.Blaha, “Anapproach for reverseengineering ofrelationaldatabases,”Commun. ACM, vol.37, pp.42–49, 1994.

    Article  Google Scholar 

  19. F.Saltor, M.Castellanosand M.García-Solaco “Suitability of datamodels ascanonicalmodels for federateddatabases,”SIGMOD,vol.20,pp.44–48, 1991.

    Article  Google Scholar 

  20. B.Vela and E. Marcos, “Extending UML to represent XML schemas,”CAiSEshort paper proceedings, 2003.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to M. Abdelsalam Maatuk .

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics