Oracle 9i Rated Better Than SQL Server By .NET Developer

Mark Rittman -

Frank Bouma's a .Net developer who normally works with Microsoft SQL Server. However, he's recently had to support Oracle 9i for a project he's working on, and his verdict: "Oracle 9i is amazing". According to Frank,

"What impressed me was Oracle's feature set. Looking at that feature-set you can only conclude: what Oracle 9i offers today is generations ahead of SqlServer 2000 and we (that is, the .NET developers) can only hope Yukon gives us what Oracle 9i already offers."

So what are the features in 9i that caught his attention?

  • Sequences, because they're an object quite separate from the table DDL and therefore they're more flexible;
  • Multi-Version Concurrency Control, which ensures tables are modified in a way that doesn't block threads and avoids potential deadlocks;
  • The concept of schemas, rather than the system of logins and users SQL Server uses;
  • Truly User Definable Data Types, which ironically is a requirement for .NET that SQL Server doesn't meet.