News

Survey Shows 60 Percent of Organizations Plan Database Upgrades in 2010-11

Database developers may be more in demand for the next year or so, judging from a new survey of 450 organizations worldwide about their database deployment plans.

That’s because more companies may be forced into infrastructure upgrades to remain competitive after 2-1/2 years of a severe economic slump, according to survey results released today by Information Technology Intelligence Corp.

The ITIC 2010 Database Deployment Trends Survey, conducted in December 2009, found that approximately 56% of respondents plan to upgrade or expand their database systems in the 2010-2011 timeframe.

Laura DiDio, principal at ITIC, said in an interview that "much of the developer activity will center on building custom applications – particularly in the legal, healthcare, financial and insurance verticals.

"When it comes to mainstream developer activity, the survey found that many ISVs are focused on extending the management and security capabilities of SQL Server 2008 to provide more granular functionality," DiDio said. "There is also a lot of activity around building extensions and increasing the integration between SQL Server and other mainstream line of business server-based applications."

During this time of increased upgrades, the ongoing wars among the Big Four database vendors (Oracle, IBM, Microsoft and Sybase) are likely to escalate, according to an ITIC blog posting on the survey's findings:

"Anytime a company decides on a major upgrade, there's always a chance that they may switch providers. The DBMS vendors know this and will do their level best to lure customers to their platform, or at the very least get a foot in the door."

That may be good news for Microsoft-centric developers because the survey found that while most companies don’t change vendors during an upgrade, Microsoft SQL Server was the top choice for organizations that did switch platforms during the last three years: "Database defectors chose to migrate to SQL Server by a two-to-one margin over the nearest competitor, Oracle."

Generally speaking, DiDio said, "the survey respondents expressed enthusiasm and high regard for the continual feature/function and performance enhancements in SQL Server. They also gave Microsoft high marks for providing excellent documentation and development tools for the platform."

However, DiDio said, independent software vendors will be challenged by "the inherent degree of difficulty in building, testing and debugging third party or customized applications to run on the newest version of SQL Server 2008."

DiDio said other challenges faced by developers include:

  • Trying to get third-party application providers to support the newest versions of the market leaders SQL Server, Oracle, IBM’s DB2 and Sybase in a timely fashion.
  • Designing redundancy for SQL Server applications -- many third-party applications do not yet support the SQL Server 2008 mirroring capabilities. Developers have to build workarounds and then make sure that the code works and seamlessly interoperates with the rest of the environment. This is extremely design and work intensive, consuming precious manpower and R&D resources.
  • Many third-party applications lag at least one version behind the latest version of the database. Developers have three choices: to try and pressure the specific ISV to hurry up and support SQL Server 2008; to build custom extensions to the application; or wait for the ISV to provide support.

About the Author

David Ramel is an editor and writer for Converge360.

comments powered by Disqus

Featured

  • AI for GitHub Collaboration? Maybe Not So Much

    No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.

  • Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

    As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.

  • .NET 9 Preview 3: 'I've Been Waiting 9 Years for This API!'

    Microsoft's third preview of .NET 9 sees a lot of minor tweaks and fixes with no earth-shaking new functionality, but little things can be important to individual developers.

  • Data Anomaly Detection Using a Neural Autoencoder with C#

    Dr. James McCaffrey of Microsoft Research tackles the process of examining a set of source data to find data items that are different in some way from the majority of the source items.

  • What's New for Python, Java in Visual Studio Code

    Microsoft announced March 2024 updates to its Python and Java extensions for Visual Studio Code, the open source-based, cross-platform code editor that has repeatedly been named the No. 1 tool in major development surveys.

Subscribe on YouTube