Abstract
The issue of database schemas comparison and integration has been discussed in this paper. The research was connected with problems of database schemas integration that are maintained by various database management systems. This operation is often realized in programmers’ group work as well as in database administrators’ duties. Automation of this process will allow the avoidance of many mistakes and will increase efficiency of work. Fulfillment of these requirements entails transformation of mechanisms supported by one database management system to mechanisms existing in the other. To make this transformation possible and easy the universal object model was proposed in the research. This model contains database schemas read from given database management systems. Thanks to this, information can be compared without taking its derivation into consideration.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Automated Office Systems, Inc.: Automated office systems. dbcompare (2007), http://www.automatedofficesystems.com/products/dbcompare/
Fowler, M.: UML Distilled: A Brief Guide to the Standard Object Modeling Language. Addison-Wesley, Reading (2003)
Microsoft Corporation: Microsoft SQL Server Books Online (2008), http://msdn.microsoft.com/en-us/library/ms130214.aspx
Oracle: Oracle Database online documentation 10g Release 2, http://www.oracle.com/pls/db102/homepage
Randell, B.A.: Introducing Visual Studio 2005 Team Edition for database professionals (2007), http://msdn.microsoft.com/en-us/magazine/cc163472.aspx
Red Gate Software Ltd.: SQLCompare (2007), http://www.red-gate.com/products/SQL_Compare/index.htm
Troelsen, A.: Pro C# 2008 and the .NET 3.5 Platform. Apress (2007)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Budny, M., Harężlak, K. (2009). Usage of the Universal Object Model in Database Schemas Comparison and Integration. In: Cyran, K.A., Kozielski, S., Peters, J.F., Stańczyk, U., Wakulicz-Deja, A. (eds) Man-Machine Interactions. Advances in Intelligent and Soft Computing, vol 59. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-00563-3_59
Download citation
DOI: https://doi.org/10.1007/978-3-642-00563-3_59
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-00562-6
Online ISBN: 978-3-642-00563-3
eBook Packages: EngineeringEngineering (R0)