Survey: 50%+ of Enterprise Devs Using XQuery

A survey of devs using XML just released found that more than half are already working with XQuery, and another sizeable group expects to start before the end of the year. See why XQuery is so hot - even before adoption of the final standards.

Tags: XQuery, XML, Developers, Survey, Integration, King, Data Access,

More than half of all XML developers are working with XQuery, and another sizeable group expects to start before the end of the year.

That's according to a DataDirect Technologies survey just released of some 550 "XML developers," (which DataDirect defines as including a wide range of XML and database professionals).

Specifically, the survey found 52% of XML developers have already started working with XQuery in the last 12 months and another 33% have plans to start using XQuery before years' end.

"That one number was of the most dramatic findings for me--that XQuery is already happening, and in a much bigger way that I would have expected," Larry Kim, DataDirect's XML Programs Manager told Integration Developer News.

"The survey data confirmed what we've known all along - that there's a tremendous interest for an alternative to the tedious, low-level methods presently employed for querying, manipulating and transforming XML data," Kim added.

The DataDirect 2005 XQuery Industry Study results closely mirror the results of a 2005 study by Evans Data Corp. a leading developer market research firm, which revealed that "44% of those surveyed said they are using XQuery, or plan to - even though the final XQuery specs have yet to be put in place."

[Although the Evans Data Corporation Study did not focus exclusively on XQuery trends, Kim said the data revealed a very high XQuery adoption rate at this point in the XQuery technology curve.]

DataDirect execs say the survey also confirms work from other sources that shows a growing number of IT professionals - architects, developers, sysadmins, are finding XML tools such as XQuery can ease integration for data and documents, and even set up complex, multi-database queries on-the-fly.

Inside DataDirect's Industry Study
When the DataDirect survey asked developers Why they are using XQuery, the plurality (43.1%) said "because it simplifies XML data access and transformation."

Kim added some insight to this reposnse: "Developers today have a tremendous amount of data already in XML, but to access that data they would often have to use hand-coding approaches, such as XSLT, which were not trivial to learn." XQuery, the survey found, provided developers with an easier-to-use method for addressing querying, accessing and general manipulation of XML data. Another XQuery plus: Is syntax is more familiar to database developers, the survey also found.

Inside the Developers Practice of XQuery
Jerry King, general manager for DataDirect's XML products told OET "Developers and architects are asking us two questions," (1) How can I get my relational data into XML?; and (2) How can I take the data access and transformation routines I am building, and my artifacts, and wrap them up into a program

The growing interest is coming as more architects and developers understand the integration power of XML. "Last year ran a dev survey that showed told us less half of our customers had even touched XQuery, let alone used it for anything important [in their companies]," King told IDN

"But, since then, the XQuery section of our site has gone from the least traveled area to consistently rank in the number 2 or 3 position. In addition, we've done a more recent survey and more than half of [our customers] said they were actively using XQuery, and a significant portion of those said they were doing something meaningful with it. The numbers have literally inverted," King added.

2005 Predictions for XML's Next Wave
As the W3C moves steadily closer to adopting an "open" and multi-vendor standard for XQuery, King says some major XML-driven trends in architecture and developer Best Practices will begin to gain critical mass in 2005. Here are his Top 5 predictions

  • Moving Beyond SQL: SQL pre-dates many cornerstones of conventional software development, making entire classes of new applications difficult to implement using current technologies. XQuery is a natural fit for XML content management applications, XML reporting, native XML programming, data integration and Web message processing. The transition to XQuery-based applications will be eased by the availability of powerful developer tools.

  • Access Relational Databases as XML: XQuery can use XML views to query relational databases the same way that it queries XML because one query can process both types of data. This will greatly ease developers' jobs because they will not have to write and maintain mountains of code, resulting in faster application development.

  • Access Non-Relational Data as XML: There is a tremendous wealth of information stored in non-relational data formats (EDI, CSV, binary data, etc.), but so many different types of formats make it difficult or impossible to reuse valuable information. Fortunately, most data formats can easily be translated to XML and processed like other XML data, which will make XQuery increasingly popular for data integration.

  • Access Distributed Data Sources: We live in a networked world and XQuery was designed to leverage this by providing built-in facilities for loading and querying data sources anywhere on the Internet. XQuery will enable developers to join, integrate, share and manipulate data on the Internet as though it was on the local file system.

  • Standards-Based Programmatic Data Access: The XQuery API for Java (XQJ), the XML equivalent to JDBC or ADO, is a powerful new Java specification for processing query results in a JDBC-like fashion. Look for data access component vendors to provide embeddable components, which will fully support standards-based XQuery data access through XQJ for all major databases, including Oracle, Microsoft, IBM, Sybase and MySQL, as early as mid 2005.

  • And it's not all about XQuery. King says that skills and tools for XSLT and XML Schema will also be in greater demand, for enabling a wide range of intra-enterprise and B2B sharing and integration projects.

    "It's already starting to get awareness among the larger vendors," King said. "Even though Oracle, Microsoft or SAP don't talk about it a lot, they all are looking very hard at how these next XML technologies will begin to reshape how they [architect] and package their applications, and how their application software can be integrated with other data sources."