Home | Issues | Profile | History | Submission | Review

Vol: 51(65) No: 2 / June 2006         About Distributed Transactions across Microsoft SQL Server and Oracle Database Server Ioan Filip Dept. of Automation and Applied Informatics, “Politehnica” University of Timisoara, Faculty of Automation and Computer Science, 2 V. Parvan, 300223 Timisoara, Romania, phone: (+40) 0256-403238, e-mail: ioan.filip@aut.upt.ro, web: http://www.aut.upt.ro/~ifilip/ Keywords: database, SQL, distributed transactions, linked server, stored procedure, trigger. Abstract This paper presents issues regarding the performing of distributed transactions across two different database servers: Microsoft SQL Server and Oracle Database Server. The paper describes various possible solutions and technologies used to solve the problems that occur during such distributed transaction. Also, an efficient proposed method based on the technique of linked server is implemented. References [1] M.T. Oszu and P.Valduriez, “Principles of Distributed Database Systems”, Prentice Hall, New York, 1999. [2] L. Davidson, “Professional SQL Server 2000 Database Design”, Wrox Press, Birmingham, 2001. [3] R.M. Riordan, “ Microsoft® ADO.NET Step by Step”, Microsoft Press Books, Redmond U.S, 2002. [4] J.A. Romalho, “Learn Oracle 8i”, Wordware Publishing, 2000. [5] A.Datta and S. H. Son, “A Study of Concurrency Control in Real-Time Active Database Systems”, IEEE Transactions on Knowledge and Data Engineering. 14(3), pp.465-484, 2002. [6] http://msdn.microsoft.com/sql/.